使用pandas v.2.1.2和SQLAlchemy >= 2.0.22可以对参数和“本机”strsql字符串使用psycopg2语法。
File"D:\Program Files (x86)\Python39\lib\site-packages\sqlalchemy\engine\base.py", line 1412,inexecuteraiseexc.ObjectNotExecutableError(statement)fromerr sqlalchemy.exc.ObjectNotExecutableError: Not an executable object:'select max(id) as maxrid FROM tspro_stock_basic' 继续查看 read_sql() 的...
使用pandas v.2.1.2和SQLAlchemy >= 2.0.22可以对参数和“本机”strsql字符串使用psycopg2语法。
Pandas version checks I have checked that this issue has not already been reported. I have confirmed this bug exists on the latest version of pandas. I have confirmed this bug exists on the main branch of pandas. Reproducible Example imp...
Describe the bug When using the pd.read_sql function in pandas, the SQLAlchemy "do_orm_execute" event is not triggered, so logic tied to that event will not run. If for example, the application is using the do_orm_execute event to enforc...
986 raise exc.ObjectNotExecutableError(object_) 987 else: --> 988 return meth(self, multiparams, params) 989 990 def _execute_function(self, func, multiparams, params): c:\users\(me)\documents\pyenv\dataproc\lib\site-packages\sqlalchemy\sql\elements.py in _execute_on_connection(self, con...
Code Sample, a copy-pastable example if possible import pandas content = open('failing_pandas.json').readline() pd = pandas.read_json(content, lines=True) Problem description This issue happens on 0.21.1+ and doesn't happen on 0.21.0 for...