René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] Tables with string columns defined manually not using `STRING(MAX)`, ie `STRING(1024)` will fail","articleBody":"If you create a table directly via sql command and then try to interact with that same db with spanner_orm then it will fail.\r\n\r\n```\r\nCREATE TABLE manuallyCreatedTable(\r\n  id INT64 NOT NULL,\r\n  ProblematicColumn STRING(1024),\r\n) PRIMARY KEY(id);\r\n```\r\n\r\nAnd you create any table.  You will get an error like:\r\n\r\n```\r\n  /usr/local/bin/spanner-orm(8)\u003cmodule\u003e()\r\n-\u003e sys.exit(main())\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/scripts.py(78)main()\r\n-\u003e args.execute(args)\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/scripts.py(33)migrate()\r\n-\u003e executor.migrate(args.name)\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/migration_executor.py(63)migrate()\r\n-\u003e self._validate_migrations()\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/migration_executor.py(184)_validate_migrations()\r\n-\u003e if (self.migrated(migration_.migration_id) and\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/migration_executor.py(46)migrated()\r\n-\u003e return self._migration_status().get(migration_id, False)\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/migration_executor.py(150)_migration_status()\r\n-\u003e model_from_db = metadata.SpannerMetadata.model(\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/metadata.py(68)model()\r\n-\u003e return cls.models().get(table_name)\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/metadata.py(43)models()\r\n-\u003e tables = cls.tables()\r\n  /usr/local/lib/python3.9/site-packages/spanner_orm/admin/metadata.py(80)tables()\r\n-\u003e column_row.field_type(), nullable=column_row.nullable())\r\n\u003e /usr/local/lib/python3.9/site-packages/spanner_orm/admin/column.py(45)field_type()\r\n-\u003e raise error.SpannerError('No corresponding Type for {}'.format(\r\n(Pdb) up\r\n\u003e /usr/local/lib/python3.9/site-packages/spanner_orm/admin/metadata.py(80)tables()\r\n-\u003e column_row.field_type(), nullable=column_row.nullable())\r\n(Pdb) column_row.field_type()\r\n*** spanner_orm.error.SpannerError: No corresponding Type for STRING(1024)`\r\n```\r\n\r\nWORKAROUND: You will need to either set `ProblematicColumn ` to `STRING(MAX)` or delete that table.\r\n\r\nLeaving this here for future intrepid souls.","author":{"url":"https://github.com/mox-bot","@type":"Person","name":"mox-bot"},"datePublished":"2021-10-01T20:30:11.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/165/python-spanner-orm/issues/165"}