The model Module

index_method(c: str) -> (<class 'str'>, None)

unquote(s: str) → str

load_range(n, f) → int

csv_reader(data, unquote=True)

class CustomColumn(name, type, extraction_method)

extract_value(input_source)

class Table(metadata_file: Optional[str] = None, get_entry=None, concurrent_indices: bool = False, data_file: Optional[str] = None, column_name_replacement: Optional[Dict] = None)

save(to_dir)

fopen(source)

get_index_ddl(column, method)

add_column(name, type, extraction_method)

make_column(name, type, sql, cursor, index=False, include_in_index=None)

make_fips_column(cursor)

make_iso_column(anchor, cursor, include=None)

Add US State ISO 3166-2 code Source: https://simplemaps.com/data/us-cities

Parameters

• anchor – existing column to use to calculate state iso code

• cursor – Database cursor

• include – Additional data (column) to include in index on the new column

Returns

parse_fips12(cursor)

make_int_column(cursor, source: str, target: str, index: bool)

analyze(entry=None)

create(cursor)

build_indices(cursor, flag: Optional[str] = None)

drop(cursor)

type_from_metadata(c: int) → Optional[str]

guess_types(rows: list, lines: list)

add_data(cursor, entry)

copy_data(cursor, input_source)

static log_progress(t0, t1, chars, lines, N)