class LogTable(sql.SQLTable): name = 'log_table' fields = (sql.PrimaryColumn('id', pytis.data.Serial()), sql.Column('table_name', pytis.data.String(),), sql.Column('action', pytis.data.String()), ) unique = (('table_name', 'action',),)
class Circular1(sql.SQLTable): """Circular REFERENCES, together with Circular2.""" name = 'circular1' fields = ( sql.PrimaryColumn('id', pytis.data.Integer()), sql.Column('x', pytis.data.Integer(), references=sql.r.Circular2.id), )
class Products(sql.SQLTable): name = 'products' fields = ( sql.PrimaryColumn('product_id', pytis.data.Serial(), _("ID")), sql.Column('product', pytis.data.String(not_null=True), _("Product")), sql.Column('count', pytis.data.Integer(not_null=True), _("Count")), sql.Column('price', pytis.data.Float(precision=2, not_null=True), _("Price")), sql.Column('since', pytis.data.DateTime(not_null=True), _("Available since")), sql.Column('marked', pytis.data.Boolean(not_null=True), _("Marked"), default=False), sql.Column('notes', pytis.data.String(not_null=False), _("Notes")), ) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data')) init_columns = ('product', 'count', 'price', 'marked', 'since', 'notes') init_values = ( ('HP LaserJet 5L', 0, 399.99, False, '1994-08-18', None), ('HP LaserJet 3050', 32, 299.99, True, '2004-04-08 10:55:20', 'Free standard shipping'), ('HP Photosmart C7180', 8, 399.99, True, '2006-10-11 16:32:41', None), ('HP LaserJet 1020', 5, 179.99, False, '2005-12-01 08:52:22', 'Free standard shipping'), ('HP DeskJet 640s', 2, 188.00, True, '2007-10-11 10:21:00', None), ('HP DeskJet 347A', 6, 219.99, True, '2007-10-11 11:07:00', None), ('HP DeskJet 24D', 9, 249.99, True, '2007-10-11 11:07:00', None), )
class EPytisCryptoKeys(Base_LogSQLTable): """Table of encryption keys of users for defined encryption areas.""" name = 'e_pytis_crypto_keys' schemas = pytis_schemas.value(globals()) fields = ( sql.PrimaryColumn('key_id', pytis.data.Serial()), sql.Column('name', pytis.data.String(not_null=True), label=_("Šifrovací oblast"), references=sql.a(sql.r.CPytisCryptoNames.name, onupdate='CASCADE')), sql.Column('username', pytis.data.String(not_null=True), label=_("Uživatel"), doc="Arbitrary user identifier."), sql.Column('key', pytis.data.Binary(not_null=True)), sql.Column( 'fresh', pytis.data.Boolean(not_null=True), label=_("Nový"), doc= "Flag indicating the key is encrypted by a non-login password. ", default=False), ) inherits = (XChanges, ) unique = (( 'name', 'username', ), ) depends_on = (CPytisCryptoNames, ) access_rights = default_access_rights.value(globals())
class CmsUsersTable(sql.SQLTable): name = 'cms_users_table' schemas = cms_schemas.value(globals()) fields = (sql.PrimaryColumn('uid', pytis.data.Serial()), ) with_oids = True depends_on = () access_rights = ()
class CmsRightsAssignment(sql.SQLTable): """Underlying binding table between menu items, roles and module actions.""" name = 'cms_rights_assignment' schemas = cms_schemas.value(globals()) fields = ( sql.PrimaryColumn('rights_assignment_id', pytis.data.Serial()), sql.Column('menu_item_id', pytis.data.Integer(not_null=True), references=sql.gA('cms_menu_structure', ondelete='CASCADE')), sql.Column('role_id', pytis.data.Integer(not_null=True), references=sql.gA('cms_roles', ondelete='CASCADE')), sql.Column('action_id', pytis.data.Integer(not_null=True), references=sql.gA('cms_actions', ondelete='CASCADE')), ) with_oids = True unique = (( 'menu_item_id', 'role_id', 'action_id', ), ) depends_on = ( CmsMenuStructure, CmsRoles, CmsActions, ) access_rights = cms_rights.value(globals())
class CmsSessionLogData(sql.SQLTable): """Log of web user logins (underlying data).""" name = 'cms_session_log_data' schemas = cms_schemas.value(globals()) fields = ( sql.PrimaryColumn('log_id', pytis.data.Serial()), sql.Column('session_id', pytis.data.Integer(not_null=False), references=sql.gA('cms_session', ondelete='SET NULL')), sql.Column('uid', pytis.data.Integer(not_null=False), references=sql.gA(cms_users_table.value(globals()), ondelete='CASCADE')), sql.Column('login', pytis.data.String(not_null=True)), sql.Column('success', pytis.data.Boolean(not_null=True), default=False), sql.Column('start_time', pytis.data.DateTime(not_null=True)), sql.Column('end_time', pytis.data.DateTime(not_null=False)), sql.Column('ip_address', pytis.data.String(not_null=True)), sql.Column('user_agent', pytis.data.String(not_null=False)), sql.Column('referer', pytis.data.String(not_null=False)), ) with_oids = True depends_on = () access_rights = cms_rights_rw.value(globals())
class EPytisHelpPagesAttachments(Base_LogSQLTable): """Attachments for help texts (images etc.)""" name = 'e_pytis_help_pages_attachments' fields = ( sql.PrimaryColumn('file_id', pytis.data.Serial()), sql.Column('page_id', pytis.data.Integer(not_null=True), references=sql.a(sql.r.EPytisHelpPages.page_id, ondelete='CASCADE')), sql.Column('file_name', pytis.data.String(not_null=True)), sql.Column('byte_size', pytis.data.Integer(not_null=True)), sql.Column('width', pytis.data.Integer(not_null=False)), sql.Column('height', pytis.data.Integer(not_null=False)), sql.Column('resized_width', pytis.data.Integer(not_null=False)), sql.Column('resized_height', pytis.data.Integer(not_null=False)), sql.Column('thumbnail_width', pytis.data.Integer(not_null=False)), sql.Column('thumbnail_height', pytis.data.Integer(not_null=False)), sql.Column('file', pytis.data.Binary(not_null=True)), sql.Column('resized', pytis.data.Binary(not_null=False)), sql.Column('thumbnail', pytis.data.Binary(not_null=False)), ) inherits = (XChanges, ) unique = (( 'page_id', 'file_name', ), ) depends_on = (EPytisHelpPages, ) access_rights = default_access_rights.value(globals())
class EPytisHelpSpecItems(Base_LogSQLTable): """Help texts for specification items, such as fields, bindings, actions.""" name = 'e_pytis_help_spec_items' fields = ( sql.PrimaryColumn('item_id', pytis.data.Serial()), sql.Column('spec_name', pytis.data.String(not_null=True), references=sql.a(sql.r.EPytisHelpSpec.spec_name, onupdate='CASCADE', ondelete='CASCADE')), sql.Column( 'kind', pytis.data.String(not_null=True), check="kind in ('field', 'profile', 'binding', 'action', 'proc')"), sql.Column('identifier', pytis.data.String(not_null=True)), sql.Column('content', pytis.data.String(not_null=False)), sql.Column('changed', pytis.data.Boolean(not_null=True), doc="True when the content was edited by hand.", default=False), sql.Column('removed', pytis.data.Boolean(not_null=True), doc="False when the item still exists in specification.", default=False), ) inherits = (XChanges, ) unique = (( 'spec_name', 'kind', 'identifier', ), ) depends_on = () access_rights = default_access_rights.value(globals())
class EPytisFormLog(sql.SQLTable): """ Statistics about using forms by users and form opening performance. form is fully qualified specification name. class is pytis class name of the form instance. login is login name of the user who has opened the form. info is optional extra information provided by the form (e.g. sorting used). t_start is the time when user invoked the form opening command. t_show is the time when the form got actually ready for operation after its start. """ name = 'e_pytis_form_log' schemas = pytis_schemas.value(globals()) fields = ( sql.PrimaryColumn('id', pytis.data.Serial()), sql.Column('form', pytis.data.String(not_null=True), index=True), sql.Column('class', pytis.data.String(not_null=True), index=True), sql.Column('info', pytis.data.String(not_null=False), index=True), sql.Column('login', pytis.data.Name(not_null=True), index=True), sql.Column('t_start', pytis.data.DateTime(not_null=True, without_timezone=True), index=True), sql.Column('t_show', pytis.data.DateTime(not_null=True, without_timezone=True)), ) inherits = (XChanges, ) with_oids = True depends_on = () access_rights = default_access_rights.value(globals())
class CmsMenuStructure(sql.SQLTable): """Language independent menu structure.""" name = 'cms_menu_structure' schemas = cms_schemas.value(globals()) fields = ( sql.PrimaryColumn('menu_item_id', pytis.data.Serial()), sql.Column('identifier', pytis.data.String(maxlen=32, not_null=True), unique=True), sql.Column('parent', pytis.data.Integer(not_null=False), references=sql.gA('cms_menu_structure')), sql.Column('mod_id', pytis.data.Integer(not_null=False), references=sql.gA('cms_modules')), sql.Column('ord', pytis.data.Integer(not_null=True)), sql.Column('tree_order', pytis.data.LTree(not_null=False)), ) index_columns = ( #('ord', sqlalchemy.literal_column('coalesce(parent, 0)'),), ( 'parent', 'ord', ), ) with_oids = True depends_on = (CmsModules, ) access_rights = cms_rights.value(globals())
class CmsActions(sql.SQLTable): """Enumeration of valid actions. (Including both module independent actions and per module actions.) Module independent actions have NULL in the mod_id column. """ name = '_cms_actions' external = True schemas = cms_schemas.value(globals()) fields = ( sql.PrimaryColumn('action_id', pytis.data.Serial()), sql.Column('mod_id', pytis.data.Integer(not_null=False), references=sql.gA('cms_modules', ondelete='CASCADE')), sql.Column('name', pytis.data.String(maxlen=16, not_null=True)), sql.Column('description', pytis.data.String(not_null=True)), ) unique = (( 'mod_id', 'name', ), ) depends_on = (CmsModules, ) access_rights = cms_rights.value(globals()) init_columns = ('name', 'description') init_values = ( ('visit', 'Display the item content'), ('show', 'See the item in the menu'), )
class ReferencingTable(sql.SQLTable): name = 'referencing_table' fields = (sql.PrimaryColumn('id', pytis.data.Serial()), sql.Column('name', pytis.data.String()), sql.Column('action', pytis.data.String()), ) foreign_keys = (sql.a(('name', 'action',), (sql.r.LogTable.table_name, sql.r.LogTable.action,), onupdate='cascade', ondelete='cascade'),)
class Longtable(sql.SQLTable): name = 'longtable' fields = ( sql.PrimaryColumn('id', pytis.data.Serial(), _("ID")), sql.Column('value', pytis.data.String(maxlen=6, not_null=False), _("Value")), ) with_oids = True depends_on = () access_rights = ()
class Passwords(sql.SQLTable): name = 'passwords' fields = ( sql.PrimaryColumn('id', pytis.data.Serial()), sql.Column('name', pytis.data.String(not_null=True), _("Name"), unique=True), sql.Column('passwd', pytis.data.String(not_null=True), _("Password")), ) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data'))
class BinaryData(sql.SQLTable): name = 'binary_data' fields = ( sql.PrimaryColumn('id', pytis.data.Serial(), _("Id")), sql.Column('data', pytis.data.Binary(not_null=True), _("File")), sql.Column('descr', pytis.data.String(not_null=True), _("Description")), sql.Column('filename', pytis.data.String(not_null=True), _("File name")), ) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data'))
class CmsUsers(sql.SQLTable): name = 'cms_users' fields = ( sql.PrimaryColumn('uid', pytis.data.Serial()), sql.Column('login', pytis.data.String(not_null=True), unique=True), sql.Column('passwd', pytis.data.String(not_null=True)), sql.Column('fullname', pytis.data.String(not_null=True)), ) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data'))
class RangeTypes(sql.SQLTable): name = 'range_types' fields = ( sql.PrimaryColumn('range_id', pytis.data.Serial(), _("ID")), sql.Column('date_range', pytis.data.DateRange(not_null=True), _("Date")), sql.Column('datetime_range', pytis.data.DateTimeRange(not_null=True), _("DateTime")), sql.Column('int_range', pytis.data.IntegerRange(not_null=True), _("Integer")), ) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data'))
class CmsUsers(sql.SQLTable): name = 'pytis_cms_users' schemas = cms_schemas.value(globals()) fields = ( sql.PrimaryColumn('uid', pytis.data.Serial()), sql.Column('login', pytis.data.String(not_null=True), unique=True), sql.Column('fullname', pytis.data.String(not_null=True)), sql.Column('passwd', pytis.data.String(not_null=True)), ) depends_on = () access_rights = ()
class XTree(sql.SQLTable): name = '_tree' fields = ( sql.PrimaryColumn('id', pytis.data.LTree(not_null=False)), sql.Column('name', pytis.data.Name()), sql.Column('amount', pytis.data.Integer(not_null=False)), sql.Column('description', pytis.data.String(not_null=False)), ) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data'))
class Files(sql.SQLTable): name = 'files' fields = ( sql.PrimaryColumn('id', pytis.data.Serial(), _("ID")), sql.Column('file', pytis.data.String(not_null=False), _("File")), sql.Column('url', pytis.data.String(not_null=False), _("URL")), ) init_columns = ('id', 'file', 'url') init_values = ((0, '/Python26/README.txt', 'http://www.python.org',),) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data'))
class Log(sql.SQLTable): """Tabulka pro logování provedených DML příkazů.""" name = 'log' fields = (sql.PrimaryColumn('id', pytis.data.Serial()), sql.Column('command', pytis.data.String(not_null=True)), sql.Column('login', pytis.data.Name(not_null=True), default=sqlalchemy.text('user')), sql.Column('timestamp', pytis.data.DateTime(not_null=True), default=sqlalchemy.text('now()')), ) with_oids = True depends_on = () access_rights = default_access_rights.value(globals())
class EPytisConfig(sql.SQLTable): """Pytis application configuration storage.""" name = 'e_pytis_config' schemas = pytis_schemas.value(globals()) fields = (sql.PrimaryColumn('id', pytis.data.Serial()), sql.Column('username', pytis.data.Name(not_null=True)), sql.Column('option', pytis.data.String(not_null=True)), sql.Column('value', pytis.data.String(not_null=True)), ) inherits = (XChanges,) unique = (('username', 'option',),) depends_on = () access_rights = default_access_rights.value(globals())
class CmsLanguages(sql.SQLTable): """Codebook of languages available in the CMS.""" name = 'cms_languages' schemas = cms_schemas.value(globals()) fields = ( sql.PrimaryColumn('lang_id', pytis.data.Serial()), sql.Column('lang', pytis.data.String(minlen=2, maxlen=2, not_null=True), unique=True), ) with_oids = True depends_on = () access_rights = cms_rights.value(globals())
class RuntimeFilterDemo(sql.SQLTable): name = 'runtime_filter_demo' fields = ( sql.PrimaryColumn('id', pytis.data.Serial()), sql.Column('product_id', pytis.data.Integer(not_null=True), references=sql.r.Products), sql.Column('country', pytis.data.String(minlen=2, maxlen=2, not_null=True), references=sql.r.Countries), sql.Column('continent', pytis.data.String(minlen=2, maxlen=2, not_null=True), references=sql.r.Continents), ) with_oids = True depends_on = () access_rights = (('all', 'pytis-demo'), ('select', 'www-data'))
class CmsModules(sql.SQLTable): """Codebook of extension modules available in the CMS.""" name = 'cms_modules' schemas = cms_schemas.value(globals()) fields = ( sql.PrimaryColumn('mod_id', pytis.data.Serial()), sql.Column('modname', pytis.data.String(maxlen=64, not_null=True), unique=True), ) with_oids = True depends_on = () access_rights = cms_rights.value(globals())
class XChangesStatistic(sql.SQLTable): """Tabulka pro statistiky změn v tabulkách.""" name = '_changes_statistic' fields = (sql.PrimaryColumn('id', pytis.data.Serial(), doc="identifikace řádku"), sql.Column('uzivatel', pytis.data.Name(not_null=True), default=sqlalchemy.text('user')), sql.Column('datum', pytis.data.Date(not_null=False)), sql.Column('inserts', pytis.data.Integer(not_null=False)), sql.Column('updates', pytis.data.Integer(not_null=False)), sql.Column('deletes', pytis.data.Integer(not_null=False)), ) with_oids = True depends_on = () access_rights = default_access_rights.value(globals())
class CTypFormular(Base_LogSQLTable): """Slouží jako číselník typů formulářů""" name = 'c_typ_formular' fields = (sql.PrimaryColumn('id', pytis.data.String(maxlen=2, not_null=False)), sql.Column('popis', pytis.data.String(not_null=False)), ) inherits = (XChanges,) init_columns = ('id', 'popis') init_values = (('BF', 'Jednoduchý náhled',), ('DF', 'Duální náhled',), ) with_oids = True depends_on = () access_rights = default_access_rights.value(globals())
class PytisCryptoDbKeys(sql.SQLTable): """ Table of asymetric encryption keys. It is currently used to encrypt user passwords passed to some database functions. Use select pytis_crypto_create_db_key('pytis', 1024) to create a key for that purpose. """ name = 'pytis_crypto_db_keys' schemas = pytis_schemas.value(globals()) fields = ( sql.PrimaryColumn('key_name', pytis.data.String(not_null=False)), sql.Column('public', pytis.data.String(not_null=False)), sql.Column('private', pytis.data.String(not_null=False)), ) depends_on = () access_rights = crypto_select_rights.value(globals())
class CPytisCryptoNames(Base_LogSQLTable): """Codebook of encryption areas defined in the application.""" name = 'c_pytis_crypto_names' schemas = pytis_schemas.value(globals()) fields = ( sql.PrimaryColumn('name', pytis.data.String(not_null=False), label=_("Šifrovací oblast")), sql.Column('description', pytis.data.String(not_null=False), label=_("Popis")), ) inherits = (XChanges, ) depends_on = () access_rights = default_access_rights.value(globals())