class DataObject(Model):
"""For queries of R_DATA_MAIN when joining to R_TICKET_MAIN.
The ticket(s) in question should be for a data object; otherwise
CAT_SQL_ERR is thrown.
"""
name = Column(String, 'TICKET_DATA_NAME', 2226)
coll = Column(String, 'TICKET_DATA_COLL_NAME', 2227)
class Collection(Model):
id = Column(Integer, 'COLL_ID', 500)
name = Column(String, 'COLL_NAME', 501)
parent_name = Column(String, 'COLL_PARENT_NAME', 502)
owner_name = Column(String, 'COLL_OWNER_NAME', 503)
owner_zone = Column(String, 'COLL_OWNER_ZONE', 504)
map_id = Column(String, 'COLL_MAP_ID', 505)
inheritance = Column(String, 'COLL_INHERITANCE', 506)
comments = Column(String, 'COLL_COMMENTS', 507)
create_time = Column(DateTime, 'COLL_CREATE_TIME', 508)
modify_time = Column(DateTime, 'COLL_MODIFY_TIME', 509)
class User(Model):
id = Column(Integer, 'USER_ID', 201)
name = Column(String, 'USER_NAME', 202)
type = Column(String, 'USER_TYPE', 203)
zone = Column(String, 'USER_ZONE', 204)
dn = Column(String, 'USER_DN', 205)
info = Column(String, 'USER_INFO', 206)
comment = Column(String, 'USER_COMMENT', 207)
create_time = Column(DateTime, 'USER_CREATE_TIME', 208)
modify_time = Column(DateTime, 'USER_MODIFY_TIME', 209)
class Collection(Model):
"""For queries of R_COLL_MAIN when joining to R_TICKET_MAIN.
The returned ticket(s) will be limited to those issued for collections.
"""
name = Column(String, 'TICKET_COLL_NAME', 2228)
class RuleExec(Model):
id = Column(Integer, 'RULE_EXEC_ID', 1000)
name = Column(String, 'RULE_EXEC_NAME', 1001)
rei_file_path = Column(String, 'RULE_EXEC_REI_FILE_PATH', 1002)
user_name = Column(String, 'RULE_EXEC_USER_NAME', 1003)
time = Column(DateTime, 'RULE_EXEC_TIME', 1005)
last_exe_time = Column(DateTime, 'RULE_EXEC_LAST_EXE_TIME', 1010)
frequency = Column(String, 'RULE_EXEC_FREQUENCY', 1006)
priority = Column(String, 'RULE_EXEC_PRIORITY', 1007)
class UserMeta(Model):
id = Column(String, 'COL_META_USER_ATTR_ID', 643)
name = Column(String, 'COL_META_USER_ATTR_NAME', 640)
value = Column(String, 'COL_META_USER_ATTR_VALUE', 641)
units = Column(String, 'COL_META_USER_ATTR_UNITS', 642)
create_time = Column(DateTime, 'COL_META_USER_CREATE_TIME', 644)
modify_time = Column(DateTime, 'COL_META_USER_MODIFY_TIME', 645)
class ResourceMeta(Model):
id = Column(String, 'COL_META_RESC_ATTR_UNITS', 633)
name = Column(String, 'COL_META_RESC_ATTR_NAME', 630)
value = Column(String, 'COL_META_RESC_ATTR_VALUE', 631)
units = Column(String, 'COL_META_RESC_ATTR_UNITS', 632)
create_time = Column(DateTime, 'COL_META_RESC_CREATE_TIME', 634)
modify_time = Column(DateTime, 'COL_META_RESC_MODIFY_TIME', 635)
class CollectionMeta(Model):
id = Column(String, 'COL_META_COLL_ATTR_UNITS', 613)
name = Column(String, 'COL_META_COLL_ATTR_NAME', 610)
value = Column(String, 'COL_META_COLL_ATTR_VALUE', 611)
units = Column(String, 'COL_META_COLL_ATTR_UNITS', 612)
create_time = Column(DateTime, 'COL_META_COLL_CREATE_TIME', 614)
modify_time = Column(DateTime, 'COL_META_COLL_MODIFY_TIME', 615)
class DataObjectMeta(Model):
id = Column(String, 'COL_META_DATA_ATTR_ID', 603)
name = Column(String, 'COL_META_DATA_ATTR_NAME', 600)
value = Column(String, 'COL_META_DATA_ATTR_VALUE', 601)
units = Column(String, 'COL_META_DATA_ATTR_UNITS', 602)
create_time = Column(DateTime, 'COL_META_DATA_CREATE_TIME', 604)
modify_time = Column(DateTime, 'COL_META_DATA_MODIFY_TIME', 605)
class Zone(Model):
id = Column(Integer, 'ZONE_ID', 101)
name = Column(String, 'ZONE_NAME', 102)
class CollectionAccess(Model):
type = Column(Integer, 'COL_COLL_ACCESS_TYPE', 710)
name = Column(String, 'COL_COLL_ACCESS_NAME', 711)
token_namespace = Column(String, 'COL_COLL_TOKEN_NAMESPACE', 712)
user_id = Column(Integer, 'COL_COLL_ACCESS_USER_ID', 713)
access_id = Column(Integer, 'COL_COLL_ACCESS_COLL_ID', 714)
class DataAccess(Model):
type = Column(Integer, 'DATA_ACCESS_TYPE', 700)
name = Column(String, 'COL_DATA_ACCESS_NAME', 701)
token_namespace = Column(String, 'COL_DATA_TOKEN_NAMESPACE', 702)
user_id = Column(Integer, 'COL_DATA_ACCESS_USER_ID', 703)
data_id = Column(Integer, 'COL_DATA_ACCESS_DATA_ID', 704)
class UserMeta(Model):
id = Column(String, 'COL_META_USER_ATTR_ID', 643)
name = Column(String, 'COL_META_USER_ATTR_NAME', 640)
value = Column(String, 'COL_META_USER_ATTR_VALUE', 641)
units = Column(String, 'COL_META_USER_ATTR_UNITS', 642)
class ResourceMeta(Model):
id = Column(String, 'COL_META_RESC_ATTR_UNITS', 633)
name = Column(String, 'COL_META_RESC_ATTR_NAME', 630)
value = Column(String, 'COL_META_RESC_ATTR_VALUE', 631)
units = Column(String, 'COL_META_RESC_ATTR_UNITS', 632)
class CollectionMeta(Model):
id = Column(String, 'COL_META_COLL_ATTR_UNITS', 613)
name = Column(String, 'COL_META_COLL_ATTR_NAME', 610)
value = Column(String, 'COL_META_COLL_ATTR_VALUE', 611)
units = Column(String, 'COL_META_COLL_ATTR_UNITS', 612)
class Resource(Model):
id = Column(Integer, 'R_RESC_ID', 301)
name = Column(String, 'R_RESC_ID', 302)
zone_name = Column(String, 'R_ZONE_NAME', 303)
type = Column(String, 'R_TYPE_NAME', 304)
class_name = Column(String, 'R_CLASS_NAME', 305)
location = Column(String, 'R_LOC', 306)
vault_path = Column(String, 'R_VALUT_PATH', 307)
free_space = Column(String, 'R_FREE_SPACE', 308)
info = Column(String, 'R_RESC_INFO', 309)
comment = Column(String, 'R_RESC_COMMENT', 310)
create_time = Column(DateTime, 'R_CREATE_TIME', 311)
modify_time = Column(DateTime, 'R_MODIFY_TIME', 312)
class AllowedHosts(Model):
"""For queries concerning R_TICKET_ALLOWED_HOSTS."""
ticket_id = Column(String, 'COL_TICKET_ALLOWED_HOST_TICKET_ID', 2220)
host = Column(String, 'COL_TICKET_ALLOWED_HOST', 2221)
class DataObject(Model):
id = Column(Integer, 'D_DATA_ID', 401)
collection_id = Column(Integer, 'D_COLL_ID', 402)
name = Column(String, 'DATA_NAME', 403) # basename
replica_number = Column(Integer, 'DATA_REPL_NUM', 404)
version = Column(String, 'DATA_VERSION', 405)
type = Column(String, 'DATA_TYPE_NAME', 406)
size = Column(Integer, 'DATA_SIZE', 407)
resource_name = Column(String, 'D_RESC_NAME', 409)
path = Column(String, 'D_DATA_PATH', 410) # physical path on resource
owner_name = Column(String, 'D_OWNER_NAME', 411)
owner_zone = Column(String, 'D_OWNER_ZONE', 412)
replica_status = Column(String, 'D_REPL_STATUS', 413)
status = Column(String, 'D_DATA_STATUS', 414)
checksum = Column(String, 'D_DATA_CHECKSUM', 415)
expiry = Column(String, 'D_EXPIRY', 416)
map_id = Column(Integer, 'D_MAP_ID', 417)
comments = Column(String, 'D_COMMENTS', 418)
create_time = Column(DateTime, 'D_CREATE_TIME', 419)
modify_time = Column(DateTime, 'D_MODIFY_TIME', 420)
resc_hier = Column(String, 'D_RESC_HIER', 422)
class UserGroup(Model):
id = Column(Integer, 'USER_GROUP_ID', 900)
name = Column(String, 'USER_GROUP_NAME', 901)
class AllowedUsers(Model):
"""For queries concerning R_TICKET_ALLOWED_USERS."""
ticket_id = Column(String, 'COL_TICKET_ALLOWED_USER_TICKET_ID', 2222)
user_name = Column(String, 'COL_TICKET_ALLOWED_USER', 2223)
class Owner(Model):
"""For queries concerning R_TICKET_USER_MAIN."""
name = Column(String, 'TICKET_OWNER_NAME', 2229)
zone = Column(String, 'TICKET_OWNER_ZONE', 2230)
class DataObjectMeta(Model):
id = Column(String, 'COL_META_DATA_ATTR_ID', 603)
name = Column(String, 'COL_META_DATA_ATTR_NAME', 600)
value = Column(String, 'COL_META_DATA_ATTR_VALUE', 601)
units = Column(String, 'COL_META_DATA_ATTR_UNITS', 602)
class CollectionUser(Model):
name = Column(String, 'COL_COLL_USER_NAME', 1300)
zone = Column(String, 'COL_COLL_USER_ZONE', 1301)
class AllowedGroups(Model):
"""For queries concerning R_TICKET_ALLOWED_GROUPS."""
ticket_id = Column(String, 'COL_TICKET_ALLOWED_GROUP_TICKET_ID', 2224)
group_name = Column(String, 'COL_TICKET_ALLOWED_GROUP', 2225)
class Resource(Model):
id = Column(Integer, 'R_RESC_ID', 301)
name = Column(String, 'R_RESC_NAME', 302)
zone_name = Column(String, 'R_ZONE_NAME', 303)
type = Column(String, 'R_TYPE_NAME', 304)
class_name = Column(String, 'R_CLASS_NAME', 305)
location = Column(String, 'R_LOC', 306)
vault_path = Column(String, 'R_VAULT_PATH', 307)
free_space = Column(String, 'R_FREE_SPACE', 308)
free_space_time = Column(String, 'R_FREE_SPACE_TIME', 314)
comment = Column(String, 'R_RESC_COMMENT', 310)
create_time = Column(DateTime, 'R_CREATE_TIME', 311)
modify_time = Column(DateTime, 'R_MODIFY_TIME', 312)
status = Column(String, 'R_RESC_STATUS', 313)
children = Column(String, 'R_RESC_CHILDREN', 315)
context = Column(String, 'R_RESC_CONTEXT', 316)
parent = Column(String, 'R_RESC_PARENT', 317)
obj_count = Column(Integer, 'R_RESC_OBJCOUNT', 318)
class SpecificQueryResult(Model):
'''
To parse results of specific queries. No corresponding iCAT table.
'''
value = Column(String, 'SQL_RESULT_VALUE', 0)
class UserAuth(Model):
user_id = Column(Integer, 'USER_AUTH_ID', 1600)
user_dn = Column(String, 'USER_DN', 1601)
class Ticket(Model):
"""For queries of R_TICKET_MAIN."""
id = Column(Integer, 'TICKET_ID', 2200)
string = Column(String, 'TICKET_STRING', 2201)
type = Column(String, 'TICKET_TYPE', 2202)
user_id = Column(Integer, 'TICKET_USER_ID', 2203)
object_id = Column(Integer, 'TICKET_OBJECT_ID', 2204)
object_type = Column(String, 'TICKET_OBJECT_TYPE', 2205)
uses_limit = Column(Integer, 'TICKET_USES_LIMIT', 2206)
uses_count = Column(Integer, 'TICKET_USES_COUNT', 2207)
expiry_ts = Column(String, 'TICKET_EXPIRY_TS', 2208)
write_file_count = Column(Integer, 'TICKET_WRITE_FILE_COUNT', 2211)
write_file_limit = Column(Integer, 'TICKET_WRITE_FILE_LIMIT', 2212)
write_byte_count = Column(Integer, 'TICKET_WRITE_BYTE_COUNT', 2213)
write_byte_limit = Column(Integer, 'TICKET_WRITE_BYTE_LIMIT', 2214)
