René's URL Explorer Experiment

Title: NOT NULL statements are not working for generated Alembic migrations · Issue #232 · googleapis/python-spanner-sqlalchemy · GitHub

Open Graph Title: NOT NULL statements are not working for generated Alembic migrations · Issue #232 · googleapis/python-spanner-sqlalchemy

X Title: NOT NULL statements are not working for generated Alembic migrations · Issue #232 · googleapis/python-spanner-sqlalchemy

Description: the following 2 statements in the Spanner DDL window do the trick : ALTER TABLE test ADD COLUMN test STRING(MAX); ALTER TABLE test ALTER COLUMN test STRING(MAX) NOT NULL; But there is no native way of doing it in SQLAlchemy The workaroun...

Open Graph Description: the following 2 statements in the Spanner DDL window do the trick : ALTER TABLE test ADD COLUMN test STRING(MAX); ALTER TABLE test ALTER COLUMN test STRING(MAX) NOT NULL; But there is no native way...

X Description: the following 2 statements in the Spanner DDL window do the trick : ALTER TABLE test ADD COLUMN test STRING(MAX); ALTER TABLE test ALTER COLUMN test STRING(MAX) NOT NULL; But there is no native way...

Opengraph URL: https://github.com/googleapis/python-spanner-sqlalchemy/issues/232

X: @github

direct link

Domain: github.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"NOT NULL statements are not working for generated Alembic migrations","articleBody":"the following 2 statements in the Spanner DDL window do the trick :\r\nALTER TABLE test ADD COLUMN test STRING(MAX);\r\nALTER TABLE test ALTER COLUMN test STRING(MAX) NOT NULL;\r\n\r\nBut there is no native way of doing it in SQLAlchemy\r\nThe workaround we currently use is to manually edit the migration file to add the two above statements using op.execute(). Tt would be nice if it worked out-of-the-box","author":{"url":"https://github.com/IlyaFaer","@type":"Person","name":"IlyaFaer"},"datePublished":"2022-08-18T08:08:09.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":12},"url":"https://github.com/232/python-spanner-sqlalchemy/issues/232"}

Links:

Viewport: width=device-width