search

vmware-archive / sql-to-dbsp-compiler

Compiler translating SQL view definitions into DBSP circuits (https://github.com/vmware/database-stream-processor)
Other
28 stars 5 forks source link

Read inputs directly from the database in SQL logic tests #87

Closed lalithsuresh closed 1 year ago

lalithsuresh commented 1 year ago

Optionally use read_db() instead of read_csv() to get inputs for SQL logic tests. Can be configured from SQLLogicTest.Main() using a -l flag to set either csv or db as the input source. The connection string is derived from the user, password and SQL dialect when using "-l db". Only supports and tested against postgres for now.

Signed-off-by: Lalith Suresh lsuresh@vmware.com