Re: [sqlalchemy] Re: Deletion of a row from an association table

Sorry I was not back sooner. Thank-you Simon King, you have solved my problem. As anyone can guess I am still in the learning stages of SqlAlchemy. My python/Sqlite solution has shown that I have neglected SqlAlchemy core. When I first downloaded and studied SqlAlchemy, I only glanced at

Re: [sqlalchemy] Table to track applied migrations?

Audit-Alembic meets the requirement. It creates an alembic_version_history table, and populates it with Alembic events. Unfortunately, it was last updated three years ago and I believe is out of date (it's check for whether 'on_version_apply' exists

[sqlalchemy] Re: can't connect to Teradata - "The UserId, Password or Account is invalid"

You will have better luck asking for help from the people who write/maintain the Teradata dialect. They list a gitter room here: https://github.com/Teradata/sqlalchemy-teradata According to a posting on gitter ( https://gitter.im/sandan/sqlalchemy-teradata), it looks like that package is

Re: [sqlalchemy] Table to track applied migrations?

this is issue 309 https://github.com/sqlalchemy/alembic/issues/309 waiting for someone with the time and motivation to work on it. On Wed, Aug 19, 2020, at 11:25 AM, Jasen Jacobsen wrote: > I've used Liquibase in the past and as part of its migration tracking it > creates a table which lists

[sqlalchemy] Table to track applied migrations?

I've used Liquibase in the past and as part of its migration tracking it creates a table which lists each migration applied. See Liquibase Changelog Table . Alembic has the alembic_version table, but it only holds a single

[sqlalchemy] can't connect to Teradata - "The UserId, Password or Account is invalid"

Hi. I'm using Anaconda Python 3.8.3, trying to use SQLAlchemy to connect to Teradata but it's not working. I've tried several ways but no luck. In "pip list" I have SQLAlchemy sqlalchemy-teradata teradata teradatasql teradatasqlalchemy Currently config is like this: import sqlalchemy

Re: [sqlalchemy] Getting column data from result set with column name as a string.

__table__ is public (private would be a single or double underscore prefix only), but also you could use inspect(cls).column_attrs: https://docs.sqlalchemy.org/en/13/orm/mapping_api.html?highlight=column_attrs#sqlalchemy.orm.Mapper.column_attrs On Wed, Aug 19, 2020, at 1:22 AM, Dale Preston