TODO: capture generated columns in all sqldrivers

[ssweber]

We now add generated columns in Datasets, , don’t try to update or insert into generated columns, and make generated columns “readonly” in CellEdit.

• [x] sqlite
• [x] MySQL
• [x] Postgres
• [x] Sqlserver
• [x] Msaccess
• [ ]

Just putting this here for future reminder.

[PySimpleSQL]

Thanks for this, it's actually something I use often in my own projects and have been trying to think of a good work around. Doing them at the driver level makes a lot of sense!

[ssweber]

For sure! I found it super useful in the orders example

I didn’t see the need to distinguish between stored vs virtual generated, but I went ahead and copied it over as-is (eg hidden = 1 or 2 for SQLite), but it still works for generated, not generated.

I’ll probably do the same for the other drivers (MySQL stores it as “, AND EXTRA = 'VIRTUAL GENERATED' OR EXTRA = 'STORED GENERATED' ) unless you want to standardize on a constant convention.

[ssweber]

330

I also standardized on True/False

Msaccess doesn't have generated columns, correct? we can then close this out.

[ssweber]

nevermind, they do have 'calculated'. and added that to sqldriver.