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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
import { _ISchema, _Transaction, NotSupported, _ISequence, _IStatementExecutor } from '../../interfaces-private.ts';import { QName, CreateSequenceStatement } from 'https://deno.land/x/pgsql_ast_parser@12.0.1/mod.ts';import { Sequence } from '../../schema/sequence.ts';import { checkExistence, ExecHelper } from '../exec-utils.ts';
export class ExecuteCreateSequence extends ExecHelper implements _IStatementExecutor {    schema: _ISchema;    constructor(inSchema: _ISchema, private p: CreateSequenceStatement, private acceptTempSequences: boolean) {        super(p);        const name: QName = p.name;        this.schema = inSchema.getThisOrSiblingFor(name);    }
    execute(t: _Transaction) {        // commit pending data before making changes        //  (because the index sequence creation does support further rollbacks)        t = t.fullCommit();
        // create the sequence        this.createSeq(t);
        // new implicit transaction        t = t.fork();        return this.noData(t, 'CREATE');    }
    createSeq(t: _Transaction) {        const p = this.p;        const name: QName = p.name;        // const ret = this.simple('CREATE', p);
        let ret: _ISequence | null = null;        checkExistence(this.schema, name, p.ifNotExists, () => {            if (p.temp && !this.acceptTempSequences) {                throw new NotSupported('temp sequences');            }            ret = new Sequence(name.name, this.schema)                .alter(t, p.options);            this.schema.db.onSchemaChange();        });        return ret;    }}