Re: database 0.0.8 released
On 9/12/17 1:14 PM, Brian wrote: dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite. Project: https://github.com/huntlabs/database ## Database Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite. I just wanted to point out that in order to bind against libmysqlclient, you must use an open-source license, or pay Oracle a license fee. This means the users of your library must use an open source license or pay the fee (not you), but your license makes it unclear that this is the case. More details here: https://www.mysql.com/about/legal/licensing/foss-exception/ Or you could instead use the mysql-native library that does not depend on Oracle's library: https://github.com/mysql-d/mysql-native -Steve
Re: database 0.0.8 released
On Wednesday, 13 September 2017 at 06:46:59 UTC, Brian wrote: Welcome to participate! :) Alas, looking at your source, it is actually not what I wanted... I want to use the database features rather than a reimplemented class. BTW the "escapedVariants" function can help you fill in that Statement class' missing methods.
Re: database 0.0.8 released
On Wednesday, 13 September 2017 at 04:30:24 UTC, Vadim Lopatin wrote: On Tuesday, 12 September 2017 at 17:14:27 UTC, Brian wrote: dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite. Project: https://github.com/huntlabs/database Did you see DDBC project? It supports postgres, mysql, and sqlite, too. API is similar to Java JDBC. Yes, thanks your project DDBC :) database is similar to PHP PDO library, no deps, api easy to use.
Re: database 0.0.8 released
Add on allocator support and many more comments, aka if public facing then document it. Then we'd be in business!
Re: database 0.0.8 released
On Tuesday, 12 September 2017 at 17:14:27 UTC, Brian wrote: dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite. Project: https://github.com/huntlabs/database Did you see DDBC project? It supports postgres, mysql, and sqlite, too. API is similar to Java JDBC.
Re: database 0.0.8 released
On Tuesday, 12 September 2017 at 17:14:27 UTC, Brian wrote: dlang database library: Database abstraction layer for D programing language, support PostgreSQL / MySQL / SQLite. not bad. - Statement Database.prepare(sql) Create a prepared Statement ooh, this is something I have been wanting to write for my database libs too...
database 0.0.8 released
dlang database library: Database abstraction layer for D
programing language, support PostgreSQL / MySQL / SQLite.
Project:
https://github.com/huntlabs/database
## Database
Database abstraction layer for D programing language, support
PostgreSQL / MySQL / SQLite.
## Example
```D
import std.stdio;
import std.experimental.logger;
import database;
void main()
{
writeln("run database MySQL demo.");
auto db = new
Database("mysql://root:123456@localhost:3306/test?charset=utf-8");
int result = db.execute(`INSERT INTO user(username)
VALUES("test")`);
writeln(result);
foreach(row; db.query("SELECT * FROM user LIMIT 10"))
{
writeln(row["username"]);
}
db.close();
}
```
## Use DatabaseOption to instantiate a Database object
```D
auto options = new
DatabaseOption("mysql://root:123456@localhost:3306/test");
options.setMaximumConnection(5);
auto db = new Database(options);
db.execute("SET NAMES utf8");
```
## API
- int Database.execute(string sql) Return number of execute
result.
```D
int result = db.execute('INSERT INTO user(username)
VALUES("Brian")');
// if execute error ,db will throw an DatabaseException
```
- ResultSet Database.query(sql) Return ResultSet object for
query(SELECT).
```D
ResultSet rs = db.query("SELECT * FROM user LIMIT 10");
```
- Statement Database.prepare(sql) Create a prepared Statement
object.
```D
Statement stmt = db.prepare("SELECT * FROM user where username
= :username and age = :age LIMIT 10");
```
- Statement.setParameter(param, value) : bind param's value to
:param for sql.
```D
stmt.setParameter("username", "viile");
stmt.setParameter("age", 18);
```
- ResultSet Statement.query() Return ResultSet
```D
ResultSet rs = stmt.query();
foreach(row; rs)
{
writeln(row["username"]);
}
```
- Row Statement.fetch() Return Row
```D
Row row = stmt.fetch();
writeln(row["username"]);
```
- int Statement.execute() : return execute status for prepared
Statement object.
```D
int result = stmt.execute();
```
- Statement.lastInsertId() : Statement.execute() for insert sql,
return lastInsertId.
