sqlalchemy-monetdb

sqlalchemy-monetdb copied to clipboard

Sqlalchemy doesn't seem to manage thread-unsafe monetdb connections very well

2

Hi, In our application we are trying to launch multiple parallel monetdb queries through sqlalchemy using scoped_session to generate thread_local session objects. However it seems that pymonetdb / sqlalchemy-monetdb cannot...

aris-koning

An error is raised when trying to inspect tables with columns with the timestamptz type ``` ~/Documentos/celero/celerov2-service-ai/env/lib/python3.5/site-packages/sqlalchemy_monetdb/dialect.py in get_columns(self, connection, table_name, schema, **kw) 178 args = (row.type_digits, row.type_scale) 179 col_type...

rudolfce

19 new failing tests for 1.2 in test_types.py and test_select.py

4

``` test/test_suite.py::JSONTest::test_crit_against_int_basic test/test_suite.py::JSONTest::test_crit_against_int_coerce_type test/test_suite.py::JSONTest::test_crit_against_string_basic test/test_suite.py::JSONTest::test_crit_against_string_coerce_type test/test_suite.py::JSONTest::test_crit_mixed_path test/test_suite.py::JSONTest::test_crit_simple_int test/test_suite.py::JSONTest::test_crit_spaces_in_key test/test_suite.py::JSONTest::test_crit_string_path test/test_suite.py::JSONTest::test_eval_none_flag_orm test/test_suite.py::JSONTest::test_round_trip_data1 test/test_suite.py::JSONTest::test_round_trip_json_null_as_json_null test/test_suite.py::JSONTest::test_round_trip_none_as_json_null test/test_suite.py::JSONTest::test_round_trip_none_as_sql_null test/test_suite.py::JSONTest::test_unicode_round_trip test/test_suite.py::LastrowidTest_monetdb+pymonetdb::test_autoincrement_on_insert test/test_suite.py::LastrowidTest_monetdb+pymonetdb::test_last_inserted_id test/test_suite.py::LastrowidTest_monetdb+pymonetdb::test_native_lastrowid_autoinc test/test_suite.py::LikeFunctionsTest_monetdb+pymonetdb::test_contains_autoescape test/test_suite.py::LikeFunctionsTest_monetdb+pymonetdb::test_contains_autoescape_escape test/test_suite.py::LikeFunctionsTest_monetdb+pymonetdb::test_contains_escape test/test_suite.py::LikeFunctionsTest_monetdb+pymonetdb::test_contains_unescaped test/test_suite.py::LikeFunctionsTest_monetdb+pymonetdb::test_endswith_autoescape test/test_suite.py::LikeFunctionsTest_monetdb+pymonetdb::test_endswith_autoescape_escape test/test_suite.py::DateTimeMicrosecondsTest::test_literal test/test_suite.py::DateTimeMicrosecondsTest::test_null test/test_suite.py::DateTimeMicrosecondsTest::test_round_trip test/test_suite.py::AutocommitTest::test_autocommit_off test/test_suite.py::AutocommitTest::test_autocommit_on ```...

gijzelaerr

5 failing tests in ComponentReflectionTest

1

``` test/test_suite.py:23 (ComponentReflectionTest_monetdb+pymonetdb.test_get_foreign_keys) Traceback (most recent call last): File "/Users/gijs/Work/sqlalchemy-monetdb/test/test_suite.py", line 27, in test_get_foreign_keys self._test_get_foreign_keys(schema='test_schema2') File "", line 2, in _test_get_foreign_keys File "/Users/gijs/Work/sqlalchemy-monetdb/.venv2/lib/python2.7/site-packages/sqlalchemy/testing/util.py", line 196, in provide_metadata return fn(*args, **kw)...

gijzelaerr

test_group_by_composed test fail

2

``` Traceback (most recent call last): File "/home/gijs/Work/sqlalchemy-monetdb/.venv3/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context context) File "/home/gijs/Work/sqlalchemy-monetdb/.venv3/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute cursor.execute(statement, parameters) File "/home/gijs/Work/sqlalchemy-monetdb/.venv3/lib/python3.5/site-packages/pymonetdb/sql/cursors.py", line 164, in execute block = self.connection.execute(query)...

gijzelaerr

Add support for MonetDBLite for Python

4

Anything we can do to help? See https://www.monetdb.org/blog/monetdblite-for-python

hannes

In the new monetdb released version, sqlalchemy stopped working. I am using python3.10 and SQLAlchemy 2.0.41 and MonetDB 11.53.9 I found 2 main problems. **1. The new monetdb version cannot...

ThanKarab