def test_execute_method_with_table_not_found(self): sqldf = SQLDF(self.default_env) self.assertRaises(Exception, lambda: sqldf.execute("select * from notable")) # table deleted self.assertRaises(sqlite3.OperationalError, lambda: sqldf.conn.execute("select * from df;"))
def test_execute_method(self): sqldf = SQLDF(self.default_env) query = "select * from df;" result = sqldf.execute(query) assert_frame_equal(result, self.default_df) # table deleted self.assertRaises(sqlite3.OperationalError, lambda: sqldf.conn.execute(query))
def test_execute_method_with_table_not_found(self): sqldf = SQLDF(self.default_env) self.assertRaises( Exception, lambda: sqldf.execute("select * from notable")) # table deleted self.assertRaises(sqlite3.OperationalError, lambda: sqldf.conn.execute("select * from df;"))
def test_execute_method(self): sqldf = SQLDF(self.default_env) query = "select * from df;" result = sqldf.execute(query) assert_frame_equal(result, self.default_df) # table deleted self.assertRaises( sqlite3.OperationalError, lambda: sqldf.conn.execute(query))
query = """ SELECT id, 'LINESTRING(' || GROUP_CONCAT(p) || ')' AS wkt FROM ( SELECT id, t, x || ' ' || y AS p FROM pointset WHERE id = {0} AND t BETWEEN {1} AND {2} ORDER BY t ) GROUP BY id """.format(pid, start, end) traj = sqldf.execute(query) traj = '{0}\t"{1}"\n'.format(fid, traj['wkt'][0]) print(traj) trajs.append(traj) query = """ SELECT id, x, y, t FROM pointset WHERE id = {0} AND t BETWEEN {1} AND {2} ORDER BY t, id """.format(pid, start, end) pointsInTraj = sqldf.execute(query)
def test_execute_method_with_query_error(self): sqldf = SQLDF(self.default_env) self.assertEqual(sqldf.execute("select a from df uuuuuu;"), None) # table deleted self.assertRaises(sqlite3.OperationalError, lambda: sqldf.conn.execute("select * from df;"))
def test_execute_method_with_table_not_found(self): sqldf = SQLDF(self.default_env) self.assertIsNone(sqldf.execute("select * from notable;"))
def test_invalid_colname(self): data = [{"a": "valid", "(b)": "invalid"}] sqldf = SQLDF(locals()) self.assertIsNone(sqldf.execute("select * from data;"))
def test_invalid_colname(self): data = [{"a": "valid", "(b)": "invalid"}] sqldf = SQLDF(locals()) self.assertRaises( Exception, lambda: sqldf.execute("select * from data;"))
#pip install pysqldf from pysqldf import SQLDF, load_meat, load_births sqldf = SQLDF(globals()) meat = load_meat() births = load_births() print(sqldf.execute("SELECT * FROM meat LIMIT 10;").head())
def test_invalid_colname(self): data = [{"a": "valid", "(b)": "invalid"}] sqldf = SQLDF(locals()) self.assertRaises(Exception, lambda: sqldf.execute("select * from data;"))
# -*- coding: utf-8 -*- """ Spyder Editor This is a temporary script file. """ from pysqldf import SQLDF, load_meat, load_births sqldf = SQLDF(globals()) meat = load_meat() births = load_births() print(sqldf.execute("SELECT * FROM meat LIMIT 10;").head()) print(sqldf.execute("SELECT * FROM births order by date;").head())