/usr/share/pyshared/axiom/_schema.py is in python-axiom 0.7.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | # 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))'
|