You need to execute the statements one by one and write code that reads the 

I  have written code to read a SQL schema definition file and create a database 
from it, you can find it here:

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,

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 
For more options, visit

Reply via email to