bug: when having a table named "order" it fails to create
scratchmex opened this issue · 1 comments
scratchmex commented
when having a table named "order" it fails to create the table because the statement does not have the quotes
22:53:12.172 [main] ERROR com.github.caiiiycuk.pg2sqlite.Boot$ -
Create Table - Exception:
[SQLITE_ERROR] SQL error or missing database (near "order": syntax error)
[SQL] 'CREATE TABLE order ([id]);'
[LINE #767] CREATE TABLE "order" ( id integer NOT NULL );,
the sql statement should be CREATE TABLE "order"
I fixed it by replacing "order" with "order_t"
scratchmex commented
just an off-topic follow-up on this. I ended up doing my implementation in rust for fun haha if you like to take a look I would appreciate it