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.
