The pycerebro.dbtypes module contains a description of data tuples and bit flags used when working with the database.
pycerebro.dbtypes.ACTIVITY_DATA_= ''
| pycerebro.dbtypes.ACTIVITY_DATA_COLOR= 2 | Activity color. RGB format is presented as an integer. |
| pycerebro.dbtypes.ACTIVITY_DATA_ID= 0 | Activity ID. |
| pycerebro.dbtypes.ACTIVITY_DATA_NAME= 1 | Activity name. |
pycerebro.dbtypes.ATTACHMENT_DATA_= ''
| pycerebro.dbtypes.ATTACHMENT_DATA_COMMENT= 9 | Comment to the file. |
| pycerebro.dbtypes.ATTACHMENT_DATA_CREATED= 4 | Time of creation. |
| pycerebro.dbtypes.ATTACHMENT_DATA_DEL= 2 | If not equal to 0, the attacment is deleted. |
| pycerebro.dbtypes.ATTACHMENT_DATA_EVENT_ID= 1 | Message ID. |
| pycerebro.dbtypes.ATTACHMENT_DATA_FILE_NAME= 8 |
Attachment file name. |
| pycerebro.dbtypes.ATTACHMENT_DATA_FILE_SIZE= 7 | Attachment file size in bytes. |
| pycerebro.dbtypes.ATTACHMENT_DATA_GROUP_ID= 3 |
Attachment ID. |
| pycerebro.dbtypes.ATTACHMENT_DATA_HASH= 5 | File hash sum. |
| pycerebro.dbtypes.ATTACHMENT_DATA_ID= 10 | ID of the file attached. |
| pycerebro.dbtypes.ATTACHMENT_DATA_MTM= 0 | Time of data modification. |
| pycerebro.dbtypes.ATTACHMENT_DATA_TAG= 6 |
Type of file attached. |
pycerebro.dbtypes.ATTACHMENT_TAG_= ''
| pycerebro.dbtypes.ATTACHMENT_TAG_FILE= 0 |
Attachment entry type – file. |
| pycerebro.dbtypes.ATTACHMENT_TAG_LINK= 5 |
Attachment entry type – link to file. |
| pycerebro.dbtypes.ATTACHMENT_TAG_REVIEW= 4 |
Attachment entry type – review file. |
| pycerebro.dbtypes.ATTACHMENT_TAG_THUMB1= 1 |
Attachment entry type – first frame or still image thumbnail. |
| pycerebro.dbtypes.ATTACHMENT_TAG_THUMB2= 2 | Attachment entry type – middle frame thumbnail. |
| pycerebro.dbtypes.ATTACHMENT_TAG_THUMB3= 3 | Attachment entry type – last frame thumbnail. |
pycerebro.dbtypes.COPY_TASKS_= ''
| pycerebro.dbtypes.COPY_TASKS_ASSIGNED_USERS= 4 | Copy assigned users |
| pycerebro.dbtypes.COPY_TASKS_ATTACHMENTS= 32 | Copy attachments. |
| pycerebro.dbtypes.COPY_TASKS_EVENTS= 8 | Copy events (by default only definition) |
| pycerebro.dbtypes.COPY_TASKS_EXTERNAL_LINKS_IN= 256 | Copy external links in. |
| pycerebro.dbtypes.COPY_TASKS_EXTERNAL_LINKS_OUT= 128 | Copy external links out. |
| pycerebro.dbtypes.COPY_TASKS_FULL_EVENT_COPY= 16 | Copy all events. |
| pycerebro.dbtypes.COPY_TASKS_INTERNAL_LINKS= 64 | Copy internal links. |
| pycerebro.dbtypes.COPY_TASKS_PERMISSIONS= 512 | Copy permissions. |
| pycerebro.dbtypes.COPY_TASKS_SUBSCRIBE_USERS_FULL= 1024 | subscribe users with full protocol (may be slow) |
| pycerebro.dbtypes.COPY_TASKS_SUB_TASKS= 1 | Copy subtasks. |
| pycerebro.dbtypes.COPY_TASKS_TAGS= 2 | Copy tags. |
pycerebro.dbtypes.MESSAGE_DATA_= ''
| pycerebro.dbtypes.MESSAGE_DATA_APPROVED_TIME= 8 | Confirmed signed off time, minutes. |
| pycerebro.dbtypes.MESSAGE_DATA_CREATED= 5 | Time of message creation. |
| pycerebro.dbtypes.MESSAGE_DATA_CREATOR_ID= 13 | Message author’s ID. |
| pycerebro.dbtypes.MESSAGE_DATA_CREATOR_NAME= 4 | Message author's name. |
| pycerebro.dbtypes.MESSAGE_DATA_FLAGS= 9 | Message flags. |
| pycerebro.dbtypes.MESSAGE_DATA_ID= 1 | Message ID. |
| pycerebro.dbtypes.MESSAGE_DATA_MODERATOR_ID= 14 | Message editor’s ID. |
| pycerebro.dbtypes.MESSAGE_DATA_MODERATOR_NAME= 10 | Message editor’s name. |
| pycerebro.dbtypes.MESSAGE_DATA_MTM= 0 | Data modification time. |
| pycerebro.dbtypes.MESSAGE_DATA_PID= 2 | Parent message ID. |
| pycerebro.dbtypes.MESSAGE_DATA_STATUS_ID= 15 | Status ID. |
| pycerebro.dbtypes.MESSAGE_DATA_TEXT= 7 | Message text in HTML format. |
| pycerebro.dbtypes.MESSAGE_DATA_TID= 11 | ID of the task, the message belongs to. |
| pycerebro.dbtypes.MESSAGE_DATA_TYPE= 3 | Message type. |
| pycerebro.dbtypes.MESSAGE_DATA_WORK_TIME= 6 | Working time to sign off, minutes. |
| pycerebro.dbtypes.MESSAGE_DATA_XMTM= 12 | Real time of data modification. |
pycerebro.dbtypes.MESSAGE_FLAG_= ''
| pycerebro.dbtypes.MESSAGE_FLAG_APPROVED= 1 | Report is accepted (confirmed). |
| pycerebro.dbtypes.MESSAGE_FLAG_CLIENT_VISIBLE= 0 | Message is visible for clients. |
pycerebro.dbtypes.MESSAGE_TYPE_= ''
| pycerebro.dbtypes.MESSAGE_TYPE_CLIENT_REVIEW= 4 | Message type - Client review. |
| pycerebro.dbtypes.MESSAGE_TYPE_DEFINITION= 0 | Message type – Definition. |
| pycerebro.dbtypes.MESSAGE_TYPE_NOTE= 3 | Message type - Note. |
| pycerebro.dbtypes.MESSAGE_TYPE_REPORT= 2 | Message type - Report. |
| pycerebro.dbtypes.MESSAGE_TYPE_RESOURCE_REPORT= 5 | Message type - Resourse report. |
| pycerebro.dbtypes.MESSAGE_TYPE_REVIEW= 1 | Message type - Review. |
| pycerebro.dbtypes.MESSAGE_TYPE_STATUS_CHANGES= 6 | Message of change of the status of the task. |
pycerebro.dbtypes.STATUS_DATA_= ''
| pycerebro.dbtypes.STATUS_DATA_COLOR= 6 | Status color. The RGB format is presented as an integer. |
| pycerebro.dbtypes.STATUS_DATA_DESCRIPTION= 4 | Status description. |
| pycerebro.dbtypes.STATUS_DATA_FLAGS= 2 | Status flags. |
| pycerebro.dbtypes.STATUS_DATA_ICON= 5 | Status icon. XPM format. |
| pycerebro.dbtypes.STATUS_DATA_ICON_HASH= 11 | Status icon hash, if exists. |
| pycerebro.dbtypes.STATUS_DATA_ID= 0 | Status ID. |
| pycerebro.dbtypes.STATUS_DATA_MTM= 10 | Modify time. |
| pycerebro.dbtypes.STATUS_DATA_NAME= 1 | Status name. |
| pycerebro.dbtypes.STATUS_DATA_ORDER= 3 | Status order number. |
| pycerebro.dbtypes.STATUS_DATA_PERM_ENTER= 9 | Permissions to enter status. |
| pycerebro.dbtypes.STATUS_DATA_PERM_LEAVE= 8 | Permissions to leave status. |
| pycerebro.dbtypes.STATUS_DATA_UNID= 7 | Universe ID. |
pycerebro.dbtypes.STATUS_FLAG_= ''
| pycerebro.dbtypes.STATUS_FLAG_INHERITABLE= 1 | Status is inherited. |
| pycerebro.dbtypes.STATUS_FLAG_WORK_STARTED= 2 | Type status, meaning that the task is in progress. |
| pycerebro.dbtypes.STATUS_FLAG_WORK_STOPPED= 3 | If the flags STATUS_FLAG_WORK_STARTED and STATUS_FLAG_WORK_STOPPED are not set, the status type means that the task is suspended.
While STATUS_FLAG_WORK_STARTED and STATUS_FLAG_WORK_STOPPED - links (if possible, if not - just text) |
pycerebro.dbtypes.TAG_DATA_= ''
| pycerebro.dbtypes.TAG_DATA_ID= 1 | Tag ID. |
| pycerebro.dbtypes.TAG_DATA_MTM= 0 | Time of data change. |
| pycerebro.dbtypes.TAG_DATA_NAME= 3 | Tag name. |
| pycerebro.dbtypes.TAG_DATA_PROJECT_ID= 2 | Project ID. |
| pycerebro.dbtypes.TAG_DATA_TYPE= 4 | Tag type. |
pycerebro.dbtypes.TAG_ENUM_DATA_= ''
| pycerebro.dbtypes.TAG_ENUM_DATA_ID= 1 | Tag’s enumeration ID. |
| pycerebro.dbtypes.TAG_ENUM_DATA_MTM= 0 | Data change time. |
| pycerebro.dbtypes.TAG_ENUM_DATA_NAME= 3 | Enumeration name. |
| pycerebro.dbtypes.TAG_ENUM_DATA_TAG_ID= 2 | Tag ID. |
pycerebro.dbtypes.TAG_TYPE_= ''
| pycerebro.dbtypes.TAG_TYPE_ENUM= 1 | Enumeration name. |
| pycerebro.dbtypes.TAG_TYPE_FLOAT= 2 | Floating point number. |
| pycerebro.dbtypes.TAG_TYPE_INTEGER= 0 | Integer. |
| pycerebro.dbtypes.TAG_TYPE_MULTI_ENUM= 4 | Multiple enumeration. A tag of this type may contain several enumerations. |
| pycerebro.dbtypes.TAG_TYPE_STRING= 3 | String. |
pycerebro.dbtypes.TASK_ALLOCATED_= ''
| pycerebro.dbtypes.TASK_ALLOCATED_FLAGS= 2 | User flags. |
| pycerebro.dbtypes.TASK_ALLOCATED_ID= 0 | User ID. |
| pycerebro.dbtypes.TASK_ALLOCATED_NAME= 1 | User full name. |
pycerebro.dbtypes.TASK_DATA_= ''
| pycerebro.dbtypes.TASK_DATA_ACTIVITY_ID= 7 | Activity ID. |
| pycerebro.dbtypes.TASK_DATA_ACTIVITY_NAME= 6 | Activity name. |
| pycerebro.dbtypes.TASK_DATA_ALLOCATED= 21 | Users allocated to the task. Type - string. Separator ‘;’. |
| pycerebro.dbtypes.TASK_DATA_BUDGET= 30 | Total budget for the task and its subtasks. |
| pycerebro.dbtypes.TASK_DATA_CC_STATUS= 37 | Calculated (automatic) task status. Calculated status may differ from the user-defined one, as it may be inherited from its parent task. Calculated status is the effective (actual) status of the task. |
| pycerebro.dbtypes.TASK_DATA_CC_STATUS_STAT= 38 | Status summary on the parent task. |
| pycerebro.dbtypes.TASK_DATA_CREATED= 10 | Task creation time. |
| pycerebro.dbtypes.TASK_DATA_CREATOR_ID= 19 | Id of a user who created the task. |
| pycerebro.dbtypes.TASK_DATA_DURATION= 23 | Calculated duration of the task, days. Type - float. |
| pycerebro.dbtypes.TASK_DATA_FLAGS= 17 | Task flags |
| pycerebro.dbtypes.TASK_DATA_HUMAN_FINISH= 27 | User-defined task finish time, days from 01.01.2000. Type - float. |
| pycerebro.dbtypes.TASK_DATA_HUMAN_START= 26 | User-defined task start time, days from 01.01.2000. Type - float. |
| pycerebro.dbtypes.TASK_DATA_ID= 1 | Task ID. |
| pycerebro.dbtypes.TASK_DATA_MODERATOR_ID= 18 | ID of a user who changed the task. |
| pycerebro.dbtypes.TASK_DATA_MODIFIED= 20 | Time when the task was modified. |
| pycerebro.dbtypes.TASK_DATA_MTM= 0 | Time of data change. |
| pycerebro.dbtypes.TASK_DATA_NAME= 4 | Task name. |
| pycerebro.dbtypes.TASK_DATA_OFFSET= 22 | Calculated start time of the task, days from 01.01.2000. Type - float. |
| pycerebro.dbtypes.TASK_DATA_ORDER= 39 | Task order number. |
| pycerebro.dbtypes.TASK_DATA_PARENT_ID= 2 | Parent task ID. |
| pycerebro.dbtypes.TASK_DATA_PARENT_URL= 5 | Full path to the parent task. Example: /Test project/Scene 1/ |
| pycerebro.dbtypes.TASK_DATA_PLANNED= 13 | Planned working time for the task, hours. Type - float. |
| pycerebro.dbtypes.TASK_DATA_PLANNED_DELTA= 3 | Obsolete, not used. |
| pycerebro.dbtypes.TASK_DATA_PRIORITY= 11 | Task priority. |
| pycerebro.dbtypes.TASK_DATA_PRIVILEGE= 25 | Current user’s access rights to the task. Type - integer. |
| pycerebro.dbtypes.TASK_DATA_PROGRESS= 12 | Task progress. Type - float, from 0.0 to 100.0. |
| pycerebro.dbtypes.TASK_DATA_PROJECT_ID= 24 | ID of the project, the task belongs to. |
| pycerebro.dbtypes.TASK_DATA_RESOURCE_APPROVED= 35 | Confirmed signed off time of a material resource for the task and its subtasks, hours. Type - float. |
| pycerebro.dbtypes.TASK_DATA_RESOURCE_DECLARED= 34 | Signed off time of a material resource for the task and its subtasks, hours. Type - float. |
| pycerebro.dbtypes.TASK_DATA_RESOURCE_SELF_APPROVED= 33 | Confirmed signed off time of a material resource, minutes. Type - float. |
| pycerebro.dbtypes.TASK_DATA_RESOURCE_SELF_DECLARED= 32 | Signed off time of a material resource, minutes. Type - float. |
| pycerebro.dbtypes.TASK_DATA_SELF_BUDGET= 28 | Task budget. |
| pycerebro.dbtypes.TASK_DATA_SELF_SPENT= 29 | Task costs. |
| pycerebro.dbtypes.TASK_DATA_SELF_STATUS= 36 | User-defined (manually set) task status. |
| pycerebro.dbtypes.TASK_DATA_SELF_USERS_APPROVED= 9 | Confirmed signed off time, minutes. Type - float. |
| pycerebro.dbtypes.TASK_DATA_SELF_USERS_DECLARED= 8 | Time, signed off by users, minutes. Type - float. |
| pycerebro.dbtypes.TASK_DATA_SPENT= 31 | Total costs of the task and its subtasks. |
| pycerebro.dbtypes.TASK_DATA_THUMBS= 16 | Thumbnail hash sums. Type - string. Separator ‘;’. |
| pycerebro.dbtypes.TASK_DATA_USERS_APPROVED= 15 | Confirmed signed off time on current task and its subtasks, hours. Type - float. |
| pycerebro.dbtypes.TASK_DATA_USERS_DECLARED= 14 | Time, signed off by users on current task and its subtasks, hours. Type - float. |
pycerebro.dbtypes.TASK_FLAG_= ''
| pycerebro.dbtypes.TASK_FLAG_ASSIGNED= 38 | Current user is allocated to this task. |
| pycerebro.dbtypes.TASK_FLAG_ARCHIVED= 2 | Task archived. |
| pycerebro.dbtypes.TASK_FLAG_CLOSED_EFFECTIVE= 30 | Task closed, because its parent task is closed also. |
| pycerebro.dbtypes.TASK_FLAG_DELETED= 0 | Task deleted. |
| pycerebro.dbtypes.TASK_FLAG_FORUM_LOCKED= 5 | Task Forum locked. |
| pycerebro.dbtypes.TASK_FLAG_HAS_CHILD= 32 | Task has subtasks. |
| pycerebro.dbtypes.TASK_FLAG_HAS_MESSAGES= 33 | There are messages in the task Forum. |
| pycerebro.dbtypes.TASK_FLAG_HAS_PLANNED= 56 | Task has its own planned time. |
| pycerebro.dbtypes.TASK_FLAG_HAS_PROGRESS= 59 | Task has its own progress value. |
| pycerebro.dbtypes.TASK_FLAG_HAS_SUB_PERMS= 35 | Outdated, not in use. |
| pycerebro.dbtypes.TASK_FLAG_INTEREST= 39 | Current user follows this task. |
| pycerebro.dbtypes.TASK_FLAG_IS_REFERENCE= 61 | Task is a reference to the original task. |
| pycerebro.dbtypes.TASK_FLAG_LAST_EV_APPROVED= 45 | The last message in the task Forum is accepted (confirmed). |
| pycerebro.dbtypes.TASK_FLAG_LAST_EV_CLIENT_VIS= 44 | The last message in the task Forum is visible for Clients. |
| pycerebro.dbtypes.TASK_FLAG_NEED_ANSWER= 34 | Task is reply pending (according to current user’s access rights). |
| pycerebro.dbtypes.TASK_FLAG_PERM_INHERIT_BLOCK= 1 | Permission inheritance is reset for the task. |
| pycerebro.dbtypes.TASK_FLAG_SUSPENED= 4 | Task paused. |
| pycerebro.dbtypes.TASK_FLAG_SUSPENED_EFFECTIVE= 31 | Task paused, because its parent task is closed. |
| pycerebro.dbtypes.TASK_FLAG_TASK_AS_EVENT= 3 | Task marked as event. |
pycerebro.dbtypes.TASK_LINK_= ''
| pycerebro.dbtypes.TASK_LINK_DEL= 2 | If False, the connection is deleted. |
| pycerebro.dbtypes.TASK_LINK_DST= 4 | The task is follower. |
| pycerebro.dbtypes.TASK_LINK_FLAGS= 5 | Connection flags. |
| pycerebro.dbtypes.TASK_LINK_ID= 1 | Connection ID. |
| pycerebro.dbtypes.TASK_LINK_MTM= 0 | Time of connection change. |
| pycerebro.dbtypes.TASK_LINK_SRC= 3 | The task is predecessor. |
pycerebro.dbtypes.TASK_PRIORITY_= ''
| pycerebro.dbtypes.TASK_PRIORITY_ABOVE_NORMAL= 1 | Above normal priority. |
| pycerebro.dbtypes.TASK_PRIORITY_BELOW_NORMAL= -1 | Below normal priority. |
| pycerebro.dbtypes.TASK_PRIORITY_CRITICAL= 3 | Critical priority. |
| pycerebro.dbtypes.TASK_PRIORITY_HIGHT= 2 | High priority. |
| pycerebro.dbtypes.TASK_PRIORITY_LOW= -2 | Low priority. |
| pycerebro.dbtypes.TASK_PRIORITY_NORMAL= 0 | Normal priority. |
pycerebro.dbtypes.TASK_TAG_DATA_= ''
| pycerebro.dbtypes.TASK_TAG_DATA_NAME= 3 | Tag name. |
| pycerebro.dbtypes.TASK_TAG_DATA_TAG_ID= 1 | Tag ID. |
| pycerebro.dbtypes.TASK_TAG_DATA_TASK_ID= 0 | Task ID. |
| pycerebro.dbtypes.TASK_TAG_DATA_TYPE= 2 | Tag type. |
| pycerebro.dbtypes.TASK_TAG_DATA_VALUE= 4 | Tag value. Type - string. In case of multiple enumerations, the latter are separated by semicolons. |
pycerebro.dbtypes.TASK_TAG_ENUM_= ''
| pycerebro.dbtypes.TASK_TAG_ENUM_ID= 1 | Enumeration ID. |
| pycerebro.dbtypes.TASK_TAG_ENUM_MTM= 0 | Data change time. |
| pycerebro.dbtypes.TASK_TAG_ENUM_NAME= 2 | Enumeration name. |
pycerebro.dbtypes.USER_DATA_= ''
| pycerebro.dbtypes.USER_DATA_EMAIL= 6 | User's e-mail. |
| pycerebro.dbtypes.USER_DATA_FIRST_NAME= 4 | User’s first name. |
| pycerebro.dbtypes.USER_DATA_FLAGS= 2 | User flags. |
| pycerebro.dbtypes.USER_DATA_FULL_NAME= 1 | User full name. |
| pycerebro.dbtypes.USER_DATA_ICQ= 8 | User ICQ/Skype ID. |
| pycerebro.dbtypes.USER_DATA_ID= 0 | User ID. |
| pycerebro.dbtypes.USER_DATA_LAST_NAME= 5 | User’s last name.. |
| pycerebro.dbtypes.USER_DATA_LOGIN= 3 | User login. |
| pycerebro.dbtypes.USER_DATA_PHONE= 7 | User's phone number. |
pycerebro.dbtypes.USER_FLAG_= ''
| pycerebro.dbtypes.USER_FLAG_IS_RESOURCE= 1 | Is a material resource. |