How to run setup.sql with multiple statements to initialize db?

[eminfedar]

Hi there,

I have a "setup.sql" file to initalize the PostgreSQL db. It has multiple queries and statements in it. But I can't run it with a query_file! macro.

Example code:

sqlx::query_file!("setup.sql").execute_many(db.as_ref()).await.unwrap();

Error at compile time:

error: error returned from database: cannot insert multiple commands into a prepared statement

How can I run a .sql file with multiple statements in it?

[eminfedar]

sqlx::migrate! can be useful but it requires VERSION_DESCRIPTION.sql format and I don't want that. I want separate sql files like users.sql, accounts.sql, players.sql etc. Every file creates its own tables. So using this migration format isn't possible to me.

How can I batch run multiple sql files with multiple statements in a folder exactly like migrate! without migration restrictions?