You need to execute the statements one by one and write code that reads the statements.
I have written code to read a SQL schema definition file and create a database from it, you can find it here: https://github.com/alex-hhh/ActivityLog2/blob/master/rkt/dbutil.rkt The `db-open` command will open a SQLite database and will create a schema if the database does not exist. I even implemented a `db-uprade' command that allows upgrading an existing database to a newer version by applying a series of SQL patches. If you want to see how it is all tied together, look at dbapp.rkt and the SQL files in the "sql" folder. Feel free to use the code if you find it useful. Best Regards, Alex. On Friday, May 12, 2017 at 8:49:37 PM UTC+8, Alexander McLin wrote: > `db` library doesn't seem to provide support for executing batch statements > against a database. I'm trying to initialize and create an in-memory SQLite3 > database using a SQL schema file. `query-exec` and its friends only support > executing single SQL statements. > > Reading documentation isn't showing me a way to be able to execute more than > one statement at once or allow a SQL text file to be read in and executed. > Does anyone know a better method? > > Thanks! > > Alexander B. McLin -- You received this message because you are subscribed to the Google Groups "Racket Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to racket-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
