isogr / register-system-transition

Covers GR system transition from 2013 Java-based version to 2023 static site based version
1 stars 1 forks source link

Provide a list of SQL queries executed when rendering group proposals #6

Closed strogonoff closed 8 months ago

phuonghuynh commented 1 year ago

Learning the code for this part, will get back asap.

phuonghuynh commented 1 year ago

@strogonoff Could you help me to capture a screenshot that displaying ProposalGroup that you need to check the SQL for it?

From the code, "Supersession" is only class that extends "ProposalGroup" ; others are "SimpleProposal"

To determine what Proposal is "Group" or "Simple"; DB use table called "Supersession"

So this SQL is use to display Proposals that are Supersessions

Select p.*, pgs.*
From proposal p, proposalgroup pg, supersession pgs
WHERE p.uuid = pg.uuid
    And p.uuid = pgs.uuid