search

PySimpleSQL / pysimplesql

SQLite3 binding for PySimpleGUI
GNU Lesser General Public License v3.0
45 stars 16 forks source link

Generated column capturing for Mysql/Postgres/Sqlserver/MsAccess #330

Closed ssweber closed 1 year ago

ssweber commented 1 year ago

Also fixed SqlLite so that only generated columns are set as generated

1 - hidden 2 - virtual generated 3 - stored generated

should we skip hidden columns?

ssweber commented 1 year ago

I didn't check if the generated column actually returns correct data... I guess that would come if/when we port orders (or another example with calculated columns) to the other databases. But at least we won't try to write to it :)

ssweber commented 1 year ago

seems like sqlalchemy got around the parent/child talk with in Relationships with: child_table -> table fk_column -> constrained_column parent_table -> referred_table pk_column -> referred_column

PySimpleSQL commented 1 year ago

Hey, I'll get back to you as soon as I can. I'm in Canada on a Backcountry camping/canoeing trip and haven't had signal. Ill be back on the 23rd

On Fri, Jun 9, 2023, 2:12 PM ssweber @.***> wrote:

seems like sqlalchemy got around the parent/child talk with in Relationships with: child_table -> table fk_column -> constrained_column parent_table -> referred_table pk_column -> referred_column

— Reply to this email directly, view it on GitHub https://github.com/PySimpleSQL/pysimplesql/pull/330#issuecomment-1584965163, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQX2REVXIORPOSDMWWAIMV3XKNRQFANCNFSM6AAAAAAY2EAMNM . You are receiving this because you are subscribed to this thread.Message ID: @.***>

ssweber commented 1 year ago

That sounds like a blast!

I’ve been working towards making sure that everything is working ok across sqldrivers.

hopefully by the time you get back I’ll have a readme for you to review, that gives me a nice deadline to work against 😉