sqlalchemy.dialects.sqlite.aiosqlite.SQLiteDialect

class documentation

class SQLiteDialect_aiosqlite(SQLiteDialect_pysqlite):

Undocumented

Class Method	`dbapi`	Undocumented
Class Method	`get_pool_class`	Undocumented
Method	`get_driver_connection`	Returns the connection object as returned by the external driver package.
Method	`is_disconnect`	Return True if the given DB-API error indicates an invalid connection
Class Variable	`driver`	Undocumented
Class Variable	`is_async`	Undocumented
Class Variable	`supports_server_side_cursors`	Undocumented
Class Variable	`supports_statement_cache`	indicates if this dialect supports caching.

Inherited from SQLiteDialect_pysqlite:

Class Method	`_is_url_file_db`	Undocumented
Method	`_get_server_version_info`	Retrieve the server version info from the given connection.
Method	`create_connect_args`	Build DB-API compatible connection arguments.
Method	`on_connect`	return a callable which sets up a newly created DBAPI connection.
Method	`set_isolation_level`	Given a DBAPI connection, set its isolation level.
Class Variable	`_isolation_lookup`	Undocumented
Class Variable	`colspecs`	Undocumented
Class Variable	`default_paramstyle`	Undocumented
Class Variable	`description_encoding`	Undocumented

Inherited from SQLiteDialect (via SQLiteDialect_pysqlite):

Method	`__init__`	Undocumented
Method	`_find_cols_in_sig`	Undocumented
Method	`_get_column_info`	Undocumented
Method	`_get_default_schema_name`	Return the string name of the currently selected schema from the given connection.
Method	`_get_table_pragma`	Undocumented
Method	`_get_table_sql`	Undocumented
Method	`_resolve_type_affinity`	Return a data type from a reflected column, using affinity rules.
Method	`get_check_constraints`	Return information about check constraints in `table_name`.
Method	`get_columns`	Return information about columns in `table_name`.
Method	`get_foreign_keys`	Return information about foreign_keys in `table_name`.
Method	`get_indexes`	Return information about indexes in `table_name`.
Method	`get_isolation_level`	Given a DBAPI connection, return its isolation level.
Method	`get_pk_constraint`	Return information about the primary key constraint on table_name`.
Method	`get_schema_names`	Undocumented
Method	`get_table_names`	Return a list of table names for `schema`.
Method	`get_temp_table_names`	Return a list of temporary table names on the given connection, if supported by the underlying backend.
Method	`get_temp_view_names`	Return a list of temporary view names on the given connection, if supported by the underlying backend.
Method	`get_unique_constraints`	Return information about unique constraints in `table_name`.
Method	`get_view_definition`	Return view definition.
Method	`get_view_names`	Return a list of all view names available in the database.
Method	`has_table`	For internal dialect use, check the existence of a particular table in the database.
Class Variable	`construct_arguments`	Optional set of argument specifiers for various SQLAlchemy constructs, typically schema items.
Class Variable	`name`	Undocumented
Class Variable	`supports_alter`	Undocumented
Class Variable	`supports_default_metavalue`	dialect supports INSERT... VALUES (DEFAULT) syntax
Class Variable	`supports_empty_insert`	dialect supports INSERT () VALUES ()
Class Variable	`supports_unicode_binds`	Undocumented
Class Variable	`supports_unicode_statements`	Undocumented
Class Variable	`tuple_in_values`	Undocumented
Instance Variable	`_broken_dotted_colnames`	Undocumented
Instance Variable	`_broken_fk_pragma_quotes`	Undocumented
Instance Variable	`_json_deserializer`	Undocumented
Instance Variable	`_json_serializer`	Undocumented
Instance Variable	`isolation_level`	Undocumented
Instance Variable	`native_datetime`	Undocumented
Instance Variable	`supports_cast`	Undocumented
Instance Variable	`supports_default_values`	dialect supports INSERT... DEFAULT VALUES syntax
Instance Variable	`supports_multivalues_insert`	Undocumented

Inherited from DefaultDialect (via SQLiteDialect_pysqlite, SQLiteDialect):

Class Method	`load_provisioning`	set up the provision.py module for this dialect.
Method	`connect`	Establish a connection using this dialect's DBAPI.
Method	`create_xid`	Create a random two-phase transaction ID.
Method	`denormalize_name`	convert the given name to a case insensitive identifier for the backend if it is an all-lowercase name.
Method	`do_begin`	Provide an implementation of `connection.begin()`, given a DB-API connection.
Method	`do_close`	Provide an implementation of `connection.close()`, given a DBAPI connection.
Method	`do_commit`	Provide an implementation of `connection.commit()`, given a DB-API connection.
Method	`do_execute`	Provide an implementation of `cursor.execute(statement, parameters)`.
Method	`do_execute_no_params`	Provide an implementation of `cursor.execute(statement)`.
Method	`do_executemany`	Provide an implementation of `cursor.executemany(statement, parameters)`.
Method	`do_release_savepoint`	Release the named savepoint on a connection.
Method	`do_rollback`	Provide an implementation of `connection.rollback()`, given a DB-API connection.
Method	`do_rollback_to_savepoint`	Rollback a connection to the named savepoint.
Method	`do_savepoint`	Create a savepoint with the given name.
Method	`get_default_isolation_level`	Given a DBAPI connection, return its isolation level, or a default isolation level if one cannot be retrieved.
Method	`has_index`	Check the existence of a particular index name in the database.
Method	`initialize`	Called during strategized creation of the dialect with a connection.
Method	`normalize_name`	convert the given name to lowercase if it is detected as case insensitive.
Method	`reset_isolation_level`	Given a DBAPI connection, revert its isolation to the default.
Method	`type_descriptor`	Provide a database-specific `.TypeEngine` object, given the generic object which comes from the types module.
Class Variable	`dbapi_exception_translation_map`	mapping used in the extremely unusual case that a DBAPI's published exceptions don't actually have the __name__ that they are linked towards.
Instance Variable	`returns_unicode_strings`	Undocumented
Instance Variable	`type_compiler`	Undocumented
Method	`_check_max_identifier_length`	Perform a connection / server version specific check to determine the max_identifier_length.
Method	`_check_unicode_description`	Undocumented
Method	`_check_unicode_returns`	Undocumented
Method	`_ensure_has_table_connection`	Undocumented
Method	`_reset_characteristics`	Undocumented
Method	`_set_connection_characteristics`	Undocumented
Method	`do_ping`	Undocumented
Method	`get_dialect_pool_class`	Undocumented
Method	`set_connection_execution_options`	Undocumented
Method	`set_engine_execution_options`	Undocumented
Method	`validate_identifier`	Undocumented
Class Variable	`connection_characteristics`	Undocumented
Class Variable	`cte_follows_insert`	Undocumented
Class Variable	`default_sequence_base`	Undocumented
Class Variable	`engine_config_types`	Undocumented
Class Variable	`full_returning`	Undocumented
Class Variable	`inline_comments`	Undocumented
Class Variable	`insert_executemany_returning`	Undocumented
Class Variable	`max_constraint_name_length`	Undocumented
Class Variable	`max_index_name_length`	Undocumented
Class Variable	`non_native_boolean_check_constraint`	Undocumented
Class Variable	`postfetch_lastrowid`	Undocumented
Class Variable	`preexecute_autoincrement_sequences`	Undocumented
Class Variable	`reflection_options`	Undocumented
Class Variable	`requires_name_normalize`	Undocumented
Class Variable	`sequences_optional`	Undocumented
Class Variable	`server_side_cursors`	Undocumented
Class Variable	`supports_comments`	Undocumented
Class Variable	`supports_for_update_of`	Undocumented
Class Variable	`supports_identity_columns`	Undocumented
Class Variable	`supports_is_distinct_from`	Undocumented
Class Variable	`supports_native_decimal`	Undocumented
Class Variable	`supports_native_enum`	Undocumented
Class Variable	`supports_sane_multi_rowcount`	Undocumented
Class Variable	`supports_sane_rowcount`	Undocumented
Class Variable	`supports_schemas`	Undocumented
Class Variable	`supports_sequences`	Undocumented
Class Variable	`supports_simple_order_by_label`	Undocumented
Class Variable	`supports_views`	Undocumented
Class Variable	`use_setinputsizes`	Undocumented
Instance Variable	`_decoder`	Undocumented
Instance Variable	`_description_decoder`	Undocumented
Instance Variable	`_encoder`	Undocumented
Instance Variable	`_ischema`	Undocumented
Instance Variable	`_user_defined_max_identifier_length`	Undocumented
Instance Variable	`case_sensitive`	Undocumented
Instance Variable	`compiler_linting`	Undocumented
Instance Variable	`convert_unicode`	Undocumented
Instance Variable	`default_isolation_level`	Undocumented
Instance Variable	`default_schema_name`	Undocumented
Instance Variable	`encoding`	Undocumented
Instance Variable	`identifier_preparer`	Undocumented
Instance Variable	`implicit_returning`	Undocumented
Instance Variable	`label_length`	Undocumented
Instance Variable	`max_identifier_length`	Undocumented
Instance Variable	`paramstyle`	Undocumented
Instance Variable	`positional`	Undocumented
Instance Variable	`server_version_info`	Undocumented
Instance Variable	`supports_native_boolean`	Undocumented
Property	`_dialect_specific_select_one`	Undocumented
Property	`_supports_statement_cache`	Undocumented
Property	`_type_memos`	Undocumented
Property	`dialect_description`	Undocumented
Property	`supports_sane_rowcount_returning`	True if this dialect supports sane rowcount even if RETURNING is in use.

Inherited from Dialect (via SQLiteDialect_pysqlite, SQLiteDialect, DefaultDialect):

Class Method	`engine_created`	A convenience hook called before returning the final `_engine.Engine`.
Class Method	`get_dialect_cls`	Given a URL, return the `.Dialect` that will be used.
Method	`do_begin_twophase`	Begin a two phase transaction on the given connection.
Method	`do_commit_twophase`	Commit a two phase transaction on the given connection.
Method	`do_prepare_twophase`	Prepare a two phase transaction on the given connection.
Method	`do_recover_twophase`	Recover list of uncommitted prepared two phase transaction identifiers on the given connection.
Method	`do_rollback_twophase`	Rollback a two phase transaction on the given connection.
Method	`do_set_input_sizes`	invoke the cursor.setinputsizes() method with appropriate arguments
Method	`get_sequence_names`	Return a list of all sequence names available in the database.
Method	`get_table_comment`	Return the "comment" for the table identified by `table_name`.
Method	`has_sequence`	Check the existence of a particular sequence in the database.
Method	`on_connect_url`	return a callable which sets up a newly created DBAPI connection.
Class Variable	`_has_events`	Undocumented

@classmethod
def dbapi(cls):

overrides sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite.dbapi

Undocumented

@classmethod
def get_pool_class(cls, url):

overrides sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite.get_pool_class

Undocumented

def get_driver_connection(self, connection):

overrides sqlalchemy.engine.default.DefaultDialect.get_driver_connection

Returns the connection object as returned by the external driver package.

For normal dialects that use a DBAPI compliant driver this call will just return the connection passed as argument. For dialects that instead adapt a non DBAPI compliant driver, like when adapting an asyncio driver, this call will return the connection-like object as returned by the driver.

New in version 1.4.24.

def is_disconnect(self, e, connection, cursor):

overrides sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite.is_disconnect

Return True if the given DB-API error indicates an invalid connection

driver: str =

overrides sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite.driver

Undocumented

is_async: bool =

overrides sqlalchemy.engine.default.DefaultDialect.is_async

Undocumented

supports_server_side_cursors: bool =

overrides sqlalchemy.engine.default.DefaultDialect.supports_server_side_cursors

Undocumented

supports_statement_cache: bool =

overrides sqlalchemy.dialects.sqlite.pysqlite.SQLiteDialect_pysqlite.supports_statement_cache

indicates if this dialect supports caching.

All dialects that are compatible with statement caching should set this flag to True directly on each dialect class and subclass that supports it. SQLAlchemy tests that this flag is locally present on each dialect subclass before it will use statement caching. This is to provide safety for legacy or new dialects that are not yet fully tested to be compliant with SQL statement caching.

New in version 1.4.5.

sqlalchemy.dialects.sqlite.aiosqlite.SQLiteDialect_aiosqlite

`sqlalchemy.dialects.sqlite.aiosqlite.SQLiteDialect_aiosqlite`