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;"))
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;"))
#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())
