René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"files generated for SQLite are missing type annotations.","articleBody":"When generating python code with the engine set to sqlite the generated code has every property annotated with the Any type.\r\n\r\nIf I switch the engine to postgresql everything works as expected.\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.2.0.wasm\r\n      sha256: a6c5d174c407007c3717eea36ff0882744346e6ba991f92f71d6ab2895204c0e\r\nsql:\r\n  - schema: \"schema.sql\"\r\n    queries: \"query.sql\"\r\n    engine: sqlite\r\n    codegen:\r\n      - out: src/modeldb/db/schema\r\n        plugin: py\r\n        options:\r\n          package: modeldb.db.schema\r\n          emit_sync_querier: true\r\n          emit_async_querier: true\r\n          query_parameter_limit: 5\r\n```\r\n\r\n```sql\r\nCREATE TABLE file\r\n(\r\n    id          INTEGER NOT NULL,\r\n    name        text NOT NULL,\r\n    path        text NOT NULL,\r\n    hash        text NOT NULL,\r\n    resource_id INTEGER NOT NULL,\r\n    PRIMARY KEY (id),\r\n    FOREIGN KEY (resource_id) REFERENCES resource (id)\r\n);\r\n```\r\n\r\n```python\r\n# Code generated by sqlc. DO NOT EDIT.\r\n# versions:\r\n#   sqlc v1.27.0\r\nimport dataclasses\r\nfrom typing import Any, Optional\r\n\r\n\r\n@dataclasses.dataclass()\r\nclass File:\r\n    id: Any\r\n    name: Any\r\n    path: Any\r\n    hash: Any\r\n    resource_id: Any\r\n```\r\n\r\nI realise sqlite plays fast and loose with types, but so does python. It'd be very beneficial to have this working. ","author":{"url":"https://github.com/rfletchr","@type":"Person","name":"rfletchr"},"datePublished":"2024-11-27T00:46:14.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/64/sqlc-gen-python/issues/64"}