[ALTER TABLE] Support parsing multiple alterations

[TheLazyDev]

I am facing this error when I try to run this query below:-

ALTER TABLE reviews ADD COLUMN IF NOT EXISTS reviewer UUID,ADD COLUMN IF NOT EXISTS reviewee UUID,ADD COLUMN IF NOT EXISTS job_id UUID,ADD COLUMN IF NOT EXISTS review VARCHAR,ADD COLUMN IF NOT EXISTS rating FLOAT DEFAULT 0;;

This query is working properly when I run it through SQL runner :/

[oguimbal]

Yup, this syntax is not supported by pgsql-ast-parser.

I'm transfering the issue there.

I dont have time to handle this these days, unfortunately 😑 So I cant give you an ETA, sorry

Thanks for the report

[TheLazyDev]

No problem I understand I actually liked your library because it is very configurable but sadly due to this error I can't use it in my project if you don't mind can you provide any suggestions for setting up a in memory instance of postgres because I have to write unit tests for my code and I am unable to find any usable module :/

[oguimbal]

There arent many alternatives, as far as I know.
The only other option that I know if is to use an actual postgres instance, wrapped in a transaction, or a brand new one for each test.
You can set this reliably up using Docker and running your tests against a clean dockerized db, but this has a significant overhead, and is definitely not trivial to setup.

Cant you split your alter statements in multiple single alter statements (that would be supported by pg-mem) ?

[oguimbal]

Released as pgsql-ast-parser@9.0.0, thanks to @bchelli