_split_sql_chunk doesn't handle CREATE FUNCTION in Pg

[osfameron]

I'm getting an error while trying to move this SQL to a DBIC::Migration

https://github.com/mysociety/fixmystreet/blob/master/db/schema.sql#L21

DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator::deploy(): DBI Exception: DBD::Pg::db do failed: ERROR:  unterminated quoted string at or near "' declare today date"
LINE 1: ...ction ms_current_timestamp() returns timestamp as ' declare ...
                                                             ^ at /var/www/fixmystreet.127.0.0.1.xip.io/fixmystreet/local/lib/perl5/x86_64-linux-gnu-thread-multi/Moose/Meta/Method/Delegation.pm line 110

As far as I can tell, the problem seems to be _split_sql_chunk in DBIx/Class/DeploymentHandler/DeployMethod/SQL/Translator.pm which chunks by ";" (which are present within the body of the function.)

Presumably this should instead be using something like Text::Balanced?

[frioux]

This should be solved by #11. If you find the time to fix that, that would solve this and so many other issues.

[osfameron]

Closing as per @frioux's comment -- in mean time I've worked around with a wrapped around DBIC::Migration at https://github.com/mysociety/fixmystreet/blob/db-migrations/bin/migrate#L10