search

sebastianwessel / surrealdb-client-generator

Tool which generates a typescript client for SurrealDB and zod schema of a given database
MIT License
76 stars 12 forks source link

`OVERWRITE` is not supported #63

Closed zvictor closed 1 month ago

zvictor commented 1 month ago

surrealdb-migrations requires the use of OVERWRITE clauses, which are not supported by surrealdb-client-generator:

No config file found.
Starting temporary SurrealDB instance
Temporary SurrealDB instance started at http://localhost:43119
Connecting to database
Connected to database successfully

🔴 This did not work as expected 🥺
🔴 I am sorry that this happened, and I kindly ask for your help to fix this.
🔴
🔴 Please open an issue here:
🔴 👉 https://github.com/sebastianwessel/surrealdb-client-generator/issues
🔴
🔴 Please copy & paste the following code into the ticket:
=====
ResponseError: There was a problem with the database: Parse error: Failed to parse query at line 87 column 8 expected query to end
   |
87 | DEFINE TABLE OVERWRITE script_migration SCHEMAFULL
   |        ^ perhaps missing a semicolon on the previous statement?

    at Surreal.query_raw (/home/zvictor/development/plugat/node_modules/.pnpm/surrealdb@1.0.0-beta.21_tslib@2.7.0_typescript@5.6.2_ws@8.18.0_bufferutil@4.0.8_utf-8-validate@6.0.4_/node_modules/surrealdb/dist/index.cjs:1:45589)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Surreal.query (/home/zvictor/development/plugat/node_modules/.pnpm/surrealdb@1.0.0-beta.21_tslib@2.7.0_typescript@5.6.2_ws@8.18.0_bufferutil@4.0.8_utf-8-validate@6.0.4_/node_modules/surrealdb/dist/index.cjs:1:45244)
    at async insertDefinitions (/home/zvictor/development/plugat/node_modules/.pnpm/@sebastianwessel+surql-gen@2.6.1_tslib@2.7.0_typescript@5.6.2_ws@8.18.0_bufferutil@4.0.8_utf-8-validate@6.0.4_/node_modules/@sebastianwessel/surql-gen/dist/index.js:92:3)
    at async main (/home/zvictor/development/plugat/node_modules/.pnpm/@sebastianwessel+surql-gen@2.6.1_tslib@2.7.0_typescript@5.6.2_ws@8.18.0_bufferutil@4.0.8_utf-8-validate@6.0.4_/node_modules/@sebastianwessel/surql-gen/dist/index.js:1006:9)
===
🔴 If possible, please provide some more detailed information if possible.
🔴 🙏 Thank You! I will try to fix it.

Removing the OVERWRITE clauses removes the error.