statements update_database.ts

100% Statements 28/28

100% Branches 1/1

100% Functions 1/1

100% Lines 28/28

Press n or j to go to the next uncovered block, b, p or k for the previous block.


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28 1x
1x
1x
1x
1x
1x
1x
1x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
3x
1x
1x import {IStatement} from "./_statement";
import {seq, opt, alt, star} from "../combi";
import {SQLSource, DatabaseTable, Dynamic, SQLFieldAndValue, SQLCond, DatabaseConnection, SQLClient} from "../expressions";
import {IStatementRunnable} from "../statement_runnable";
 
export class UpdateDatabase implements IStatement {
 
  public getMatcher(): IStatementRunnable {
    const parameters = seq(SQLFieldAndValue, star(seq(opt(","), SQLFieldAndValue)));
 
    const set = seq("SET",
                    alt(parameters, Dynamic),
                    opt(seq("WHERE", SQLCond)));
 
    const fromTable = seq("FROM",
                          opt("TABLE"),
                          SQLSource);
 
    const ret = seq("UPDATE",
                    DatabaseTable,
                    opt(SQLClient),
                    opt(DatabaseConnection),
                    opt(alt(fromTable, set)));
 
    return ret;
  }
 
}