Re: sqlite support added to sqlbuilder

2024-01-21 Thread Steven Schveighoffer via Digitalmars-d-announce
On Sunday, 21 January 2024 at 21:27:30 UTC, zoujiaqing wrote: Thank you! I want postgresql :) It should be pretty straightforward. I had to rewrite a lot of it to fit the API of sqlite, those changes should make it easier to add postgresql (which is on my todo list). -Steve

Re: sqlite support added to sqlbuilder

2024-01-21 Thread zoujiaqing via Digitalmars-d-announce
On Saturday, 30 December 2023 at 22:11:55 UTC, Steven Schveighoffer wrote: https://code.dlang.org/packages/sqlbuilder This project is something I use extensively in my work project, and allows dynamic building of SQL statements in a way that automatically deals with joins. It also

Re: sqlite support added to sqlbuilder

2024-01-04 Thread Steven Schveighoffer via Digitalmars-d-announce
On Thursday, 4 January 2024 at 18:03:56 UTC, Leonardo wrote: On Saturday, 30 December 2023 at 22:11:55 UTC, Steven Schveighoffer wrote: auto andrei = db.fetchOne(select(ads).where(ads.firstname, " = 'Andrei'")); How SQL injection are avoided here? SQL injection is avoided by passing

Re: sqlite support added to sqlbuilder

2024-01-04 Thread Leonardo via Digitalmars-d-announce
On Saturday, 30 December 2023 at 22:11:55 UTC, Steven Schveighoffer wrote: auto andrei = db.fetchOne(select(ads).where(ads.firstname, " = 'Andrei'")); How SQL injection are avoided here?

sqlite support added to sqlbuilder

2023-12-30 Thread Steven Schveighoffer via Digitalmars-d-announce
https://code.dlang.org/packages/sqlbuilder This project is something I use extensively in my work project, and allows dynamic building of SQL statements in a way that automatically deals with joins. It also automatically serializes directly to structs representing database rows. It was