Viewing file: _schema.py (2.21 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
# DELETE_OBJECT = 'DELETE FROM axiom_objects WHERE oid = ?' CREATE_OBJECT = 'INSERT INTO *DATABASE*.axiom_objects (type_id) VALUES (?)' CREATE_TYPE = 'INSERT INTO *DATABASE*.axiom_types (typename, module, version) VALUES (?, ?, ?)'
BASE_SCHEMA = [""" CREATE TABLE *DATABASE*.axiom_objects ( type_id INTEGER NOT NULL CONSTRAINT fk_type_id REFERENCES axiom_types(oid) ) """,
""" CREATE INDEX *DATABASE*.axiom_objects_type_idx ON axiom_objects(type_id); """,
""" CREATE TABLE *DATABASE*.axiom_types ( typename VARCHAR, module VARCHAR, version INTEGER ) """,
""" CREATE TABLE *DATABASE*.axiom_attributes ( type_id INTEGER, row_offset INTEGER, indexed BOOLEAN, sqltype VARCHAR, allow_none BOOLEAN, pythontype VARCHAR, attribute VARCHAR, docstring TEXT ) """]
TYPEOF_QUERY = """ SELECT *DATABASE*.axiom_types.typename, *DATABASE*.axiom_types.module, *DATABASE*.axiom_types.version FROM *DATABASE*.axiom_types, *DATABASE*.axiom_objects WHERE *DATABASE*.axiom_objects.oid = ? AND *DATABASE*.axiom_types.oid = *DATABASE*.axiom_objects.type_id """
HAS_SCHEMA_FEATURE = ("SELECT COUNT(oid) FROM *DATABASE*.sqlite_master " "WHERE type = ? AND name = ?")
IDENTIFYING_SCHEMA = ('SELECT indexed, sqltype, allow_none, attribute ' 'FROM *DATABASE*.axiom_attributes WHERE type_id = ? ' 'ORDER BY row_offset')
ADD_SCHEMA_ATTRIBUTE = ( 'INSERT INTO *DATABASE*.axiom_attributes ' '(type_id, row_offset, indexed, sqltype, allow_none, attribute, docstring, pythontype) ' 'VALUES (?, ?, ?, ?, ?, ?, ?, ?)')
ALL_TYPES = 'SELECT oid, module, typename, version FROM *DATABASE*.axiom_types'
GET_GREATER_VERSIONS_OF_TYPE = ('SELECT version FROM *DATABASE*.axiom_types ' 'WHERE typename = ? AND version > ?')
SCHEMA_FOR_TYPE = ('SELECT indexed, pythontype, attribute, docstring ' 'FROM *DATABASE*.axiom_attributes ' 'WHERE type_id = ?')
CHANGE_TYPE = 'UPDATE *DATABASE*.axiom_objects SET type_id = ? WHERE oid = ?'
APP_VACUUM = 'DELETE FROM *DATABASE*.axiom_objects WHERE (type_id == -1) AND (oid != (SELECT MAX(oid) from *DATABASE*.axiom_objects))'
|