fluentsqlite 0.1.3

FluentSQLite

An implementation of SQLite Query Builder in D Lang, originally ported from fluks in Kotlin.

Usage

import taskdesigns.sqlite;

// Define a table
auto users = new Table("users");

// Creating a table example
users.create( (it) {
    auto id = new Column!int("id");
    auto name = new Column!string("name");
    auto email = new Column!string("email");
    it.column(id, true, false, true);
    it.column(name);
    it.column(email);
}).asSQL();

// Insert statement example
users.insert( (it) {
    auto name = new Column!string("name");
    auto email = new Column!string("email");
    it[name] = "John Smith";
    it[email] = "[email protected]";
}).asSQL();

// Select query example
auto email = new Column!string("email");
users.select().where(email.eq("[email protected]")).asSQL();

Installation

Dub Manually:

dub add fluentsqlite

Dub SDL:

dependency "fluentsqlite" version="~>0.1.1"

Dub JSON:

"fluentsqlite": "~>0.1.1"