RejectedSoftware Forums

On Tue, 17 Dec 2013 20:43:02 GMT, Luís Marques wrote:

I have ddb working, but I don't know how to pass parameters to queries (without concatenating strings, which is unsafe and awkward). That is, I'm looking for something like this:

PGCommand(conn, "SELECT * FROM foo WHERE bar = ?", barValue);

Suggestions?

I can't get ddb working. I get this error

object.Exception@../../../home/visus/.dub/packages/vibe-d-master/source/vibe/core/drivers/libevent2_tcp.d(348): Connection error while reading from TCPConnection.
Error: Program exited with code 1

here is my code

import postgres.db;

this()
{
	auto pdb = new PostgresDB([
		"host" : "localhost",
		"database" : "mydb",
		"user" : "postgres",
		"password" : "postgres"
	]);
	auto conn = pdb.lockConnection();
	
	auto cmd = new PGCommand(conn, "SELECT typname, typlen FROM pg_type");
	auto result = cmd.executeQuery;
	
	try
	{
		foreach (row; result)
		{
			writeln(row["typname"], ", ", row[1]);
		}
	}
	finally
	{
		result.close;
	}
}

On Wed, 18 Dec 2013 15:54:38 GMT, Luís Marques wrote:

On Tue, 17 Dec 2013 20:43:02 GMT, Luís Marques wrote:

I have ddb working, but I don't know how to pass parameters to queries (without concatenating strings, which is unsafe and awkward). That is, I'm looking for something like this:

PGCommand(conn, "SELECT * FROM foo WHERE bar = ?", barValue);

I had missed the right part of the source (I couldn't get dmd -D to work for postgres.d) where it says:

Examples:
---
// without spaces between $ and number
auto cmd = new PGCommand(conn, "INSERT INTO users (name, surname) VALUES ($ 1, $ 2)");
cmd.parameters.add(1, PGType.TEXT).value = "John";
cmd.parameters.add(2, PGType.TEXT).value = "Doe";

I had expected that one could pass the params directly in the ctor, like in my example.

I'd also open up an issue on github, Piotr may not be active enough here in the forum to see it.

But I agree with that sentiment, at least in a D API I'd expect that, too. Maybe even statically checked for validity with something like

auto cmd = makePGCommand!"INSERT INTO users (name, surname) VALUES ($1, $2)"("John", "Doe");