sqlalchemy-access | Python Ecosystem Directory

sqlalchemy-access - Fix DDL error with YesNo columns Latest Release

Published by gordthompson over 1 year ago

Fix DDL (CREATE TABLE) error when column defined as sqlalchemy_access.YesNo instead of sqlalchemy.Boolean. PR courtesy of @TOTOleHero .

sqlalchemy-access - Fix has_table() error

Published by gordthompson over 1 year ago

unexpected keyword argument 'info_cache'

sqlalchemy-access - Support SQLAlchemy 2.0

Published by gordthompson over 1 year ago

sqlalchemy-access - Fix has_table() to be case-insensitive

Published by gordthompson almost 2 years ago

sqlalchemy-access - Fix reflection with accented table names

Published by gordthompson over 2 years ago

sqlalchemy-access - Fix crash when using NullPool

Published by gordthompson almost 3 years ago

PR courtesy of Chuck Cadman.

sqlalchemy-access - Support reflection for encrypted databases

Published by gordthompson about 3 years ago

sqlalchemy-access - Add support for PK and FK reflection via ACE DAO

Published by gordthompson about 3 years ago

sqlalchemy-access - Enhance reflection of LongText and Single columns

Published by gordthompson about 4 years ago

Original PR courtesy of Kevin Edwards.

sqlalchemy-access - Add warnings for unsupported ODBC functions

Published by gordthompson about 4 years ago

Emit warnings for get_pk_constraint() and get_foreign_keys() instead of just silently returning empty lists.

sqlalchemy-access - Explicit checking for .offset() - not supported

Published by gordthompson over 4 years ago

Raise NotImplementedError instead of silently ignoring .offset() (not supported by Access ODBC). Fixes #8

sqlalchemy-access - Not-equals operator override

Published by gordthompson over 4 years ago

Add not-equals operator override (' <> '). Original PR courtesy of Mark S.

sqlalchemy-access - reflection support for views

Published by gordthompson over 4 years ago

Add reflection support for view names and columns. Original PR courtesy of Carsten Steckel.

sqlalchemy-access - cleanup type mapping

Published by gordthompson about 5 years ago

This release exposes column (field) types that match the field type names in the Microsoft Access UI. For example:

import sqlalchemy
import sqlalchemy_access as sa_a

metadata = sqlalchemy.MetaData()
tbl = sqlalchemy.Table("foo_tbl", metadata,
                       sqlalchemy.Column("id", sa_a.AutoNumber, primary_key=True),
                       sqlalchemy.Column("txt", sa_a.ShortText(50)))