def runTool(inGTFSdir, SQLDbase):
try:
BBB_SharedFunctions.CheckArcVersion(min_version_pro="1.2")
#----- SQLize the GTFS data-----
arcpy.AddMessage("SQLizing the GTFS data...")
arcpy.AddMessage("(This will take a while for large datasets.)")
# GTFS files
if not SQLDbase.lower().endswith(".sql"):
SQLDbase = SQLDbase + ".sql"
# Fix up list of GTFS datasets
inGTFSdirList = inGTFSdir.split(";")
# Remove single quotes ArcGIS puts in if there are spaces in the filename.
for d in inGTFSdirList:
if d[0] == "'" and d[-1] == "'":
loc = inGTFSdirList.index(d)
inGTFSdirList[loc] = d[1:-1]
# The main SQLizing work is done in the sqlize_csv module
# written by Luitien Pan.
# Connect to or create the SQL file.
sqlize_csv.connect(SQLDbase)
# Create tables.
for tblname in sqlize_csv.sql_schema:
sqlize_csv.create_table(tblname)
# SQLize all the GTFS files, for each separate GTFS dataset.
for gtfs_dir in inGTFSdirList:
# handle_agency checks for blank values in arrival_time and departure_time
sqlize_csv.handle_agency(gtfs_dir)
# Create indices to make queries faster.
sqlize_csv.create_indices()
# Check for non-overlapping date ranges to prevent double-counting.
overlapwarning = sqlize_csv.check_nonoverlapping_dateranges()
if overlapwarning:
arcpy.AddWarning(overlapwarning)
arcpy.AddMessage("Successfully created SQL database of GTFS data:")
arcpy.AddMessage("- " + SQLDbase)
except BBB_SharedFunctions.CustomError:
arcpy.AddMessage("Failed to create SQL database of GTFS data.")
pass
except:
arcpy.AddMessage("Failed to create SQL database of GTFS data.")
raise
def runTool(inGTFSdir, SQLDbase):
try:
BBB_SharedFunctions.CheckArcVersion(min_version_pro="1.2")
#----- SQLize the GTFS data-----
arcpy.AddMessage("SQLizing the GTFS data...")
arcpy.AddMessage("(This will take a while for large datasets.)")
# GTFS files
if not SQLDbase.lower().endswith(".sql"):
SQLDbase = SQLDbase + ".sql"
# Fix up list of GTFS datasets
inGTFSdirList = inGTFSdir.split(";")
# Remove single quotes ArcGIS puts in if there are spaces in the filename.
for d in inGTFSdirList:
if d[0] == "'" and d[-1] == "'":
loc = inGTFSdirList.index(d)
inGTFSdirList[loc] = d[1:-1]
# The main SQLizing work is done in the sqlize_csv module
# written by Luitien Pan.
# Connect to or create the SQL file.
sqlize_csv.connect(SQLDbase)
# Create tables.
for tblname in sqlize_csv.sql_schema:
sqlize_csv.create_table(tblname)
# SQLize all the GTFS files, for each separate GTFS dataset.
for gtfs_dir in inGTFSdirList:
# handle_agency checks for blank values in arrival_time and departure_time
sqlize_csv.handle_agency(gtfs_dir)
# Create indices to make queries faster.
sqlize_csv.create_indices()
# Check for non-overlapping date ranges to prevent double-counting.
overlapwarning = sqlize_csv.check_nonoverlapping_dateranges()
if overlapwarning:
arcpy.AddWarning(overlapwarning)
arcpy.AddMessage("Successfully created SQL database of GTFS data:")
arcpy.AddMessage("- " + SQLDbase)
except BBB_SharedFunctions.CustomError:
arcpy.AddMessage("Failed to create SQL database of GTFS data.")
pass
except:
arcpy.AddMessage("Failed to create SQL database of GTFS data.")
raise
for tblname in sqlize_csv.sql_schema:
sqlize_csv.create_table(tblname)
# SQLize all the GTFS files, for each separate GTFS dataset.
for gtfs_dir in inGTFSdirList:
# Run sqlize for each GTFS dataset. Check for returned errors
GTFSErrors = sqlize_csv.handle_agency(gtfs_dir)
if GTFSErrors:
for error in GTFSErrors:
arcpy.AddError(error)
raise CustomError
# Create indices to make queries faster.
sqlize_csv.create_indices()
# Check for non-overlapping date ranges to prevent double-counting.
overlapwarning = sqlize_csv.check_nonoverlapping_dateranges()
if overlapwarning:
arcpy.AddWarning(overlapwarning)
# ----- Connect to SQL locally for further queries and entries -----
# Connect to the SQL database
conn = sqlite3.connect(SQLDbase)
c = conn.cursor()
# ----- Make dictionary of route types -----
# Find all routes and associated info.
RouteDict = {}
routesfetch = '''
SELECT route_id, route_type
# Create tables.
for tblname in sqlize_csv.sql_schema:
sqlize_csv.create_table(tblname)
# SQLize all the GTFS files, for each separate GTFS dataset.
for gtfs_dir in inGTFSdirList:
# handle_agency checks for blank values in arrival_time and departure_time
GTFSErrors = sqlize_csv.handle_agency(gtfs_dir)
if GTFSErrors:
for error in GTFSErrors:
arcpy.AddError(error)
raise CustomError
# Create indices to make queries faster.
sqlize_csv.create_indices()
# Check for non-overlapping date ranges to prevent double-counting.
overlapwarning = sqlize_csv.check_nonoverlapping_dateranges()
if overlapwarning:
arcpy.AddWarning(overlapwarning)
arcpy.AddMessage("Successfully created SQL database of GTFS data:")
arcpy.AddMessage("- " + SQLDbase)
except CustomError:
arcpy.AddMessage("Failed to create SQL database of GTFS data.")
pass
except:
arcpy.AddMessage("Failed to create SQL database of GTFS data.")
raise