Go to the source code of this file.

Classes
class	homeassistant.components.recorder.db_schema._StatisticsMeta

class	homeassistant.components.recorder.db_schema._StatisticsShortTerm

class	homeassistant.components.recorder.db_schema.Base

class	homeassistant.components.recorder.db_schema.EventData

class	homeassistant.components.recorder.db_schema.Events

class	homeassistant.components.recorder.db_schema.EventTypes

class	homeassistant.components.recorder.db_schema.FAST_PYSQLITE_DATETIME

class	homeassistant.components.recorder.db_schema.JSONLiteral

class	homeassistant.components.recorder.db_schema.LegacyBase

class	homeassistant.components.recorder.db_schema.LegacyStatisticsMeta

class	homeassistant.components.recorder.db_schema.LegacyStatisticsShortTerm

class	homeassistant.components.recorder.db_schema.MigrationChanges

class	homeassistant.components.recorder.db_schema.NativeLargeBinary

class	homeassistant.components.recorder.db_schema.RecorderRuns

class	homeassistant.components.recorder.db_schema.SchemaChanges

class	homeassistant.components.recorder.db_schema.StateAttributes

class	homeassistant.components.recorder.db_schema.States

class	homeassistant.components.recorder.db_schema.StatesMeta

class	homeassistant.components.recorder.db_schema.Statistics

class	homeassistant.components.recorder.db_schema.StatisticsBase

class	homeassistant.components.recorder.db_schema.StatisticsMeta

class	homeassistant.components.recorder.db_schema.StatisticsRuns

class	homeassistant.components.recorder.db_schema.StatisticsShortTerm

class	homeassistant.components.recorder.db_schema.Unused

class	homeassistant.components.recorder.db_schema.UnusedDateTime

Namespaces
	homeassistant.components.recorder.db_schema

Functions
str	homeassistant.components.recorder.db_schema.compile_char_one (TypeDecorator type_, Any compiler, **Any kw)

str	homeassistant.components.recorder.db_schema.compile_char_zero (TypeDecorator type_, Any compiler, **Any kw)

Variables
dictionary	homeassistant.components.recorder.db_schema._DEFAULT_TABLE_ARGS

	homeassistant.components.recorder.db_schema._LOGGER = logging.getLogger(__name__)

dictionary	homeassistant.components.recorder.db_schema._MATCH_ALL_KEEP

list	homeassistant.components.recorder.db_schema.ALL_TABLES

string	homeassistant.components.recorder.db_schema.BIG_INTEGER_SQL = "BIGINT"

	homeassistant.components.recorder.db_schema.ColumnElement

	homeassistant.components.recorder.db_schema.CONTEXT_BINARY_TYPE

int	homeassistant.components.recorder.db_schema.CONTEXT_ID_BIN_MAX_LENGTH = 16

tuple	homeassistant.components.recorder.db_schema.DATETIME_TYPE

string	homeassistant.components.recorder.db_schema.DOUBLE_PRECISION_TYPE_SQL = "DOUBLE PRECISION"

tuple	homeassistant.components.recorder.db_schema.DOUBLE_TYPE

	homeassistant.components.recorder.db_schema.EVENT_DATA_JSON

list	homeassistant.components.recorder.db_schema.EVENT_ORIGIN_ORDER = [EventOrigin.local, EventOrigin.remote]

string	homeassistant.components.recorder.db_schema.EVENTS_CONTEXT_ID_BIN_INDEX = "ix_events_context_id_bin"

	homeassistant.components.recorder.db_schema.ID_TYPE = BigInteger().with_variant(sqlite.INTEGER, "sqlite")

	homeassistant.components.recorder.db_schema.JSON_VARIANT_CAST

	homeassistant.components.recorder.db_schema.JSONB_VARIANT_CAST

string	homeassistant.components.recorder.db_schema.LAST_UPDATED_INDEX_TS = "ix_states_last_updated_ts"

string	homeassistant.components.recorder.db_schema.LEGACY_STATES_ENTITY_ID_LAST_UPDATED_INDEX = "ix_states_entity_id_last_updated_ts"

string	homeassistant.components.recorder.db_schema.LEGACY_STATES_EVENT_ID_INDEX = "ix_states_event_id"

int	homeassistant.components.recorder.db_schema.MAX_EVENT_DATA_BYTES = 32768

int	homeassistant.components.recorder.db_schema.MAX_STATE_ATTRS_BYTES = 16384

string	homeassistant.components.recorder.db_schema.METADATA_ID_LAST_UPDATED_INDEX_TS = "ix_states_metadata_id_last_updated_ts"

string	homeassistant.components.recorder.db_schema.MYSQL_COLLATE = "utf8mb4_unicode_ci"

string	homeassistant.components.recorder.db_schema.MYSQL_DEFAULT_CHARSET = "utf8mb4"

string	homeassistant.components.recorder.db_schema.MYSQL_ENGINE = "InnoDB"

	homeassistant.components.recorder.db_schema.OLD_FORMAT_ATTRS_JSON

	homeassistant.components.recorder.db_schema.OLD_FORMAT_EVENT_DATA_JSON

	homeassistant.components.recorder.db_schema.OLD_STATE = aliased(States, name="old_state")

	homeassistant.components.recorder.db_schema.PSQL_DIALECT = SupportedDialect.POSTGRESQL

int	homeassistant.components.recorder.db_schema.SCHEMA_VERSION = 47

	homeassistant.components.recorder.db_schema.SHARED_ATTR_OR_LEGACY_ATTRIBUTES

	homeassistant.components.recorder.db_schema.SHARED_ATTRS_JSON

	homeassistant.components.recorder.db_schema.SHARED_DATA_OR_LEGACY_EVENT_DATA

string	homeassistant.components.recorder.db_schema.STATES_CONTEXT_ID_BIN_INDEX = "ix_states_context_id_bin"

tuple	homeassistant.components.recorder.db_schema.STATISTICS_TABLES = ("statistics", "statistics_short_term")

string	homeassistant.components.recorder.db_schema.TABLE_EVENT_DATA = "event_data"

string	homeassistant.components.recorder.db_schema.TABLE_EVENT_TYPES = "event_types"

string	homeassistant.components.recorder.db_schema.TABLE_EVENTS = "events"

string	homeassistant.components.recorder.db_schema.TABLE_MIGRATION_CHANGES = "migration_changes"

string	homeassistant.components.recorder.db_schema.TABLE_RECORDER_RUNS = "recorder_runs"

string	homeassistant.components.recorder.db_schema.TABLE_SCHEMA_CHANGES = "schema_changes"

string	homeassistant.components.recorder.db_schema.TABLE_STATE_ATTRIBUTES = "state_attributes"

string	homeassistant.components.recorder.db_schema.TABLE_STATES = "states"

string	homeassistant.components.recorder.db_schema.TABLE_STATES_META = "states_meta"

string	homeassistant.components.recorder.db_schema.TABLE_STATISTICS = "statistics"

string	homeassistant.components.recorder.db_schema.TABLE_STATISTICS_META = "statistics_meta"

string	homeassistant.components.recorder.db_schema.TABLE_STATISTICS_RUNS = "statistics_runs"

string	homeassistant.components.recorder.db_schema.TABLE_STATISTICS_SHORT_TERM = "statistics_short_term"

list	homeassistant.components.recorder.db_schema.TABLES_TO_CHECK

tuple	homeassistant.components.recorder.db_schema.TIMESTAMP_TYPE = DOUBLE_TYPE

	homeassistant.components.recorder.db_schema.UINT_32_TYPE

	homeassistant.components.recorder.db_schema.UNUSED_LEGACY_COLUMN = Unused(0)

	homeassistant.components.recorder.db_schema.UNUSED_LEGACY_DATETIME_COLUMN = UnusedDateTime(timezone=True)

	homeassistant.components.recorder.db_schema.UNUSED_LEGACY_INTEGER_COLUMN = SmallInteger()

Home Assistant Unofficial Reference 2024.12.1

Classes

Namespaces

Functions

Variables