Moscrif API Docs for: 2012q3
Show:

Database Class

Library: sqlite

This class allows to manipulate local SQLite database.

Example:

// load database file
var database = Database.open("dat://db.db");

// create SQL query
var result = database.exec("....SQL QUERY....");

// release sources reserved for database
database.close();

Item Index

Methods

Methods

close

()

This function release resource, allocated in memory. It is recommended to use this function, when dabase is no longer needed.

exec

(
  • sql
  • [value]
)
Dataset | Integer

Easy way to make sql request.

Parameters:

  • sql String

    SQL command to execute.

  • [value] Object optional multiple

    Optional parameters - effective way to set number of string values in sql query.

Returns:

Dataset | Integer: Returns Dataset or error code .

Example:

    db.exec("select * form persons where id > ?", 10);

    //load database file
    var database = Database.open("dat://db.db");

    //create SQL query
    var result = database.exec("INSERT INTO db VALUES (null,?);", "value instead of a question mark");

lastInsertedID

() Integer

Method to find last ID insert into database.

Returns:

Integer: Returns last inserted ID.

open

(
  • file
)
Database static

Open database file. Supported format is .db - SQLite file.

Parameters:

  • file String

    Filename offset the databse.

Returns:

Database: