I can reproduce this error in .8 and .9 series.
My SQL creation script:
*create table invited_players (*
* invited_player_id integer NOT NULL primary key,*
* game_id integer NOT NULL,*
* player_id integer NOT NULL*
*);*
*
*
*alter sequence invited_player_id_seq owned by
invited_players.invited_player_id;*
*
*
*create index invited_play_game_id_idx on invited_players (game_id);*
My python:
*#!/usr/local/bin/python3*
*
*
*from sqlalchemy import create_engine*
*from sqlalchemy import create_engine, Integer, Column, MetaData, Table,
Sequence*
*from sqlalchemy.orm import mapper, sessionmaker*
*
*
*class InvitedPlayers:*
* pass*
*
*
*engine =
create_engine("postgresql+pypostgresql://username:@localhost:5432/dbname",
echo=True)*
*metadata = MetaData()*
*metadata.bind = engine*
*
*
*invitedPlayers = Table("invited_players", metadata,*
* Column("invited_player_id", Integer, Sequence('invited_player_id_seq'),
primary_key=True),*
* autoload=True)*
The error I receive below occurs when there are two indexes on the table
(the implicit primary key one and the explicit one I create on game_id). If
only the primary key index exists then sqlalchemy reflects the table
properly. Here's the error:
*Traceback (most recent call last):*
* File "./autoload.py", line 16, in <module>*
* autoload=True)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/sql/schema.py",
line 355, in __new__*
* table._init(name, metadata, *args, **kw)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/sql/schema.py",
line 428, in _init*
* self._autoload(metadata, autoload_with, include_columns)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/sql/schema.py",
line 456, in _autoload*
* self, include_columns, exclude_columns*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/engine/base.py",
line 1579, in run_callable*
* return conn.run_callable(callable_, *args, **kwargs)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/engine/base.py",
line 1107, in run_callable*
* return callable_(self, *args, **kwargs)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/engine/default.py",
line 296, in reflecttable*
* return insp.reflecttable(table, include_columns, exclude_columns)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/engine/reflection.py",
line 576, in reflecttable*
* indexes = self.get_indexes(table_name, schema)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/engine/reflection.py",
line 383, in get_indexes*
* info_cache=self.info_cache, **kw)*
* File "<string>", line 1, in <lambda>*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/engine/reflection.py",
line 53, in cache*
* ret = fn(self, con, *args, **kw)*
* File
"/Library/Frameworks/Python.framework/Versions/3.3/lib/python3.3/site-packages/sqlalchemy/dialects/postgresql/base.py",
line 2014, in get_indexes*
* index['key'] = [int(k.strip()) for k in idx_key.split()]*
*AttributeError: 'Array' object has no attribute 'split'*
--
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 http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
