Re: Any sample how to use Sqlite-d?

[biozic via Digitalmars-d-learn]

On Wednesday, 17 January 2018 at 13:36:26 UTC, Marc wrote:
I was looking for a library to use SQLite with D, found this 
(https://code.dlang.org/packages/sqlite-d) but it has no 
documentation or code example. I looked into files in the 
source code and wrote this:



Database db = Database(name);
auto table = db.table(tableName);
auto rows = table.findRows!(format!"(id,date) => id == %s"(id));

(i'm aware of sql injection above)

but it doesnt work, it seems the library has changed. If happen 
to that library author see this, would be very helpful.


Also have a look at https://github.com/biozic/d2sqlite3 
(documentation: http://biozic.github.io/d2sqlite3/d2sqlite3.html).

Re: Any sample how to use Sqlite-d?

[Stefan Koch via Digitalmars-d-learn]

On Wednesday, 17 January 2018 at 13:36:26 UTC, Marc wrote:
I was looking for a library to use SQLite with D, found this 
(https://code.dlang.org/packages/sqlite-d) but it has no 
documentation or code example. I looked into files in the 
source code and wrote this:



Database db = Database(name);
auto table = db.table(tableName);
auto rows = table.findRows!(format!"(id,date) => id == %s"(id));

(i'm aware of sql injection above)

but it doesnt work, it seems the library has changed. If happen 
to that library author see this, would be very helpful.


Hello Marc,

I am the author of sqlite-d, since it is a very low level library 
it does correlate rows and names.


I would need to see the schema to tell you which rows to compare.

Otherwise there is an code example in the repo call example_app.d

Re: Any sample how to use Sqlite-d?

[H. S. Teoh via Digitalmars-d-learn]

On Wed, Jan 17, 2018 at 01:36:26PM +, Marc via Digitalmars-d-learn wrote:
> I was looking for a library to use SQLite with D, found this
> (https://code.dlang.org/packages/sqlite-d) but it has no documentation
> or code example. I looked into files in the source code and wrote
> this:
> 
> > Database db = Database(name);
> > auto table = db.table(tableName);
> > auto rows = table.findRows!(format!"(id,date) => id == %s"(id));
> (i'm aware of sql injection above)
> 
> but it doesnt work, it seems the library has changed. If happen to
> that library author see this, would be very helpful.

You might want to try this instead:

https://github.com/adamdruppe/arsd/blob/master/sqlite.d

I've used it myself, and can vouch for its ease-of-use, depending on
what you want to do. The equivalent of your code above is:

Database db = new SQLite(filename);
auto rows = db.query("SELECT * FROM " ~ tableName ~
" WHERE id=?", id);
// Note: no SQL injection issue here
foreach (row; rows) {
...
}


T

-- 
Leather is waterproof.  Ever see a cow with an umbrella?

Any sample how to use Sqlite-d?

[Marc via Digitalmars-d-learn]

I was looking for a library to use SQLite with D, found this 
(https://code.dlang.org/packages/sqlite-d) but it has no 
documentation or code example. I looked into files in the source 
code and wrote this:



Database db = Database(name);
auto table = db.table(tableName);
auto rows = table.findRows!(format!"(id,date) => id == %s"(id));

(i'm aware of sql injection above)

but it doesnt work, it seems the library has changed. If happen 
to that library author see this, would be very helpful.