Re: std.database

[Erik Smith via Digitalmars-d]

On Friday, 4 March 2016 at 22:44:24 UTC, Sebastiaan Koppe wrote:
On Friday, 4 March 2016 at 18:42:45 UTC, Erik Smith wrote:
    auto db = createDatabase("file:///testdb");
    auto rowSet = db.connection().statement("select name,score 
from score").execute;
    foreach (r; rowSet) 
writeln(r[0].as!string,",",r[1].as!int);

You'll want to have some types in there. As in

struct S
{
  string name;
  int age;
}

auto rowSet = db.connection().statement("select name,score from 
score").executeAs!S;
foreach (r; rowSet) writeln(r.name,",",r.age);


I think some basic object serialization capabilities would be 
great although I'm not sure how the bare names can be accessed 
like that through the rowSet  How would that work?  I can see 
this:

S s;
auto rowSet = db.connection().statement("select name,score from 
score").into(s);
writeln(s.name,",",s.age);


Two other options (not really serialization):

// 1
string name;
int age;
auto rowSet = db.connection().execute("select name,age from 
score").into(s.name,age);
foreach (r; rowSet) writeln(name,",",age);

// 2
foreach (r; rowSet) writeln(r["name"],",",r["age"]);