Index

A

Adapter (class in shillelagh.adapters.base) AdapterLoader (class in shillelagh.adapters.registry) add() (shillelagh.adapters.registry.AdapterLoader method) adjust_value() (in module shillelagh.adapters.api.gsheets.parsing.number) AM (shillelagh.adapters.api.gsheets.parsing.date.Meridiem attribute) AMPM (class in shillelagh.adapters.api.gsheets.parsing.date) analyze() (in module shillelagh.lib)

ANY (shillelagh.fields.Order attribute) AP (class in shillelagh.adapters.api.gsheets.parsing.date) apply_limit_and_offset() (in module shillelagh.lib) APSWDialect (class in shillelagh.backends.apsw.dialects.base) APSWSafeDialect (class in shillelagh.backends.apsw.dialects.safe) ASCENDING (shillelagh.fields.Order attribute) AT (class in shillelagh.adapters.api.gsheets.parsing.number) autoincrement (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute)

B

BATCH (shillelagh.adapters.api.gsheets.types.SyncMode attribute) best_index_object_available() (in module shillelagh.lib) BestIndex() (shillelagh.backends.apsw.vt.VTTable method) BestIndexObject() (shillelagh.backends.apsw.vt.VTTable method) BIDIRECTIONAL (shillelagh.adapters.api.gsheets.types.SyncMode attribute) Binary() (in module shillelagh.backends.apsw.db) (in module shillelagh.db) (in module shillelagh.types) Blob (class in shillelagh.fields)

Boolean (class in shillelagh.fields) build() (shillelagh.filters.Equal class method) (shillelagh.filters.Filter class method) (shillelagh.filters.Impossible class method) (shillelagh.filters.IsNotNull class method) (shillelagh.filters.IsNull class method) (shillelagh.filters.Like class method) (shillelagh.filters.NotEqual class method) (shillelagh.filters.Range class method) build_sql() (in module shillelagh.lib)

C

c (shillelagh.adapters.api.gsheets.typing.QueryResultsRow attribute) cachedContents (shillelagh.adapters.api.socrata.MetadataColumn attribute) chance_of_rain (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) chance_of_snow (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) check() (shillelagh.filters.Equal method) (shillelagh.filters.Filter method) (shillelagh.filters.Impossible method) (shillelagh.filters.IsNotNull method) (shillelagh.filters.IsNull method) (shillelagh.filters.Like method) (shillelagh.filters.NotEqual method) (shillelagh.filters.Range method) check_row_id() (shillelagh.lib.RowIDManager method) clear() (shillelagh.adapters.registry.AdapterLoader method) close() (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) Close() (shillelagh.backends.apsw.vt.VTCursor method) cloud (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) COLOR (class in shillelagh.adapters.api.gsheets.parsing.number) cols (shillelagh.adapters.api.gsheets.typing.QueryResultsTable attribute)

colspecs (shillelagh.backends.apsw.dialects.base.APSWDialect attribute) Column() (shillelagh.backends.apsw.vt.VTCursor method) combine_args_kwargs() (in module shillelagh.lib) combine_time_filters() (in module shillelagh.adapters.api.weatherapi) COMMA (class in shillelagh.adapters.api.gsheets.parsing.number) comment (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) computed (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) ComputedColumn (class in shillelagh.backends.apsw.dialects.base) CONDITION (class in shillelagh.adapters.api.gsheets.parsing.number) condition_matches() (in module shillelagh.adapters.api.gsheets.parsing.number) Connect() (shillelagh.backends.apsw.vt.VTModule method) consume() (shillelagh.adapters.api.gsheets.parsing.base.Token class method) (shillelagh.adapters.api.gsheets.parsing.date.DurationToken class method) convert_rows_from_sqlite() (in module shillelagh.backends.apsw.vt) convert_rows_to_sqlite() (in module shillelagh.backends.apsw.vt) Create() (shillelagh.backends.apsw.vt.VTModule method) create_connect_args() (shillelagh.backends.apsw.dialects.base.APSWDialect method) (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect method) create_namespaced_cache_key() (in module shillelagh.lib) CSVFile (class in shillelagh.adapters.file.csvfile)

D

D (class in shillelagh.adapters.api.gsheets.parsing.date) DatabaseError, [1], [2] DataError, [1], [2] DatasetteAPI (class in shillelagh.adapters.api.datasette) dataTypeName (shillelagh.adapters.api.socrata.MetadataColumn attribute) Date (class in shillelagh.fields) Date() (in module shillelagh.backends.apsw.db) (in module shillelagh.db) (in module shillelagh.types) date_trunc() (in module shillelagh.functions) DateFromTicks() (in module shillelagh.backends.apsw.db) (in module shillelagh.db) (in module shillelagh.types) DateParseError DateTime (class in shillelagh.fields) db_api_type (shillelagh.adapters.api.gsheets.fields.GSheetsBoolean attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsDate attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsDateTime attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsDuration attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsNumber attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsString attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsTime attribute) (shillelagh.adapters.api.socrata.Number attribute) (shillelagh.fields.Blob attribute) (shillelagh.fields.Boolean attribute) (shillelagh.fields.Date attribute) (shillelagh.fields.DateTime attribute) (shillelagh.fields.Decimal attribute) (shillelagh.fields.Duration attribute) (shillelagh.fields.Field attribute) (shillelagh.fields.Float attribute) (shillelagh.fields.IntBoolean attribute) (shillelagh.fields.Integer attribute) (shillelagh.fields.ISODate attribute) (shillelagh.fields.ISODateTime attribute) (shillelagh.fields.ISOTime attribute) (shillelagh.fields.RowID attribute) (shillelagh.fields.String attribute) (shillelagh.fields.StringBlob attribute) (shillelagh.fields.StringBoolean attribute) (shillelagh.fields.StringDecimal attribute) (shillelagh.fields.StringDuration attribute) (shillelagh.fields.StringInteger attribute) (shillelagh.fields.Time attribute) (shillelagh.fields.Unknown attribute)

dbapi() (shillelagh.backends.apsw.dialects.base.APSWDialect class method) DBAPIType (class in shillelagh.types) DD (class in shillelagh.adapters.api.gsheets.parsing.date) DDD (class in shillelagh.adapters.api.gsheets.parsing.date) DDDDPlus (class in shillelagh.adapters.api.gsheets.parsing.date) Decimal (class in shillelagh.fields) default (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) delete() (shillelagh.lib.RowIDManager method) delete_data() (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) delete_row() (shillelagh.adapters.base.Adapter method) DESCENDING (shillelagh.fields.Order attribute) description (shillelagh.adapters.api.socrata.MetadataColumn attribute) deserialize() (in module shillelagh.lib) Destroy() (shillelagh.backends.apsw.vt.VTTable method) detailed_message (shillelagh.adapters.api.gsheets.typing.QueryResultsError attribute) dewpoint_c (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) dewpoint_f (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) DIGITS (class in shillelagh.adapters.api.gsheets.parsing.number) Disconnect() (shillelagh.backends.apsw.vt.VTTable method) do_ping() (shillelagh.backends.apsw.dialects.base.APSWDialect method) driver (shillelagh.backends.apsw.dialects.base.APSWDialect attribute) drop_table() (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) Duration (class in shillelagh.fields) DurationToken (class in shillelagh.adapters.api.gsheets.parsing.date)

E

E (class in shillelagh.adapters.api.gsheets.parsing.number) Endpoint (class in shillelagh.filters) Eof() (shillelagh.backends.apsw.vt.VTCursor method) EQ (shillelagh.filters.Operator attribute)

Equal (class in shillelagh.filters) Error, [1], [2] errors (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) escape_identifier() (in module shillelagh.lib) escape_string() (in module shillelagh.lib)

F

f (shillelagh.adapters.api.gsheets.typing.QueryResultsCell attribute) FastISODateTime (class in shillelagh.fields) feelslike_c (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) feelslike_f (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) Field (class in shillelagh.fields) fieldName (shillelagh.adapters.api.socrata.MetadataColumn attribute) Filter (class in shillelagh.filters) Filter() (shillelagh.backends.apsw.vt.VTCursor method) filter_data() (in module shillelagh.lib) find_adapter() (in module shillelagh.lib) fix_periods() (in module shillelagh.adapters.api.gsheets.parsing.number) flatten() (in module shillelagh.lib) Float (class in shillelagh.fields) format (shillelagh.adapters.api.socrata.MetadataColumn attribute) format() (shillelagh.adapters.api.gsheets.fields.GSheetsBoolean method) (shillelagh.adapters.api.gsheets.fields.GSheetsDate method) (shillelagh.adapters.api.gsheets.fields.GSheetsDateTime method) (shillelagh.adapters.api.gsheets.fields.GSheetsDuration method) (shillelagh.adapters.api.gsheets.fields.GSheetsNumber method) (shillelagh.adapters.api.gsheets.fields.GSheetsString method) (shillelagh.adapters.api.gsheets.fields.GSheetsTime method) (shillelagh.adapters.api.gsheets.parsing.base.LITERAL method) (shillelagh.adapters.api.gsheets.parsing.base.Token method) (shillelagh.adapters.api.gsheets.parsing.date.AMPM method) (shillelagh.adapters.api.gsheets.parsing.date.AP method) (shillelagh.adapters.api.gsheets.parsing.date.D method) (shillelagh.adapters.api.gsheets.parsing.date.DD method) (shillelagh.adapters.api.gsheets.parsing.date.DDD method) (shillelagh.adapters.api.gsheets.parsing.date.DDDDPlus method) (shillelagh.adapters.api.gsheets.parsing.date.H method) (shillelagh.adapters.api.gsheets.parsing.date.HHPlus method) (shillelagh.adapters.api.gsheets.parsing.date.HPlusDuration method) (shillelagh.adapters.api.gsheets.parsing.date.M method) (shillelagh.adapters.api.gsheets.parsing.date.MM method) (shillelagh.adapters.api.gsheets.parsing.date.MMM method) (shillelagh.adapters.api.gsheets.parsing.date.MMMM method) (shillelagh.adapters.api.gsheets.parsing.date.MMMMM method) (shillelagh.adapters.api.gsheets.parsing.date.MPlusDuration method) (shillelagh.adapters.api.gsheets.parsing.date.S method) (shillelagh.adapters.api.gsheets.parsing.date.SPlusDuration method) (shillelagh.adapters.api.gsheets.parsing.date.SS method) (shillelagh.adapters.api.gsheets.parsing.date.YY method) (shillelagh.adapters.api.gsheets.parsing.date.YYYY method) (shillelagh.adapters.api.gsheets.parsing.date.ZERO method) (shillelagh.adapters.api.gsheets.parsing.number.AT method) (shillelagh.adapters.api.gsheets.parsing.number.COLOR method) (shillelagh.adapters.api.gsheets.parsing.number.COMMA method) (shillelagh.adapters.api.gsheets.parsing.number.CONDITION method) (shillelagh.adapters.api.gsheets.parsing.number.DIGITS method) (shillelagh.adapters.api.gsheets.parsing.number.E method) (shillelagh.adapters.api.gsheets.parsing.number.FRACTION method) (shillelagh.adapters.api.gsheets.parsing.number.PERCENT method) (shillelagh.adapters.api.gsheets.parsing.number.PERIOD method) (shillelagh.adapters.api.gsheets.parsing.number.STAR method) (shillelagh.adapters.api.gsheets.parsing.number.UNDERSCORE method) (shillelagh.adapters.api.socrata.Number method) (shillelagh.fields.Field method) (shillelagh.fields.IntBoolean method) (shillelagh.fields.ISODate method) (shillelagh.fields.ISODateTime method) (shillelagh.fields.ISOTime method) (shillelagh.fields.StringBlob method) (shillelagh.fields.StringBoolean method) (shillelagh.fields.StringDecimal method) (shillelagh.fields.StringDuration method) (shillelagh.fields.StringInteger method)

format_date_time_pattern() (in module shillelagh.adapters.api.gsheets.parsing.date) format_number_pattern() (in module shillelagh.adapters.api.gsheets.parsing.number) FRACTION (class in shillelagh.adapters.api.gsheets.parsing.number)

G

GE (shillelagh.filters.Operator attribute) get_adapter_for_table_name() (in module shillelagh.backends.apsw.dialects.base) get_all_bounds() (in module shillelagh.backends.apsw.vt) get_bounds() (in module shillelagh.lib) get_columns() (shillelagh.adapters.api.datasette.DatasetteAPI method) (shillelagh.adapters.api.socrata.SocrataAPI method) (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) (shillelagh.adapters.memory.virtual.VirtualMemory method) (shillelagh.backends.apsw.dialects.base.APSWDialect method) get_conditions() (in module shillelagh.lib) get_cost() (shillelagh.adapters.api.datasette.DatasetteAPI method) (shillelagh.adapters.api.socrata.SocrataAPI method) (shillelagh.adapters.api.weatherapi.WeatherAPI method) (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) get_create_table() (shillelagh.backends.apsw.vt.VTTable method) get_data() (shillelagh.adapters.api.datasette.DatasetteAPI method) (shillelagh.adapters.api.socrata.SocrataAPI method) (shillelagh.adapters.api.weatherapi.WeatherAPI method) (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) (shillelagh.adapters.memory.virtual.VirtualMemory method)

get_endpoints_from_operation() (in module shillelagh.filters) get_field() (in module shillelagh.adapters.api.datasette) (in module shillelagh.adapters.api.socrata) get_fraction() (in module shillelagh.adapters.api.gsheets.parsing.number) get_limit_offset() (in module shillelagh.backends.apsw.vt) get_max_row_id() (shillelagh.lib.RowIDManager method) get_metadata() (in module shillelagh.functions) (shillelagh.adapters.api.datasette.DatasetteAPI method) (shillelagh.adapters.base.Adapter method) get_order() (in module shillelagh.backends.apsw.vt) get_rows() (shillelagh.adapters.base.Adapter method) get_session() (in module shillelagh.lib) gid (shillelagh.adapters.api.gsheets.typing.UrlArgs attribute) GSheetsBoolean (class in shillelagh.adapters.api.gsheets.fields) GSheetsDate (class in shillelagh.adapters.api.gsheets.fields) GSheetsDateTime (class in shillelagh.adapters.api.gsheets.fields) GSheetsDuration (class in shillelagh.adapters.api.gsheets.fields) GSheetsField (class in shillelagh.adapters.api.gsheets.fields) GSheetsNumber (class in shillelagh.adapters.api.gsheets.fields) GSheetsString (class in shillelagh.adapters.api.gsheets.fields) GSheetsTime (class in shillelagh.adapters.api.gsheets.fields) GT (shillelagh.filters.Operator attribute) gust_kph (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) gust_mph (shillelagh.adapters.api.weatherapi.WeatherAPI attribute)

H

H (class in shillelagh.adapters.api.gsheets.parsing.date) has_condition() (in module shillelagh.adapters.api.gsheets.parsing.number) has_table() (shillelagh.backends.apsw.dialects.base.APSWDialect method) headers (shillelagh.adapters.api.gsheets.typing.UrlArgs attribute)

heatindex_c (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) heatindex_f (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) HHPlus (class in shillelagh.adapters.api.gsheets.parsing.date) HPlusDuration (class in shillelagh.adapters.api.gsheets.parsing.date) humidity (shillelagh.adapters.api.weatherapi.WeatherAPI attribute)

I

id (shillelagh.adapters.api.gsheets.typing.QueryResultsColumn attribute) (shillelagh.adapters.api.socrata.MetadataColumn attribute) import_dbapi() (shillelagh.backends.apsw.dialects.base.APSWDialect class method) Impossible (class in shillelagh.filters) infer_column_type() (in module shillelagh.adapters.api.gsheets.parsing.date) insert() (shillelagh.lib.RowIDManager method) insert_data() (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) insert_row() (shillelagh.adapters.base.Adapter method) int_to_base26() (in module shillelagh.adapters.memory.virtual) IntBoolean (class in shillelagh.fields) Integer (class in shillelagh.fields) IntegrityError, [1], [2] InterfaceError, [1], [2] InternalError, [1], [2] InvalidPattern

InvalidValue is_datasette() (in module shillelagh.adapters.api.datasette) is_day (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) is_duration (shillelagh.adapters.api.gsheets.parsing.date.DurationToken attribute) is_fractional() (in module shillelagh.adapters.api.gsheets.parsing.number) is_known_domain() (in module shillelagh.adapters.api.datasette) IS_NOT_NULL (shillelagh.filters.Operator attribute) is_not_null() (in module shillelagh.lib) IS_NULL (shillelagh.filters.Operator attribute) is_null() (in module shillelagh.lib) is_unescaped_literal() (in module shillelagh.adapters.api.gsheets.parsing.base) IsNotNull (class in shillelagh.filters) IsNull (class in shillelagh.filters) ISODate (class in shillelagh.fields) ISODateTime (class in shillelagh.fields) ISOTime (class in shillelagh.fields)

L

label (shillelagh.adapters.api.gsheets.typing.QueryResultsColumn attribute) last_row (shillelagh.adapters.file.csvfile.RowTracker attribute) LE (shillelagh.filters.Operator attribute) LEFT (shillelagh.filters.Side attribute) Like (class in shillelagh.filters)

LIKE (shillelagh.filters.Operator attribute) LIMIT (shillelagh.filters.Operator attribute) LITERAL (class in shillelagh.adapters.api.gsheets.parsing.base) load() (shillelagh.adapters.registry.AdapterLoader method) load_all() (shillelagh.adapters.registry.AdapterLoader method) LT (shillelagh.filters.Operator attribute)

M

M (class in shillelagh.adapters.api.gsheets.parsing.date) make_seq() (in module shillelagh.adapters.memory.virtual) match() (shillelagh.adapters.api.gsheets.parsing.base.Token class method) (shillelagh.adapters.api.gsheets.parsing.date.DurationToken class method) Meridiem (class in shillelagh.adapters.api.gsheets.parsing.date) message (shillelagh.adapters.api.gsheets.typing.QueryResultsError attribute) MetadataColumn (class in shillelagh.adapters.api.socrata) MM (class in shillelagh.adapters.api.gsheets.parsing.date) MMM (class in shillelagh.adapters.api.gsheets.parsing.date) MMMM (class in shillelagh.adapters.api.gsheets.parsing.date) MMMMM (class in shillelagh.adapters.api.gsheets.parsing.date) module shillelagh shillelagh.adapters shillelagh.adapters.api shillelagh.adapters.api.datasette shillelagh.adapters.api.gsheets shillelagh.adapters.api.gsheets.exceptions shillelagh.adapters.api.gsheets.fields shillelagh.adapters.api.gsheets.parsing shillelagh.adapters.api.gsheets.parsing.base shillelagh.adapters.api.gsheets.parsing.date shillelagh.adapters.api.gsheets.parsing.number shillelagh.adapters.api.gsheets.types shillelagh.adapters.api.gsheets.typing shillelagh.adapters.api.socrata shillelagh.adapters.api.weatherapi shillelagh.adapters.base shillelagh.adapters.file shillelagh.adapters.file.csvfile shillelagh.adapters.memory shillelagh.adapters.memory.virtual shillelagh.adapters.registry shillelagh.backends shillelagh.backends.apsw shillelagh.backends.apsw.db shillelagh.backends.apsw.dialects shillelagh.backends.apsw.dialects.base shillelagh.backends.apsw.dialects.safe shillelagh.backends.apsw.vt shillelagh.backends.multicorn shillelagh.backends.multicorn.dialects shillelagh.backends.sqlglot shillelagh.backends.sqlglot.dialects shillelagh.db shillelagh.exceptions shillelagh.fields shillelagh.filters shillelagh.functions shillelagh.lib shillelagh.types shillelagh.typing

MPlusDuration (class in shillelagh.adapters.api.gsheets.parsing.date)

N

name (shillelagh.adapters.api.socrata.MetadataColumn attribute) (shillelagh.backends.apsw.dialects.base.APSWDialect attribute) (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) NE (shillelagh.filters.Operator attribute) NetworkAPICostModel() (in module shillelagh.lib)

Next() (shillelagh.backends.apsw.vt.VTCursor method) NONE (shillelagh.fields.Order attribute) NotEqual (class in shillelagh.filters) NotSupportedError, [1] nullable (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) Number (class in shillelagh.adapters.api.socrata)

O

OFFSET (shillelagh.filters.Operator attribute) Open() (shillelagh.backends.apsw.vt.VTTable method) OperationalError, [1], [2] Operator (class in shillelagh.filters) operators (shillelagh.filters.Equal attribute) (shillelagh.filters.Filter attribute) (shillelagh.filters.IsNotNull attribute) (shillelagh.filters.IsNull attribute) (shillelagh.filters.Like attribute) (shillelagh.filters.NotEqual attribute) (shillelagh.filters.Range attribute)

Order (class in shillelagh.fields)

P

parse() (shillelagh.adapters.api.gsheets.fields.GSheetsBoolean method) (shillelagh.adapters.api.gsheets.fields.GSheetsDate method) (shillelagh.adapters.api.gsheets.fields.GSheetsDateTime method) (shillelagh.adapters.api.gsheets.fields.GSheetsDuration method) (shillelagh.adapters.api.gsheets.fields.GSheetsNumber method) (shillelagh.adapters.api.gsheets.fields.GSheetsString method) (shillelagh.adapters.api.gsheets.fields.GSheetsTime method) (shillelagh.adapters.api.gsheets.parsing.base.LITERAL method) (shillelagh.adapters.api.gsheets.parsing.base.Token method) (shillelagh.adapters.api.gsheets.parsing.date.AMPM method) (shillelagh.adapters.api.gsheets.parsing.date.AP method) (shillelagh.adapters.api.gsheets.parsing.date.D method) (shillelagh.adapters.api.gsheets.parsing.date.DD method) (shillelagh.adapters.api.gsheets.parsing.date.DDD method) (shillelagh.adapters.api.gsheets.parsing.date.DDDDPlus method) (shillelagh.adapters.api.gsheets.parsing.date.H method) (shillelagh.adapters.api.gsheets.parsing.date.HHPlus method) (shillelagh.adapters.api.gsheets.parsing.date.HPlusDuration method) (shillelagh.adapters.api.gsheets.parsing.date.M method) (shillelagh.adapters.api.gsheets.parsing.date.MM method) (shillelagh.adapters.api.gsheets.parsing.date.MMM method) (shillelagh.adapters.api.gsheets.parsing.date.MMMM method) (shillelagh.adapters.api.gsheets.parsing.date.MMMMM method) (shillelagh.adapters.api.gsheets.parsing.date.MPlusDuration method) (shillelagh.adapters.api.gsheets.parsing.date.S method) (shillelagh.adapters.api.gsheets.parsing.date.SPlusDuration method) (shillelagh.adapters.api.gsheets.parsing.date.SS method) (shillelagh.adapters.api.gsheets.parsing.date.YY method) (shillelagh.adapters.api.gsheets.parsing.date.YYYY method) (shillelagh.adapters.api.gsheets.parsing.date.ZERO method) (shillelagh.adapters.api.gsheets.parsing.number.AT method) (shillelagh.adapters.api.gsheets.parsing.number.COLOR method) (shillelagh.adapters.api.gsheets.parsing.number.COMMA method) (shillelagh.adapters.api.gsheets.parsing.number.CONDITION method) (shillelagh.adapters.api.gsheets.parsing.number.DIGITS method) (shillelagh.adapters.api.gsheets.parsing.number.E method) (shillelagh.adapters.api.gsheets.parsing.number.FRACTION method) (shillelagh.adapters.api.gsheets.parsing.number.PERCENT method) (shillelagh.adapters.api.gsheets.parsing.number.PERIOD method) (shillelagh.adapters.api.gsheets.parsing.number.STAR method) (shillelagh.adapters.api.gsheets.parsing.number.UNDERSCORE method) (shillelagh.adapters.api.socrata.Number method) (shillelagh.fields.FastISODateTime method) (shillelagh.fields.Field method) (shillelagh.fields.IntBoolean method) (shillelagh.fields.ISODate method) (shillelagh.fields.ISODateTime method) (shillelagh.fields.ISOTime method) (shillelagh.fields.StringBlob method) (shillelagh.fields.StringBoolean method) (shillelagh.fields.StringDate method) (shillelagh.fields.StringDateTime method) (shillelagh.fields.StringDecimal method) (shillelagh.fields.StringDuration method) (shillelagh.fields.StringInteger method) (shillelagh.fields.StringTime method)

parse_date_time_pattern() (in module shillelagh.adapters.api.gsheets.parsing.date) parse_number_format() (in module shillelagh.adapters.api.gsheets.parsing.number) parse_number_pattern() (in module shillelagh.adapters.api.gsheets.parsing.number) parse_uri() (shillelagh.adapters.api.datasette.DatasetteAPI static method) (shillelagh.adapters.api.socrata.SocrataAPI static method) (shillelagh.adapters.api.weatherapi.WeatherAPI static method) (shillelagh.adapters.base.Adapter static method) (shillelagh.adapters.file.csvfile.CSVFile static method) (shillelagh.adapters.memory.virtual.VirtualMemory static method) parsedNumHeaders (shillelagh.adapters.api.gsheets.typing.QueryResultsTable attribute) pattern (shillelagh.adapters.api.gsheets.fields.GSheetsField attribute) (shillelagh.adapters.api.gsheets.typing.QueryResultsColumn attribute) pattern_substitutions (shillelagh.adapters.api.gsheets.fields.GSheetsField attribute) PERCENT (class in shillelagh.adapters.api.gsheets.parsing.number) PERIOD (class in shillelagh.adapters.api.gsheets.parsing.number) persisted (shillelagh.backends.apsw.dialects.base.ComputedColumn attribute) PM (shillelagh.adapters.api.gsheets.parsing.date.Meridiem attribute) position (shillelagh.adapters.api.socrata.MetadataColumn attribute) precip_in (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) precip_mm (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) pressure_in (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) pressure_mb (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) primary_key (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) ProgrammingError

Q

QueryResults (class in shillelagh.adapters.api.gsheets.typing) QueryResultsCell (class in shillelagh.adapters.api.gsheets.typing) QueryResultsColumn (class in shillelagh.adapters.api.gsheets.typing) QueryResultsError (class in shillelagh.adapters.api.gsheets.typing) QueryResultsRow (class in shillelagh.adapters.api.gsheets.typing) QueryResultsTable (class in shillelagh.adapters.api.gsheets.typing) quote() (shillelagh.adapters.api.gsheets.fields.GSheetsBoolean method) (shillelagh.adapters.api.gsheets.fields.GSheetsDate method) (shillelagh.adapters.api.gsheets.fields.GSheetsDateTime method) (shillelagh.adapters.api.gsheets.fields.GSheetsDuration method) (shillelagh.adapters.api.gsheets.fields.GSheetsNumber method) (shillelagh.adapters.api.gsheets.fields.GSheetsString method) (shillelagh.adapters.api.gsheets.fields.GSheetsTime method) (shillelagh.fields.Blob method) (shillelagh.fields.Boolean method) (shillelagh.fields.Date method) (shillelagh.fields.DateTime method) (shillelagh.fields.Decimal method) (shillelagh.fields.Field method) (shillelagh.fields.IntBoolean method) (shillelagh.fields.ISODate method) (shillelagh.fields.ISODateTime method) (shillelagh.fields.ISOTime method) (shillelagh.fields.String method) (shillelagh.fields.StringBlob method) (shillelagh.fields.StringBoolean method) (shillelagh.fields.StringDecimal method) (shillelagh.fields.StringDuration method) (shillelagh.fields.Time method) (shillelagh.fields.Unknown method)

R

Range (class in shillelagh.filters) reason (shillelagh.adapters.api.gsheets.typing.QueryResultsError attribute) regex (shillelagh.adapters.api.gsheets.parsing.base.LITERAL attribute) (shillelagh.adapters.api.gsheets.parsing.base.Token attribute) (shillelagh.adapters.api.gsheets.parsing.date.AMPM attribute) (shillelagh.adapters.api.gsheets.parsing.date.AP attribute) (shillelagh.adapters.api.gsheets.parsing.date.D attribute) (shillelagh.adapters.api.gsheets.parsing.date.DD attribute) (shillelagh.adapters.api.gsheets.parsing.date.DDD attribute) (shillelagh.adapters.api.gsheets.parsing.date.DDDDPlus attribute) (shillelagh.adapters.api.gsheets.parsing.date.H attribute) (shillelagh.adapters.api.gsheets.parsing.date.HHPlus attribute) (shillelagh.adapters.api.gsheets.parsing.date.M attribute) (shillelagh.adapters.api.gsheets.parsing.date.MM attribute) (shillelagh.adapters.api.gsheets.parsing.date.MMM attribute) (shillelagh.adapters.api.gsheets.parsing.date.MMMM attribute) (shillelagh.adapters.api.gsheets.parsing.date.MMMMM attribute) (shillelagh.adapters.api.gsheets.parsing.date.S attribute) (shillelagh.adapters.api.gsheets.parsing.date.SS attribute) (shillelagh.adapters.api.gsheets.parsing.date.YY attribute) (shillelagh.adapters.api.gsheets.parsing.date.YYYY attribute) (shillelagh.adapters.api.gsheets.parsing.date.ZERO attribute) (shillelagh.adapters.api.gsheets.parsing.number.AT attribute) (shillelagh.adapters.api.gsheets.parsing.number.COLOR attribute) (shillelagh.adapters.api.gsheets.parsing.number.COMMA attribute) (shillelagh.adapters.api.gsheets.parsing.number.CONDITION attribute) (shillelagh.adapters.api.gsheets.parsing.number.DIGITS attribute) (shillelagh.adapters.api.gsheets.parsing.number.E attribute) (shillelagh.adapters.api.gsheets.parsing.number.FRACTION attribute) (shillelagh.adapters.api.gsheets.parsing.number.PERCENT attribute) (shillelagh.adapters.api.gsheets.parsing.number.PERIOD attribute) (shillelagh.adapters.api.gsheets.parsing.number.STAR attribute) (shillelagh.adapters.api.gsheets.parsing.number.UNDERSCORE attribute)

regexes (shillelagh.adapters.api.gsheets.parsing.date.DurationToken attribute) (shillelagh.adapters.api.gsheets.parsing.date.HPlusDuration attribute) (shillelagh.adapters.api.gsheets.parsing.date.MPlusDuration attribute) (shillelagh.adapters.api.gsheets.parsing.date.SPlusDuration attribute) register() (shillelagh.adapters.registry.AdapterLoader method) renderTypeName (shillelagh.adapters.api.socrata.MetadataColumn attribute) reqId (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) RIGHT (shillelagh.filters.Side attribute) RowID (class in shillelagh.fields) Rowid() (shillelagh.backends.apsw.vt.VTCursor method) RowIDManager (class in shillelagh.lib) rows (shillelagh.adapters.api.gsheets.typing.QueryResultsTable attribute) RowTracker (class in shillelagh.adapters.file.csvfile)

S

S (class in shillelagh.adapters.api.gsheets.parsing.date) safe (shillelagh.adapters.api.datasette.DatasetteAPI attribute) (shillelagh.adapters.api.socrata.SocrataAPI attribute) (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) (shillelagh.adapters.base.Adapter attribute) (shillelagh.adapters.file.csvfile.CSVFile attribute) (shillelagh.adapters.memory.virtual.VirtualMemory attribute) serialize() (in module shillelagh.lib) sheet (shillelagh.adapters.api.gsheets.typing.UrlArgs attribute) shillelagh module shillelagh.adapters module shillelagh.adapters.api module shillelagh.adapters.api.datasette module shillelagh.adapters.api.gsheets module shillelagh.adapters.api.gsheets.exceptions module shillelagh.adapters.api.gsheets.fields module shillelagh.adapters.api.gsheets.parsing module shillelagh.adapters.api.gsheets.parsing.base module shillelagh.adapters.api.gsheets.parsing.date module shillelagh.adapters.api.gsheets.parsing.number module shillelagh.adapters.api.gsheets.types module shillelagh.adapters.api.gsheets.typing module shillelagh.adapters.api.socrata module shillelagh.adapters.api.weatherapi module shillelagh.adapters.base module shillelagh.adapters.file module shillelagh.adapters.file.csvfile module shillelagh.adapters.memory module shillelagh.adapters.memory.virtual module shillelagh.adapters.registry module shillelagh.backends module shillelagh.backends.apsw module shillelagh.backends.apsw.db module shillelagh.backends.apsw.dialects module shillelagh.backends.apsw.dialects.base module shillelagh.backends.apsw.dialects.safe module shillelagh.backends.apsw.vt module shillelagh.backends.multicorn module

shillelagh.backends.multicorn.dialects module shillelagh.backends.sqlglot module shillelagh.backends.sqlglot.dialects module shillelagh.db module shillelagh.exceptions module shillelagh.fields module shillelagh.filters module shillelagh.functions module shillelagh.lib module shillelagh.types module shillelagh.typing module Side (class in shillelagh.filters) sig (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) SimpleCostModel() (in module shillelagh.lib) sleep() (in module shillelagh.functions) SocrataAPI (class in shillelagh.adapters.api.socrata) SPlusDuration (class in shillelagh.adapters.api.gsheets.parsing.date) SQLAlchemyColumn (class in shillelagh.backends.apsw.dialects.base) sqltext (shillelagh.backends.apsw.dialects.base.ComputedColumn attribute) SS (class in shillelagh.adapters.api.gsheets.parsing.date) STAR (class in shillelagh.adapters.api.gsheets.parsing.number) status (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) String (class in shillelagh.fields) StringBlob (class in shillelagh.fields) StringBoolean (class in shillelagh.fields) StringDate (class in shillelagh.fields) StringDateTime (class in shillelagh.fields) StringDecimal (class in shillelagh.fields) StringDuration (class in shillelagh.fields) StringInteger (class in shillelagh.fields) StringTime (class in shillelagh.fields) strtobool() (shillelagh.fields.StringBoolean static method) supports() (shillelagh.adapters.api.datasette.DatasetteAPI static method) (shillelagh.adapters.api.socrata.SocrataAPI static method) (shillelagh.adapters.api.weatherapi.WeatherAPI static method) (shillelagh.adapters.base.Adapter static method) (shillelagh.adapters.file.csvfile.CSVFile static method) (shillelagh.adapters.memory.virtual.VirtualMemory static method) supports_limit (shillelagh.adapters.api.datasette.DatasetteAPI attribute) (shillelagh.adapters.api.socrata.SocrataAPI attribute) (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) (shillelagh.adapters.base.Adapter attribute) (shillelagh.adapters.file.csvfile.CSVFile attribute) (shillelagh.adapters.memory.virtual.VirtualMemory attribute) supports_offset (shillelagh.adapters.api.datasette.DatasetteAPI attribute) (shillelagh.adapters.api.socrata.SocrataAPI attribute) (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) (shillelagh.adapters.base.Adapter attribute) (shillelagh.adapters.file.csvfile.CSVFile attribute) (shillelagh.adapters.memory.virtual.VirtualMemory attribute) supports_requested_columns (shillelagh.adapters.base.Adapter attribute) (shillelagh.adapters.file.csvfile.CSVFile attribute) (shillelagh.adapters.memory.virtual.VirtualMemory attribute) supports_sane_rowcount (shillelagh.backends.apsw.dialects.base.APSWDialect attribute) supports_statement_cache (shillelagh.backends.apsw.dialects.base.APSWDialect attribute) (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect attribute) SyncMode (class in shillelagh.adapters.api.gsheets.types)

T

table (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) tableColumnId (shillelagh.adapters.api.socrata.MetadataColumn attribute) temp_c (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) temp_f (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) Time (class in shillelagh.fields) time (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) Time() (in module shillelagh.backends.apsw.db) (in module shillelagh.db) (in module shillelagh.types) time_epoch (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) TimeFromTicks() (in module shillelagh.backends.apsw.db) (in module shillelagh.db) (in module shillelagh.types) Timestamp() (in module shillelagh.backends.apsw.db) (in module shillelagh.db) (in module shillelagh.types) TimestampFromTicks() (in module shillelagh.backends.apsw.db) (in module shillelagh.db) (in module shillelagh.types) Token (class in shillelagh.adapters.api.gsheets.parsing.base) tokenize() (in module shillelagh.adapters.api.gsheets.parsing.base) type (shillelagh.adapters.api.gsheets.fields.GSheetsBoolean attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsDate attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsDateTime attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsDuration attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsNumber attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsString attribute) (shillelagh.adapters.api.gsheets.fields.GSheetsTime attribute) (shillelagh.adapters.api.gsheets.typing.QueryResultsColumn attribute) (shillelagh.adapters.api.socrata.Number attribute) (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) (shillelagh.fields.Blob attribute) (shillelagh.fields.Boolean attribute) (shillelagh.fields.Date attribute) (shillelagh.fields.DateTime attribute) (shillelagh.fields.Decimal attribute) (shillelagh.fields.Duration attribute) (shillelagh.fields.Field attribute) (shillelagh.fields.Float attribute) (shillelagh.fields.IntBoolean attribute) (shillelagh.fields.Integer attribute) (shillelagh.fields.ISODate attribute) (shillelagh.fields.ISODateTime attribute) (shillelagh.fields.ISOTime attribute) (shillelagh.fields.String attribute) (shillelagh.fields.StringBlob attribute) (shillelagh.fields.StringBoolean attribute) (shillelagh.fields.StringDecimal attribute) (shillelagh.fields.StringDuration attribute) (shillelagh.fields.StringInteger attribute) (shillelagh.fields.Time attribute) (shillelagh.fields.Unknown attribute)

U

UNDERSCORE (class in shillelagh.adapters.api.gsheets.parsing.number) unescape_identifier() (in module shillelagh.lib) unescape_string() (in module shillelagh.lib) UNIDIRECTIONAL (shillelagh.adapters.api.gsheets.types.SyncMode attribute) Unknown (class in shillelagh.fields) UnsafeAdaptersError update_data() (shillelagh.adapters.base.Adapter method)

update_order() (in module shillelagh.lib) update_row() (shillelagh.adapters.base.Adapter method) UpdateChangeRow() (shillelagh.backends.apsw.vt.VTTable method) UpdateDeleteRow() (shillelagh.backends.apsw.vt.VTTable method) UpdateInsertRow() (shillelagh.backends.apsw.vt.VTTable method) upgrade() (in module shillelagh.functions) UrlArgs (class in shillelagh.adapters.api.gsheets.typing)

V

v (shillelagh.adapters.api.gsheets.typing.QueryResultsCell attribute) version (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) version() (in module shillelagh.functions) VirtualMemory (class in shillelagh.adapters.memory.virtual)

vis_km (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) vis_miles (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) VTCursor (class in shillelagh.backends.apsw.vt) VTModule (class in shillelagh.backends.apsw.vt) VTTable (class in shillelagh.backends.apsw.vt)

W

Warning, [1], [2] WeatherAPI (class in shillelagh.adapters.api.weatherapi) will_it_rain (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) will_it_snow (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) wind_degree (shillelagh.adapters.api.weatherapi.WeatherAPI attribute)

wind_dir (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) wind_kph (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) wind_mph (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) windchill_c (shillelagh.adapters.api.weatherapi.WeatherAPI attribute) windchill_f (shillelagh.adapters.api.weatherapi.WeatherAPI attribute)

Y

YY (class in shillelagh.adapters.api.gsheets.parsing.date)

YYYY (class in shillelagh.adapters.api.gsheets.parsing.date)

Z

ZERO (class in shillelagh.adapters.api.gsheets.parsing.date)