Vibe/Mysql Testing

[Andre Pany]

On Thursday, 17 October 2019 at 19:05:44 UTC, Vino wrote:
> Hi All,
>
>   Request your help on the below code and error
>
> Error:
> source\app.d(25,15): Error: none of the overloads of writeBody 
> are callable using argument types (VariantN!20LU), candidates 
> are
>
> Code:
> import vibe.vibe;
> import std.array : array;
> import mysql;
> import std.stdio;
> import std.range;
>
> void main()
> {
> 	auto settings = new HTTPServerSettings;
> 	settings.port = 8080;
> 	settings.bindAddresses = ["127.0.0.1"];
> 	listenHTTP(settings, &hello);
>
> 	logInfo("Please open http://127.0.0.1:8080/ in your browser.");
> 	runApplication();
> }
>
> void hello(HTTPServerRequest req, HTTPServerResponse res)
> {
> 	auto connectionStr = 
> "host=test.srv.com;port=3910;user=testusr;pwd=xxxx#;db=test";
> 	Connection conn = new Connection(connectionStr);
> 	scope(exit) conn.close();
> 	ResultRange range = conn.query("SELECT host_name FROM 
> `hosts_coll`");
> 	Row row = range.front;
> 	res.writeBody(row[0]);
> }
>
> From,
> Vino.B

Hi,

I assume you are using this mysql package 
http://code.dlang.org/packages/mysql-native.
(If not please check wheter the package you are using is vibe-d 
compliant.)

The mysql package uses Variant from Phobos for storing values. 
For your example, you could write 
```res.writeBody(row[0].toString());```

Kind regards
Andre