Appearance

API: sequence ​

Source: db/sequence.ts

API Sequence

Provides static methods for managing and accessing database sequences.

Usage ​

javascript
import { sequence } from "sdk/db";
import { response } from "sdk/http";

let value = sequence.nextval("MYSEQUENCE");

response.println(value.toString());
response.flush();
response.close();

Classes ​

Sequence ​

Utility class for interacting with database sequence objects.

Methods ​

nextval ​

  • nextval (sequence:string, tableName?:string, datasourceName?:string):number

    Retrieves the next available value from a specified sequence.

    @param sequence The name of the database sequence.
    @param tableName Optional: The name of the table associated with the sequence (depends on database dialect/facade implementation).
    @param datasourceName Optional: The name of the database connection to use.
    @returns The next sequence value as a number.

create ​

  • create (sequence:string, start?:number, datasourceName?:string):void

    Creates a new database sequence.

    @param sequence The name of the sequence to create.
    @param start Optional: The starting value for the sequence (defaults to 1 if not provided).
    @param datasourceName Optional: The name of the database connection to use.

drop ​

  • drop (sequence:string, datasourceName?:string):void

    Drops (deletes) an existing database sequence.

    @param sequence The name of the sequence to drop.
    @param datasourceName Optional: The name of the database connection to use.