Jira (PDB-5326) Add database storage for workspaces

Issue Type:	Improvement
Assignee:	Unassigned
Components:	PuppetDB
Created:	2021/10/18 8:33 AM
Priority:	Normal
Reporter:	Rob Browning

This message was sent by Atlassian Jira (v8.13.2#813002-sha1:c495a97)

Rob Browning (Jira)

unread,

Oct 18, 2021, 11:37:05 AM10/18/21

to puppe...@googlegroups.com

Rob Browning updated an issue

PuppetDB /

Change By:	Rob Browning
Sprint:	HAHA/Grooming

Austin Blatt (Jira)

unread,

Oct 19, 2021, 1:44:02 PM10/19/21

to puppe...@googlegroups.com

Austin Blatt updated an issue

PuppetDB /

Change By:	Austin Blatt
Acceptance Criteria:	* New migration to add workspaces and workspace_memberships tables * Ensure proper primary key/foreign key constraints * Add a migration schema diff test Doesn't need * A migration test with data because the tables are totally new.
Story Points:	3

Create new tables for storing workspace information. We will need to store workspace uuid's with their {{producer_timestamp}}'s (in the {{workspaces}} table. And a table of {{certname}}, {{workspace_uuid}} membership pairs in {{workspace_memberships}}

Q: Will this be on {{6.x}} and {{main}}, or just {{main}}?
A: {{main}} to reduce LTS risk

Austin Blatt (Jira)

unread,

Oct 20, 2021, 12:54:02 PM10/20/21

to puppe...@googlegroups.com

Austin Blatt updated an issue

PuppetDB /

Change By:	Austin Blatt
Sprint:	HAHA/Grooming HA 2021-11-03

Austin Blatt (Jira)

unread,

Oct 20, 2021, 1:00:04 PM10/20/21

to puppe...@googlegroups.com

Austin Blatt updated an issue

PuppetDB /