Hi everyone,
I am testing hana with sqlalchemy and the all the ComponentReflectionTests
show an error. The traceback for test_varchar_reflection is as follows:
ERROR at setup of
ComponentReflectionTest_hana+hdbcli.test_varchar_reflection
Traceback (most recent call last):
File "build\bdist.win-amd64\egg\sqlalchemy\testing\fixtures.py", line 83,
in setup_class
cls._setup_once_tables()
File "build\bdist.win-amd64\egg\sqlalchemy\testing\fixtures.py", line
112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "build\bdist.win-amd64\egg\sqlalchemy\sql\schema.py", line 3992, in
create_all
tables=tables)
File "build\bdist.win-amd64\egg\sqlalchemy\engine\base.py", line 1940, in
_run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "build\bdist.win-amd64\egg\sqlalchemy\engine\base.py", line 1549, in
_run_visitor
**kwargs).traverse_single(element)
File "build\bdist.win-amd64\egg\sqlalchemy\sql\visitors.py", line 121, in
traverse_single
return meth(obj, **kw)
File "build\bdist.win-amd64\egg\sqlalchemy\sql\ddl.py", line 757, in
visit_metadata
_is_metadata_operation=True)
File "build\bdist.win-amd64\egg\sqlalchemy\sql\visitors.py", line 121, in
traverse_single
return meth(obj, **kw)
File "build\bdist.win-amd64\egg\sqlalchemy\sql\ddl.py", line 791, in
visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "build\bdist.win-amd64\egg\sqlalchemy\engine\base.py", line 948, in
execute
return meth(self, multiparams, params)
File "build\bdist.win-amd64\egg\sqlalchemy\sql\ddl.py", line 68, in
_execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "build\bdist.win-amd64\egg\sqlalchemy\engine\base.py", line 1009, in
_execute_ddl
compiled
File "build\bdist.win-amd64\egg\sqlalchemy\engine\base.py", line 1200, in
_execute_context
context)
File "build\bdist.win-amd64\egg\sqlalchemy\engine\base.py", line 1413, in
_handle_dbapi_exception
exc_info
File "build\bdist.win-amd64\egg\sqlalchemy\util\compat.py", line 203, in
raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "build\bdist.win-amd64\egg\sqlalchemy\engine\base.py", line 1193, in
_execute_context
context)
File "build\bdist.win-amd64\egg\sqlalchemy\engine\default.py", line 507,
in do_execute
cursor.execute(statement, parameters)
File "C:\Python27\Lib\site-packages\hdbcli\dbapi.py", line 383, in execute
ret = self.__execute(operation, parameters)
File "C:\Python27\Lib\site-packages\hdbcli\dbapi.py", line 254, in
__execute
ret = self.__cursor.execute(operation, parameters=parameters,
iscall=iscall, scrollable=self._scrollable)
DBAPIError: (hdbcli.dbapi.Error) (365, 'no matching primary key for this
column list: line 2 col 1 (at pos 1)') [SQL: u'\nCREATE TABLE
email_addresses (\n\taddress_id INTEGER NOT NULL, \n\tremote_user_id
INTEGER, \n\temail_address VARCHAR(20), \n\tCONSTRAINT email_ad_pk PRIMARY
KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users
(user_id)\n)\n\n']
Does one manually have to create some tables for this test? Or can this be
a Problem of the hana Driver dpabi? Are there some tables or Schemas that
must already exist in the database? Please excuse me if thats a very Basic
question. If I am not wrong, the test isnt even getting executed since the
Setup Fails, but what could I be doing wrong?
Wishes,
S
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
