Hello-World-Software-Studios / calculator

Carpenter's tool for wall layout
0 stars 1 forks source link

Goal: Make a post to add a project #40

Closed ecumene closed 3 years ago

ecumene commented 3 years ago

Nice work! Just need to return the Project ID and such via INSERT ... RETURNING ...

ecumene commented 3 years ago

https://www.postgresql.org/docs/9.5/dml-returning.html

JPM709 commented 3 years ago

Can create a user that returns a unique user ID from SQL. That ID is then used when a project is created as owner_user_id. The created project then returns a project_id, which is used when a wall is added to the project. Tested a couple times last night, appears to be working correctly. I'm very happy about this