changeset 78151 | 2fdf3d8a94e6 |
parent 77678 | e7d8e990d378 |
child 78153 | 55a6aa77f3d8 |
78148:b7b777fc916c | 78151:2fdf3d8a94e6 |
---|---|
574 val stop = SQL.Column.date("stop") |
574 val stop = SQL.Column.date("stop") |
575 val serial = SQL.Column.long("serial") |
575 val serial = SQL.Column.long("serial") |
576 |
576 |
577 val table = make_table("workers", |
577 val table = make_table("workers", |
578 List(worker_uuid, build_uuid, hostname, java_pid, java_start, start, stamp, stop, serial)) |
578 List(worker_uuid, build_uuid, hostname, java_pid, java_start, start, stamp, stop, serial)) |
579 |
|
580 val serial_max = serial.copy(expr = "MAX(" + serial.ident + ")") |
|
581 } |
579 } |
582 |
580 |
583 def read_serial(db: SQL.Database): Long = |
581 def read_serial(db: SQL.Database): Long = |
584 db.execute_query_statementO[Long]( |
582 db.execute_query_statementO[Long]( |
585 Workers.table.select(List(Workers.serial_max)), _.long(Workers.serial)).getOrElse(0L) |
583 Workers.table.select(List(Workers.serial.max)), _.long(Workers.serial)).getOrElse(0L) |
586 |
584 |
587 def read_workers( |
585 def read_workers( |
588 db: SQL.Database, |
586 db: SQL.Database, |
589 build_uuid: String = "", |
587 build_uuid: String = "", |
590 worker_uuid: String = "" |
588 worker_uuid: String = "" |