mysql-native v2.1.0

[bauss]

On Saturday, 3 March 2018 at 07:37:38 UTC, Nick Sabalausky 
(Abscissa) wrote:
> An all-D MySQL/MariaDB client library:
> https://github.com/mysql-d/mysql-native
> ==========================================
>
> Tagged 'v2.1.0', which mainly adds a few new features, 
> including greatly simplified shortcut syntax for prepared 
> statements (with automatic, implicit caching and re-use):
>
> ---
> int i = 5;
> string s = "Hello world";
> conn.exec("INSERT INTO table_name VALUES (?, ?)", i, s);
> conn.query("SELECT * FROM table_name WHERE id=? AND name=?", i, 
> s);
>
> // Also works:
> Prepared stmt = conn.prepare("INSERT ...blah... (?, ?)");
> conn.exec(stmt, i, s);
> ---
>
> As well as additional tools for optional micro-management of 
> registering/releasing prepared statements.
>
> It also fixes #28: "MYXProtocol thrown when using large 
> integers as prepared parameters."
>
> Full changelog
> https://github.com/mysql-d/mysql-native/blob/master/CHANGELOG.md#v210---2018-03-02

I'm unsure how I'd go about implementing prepared statements in a 
vibe.d application correctly.

With older versions it didn't work properly and I'm not sure how 
to implement it with the new version of prepared statements.

I can't seem to find any examples on how they were updated and 
what exactly to change in my code.

It would be nice with some more examples that aren't basics.

Especially, because I call setArgs() to set arguments from an 
array since I have no control over the arguments passed to the 
function as they're generated elsewhere and thus I cannot 
manually specify the arguments.


I guess I will try to dig around and see what works and what 
doesn't, unless you can pinpoint me in the correct direction.