sqlbag
sqlbag copied to clipboard
Handy python code for doing database things.
Following test seem to fail, when run with the latest versions of all dependencies: ``` "test_basic" "test_createdrop" "test_errors_and_messages" "test_flask_integration" "test_orm_stuff" "test_pendulum_for_time_types" "test_transaction_separation" ``` The issue seems to be caused by...
I'm building a fork of `migra`. It includes `schemainspect` package. That relays on `sqlbag[pg]`. That wants `psycopg2` (not `psycopg2-binary`) in turn. The box where I have to run the code...
- Replace Engine.execute with Connection.execute - Ensure all raw SQL strings are wrapped in sqlalchemy.text - Use explicit bound parameter dicts (see https://docs.sqlalchemy.org/en/20/changelog/migration_20.html#execute-method-more-strict-execution-options-are-more-prominent) `tests/test_pg.py::test_errors_and_messages` is failing for me, but it...
I'm running into a permission error on windows when using the temp file in testing. Not sure if that's me or the implementation only considers the linux environment. (https://stackoverflow.com/questions/23212435/permission-denied-to-write-to-my-temporary-file) Say...
:wave: Looks like this change in SQLAlchemy 1.4.0 is a problem: https://docs.sqlalchemy.org/en/14/changelog/migration_14.html#the-url-object-is-now-immutable ``` @contextmanager def admin_db_connection(db_url): url = copy_url(db_url) dbtype = url.get_dialect().name if dbtype == "postgresql": > url.database = ""...
This line breaks: https://github.com/djrobstep/sqlbag/blob/master/sqlbag/sqla.py#L160 Because connect_args is a dict
I am trying to connect to postgres db hosted inside docker. Because I am connecting to it from outside docker I should specify username and password. But currently it seems...