Diamond-db

Diamond-db is a high-performance ORM based on mysql-native which is compatible with Diamond's MVC Framework.

All models used by the ORM must be accessible by the module models.

In your config folder you must have a db.json file which is used for the default database configurations.

 {
   "host": "127.0.0.1",
   "user": "mydbuser",
   "password": "mydbpw",
   "database": "mydb"
 }

Example

Model

class MyModel : DatabaseModel!"mymodel_table"
{
  public:
  @DbId ulong id;
  string name;

  this() { super(); }
}

Attributes for models are:

• @DbNull
  • All values that can be null should be marked @DbNull to handle them properly when reading from the database.
• @DbEnum
  • All values that are based on string enums should be marked with @DbEnum.
• @DbTimestamp
  • All fields of std.datetime.DateTime that should be updated to current time when inserting or updating should be marked with this.
• @DbNoMap
  • Used to ignore mapping of specific fields in the model.
• @DbId
  • Used to mark the identity column of a model.

Read Single

import diamond.database;
import models;

static const sql = "SELECT * FROM `@table` WHERE `id` = @id";

auto params = getParams();
params["id"] = cast(ulong)1;

auto model = MySql.readSingle!MyModel(sql, params);

Read Many

import diamond.database;
import models;

static const sql = "SELECT * FROM `@table`";

auto modelsRead = MySql.readMany!MyModel(sql, null);

Insert

import models;

auto model = new MyModel;
model.name = "Bob";

model.insertModel();

Insert Many

import models;
import diamond.database;

auto model1 = new MyModel;
model1.name = "Bob";

auto model2 = new MyModel;
model2.name = "Sally";

auto modelsToInsert = [model1, model2];

modelsToInsert.insertMany();

Update

import models;

auto model = new MyModel;
model.id = 1;
model.name = "ThisIsNotBobAnymore";

model.updateModel();

UpdateMany

import models;
import diamond.database;

auto model1 = new MyModel;
model1.id = 1;
model1.name = "ThisIsNotBobAnymore";

auto model2 = new MyModel;
model2.id = 2;
model2.name = "ThisIsNotSallyAnymore";

auto modelsToUpdate = [model1, model2];

modelsToUpdate.updateMany();

Delete

import models;

auto model = new MyModel;
model.id = 1;

model.deleteModel();

Delete Many

import models;
import diamond.database;

auto model1 = new MyModel;
model1.id = 1;

auto model2 = new MyModel;
model2.id = 2;

auto modelsToDelete = [model1, model2];

modelsToDelete.deleteMany();