Readme examples improvements

[Abscissa]

Should split up the example in the readme into separate parts, and add new front-page examples to illustrate other key aspects of mysql-native.

[EmTee70]

Can you please give an example of how to use asAA?
I just want to loop through a result range accessing the members by name?

Similar to:
foreach( row; result){writeln(row["col_name"])}

I found a solution hint here: https://forum.dlang.org/post/[email protected]

But some examples with loops are missing!

[Abscissa]

https://dlang.org/spec/statement.html#foreach_over_associative_arrays

[EmTee70]

That was not the point, I was wondering how I can do:
ResultRange range = conn.query("SELECT * FROM tablename");
foreach(row;range){
writeln(row[0]);
}
But with an AA.

So I ended up with:
while (!range.empty){
auto aa = range.asAA; // not intuitive for me, I thought asAA should work on the row level.
writeln(aa["col_name"]);
range.popFront;
}
I was wondering if there is a way to express this in a foreach loop?
So that foreach( aa_row; range.asAA) or foreach( row:range){ auto aa = row.asAA; }

So I want to ask you to put a foreach and/or while loop example(s) for handling the result range in your documentation, too.

[Abscissa]

Ahh, I see, I misunderstood.

asAA is one of those things that predates my involvement in this lib that I haven't looked real closely into (except to be careful not to break it.)

It predates D's ranges, too, so that probably explains the weirdness of it being a method of ResultRange (and whatever the predecessor of ResultRange was called - ResultSequence, IIRC) instead of Row. Also, Row doesn't currently have access to the column names - yet. I agree this is very awkward.

I'll see what I can do about documenting this with an example.

But, FWIW, I do intend to augment Row with the ability to lookup columns by name. Aside from being a feature that's been on my personal wishlist for far too long, that should also reduce (maybe even eliminate?) the need for ResultRange.asAA. Though I might still add a Row.toAA as well, if there's still desire for it.

[EmTee70]

foreach(row; db.query("SELECT id, name FROM people ORDER BY name LIMIT 10"))
writeln(row[0], " ", row["name"]); // index and name supported
Do you know where this is from?
https://github.com/adamdruppe/arsd/blob/master/mysql.d

Might be useful to make it similar?

Just saw this at the bottom: Authors: Adam D. Ruppe, with contributions from Nick Sabalausky :-)

[Abscissa]

Interesting. I guess he must've borrowed some stuff from either this or one of my other libs.

And yes, that's basically the syntax I had in mind for looking up a column by name. The implementation should be pretty straightforward, the hardest part is just finding the time for it and everything else :/