Statement.bind

Binds the passed value to the specified dynamic parameter

Dynamic paramters are 0-indexed, i.e. the first parameter is 0 (not 1).

Yes, indexes start with 1 in SQL, but in oceandrift they don’t.

I’ve not only considered implementing them 1-indexed (like PHP’s PDO or the SQLite3 C library does), I even implemented them that way. And got burned. Multiple times.

In the end it’s a choice between two evils (as in: inconsistencies):

As we can’t change SQL and the database, those are always going to be 1-index.
Query results will always be 0-indexed, unless we’d wrap them into a magic type that would make them inconsistent with the rest of the D ecosystem (or use AAs – this option also comes with its own pitfalls and disadvantages).
Dynamic parameters are the only thing we can realistically choose to have either zero- or one-indexed. They can now be inconsistent with either query results or the database.

Data structures in D are 0-indexed (like in most programming languages). So I chose to go with this for dynamic parameters on the D side as well.

In D (where 0-indexed arrays and slices are prefered) 0-indexing is the way to go whereever possible.

Oh well, even in PHP PDO::FETCH_NUM means result is an array starting at column 0. Inconsistent, isn’t it?

void bind(int index, bool value)
void bind(int index, byte value)
void bind(int index, ubyte value)
void bind(int index, short value)
void bind(int index, ushort value)
void bind(int index, int value)
interface Statement
@safe
void
bind
(
int index
,
const int value
)
void bind(int index, uint value)
void bind(int index, long value)
void bind(int index, ulong value)
void bind(int index, double value)
void bind(int index, const(ubyte)[] value)
void bind(int index, string value)
void bind(int index, DateTime value)
void bind(int index, TimeOfDay value)
void bind(int index, Date value)
void bind(int index, typeof(null) )

Parameters

index int: 0-indexed index-number of the dynamic parameter to bind to
value int: value to bind

Statement.bind

Parameters

Meta

Source