Tests fail

[spenoir]

"DatabaseError: current transaction is aborted, commands ignored until end of transaction block"

30 errors when running the tests using nose, the error is the same as above for all tests.

[fdemmer]

i just wanted to work on an issue where None values are not stored as NULL, but as u'None' strings, but unfortunately I also see a lot of tests failing, but with all kinds of different errors:

test_join_lookup_with_expression_01 (djorm_expressions.tests.SqlExpressionsTests) ... ok
test_join_lookup_with_expression_02 (djorm_expressions.tests.SqlExpressionsTests) ... ok
test_join_lookup_with_expression_03 (djorm_expressions.tests.SqlExpressionsTests) ... ok
test_raw_statements_0 (djorm_expressions.tests.SqlExpressionsTests) ... ok
test_string_sample_statement (djorm_expressions.tests.SqlExpressionsTests) ... ok
test_aggregates (djorm_hstore.tests.TestDictionaryField) ... ok
test_annotations (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_empty_instantiation (djorm_hstore.tests.TestDictionaryField) ... ok
test_empty_querying (djorm_hstore.tests.TestDictionaryField) ... ok
test_equivalence_querying (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_hkeys (djorm_hstore.tests.TestDictionaryField) ... ok
test_hkeys_annotation (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_hpeek (djorm_hstore.tests.TestDictionaryField) ... ok
test_hpeek_annotation (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_hremove (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_hslice (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_hslice_annotation (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_hupdate (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_key_value_subset_querying (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_multiple_key_subset_querying (djorm_hstore.tests.TestDictionaryField) ... ok
test_named_querying (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_nested_filtering (djorm_hstore.tests.TestDictionaryField) ... ok
test_query_escaping (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_regression_handler (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_replace_full_dictionary (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_single_key_querying (djorm_hstore.tests.TestDictionaryField) ... ok
test_unicode_processing (djorm_hstore.tests.TestDictionaryField) ... ERROR
test_empty_instantiation (djorm_hstore.tests.TestReferencesField) ... ok
test_empty_querying (djorm_hstore.tests.TestReferencesField) ... ok
test_equivalence_querying (djorm_hstore.tests.TestReferencesField) ... ERROR
test_hkeys (djorm_hstore.tests.TestReferencesField) ... ok
test_hpeek (djorm_hstore.tests.TestReferencesField) ... ok
test_hslice (djorm_hstore.tests.TestReferencesField) ... ERROR
test_multiple_key_subset_querying (djorm_hstore.tests.TestReferencesField) ... ok
test_single_key_querying (djorm_hstore.tests.TestReferencesField) ... ok

most of them fail with: ValueError: dictionary update sequence element #0 has length 1; 2 is required

am i doing it wrong?

[niwinz]

I don't known, but the tests pass ok.

(kk)[3/5.0.2]{1}niwi@localhost:~/devel/djorm-ext-hstore/testing> python runtests.py Creating test database for alias 'default' ('test_test')... Creating tables ... Creating table tests_ref Creating table tests_databag Creating table tests_refsbag Creating table tests_person Creating table tests_profile Creating table tests_node Installing custom SQL ... Installing indexes ... Installed 0 object(s) from 0 fixture(s) test_join_lookup_with_expression_01 (djorm_expressions.tests.SqlExpressionsTests) ... ok test_join_lookup_with_expression_02 (djorm_expressions.tests.SqlExpressionsTests) ... ok test_join_lookup_with_expression_03 (djorm_expressions.tests.SqlExpressionsTests) ... ok test_raw_statements_0 (djorm_expressions.tests.SqlExpressionsTests) ... ok test_string_sample_statement (djorm_expressions.tests.SqlExpressionsTests) ... ok test_aggregates (djorm_hstore.tests.TestDictionaryField) ... ok test_annotations (djorm_hstore.tests.TestDictionaryField) ... ok test_empty_instantiation (djorm_hstore.tests.TestDictionaryField) ... ok test_empty_querying (djorm_hstore.tests.TestDictionaryField) ... ok test_equivalence_querying (djorm_hstore.tests.TestDictionaryField) ... ok test_hkeys (djorm_hstore.tests.TestDictionaryField) ... ok test_hkeys_annotation (djorm_hstore.tests.TestDictionaryField) ... ok test_hpeek (djorm_hstore.tests.TestDictionaryField) ... ok test_hpeek_annotation (djorm_hstore.tests.TestDictionaryField) ... ok test_hremove (djorm_hstore.tests.TestDictionaryField) ... ok test_hslice (djorm_hstore.tests.TestDictionaryField) ... ok test_hslice_annotation (djorm_hstore.tests.TestDictionaryField) ... ok test_hupdate (djorm_hstore.tests.TestDictionaryField) ... ok test_key_value_subset_querying (djorm_hstore.tests.TestDictionaryField) ... ok test_multiple_key_subset_querying (djorm_hstore.tests.TestDictionaryField) ... ok test_named_querying (djorm_hstore.tests.TestDictionaryField) ... ok test_nested_filtering (djorm_hstore.tests.TestDictionaryField) ... ok test_query_escaping (djorm_hstore.tests.TestDictionaryField) ... ok test_regression_handler (djorm_hstore.tests.TestDictionaryField) ... ok test_replace_full_dictionary (djorm_hstore.tests.TestDictionaryField) ... ok test_single_key_querying (djorm_hstore.tests.TestDictionaryField) ... ok test_unicode_processing (djorm_hstore.tests.TestDictionaryField) ... ok test_empty_instantiation (djorm_hstore.tests.TestReferencesField) ... ok test_empty_querying (djorm_hstore.tests.TestReferencesField) ... ok test_equivalence_querying (djorm_hstore.tests.TestReferencesField) ... ok test_hkeys (djorm_hstore.tests.TestReferencesField) ... ok test_hpeek (djorm_hstore.tests.TestReferencesField) ... ok test_hslice (djorm_hstore.tests.TestReferencesField) ... ok test_multiple_key_subset_querying (djorm_hstore.tests.TestReferencesField) ... ok test_single_key_querying (djorm_hstore.tests.TestReferencesField) ... ok

---

Ran 35 tests in 0.289s

OK Destroying test database for alias 'default' ('test_test')... (kk)[3/5.0.2]niwi@localhost:~/devel/djorm-ext-hstore/testing> pip freeze Django==1.5.1 djorm-ext-core==0.4.2 djorm-ext-expressions==0.4.4 psycopg2==2.4.2 wsgiref==0.1.2

[niwinz]

Seems duplicate to #11

[fdemmer]

wow, there is an evil bug somewhere... i started fresh with new clone and virtualenv with your package suggestions on another machine: works. so then i created a new virtualenv on the notebook, where it failed before: it still fails!

EDIT: of course both times tests were run with postgres and hstore extension.

[spenoir]

Can I recommend that one should never take test results run on a sqllite database seriously. I'm happy to help get the tests working if I come across any bugs.

thanks, adam

On Tue, Jun 18, 2013 at 7:31 PM, Florian Demmer notifications@github.comwrote:

wow, there is an evil bug somewhere... i started fresh with new clone and virtualenv with your package suggestions on another machine: works. so then i created a new virtualenv on the notebook, where it failed before: it still fails!

— Reply to this email directly or view it on GitHubhttps://github.com/niwibe/djorm-ext-hstore/issues/12#issuecomment-19631077 .

[niwinz]

This problems it seems due to oid registration when you database have hstore instaled manually instead of use template1 database for install hstore.

Detailed explanation: https://github.com/niwibe/djorm-ext-hstore/issues/11#issuecomment-20119075