lsst.dax.apdb.sql.modelToSql.GUID Class Reference

Inheritance diagram for lsst.dax.apdb.sql.modelToSql.GUID:

Public Member Functions
sqlalchemy.types.TypeEngine	load_dialect_impl (self, sqlalchemy.engine.Dialect dialect)
str|None	process_bind_param (self, Any value, sqlalchemy.engine.Dialect dialect)
uuid.UUID|None	process_result_value (self, str|uuid.UUID|None value, sqlalchemy.engine.Dialect dialect)

Static Public Attributes
	impl = sqlalchemy.CHAR
bool	cache_ok = True

Detailed Description

Platform-independent GUID type.

Uses PostgreSQL's UUID type, otherwise uses CHAR(32), storing as
stringified hex values.

Definition at line 40 of file modelToSql.py.

Member Function Documentation

load_dialect_impl()

sqlalchemy.types.TypeEngine lsst.dax.apdb.sql.modelToSql.GUID.load_dialect_impl	(		self,
		sqlalchemy.engine.Dialect	dialect )

Definition at line 51 of file modelToSql.py.

    def load_dialect_impl(self, dialect: sqlalchemy.engine.Dialect) -> sqlalchemy.types.TypeEngine:
        if dialect.name == "postgresql":
            return dialect.type_descriptor(UUID())
        else:
            return dialect.type_descriptor(sqlalchemy.CHAR(32))
 

process_bind_param()

str | None lsst.dax.apdb.sql.modelToSql.GUID.process_bind_param	(		self,
		Any	value,
		sqlalchemy.engine.Dialect	dialect )

Definition at line 57 of file modelToSql.py.

    def process_bind_param(self, value: Any, dialect: sqlalchemy.engine.Dialect) -> str | None:
        if value is None:
            return value
 
        # Coerce input to UUID type, in general having UUID on input is the
        # only thing that we want but there is code right now that uses ints.
        if isinstance(value, int):
            value = uuid.UUID(int=value)
        elif isinstance(value, bytes):
            value = uuid.UUID(bytes=value)
        elif isinstance(value, str):
            # hexstring
            value = uuid.UUID(hex=value)
        elif not isinstance(value, uuid.UUID):
            raise TypeError(f"Unexpected type of a bind value: {type(value)}")
 
        if dialect.name == "postgresql":
            return str(value)
        else:
            return "%.32x" % value.int
 

process_result_value()

uuid.UUID | None lsst.dax.apdb.sql.modelToSql.GUID.process_result_value	(		self,
		str | uuid.UUID | None	value,
		sqlalchemy.engine.Dialect	dialect )

Definition at line 78 of file modelToSql.py.

    ) -> uuid.UUID | None:
        if value is None:
            return value
        elif isinstance(value, uuid.UUID):
            # sqlalchemy 2 converts to UUID internally
            return value
        else:
            return uuid.UUID(hex=value)
 
 

Member Data Documentation

cache_ok

bool lsst.dax.apdb.sql.modelToSql.GUID.cache_ok = True

static

Definition at line 49 of file modelToSql.py.

impl

lsst.dax.apdb.sql.modelToSql.GUID.impl = sqlalchemy.CHAR

static

Definition at line 47 of file modelToSql.py.

---

The documentation for this class was generated from the following file:

• /j/snowflake/release/lsstsw/stack/lsst-scipipe-8.0.0/Linux64/dax_apdb/g88963caddf+0cb8e002cc/python/lsst/dax/apdb/sql/modelToSql.py