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) apsw_version() (in module shillelagh.backends.apsw.db) 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.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) 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_closed() (in module shillelagh.backends.apsw.db) check_result() (in module shillelagh.backends.apsw.db) 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) (shillelagh.backends.apsw.db.Connection method) (shillelagh.backends.apsw.db.Cursor method) Close() (shillelagh.backends.apsw.vt.VTCursor method) 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) COMMA (class in shillelagh.adapters.api.gsheets.parsing.number) commit() (shillelagh.backends.apsw.db.Connection method) compiler_linting (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect attribute) CONDITION (class in shillelagh.adapters.api.gsheets.parsing.number) condition_matches() (in module shillelagh.adapters.api.gsheets.parsing.number) connect() (in module shillelagh.backends.apsw.db) Connect() (shillelagh.backends.apsw.vt.VTModule method) Connection (class in shillelagh.backends.apsw.db) consume() (shillelagh.adapters.api.gsheets.parsing.base.Token class method) (shillelagh.adapters.api.gsheets.parsing.date.DurationToken class method) convert_binding() (in module shillelagh.backends.apsw.db) 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) CSVFile (class in shillelagh.adapters.file.csvfile) Cursor (class in shillelagh.backends.apsw.db) cursor() (shillelagh.backends.apsw.db.Connection method)

D

D (class in shillelagh.adapters.api.gsheets.parsing.date) DatabaseError DataError Date (class in shillelagh.fields) Date() (in module shillelagh.types) DateFromTicks() (in module shillelagh.types) 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.fields.Blob attribute) (shillelagh.fields.Boolean attribute) (shillelagh.fields.Date attribute) (shillelagh.fields.DateTime 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.StringDuration attribute) (shillelagh.fields.StringInteger attribute) (shillelagh.fields.Time 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) default (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute) default_isolation_level (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect 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) deserialize() (in module shillelagh.lib) Destroy() (shillelagh.backends.apsw.vt.VTTable method) detailed_message (shillelagh.adapters.api.gsheets.typing.QueryResultsError 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) 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

errors (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) escape_identifier() (in module shillelagh.lib) escape_string() (in module shillelagh.lib) execute() (shillelagh.backends.apsw.db.Connection method) (shillelagh.backends.apsw.db.Cursor method) executemany() (shillelagh.backends.apsw.db.Cursor method)

F

f (shillelagh.adapters.api.gsheets.typing.QueryResultsCell attribute) FastISODateTime (class in shillelagh.fields) fetchall() (shillelagh.backends.apsw.db.Cursor method) fetchmany() (shillelagh.backends.apsw.db.Cursor method) fetchone() (shillelagh.backends.apsw.db.Cursor method) Field (class in shillelagh.fields) 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.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.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.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.backends.apsw.vt) get_columns() (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) (shillelagh.backends.apsw.dialects.base.APSWDialect method) get_conditions() (in module shillelagh.lib) get_cost() (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) get_create_table() (shillelagh.backends.apsw.vt.VTTable method) get_data() (shillelagh.adapters.base.Adapter method) (shillelagh.adapters.file.csvfile.CSVFile method) get_endpoints_from_operation() (in module shillelagh.filters) 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.base.Adapter method) get_order() (in module shillelagh.backends.apsw.vt) get_rows() (shillelagh.adapters.base.Adapter method) get_type_code() (in module shillelagh.backends.apsw.db) 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)

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) HHPlus (class in shillelagh.adapters.api.gsheets.parsing.date) HPlusDuration (class in shillelagh.adapters.api.gsheets.parsing.date)

I

id (shillelagh.adapters.api.gsheets.typing.QueryResultsColumn attribute) identifier_preparer (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect attribute) 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) IntBoolean (class in shillelagh.fields) Integer (class in shillelagh.fields) IntegrityError InterfaceError InternalError

InvalidPattern InvalidValue is_duration (shillelagh.adapters.api.gsheets.parsing.date.DurationToken attribute) is_fractional() (in module shillelagh.adapters.api.gsheets.parsing.number) 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) label_length (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect 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) 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) 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.gsheets 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.base shillelagh.adapters.file shillelagh.adapters.file.csvfile shillelagh.adapters.memory 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.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.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.db.Cursor method)

Next() (shillelagh.backends.apsw.vt.VTCursor method) NONE (shillelagh.fields.Order attribute) NotEqual (class in shillelagh.filters) NotSupportedError nullable (shillelagh.backends.apsw.dialects.base.SQLAlchemyColumn attribute)

O

OFFSET (shillelagh.filters.Operator attribute) Open() (shillelagh.backends.apsw.vt.VTTable method) OperationalError 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

paramstyle (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect attribute) 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.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.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.base.Adapter static method) (shillelagh.adapters.file.csvfile.CSVFile static method) parsedNumHeaders (shillelagh.adapters.api.gsheets.typing.QueryResultsTable attribute) pattern (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) 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) PM (shillelagh.adapters.api.gsheets.parsing.date.Meridiem attribute) positional (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect 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.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.StringDuration method) (shillelagh.fields.Time 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.HPlusDuration 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.MPlusDuration attribute) (shillelagh.adapters.api.gsheets.parsing.date.S attribute) (shillelagh.adapters.api.gsheets.parsing.date.SPlusDuration 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) reqId (shillelagh.adapters.api.gsheets.typing.QueryResults attribute) RIGHT (shillelagh.filters.Side attribute) rollback() (shillelagh.backends.apsw.db.Connection method) rowcount (shillelagh.backends.apsw.db.Cursor property) 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.base.Adapter attribute) (shillelagh.adapters.file.csvfile.CSVFile attribute) serialize() (in module shillelagh.lib) setinputsizes() (shillelagh.backends.apsw.db.Cursor method) setoutputsizes() (shillelagh.backends.apsw.db.Cursor method) sheet (shillelagh.adapters.api.gsheets.typing.UrlArgs attribute) shillelagh module shillelagh.adapters module shillelagh.adapters.api module shillelagh.adapters.api.gsheets 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.base module shillelagh.adapters.file module shillelagh.adapters.file.csvfile module shillelagh.adapters.memory 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.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) SPlusDuration (class in shillelagh.adapters.api.gsheets.parsing.date) SQLAlchemyColumn (class in shillelagh.backends.apsw.dialects.base) 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) StringDuration (class in shillelagh.fields) StringInteger (class in shillelagh.fields) StringTime (class in shillelagh.fields) strtobool() (shillelagh.fields.StringBoolean static method) supports() (shillelagh.adapters.base.Adapter static method) (shillelagh.adapters.file.csvfile.CSVFile static method) supports_limit (shillelagh.adapters.base.Adapter attribute) (shillelagh.adapters.file.csvfile.CSVFile attribute) supports_offset (shillelagh.adapters.base.Adapter attribute) (shillelagh.adapters.file.csvfile.CSVFile attribute) supports_requested_columns (shillelagh.adapters.base.Adapter 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) Time (class in shillelagh.fields) Time() (in module shillelagh.types) TimeFromTicks() (in module shillelagh.types) Timestamp() (in module shillelagh.types) TimestampFromTicks() (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.backends.apsw.dialects.base.SQLAlchemyColumn attribute) (shillelagh.fields.Blob attribute) (shillelagh.fields.Boolean attribute) (shillelagh.fields.Date attribute) (shillelagh.fields.DateTime 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.StringDuration attribute) (shillelagh.fields.StringInteger attribute) (shillelagh.fields.Time attribute)

type_compiler (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect attribute) type_compiler_instance (shillelagh.backends.apsw.dialects.safe.APSWSafeDialect 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) 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) 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)

VTCursor (class in shillelagh.backends.apsw.vt) VTModule (class in shillelagh.backends.apsw.vt) VTTable (class in shillelagh.backends.apsw.vt)

W

Warning

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)