If the datatype of in database is Varchar its working fine, error comes only with integer. Any help here is highly appreciated.
Best Regards, Nikhil On Sunday, 31 July 2016 22:28:27 UTC+5:30, Nikhil S Menon wrote: > > i am using *SQLAlchemy-1.0.5.* > > > i have an external db with a table having integer. while i run the select > query i am getting below error. > > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 914, in execute > return meth(self, multiparams, params) > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", > > line 323, in _execute_on_connection > return connection._execute_clauseelement(self, multiparams, params) > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 1010, in _execute_clauseelement > compiled_sql, distilled_params > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 1146, in _execute_context > context) > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 1334, in _handle_dbapi_exception > self._autorollback() > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 791, in _autorollback > self._root._rollback_impl() > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 670, in _rollback_impl > self._handle_dbapi_exception(e, None, None, None, None) > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 1266, in _handle_dbapi_exception > exc_info > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", > > line 202, in raise_from_cause > reraise(type(exception), exception, tb=exc_tb, cause=cause) > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", > > line 668, in _rollback_impl > self.engine.dialect.do_rollback(self.connection) > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", > > line 420, in do_rollback > dbapi_connection.rollback() > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/pg8000/core.py", line > 1751, in rollback > self.execute(self._cursor, "rollback", None) > File > "/home/nfs/nikhil/local/lib/python2.7/site-packages/pg8000/core.py", line > 2016, in execute > self._flush() > File "/usr/lib/python2.7/socket.py", line 303, in flush > self._sock.sendall(view[write_offset:write_offset+buffer_size]) > sqlalchemy.exc.DBAPIError: (exceptions.AttributeError) 'NoneType' object > has no attribute 'sendall' > No handlers could be found for logger "sqlalchemy.pool.QueuePool" > > > *sqlalchemy.exc.DBAPIError: (exceptions.AttributeError) 'NoneType' object > has no attribute 'sendall'* > > > *from sqlalchemy import ** > *def connect_db(db):* > * > engine=create_engine('postgresql+pg8000://postgres@10.102.31.123:5432/%s'%db)* > * return engine* > > *def load_table(table_name):* > * table_data = Table(table_name, m, autoload=True, > autoload_with=engine)* > * return table_data* > > *def get_all_tables_data():* > * m.reflect(bind=engine)* > * for table in m.tables:* > * print "%s\n---------\n"%table* > * table_data = load_table(table)* > * q = select([table_data])* > * print q* > * res = conn.execute(q)* > * for row in res:* > * print row* > *engine = connect_db("db")* > *m = MetaData(engine)* > *conn = engine.connect()* > *get_all_tables_data()* > > > Its happening with external database only when I use the sqlalchemy > library in python. If i use postgres shell its working. Please find below > details from postgres interface. > > db=# \d mas_license; > Table "public.mas_license" > Column | Type | Modifiers > ----------------+-------------------+----------- > id | character varying | not null > node_id | character varying | > rpt_sampletime | bigint | > max_vips | character varying | > pooled_lic | integer | > cpx_lic | integer | > perf | integer | > snmp_traps | integer | > syslog | integer | > analytics | integer | > adv_analytics | integer | > Indexes: > "mas_license_pkey" PRIMARY KEY, btree (id) > > =# select * from mas_license; > id | node_id | rpt_sampletime | > max_vips | pooled_lic | > cpx_lic | perf | snmp_traps | syslog | analytics | adv_analytics > > --------------------------------------+---------+----------------+------------------------------------------------------------------+------------+---------+------+------------+--------+-----------+--------------- > 5-34 | | 1469625865 | f6f6-34437c | 1 | 1 | > 3 | 3 | 3 | 3 | 1 > (1 row) > > Using pgxl as external database. > > > Best Regards, > Nikhil > -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.