René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Basic usage  - relation \"x\" does not exist","articleBody":"### Version\r\n\r\n1.26.0\r\n\r\n### What happened?\r\n\r\nGetting `relation \"x\" does not exist` for every query I mention in my `queries` .sql files\r\n\r\n### Relevant log output\r\n\r\n```shell\r\nquery.sql:1:1: relation \"models\" does not exist\r\nquery.sql:15:1: relation \"models\" does not exist\r\nquery.sql:20:1: relation \"models\" does not exist\r\nquery.sql:28:1: relation \"models\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE `transcription_jobs` (\r\n  `id` integer PRIMARY KEY,\r\n  `org_id` integer,\r\n  `user_id` integer,\r\n  `started_at` timestamp,\r\n  `ended_at` timestamp,\r\n  `tokens` integer,\r\n  FOREIGN KEY (`org_id`) REFERENCES `organization` (`org_id`)\r\n);\r\n\r\nCREATE TABLE `organization` (\r\n  `org_id` integer PRIMARY KEY\r\n);\r\n\r\nCREATE TABLE `models` (\r\n  `id` integer PRIMARY KEY,\r\n  `model_name` VARCHAR(255),\r\n  `balance` integer,\r\n  `org_id` integer,\r\n  FOREIGN KEY (`org_id`) REFERENCES `organization` (`org_id`)\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: CreateModel :one\r\nINSERT INTO models (\r\n    id,\r\n    model_name,\r\n    org_id,\r\n    balance\r\n) VALUES (\r\n    :id,\r\n    :model_name,\r\n    :org_id,\r\n    :balance\r\n) RETURNING *;\r\n\r\n-- name: GetModel :one\r\nSELECT * FROM models\r\nWHERE id = :id\r\nLIMIT 1;\r\n\r\n-- name: UpdateModel :one\r\nUPDATE models\r\nSET model_name = :model_name,\r\n        org_id = :org_id,\r\n        balance = :balance\r\nWHERE id = :id\r\nRETURNING *;\r\n\r\n-- name: DeleteModel :one\r\nDELETE FROM models\r\nWHERE id = :id\r\nRETURNING *;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\nversion: \"2\"\r\nplugins:\r\n  - name: \"py\"\r\n    wasm:\r\n      url: \"https://downloads.sqlc.dev/plugin/sqlc-gen-python_1.0.0.wasm\"\r\n      sha256: \"aca83e1f59f8ffdc604774c2f6f9eb321a2b23e07dc83fc12289d25305fa065b\"\r\nsql:\r\n  - schema: \"path_to_folder\"\r\n    queries: \"path_to_folder\"\r\n    engine: \"sqlite\"\r\n    codegen:\r\n      - plugin: \"py\"\r\n        out: \"src\"\r\n        options:\r\n          package: \"foo\"\r\n          emit_sync_querier: true\r\n          emit_async_querier: true\r\n          query_parameter_limit: 5\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/7150dcc1ccab07d5dcca915b08525b015d4f94968345157779d016a74eb04279\r\n\r\n### What operating system are you using?\r\n\r\nmacOS\r\n\r\n### What database engines are you using?\r\n\r\nSQLite\r\n\r\n### What type of code are you generating?\r\n\r\nPython","author":{"url":"https://github.com/eyal-solomon1","@type":"Person","name":"eyal-solomon1"},"datePublished":"2024-04-22T11:46:36.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":6},"url":"https://github.com/3350/sqlc/issues/3350"}