sqlalchemy.databases.sybase.SybaseDialect

class documentation

class SybaseDialect(default.DefaultDialect):

Known subclasses: sqlalchemy.dialects.sybase.pyodbc.SybaseDialect_pyodbc, sqlalchemy.dialects.sybase.pysybase.SybaseDialect_pysybase

View In Hierarchy

Undocumented

Method	`__init__`	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_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_pk_constraint`	Return information about the primary key constraint on table_name`.
Method	`get_schema_names`	Undocumented
Method	`get_table_id`	Fetch the id for schema.table_name.
Method	`get_table_names`	Return a list of table names for `schema`.
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.
Method	`initialize`	Called during strategized creation of the dialect with a connection.
Class Variable	`colspecs`	Undocumented
Class Variable	`construct_arguments`	Optional set of argument specifiers for various SQLAlchemy constructs, typically schema items.
Class Variable	`name`	Undocumented
Class Variable	`postfetch_lastrowid`	Undocumented
Class Variable	`supports_native_boolean`	Undocumented
Class Variable	`supports_sane_multi_rowcount`	Undocumented
Class Variable	`supports_sane_rowcount`	Undocumented
Class Variable	`supports_statement_cache`	indicates if this dialect supports caching.
Class Variable	`supports_unicode_binds`	Undocumented
Class Variable	`supports_unicode_statements`	Undocumented
Instance Variable	`max_identifier_length`	Undocumented

Inherited from DefaultDialect:

Class Method	`get_pool_class`	Undocumented
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_connect_args`	Build DB-API compatible connection arguments.
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	`get_driver_connection`	Returns the connection object as returned by the external driver package.
Method	`has_index`	Check the existence of a particular index name in the database.
Method	`is_disconnect`	Return True if the given DB-API error indicates an invalid connection
Method	`normalize_name`	convert the given name to lowercase if it is detected as case insensitive.
Method	`on_connect`	return a callable which sets up a newly created DBAPI connection.
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.
Class Variable	`supports_default_metavalue`	dialect supports INSERT... VALUES (DEFAULT) syntax
Class Variable	`supports_default_values`	dialect supports INSERT... DEFAULT VALUES syntax
Class Variable	`supports_empty_insert`	dialect supports INSERT () VALUES ()
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_paramstyle`	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	`is_async`	Undocumented
Class Variable	`isolation_level`	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	`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_alter`	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_multivalues_insert`	Undocumented
Class Variable	`supports_native_decimal`	Undocumented
Class Variable	`supports_native_enum`	Undocumented
Class Variable	`supports_schemas`	Undocumented
Class Variable	`supports_sequences`	Undocumented
Class Variable	`supports_server_side_cursors`	Undocumented
Class Variable	`supports_simple_order_by_label`	Undocumented
Class Variable	`supports_views`	Undocumented
Class Variable	`tuple_in_values`	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	`dbapi`	Undocumented
Instance Variable	`default_isolation_level`	Undocumented
Instance Variable	`default_schema_name`	Undocumented
Instance Variable	`description_encoding`	Undocumented
Instance Variable	`encoding`	Undocumented
Instance Variable	`identifier_preparer`	Undocumented
Instance Variable	`implicit_returning`	Undocumented
Instance Variable	`label_length`	Undocumented
Instance Variable	`paramstyle`	Undocumented
Instance Variable	`positional`	Undocumented
Instance Variable	`server_version_info`	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 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	`_get_server_version_info`	Retrieve the server version info from the given connection.
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_check_constraints`	Return information about check constraints in `table_name`.
Method	`get_isolation_level`	Given a DBAPI connection, return its isolation level.
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	`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	`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.
Method	`set_isolation_level`	Given a DBAPI connection, set its isolation level.
Class Variable	`_has_events`	Undocumented

def __init__(self, *args, **kwargs):

overrides sqlalchemy.engine.default.DefaultDialect.__init__

Undocumented

def _get_column_info(self, name, type_, nullable, autoincrement, default, precision, scale, length):

Undocumented

def _get_default_schema_name(self, connection):

overrides sqlalchemy.engine.interfaces.Dialect._get_default_schema_name

Return the string name of the currently selected schema from the given connection.

This is used by the default implementation to populate the "default_schema_name" attribute and is called exactly once upon first connect.

@reflection.cache
def get_columns(self, connection, table_name, schema=None, **kw):

overrides sqlalchemy.engine.interfaces.Dialect.get_columns

Return information about columns in table_name.

Given a _engine.Connection, a string table_name, and an optional string schema, return column information as a list of dictionaries with these keys:

name

the column's name

type

[sqlalchemy.types#TypeEngine]

nullable

boolean

default

the column's default value

autoincrement

boolean

sequence

a dictionary of the form

{'name' : str, 'start' :int, 'increment': int, 'minvalue': int,: 'maxvalue': int, 'nominvalue': bool, 'nomaxvalue': bool, 'cycle': bool, 'cache': int, 'order': bool}

Additional column attributes may be present.

@reflection.cache
def get_foreign_keys(self, connection, table_name, schema=None, **kw):

overrides sqlalchemy.engine.interfaces.Dialect.get_foreign_keys

Return information about foreign_keys in table_name.

Given a _engine.Connection, a string table_name, and an optional string schema, return foreign key information as a list of dicts with these keys:

name: the constraint's name
constrained_columns: a list of column names that make up the foreign key
referred_schema: the name of the referred schema
referred_table: the name of the referred table
referred_columns: a list of column names in the referred table that correspond to constrained_columns

@reflection.cache
def get_indexes(self, connection, table_name, schema=None, **kw):

overrides sqlalchemy.engine.interfaces.Dialect.get_indexes

Return information about indexes in table_name.

Given a _engine.Connection, a string table_name and an optional string schema, return index information as a list of dictionaries with these keys:

name: the index's name
column_names: list of column names in order
unique: boolean

@reflection.cache
def get_pk_constraint(self, connection, table_name, schema=None, **kw):

overrides sqlalchemy.engine.interfaces.Dialect.get_pk_constraint

Return information about the primary key constraint on table_name`.

Given a _engine.Connection, a string table_name, and an optional string schema, return primary key information as a dictionary with these keys:

constrained_columns: a list of column names that make up the primary key
name: optional name of the primary key constraint.

@reflection.cache
def get_schema_names(self, connection, **kw):

Undocumented

def get_table_id(self, connection, table_name, schema=None, **kw):

Fetch the id for schema.table_name.

Several reflection methods require the table id. The idea for using this method is that it can be fetched one time and cached for subsequent calls.

@reflection.cache
def get_table_names(self, connection, schema=None, **kw):

overrides sqlalchemy.engine.interfaces.Dialect.get_table_names

Return a list of table names for schema.

@reflection.cache
def get_view_definition(self, connection, view_name, schema=None, **kw):

overrides sqlalchemy.engine.interfaces.Dialect.get_view_definition

Return view definition.

Given a _engine.Connection, a string view_name, and an optional string schema, return the view definition.

@reflection.cache
def get_view_names(self, connection, schema=None, **kw):

overrides sqlalchemy.engine.interfaces.Dialect.get_view_names

Return a list of all view names available in the database.

Parameters
connection	Undocumented
schema	schema name to query, if not the default schema.
**kw	Undocumented

def has_table(self, connection, table_name, schema=None):

overrides sqlalchemy.engine.interfaces.Dialect.has_table

For internal dialect use, check the existence of a particular table in the database.

Given a _engine.Connection object, a string table_name and optional schema name, return True if the given table exists in the database, False otherwise.

This method serves as the underlying implementation of the public facing .Inspector.has_table method, and is also used internally to implement the "checkfirst" behavior for methods like _schema.Table.create and _schema.MetaData.create_all.

Note

This method is used internally by SQLAlchemy, and is published so that third-party dialects may provide an implementation. It is not the public API for checking for table presence. Please use the .Inspector.has_table method. Alternatively, for legacy cross-compatibility, the _engine.Engine.has_table method may be used.

def initialize(self, connection):

overrides sqlalchemy.engine.default.DefaultDialect.initialize

Called during strategized creation of the dialect with a connection.

Allows dialects to configure options based on server version info or other properties.

The connection passed here is a SQLAlchemy Connection object, with full capabilities.

The initialize() method of the base dialect should be called via super().

Note

as of SQLAlchemy 1.4, this method is called before any _engine.Dialect.on_connect hooks are called.

colspecs: dict =

overrides sqlalchemy.engine.default.DefaultDialect.colspecs

overridden in sqlalchemy.dialects.sybase.pyodbc.SybaseDialect_pyodbc, sqlalchemy.dialects.sybase.pysybase.SybaseDialect_pysybase

Undocumented

construct_arguments: list =

overrides sqlalchemy.engine.default.DefaultDialect.construct_arguments

Optional set of argument specifiers for various SQLAlchemy constructs, typically schema items.

To implement, establish as a series of tuples, as in:

construct_arguments = [
    (schema.Index, {
        "using": False,
        "where": None,
        "ops": None
    })
]

If the above construct is established on the PostgreSQL dialect, the .Index construct will now accept the keyword arguments postgresql_using, postgresql_where, nad postgresql_ops. Any other argument specified to the constructor of .Index which is prefixed with postgresql_ will raise .ArgumentError.

A dialect which does not include a construct_arguments member will not participate in the argument validation system. For such a dialect, any argument name is accepted by all participating constructs, within the namespace of arguments prefixed with that dialect name. The rationale here is so that third-party dialects that haven't yet implemented this feature continue to function in the old way.

New in version 0.9.2.