MySql

The main class for accessing the MySql database.

// connect to database with the constructor
auto db = new MySql("localhost", "my_user", "my_password", "my_database_name");
// use the query function to execute sql...
// use ? for data placeholders...
db.query("INSERT INTO people (id, name) VALUES (?, ?)", 10, "My Name");
// and use foreach to loop over result sets
foreach(row; db.query("SELECT id, name FROM people ORDER BY name LIMIT 10"))
	writeln(row[0], " ", row["name"]); // index and name supported

class MySql : Database {

string dbname;

void startTransaction();

int lastInsertId();

int insert(string table, MySqlResult result, string[string] columnsToModify, string[] columnsToSkip);

ResultByDataObject!R queryDataObject(string sql, T t);

ResultByDataObject!R queryDataObjectWithCustomKeys(string[string] keyMapping, string sql, T t);

int affectedRows();

}

Destructor

A destructor is present on this object, but not explicitly documented in the source.

Members

Functions

affectedRows int affectedRows()
insert int insert(string table, MySqlResult result, string[string] columnsToModify, string[] columnsToSkip): Builds and executes an INERT INTO statement
lastInsertId int lastInsertId()
queryDataObject ResultByDataObject!R queryDataObject(string sql, T t)
queryDataObjectWithCustomKeys ResultByDataObject!R queryDataObjectWithCustomKeys(string[string] keyMapping, string sql, T t): Gets a minimal ORM object from a query
startTransaction void startTransaction()

MySql

Destructor

Members

Functions

Meta

Source