Multiple commands in raw sql migrations

[halldorrt]

Hi,

My team and I would like to write our migrations is sql. Sea-orm offers that feature, however the migration tool only seems to be able to execute one command at a time. If we perform more than one command in the same sql string we get the following error: Execution Error: error returned from database: cannot insert multiple commands into a prepared statement

I can get around it by using the DO command in postgres:

DO $$ BEGIN
  -- All the statements you could ever dream of
END $$;

I also came across this: SeaQL/sea-query#437
This is slightly different however, since it revolves around executing sql files. We are writing the sql in the migration.

I am just wondering whether there is some better way that sea-orm provides of doing this, and whether multiple commands will be supported without a workaround in the future?

[billy1624]

Hey @halldorrt, welcome and thanks for asking!! I think we can provide an interface to execute an unprepared statement(s). I'll try to draft a PR for this later today.

Since this is more related to sea-orm, I'd transfer this discussion.

[billy1624]

Hey @halldorrt, please check #1327

[halldorrt]

Hi, sorry for the late response, the holidays :)
Thanks a lot, I will check that out.

[tyt2y3]

You can also call get_connection and basically do whatever you need