PySimpleSQL / pysimplesql

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

*Untested sql_commands/sql_script support in mysql/postgres/sqlserver #331

Closed ssweber closed 1 year ago

ssweber commented 1 year ago

self.con.executescript is sqlite only.

So I did basic conversion over to how it should be, but not sure how it works if sql_script/commands have things like SELECTS.

Perhaps we consider taking this functionality completely out for mysql/postgres/sqlserver, and point users in the direction of something like: http://execsql.osdn.io/ if they need to execute a script.

ssweber commented 1 year ago

if you end up merging this before I port orders to test properly, I think that'll be OK.

ssweber commented 1 year ago

I tested these and they seem to work OK

ssweber commented 1 year ago

Once again, I'm finding it easier to just have a WIP, but the commits are cleaner this time