Difference between revisions of "Jobqueue table"
From MythTV Official Wiki
m (Added wrongtitle) |
Blackcamera (talk | contribs) (→Fields) |
||
| Line 36: | Line 36: | ||
*'''id''' is a unique identifier for entries in the table. | *'''id''' is a unique identifier for entries in the table. | ||
*'''chanid''' relates to the ''chanid'' field of the [[channel table]]. | *'''chanid''' relates to the ''chanid'' field of the [[channel table]]. | ||
| − | *'''starttime''' is the time the | + | *'''starttime''' is the start time of the recording. |
*'''inserttime''' is the time the job was queued. | *'''inserttime''' is the time the job was queued. | ||
*'''type''' is the type of job. | *'''type''' is the type of job. | ||
Revision as of 16:34, 26 July 2007
Note: The correct title of this article is jobqueue table. It appears incorrectly here due to technical restrictions.
The jobqueue table maintains a list of outstanding, in-progress and recently finished commercial flagging, transcoding and user processing jobs.
Table Description
| Field name | Type | Null | Key | Default | Extras |
|---|---|---|---|---|---|
| id | int(11) | PRI | NULL | auto_increment | |
| chanid | int(10) | MUL | 0 | ||
| starttime | datetime | 0000-00-00 00:00:00 | |||
| inserttime | datetime | 0000-00-00 00:00:00 | |||
| type | int(11) | 0 | |||
| cmds | int(11) | 0 | |||
| flags | int(11) | 0 | |||
| status | int(11) | 0 | |||
| statustime | timestamp | CURRENT_TIMESTAMP | |||
| hostname | varchar(255) | ||||
| args | blob | ||||
| comment | varchar(128) |
Fields
- id is a unique identifier for entries in the table.
- chanid relates to the chanid field of the channel table.
- starttime is the start time of the recording.
- inserttime is the time the job was queued.
- type is the type of job.
- NONE = 0x0000, SYSTEMJOB = 0x00ff, TRANSCODE = 0x0001, COMMFLAG = 0x0002, USERJOB = 0xff00, USERJOB1 = 0x0100, USERJOB2 = 0x0200, USERJOB3 = 0x0400, USERJOB4 = 0x0800
- cmds
- RUN = 0x0000, PAUSE = 0x0001, RESUME = 0x0002, STOP = 0x0004, RESTART = 0x0008
- flags
- NO_FLAGS = 0x0000, USE_CUTLIST = 0x0001, LIVE_REC = 0x0002, EXTERNAL = 0x0004
- status
- UNKNOWN = 0x0000, QUEUED = 0x0001, PENDING = 0x0002, STARTING = 0x0003, RUNNING = 0x0004, STOPPING = 0x0005, PAUSED = 0x0006, RETRY = 0x0007, ERRORING = 0x0008, ABORTING = 0x0009, DONE = 0x0100, FINISHED = 0x0110, ABORTED = 0x0120, ERRORED = 0x0130, CANCELLED = 0x0140,
- statustime is the time the status was last updated
Example Entries
id: 4061
chanid: 1039
starttime: 2007-01-13 09:00:00
inserttime: 2007-03-12 16:33:25
type: 1
cmds: 0
flags: 1
status: 272
statustime: 2006-12-10 22:18:48
hostname: localhost.localdomain
args:
comment: High Quality: 4.5 GB => 4.5
id: 4588
chanid: 1005
starttime: 2007-03-10 20:00:00
inserttime: 2007-03-11 15:56:13
type: 1
cmds: 0
flags: 1
status: 272
statustime: 2007-03-11 17:35:46
hostname: localhost.localdomain
args: RENAME_TO_NUV
comment: Low Quality: 1.5 GB => 799.9
id: 4559
chanid: 1039
starttime: 2007-03-10 08:00:00
inserttime: 2007-03-10 10:30:00
type: 2
cmds: 0
flags: 0
status: 272
statustime: 2007-03-10 12:41:26
hostname: localhost.localdomain
args:
comment: Finished, 11 break(s) found.
