gtfspy icon indicating copy to clipboard operation
gtfspy copied to clipboard

Execution failed on sql

Open Alirezat0 opened this issue 2 years ago • 0 comments

hello, when i run the code it errors and the error is

""" Traceback (most recent call last): File "C:\Users\Asus\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\io\sql.py", line 1681, in execute cur.execute(*args, **kwargs) sqlite3.OperationalError: no such table: stops

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "C:\Users\Asus\Desktop\gtfspy-master - Copy\examples\data\Compute and plot temporal distance profiles between an origin--destination pair.py", line 15, in stop_dict = G.stops().to_dict("index") File "C:\Users\Asus\AppData\Local\Programs\Python\Python38\lib\site-packages\gtfspy\gtfs.py", line 1261, in stops return self.get_table("stops") File "C:\Users\Asus\AppData\Local\Programs\Python\Python38\lib\site-packages\gtfspy\gtfs.py", line 185, in get_table return pd.read_sql("SELECT * FROM " + table_name, self.conn) File "C:\Users\Asus\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\io\sql.py", line 483, in read_sql return pandas_sql.read_query( File "C:\Users\Asus\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\io\sql.py", line 1727, in read_query cursor = self.execute(*args) File "C:\Users\Asus\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\io\sql.py", line 1693, in execute raise ex from exc pandas.io.sql.DatabaseError: Execution failed on sql 'SELECT * FROM stops': no such table: stops

"""

could you please help me ? thanks

Alirezat0 avatar Jul 25 '22 14:07 Alirezat0