DBConnection(connectionString, provider?, commandTimeout = 300) : DBConnection
Alias: DB
Returns new database connection.
DBConnection Parameters
connectionString : String
provider? : String?
Can be ‘MSSQL’ or missing for now.
commandTimeout : Integer = 300
The time in seconds for commands to execute.
DBConnection Examples
var db = DBConnection('Server=dbserver.com;Database=MyDB;User=user;Password=password');
DBExecute(db, query, params?) : Integer
Executes SQL statement in database (e.g. INSERT, UPDATE, DELETE).
DBExecute Parameters
db : DBConnection?
query : String
SQL statement to execute.
params? : Dict?
Query parameters.
DBExecute Examples
var count = DBExecute(db, 'UPDATE someTable WHERE someField=1');
DBProcedure(db, name, params?)
Executes stored procedure in database.
DBProcedure Parameters
db : DBConnection?
name : String
Stored procedure name.
params? : Dict?
Stored procedure parameters.
DBProcedure Examples
var result = DBProcedure(db, 'someProcedure', { someParam = 1 });
DBQuery(db, query, params?) : Dict[]?
Loads data from database using SQL SELECT query.
DBQuery Parameters
db : DBConnection?
query : String
SQL SELECT query.
params? : Dict?
Query parameters.
DBQuery Examples
var rows = DBQuery(db, 'SELECT * FROM someTable');
var rows = DBQuery(db, '* FROM someTable');
DBSchema(db, query?) : Schema
Returns database or query result schema.
DBSchema Parameters
db : DBConnection
query? : String?
If not empty, then result schema is returned, otherwise database schema is returned.
DBSchema Examples
var schema = DBSchema(db);
var schema = DBSchema(db, 'SELECT * FROM someTable');
ParseXsd(xsd) : Schema
Parses XSD content to a schema object.
ParseXsd Parameters
xsd : Binary?
ParseXsd Examples
var schema = ParseXsd(File('res:///internal/schema.xsd'));