~sircmpwn/sr.ht#303: 
Figure out *-initdb scripts with non-SA tables

The gql webhook tables, for instance, do not have corresponding sqlalchemy types, so they are not created when running -initd. Need to address this. How?

Status
REPORTED
Submitter
~sircmpwn
Assigned to
Submitted
3 years ago
Updated
3 years ago
Labels
beta

~adnano 3 years ago

I'm not sure there is a way to do this with sqlalchemy. Maybe we could maintain a database schema separate from sqlalchemy for initialization purposes?

Alternatively, we can just run the necessary migrations from the initdb script.

~sircmpwn 3 years ago

Maybe we could maintain a database schema separate from sqlalchemy for initialization purposes?

Yes, I think this is the best option.

~adnano 3 years ago

Are there any other tables that need to be added besides the GraphQL webhook tables?

~sircmpwn 3 years ago

Yeah: all of the other tables. Trying to move away from sqlalchemy and alembic so this is a good chance to establish a new authoritative source for the SQL schema.

~adnano 3 years ago*

I meant other than the ones covered by sqlalchemy.

~sircmpwn 3 years ago

Ah, no, none that I'm aware of.

Register here or Log in to comment, or comment via email.