Process option

The process option takes a prefix, optional suffix and optional year then iterates over all csv files with those properties. For each file, an sql table is created with all columns as text and an additional year column added.

The process option will attempt to create a view using columns and names define in a python script. The file is expected to have the form prefix_suffix.py with the '_' omitted if no suffix exists. The column names are to be specified as a list of tuples with the table's name first then name for the view and code. If no file is found, common column names and data types are used for the view.