Name of id columns on database tables

[njmattes]

@legendOfZelda Is it possible to change the database schema so that each table's primary_key is called id (rather than eg gid)? ForeignKeys would still take names like gid to distinguish themselves. See the following files in the db_ids branch for a sense of what I'm talking about:

• ede/database.py:18–29
• ede/schema/models.py

[ghost]

i haven't used id so far because it's a keyword in python

[njmattes]

Fair enough. How about uid then, and perhaps slightly more verbose foreign key names. See the last commit on the db_ids branch (here and here).

[ghost]

yes, I'm fine with your schema. only minor suggestions:

• i want to call the object Grid_Var (singular) but the underlying table grid_vars (plural) because the object really stands for one row, thus singular
• similarly, i want to use var_id instead of vars_id

[njmattes]

I'm fine with that. We should rip out the @declared_attr of the EDEBase object, and add __table_name__s back to the model objects. Do you want to do this refactor or want me to? I'm happy to do it—or to stay out of the way.

[ghost]

ok, i refined the schema and actually removed EDEBase to simplify + make the uid's and tablenames more explicitly visible in models.py which can't hurt, certainly not for the beginning.

[njmattes]

Works for me.