Define the Process table.
| 445 | |
| 446 | |
| 447 | class Process(db.Model, UserScopedMixin): |
| 448 | """Define the Process table.""" |
| 449 | __tablename__ = 'process' |
| 450 | pid = db.Column(db.String(), nullable=False, primary_key=True) |
| 451 | user_id = db.Column( |
| 452 | db.Integer, |
| 453 | db.ForeignKey(USER_ID), |
| 454 | nullable=False |
| 455 | ) |
| 456 | command = db.Column(db.String(), nullable=False) |
| 457 | desc = db.Column(db.String(), nullable=False) |
| 458 | arguments = db.Column(db.String(), nullable=True) |
| 459 | logdir = db.Column(db.String(), nullable=True) |
| 460 | start_time = db.Column(db.String(), nullable=True) |
| 461 | end_time = db.Column(db.String(), nullable=True) |
| 462 | exit_code = db.Column(db.Integer(), nullable=True) |
| 463 | acknowledge = db.Column(db.String(), nullable=True) |
| 464 | utility_pid = db.Column(db.Integer, nullable=False) |
| 465 | process_state = db.Column(db.Integer, nullable=False) |
| 466 | server_id = db.Column( |
| 467 | db.Integer, |
| 468 | db.ForeignKey('server.id'), |
| 469 | nullable=True |
| 470 | ) |
| 471 | |
| 472 | |
| 473 | class Keys(db.Model): |