python query方法_Python pandas.read_sql_query()常用操作方法代码

1、测试数据库连接问题代码def test_connectable_issue_example(self):

# This tests the example raised in issue

# https://github.com/pydata/pandas/issues/10104

def foo(connection):

query = 'SELECT test_foo_data FROM test_foo_data'

return sql.read_sql_query(query, con=connection)

def bar(connection, data):

data.to_sql(name='test_foo_data',

con=connection, if_exists='append')

def main(connectable):

with connectable.connect() as conn:

with conn.begin():

foo_data = conn.run_callable(foo)

conn.run_callable(bar, foo_data)

DataFrame({'test_foo_data': [0, 1, 2]}).to_sql(

'test_foo_data', self.conn)

main(self.conn)

2、临时表相关操作示例代码def test_temporary_table(self):

test_data = u'Hello, World!'

expected = DataFrame({'spam': [tes