Hunt database

Andre Pany andre at s-e-a-p.de
Tue Nov 3 18:14:33 UTC 2020


On Tuesday, 3 November 2020 at 14:05:18 UTC, Vino wrote:
> Hi All,
>
>   Currently testing Hunt database, and facing an issue as 
> below, hence request your help
>
> File : GetConnections.d
> #######################
> module common.GetConnections;
> import hunt.database;
>
> class Connections
> {
>   public Database conn;
>   this() { conn = new 
> Database("mysql://username:password@localhost:3910/testdb"); }
> }
>
> ###################################################################################
> File: GetConfig.d
> #######################
> import common.GetConnections;
> import hunt.database;
>
> auto getConfig(int Seq)
> {
>  auto mdb = new Connections();
>  Statement stmt = mdb.conn.prepare("SELECT * FROM settings 
> WHERE Seq = :Sq");
>            stmt.setParameter("Sq", Seq);
>            stmt.execute();
>  RowSet rs = stmt.query();
>  mdb.conn.close();
>  return rs;
> }
> ##################################################################################
> File : app.d
> #######################
> import std.stdio;
> imoprt common.GetConfig;
>
> void main() {
> writeln(getConfig(1));
> }
>
> Error:
> GetConfig.d
> Error: function 
> hunt.database.Database.Database.prepare(SqlConnection conn, 
> string sql) is not callable using argument types (string)
> cannot pass argument "SELECT * FROM settings WHERE Seq = :Sq" 
> of type string to parameter SqlConnection conn
> Error: template hunt.database.Statement.Statement.setParameter 
> cannot deduce function from argument types !()(int, int), 
> candidates are:
>
> From,
> Vino.B

The hunt database class has a prepare method which expects a 
SqlConnection as first argument and a string as second argument. 
You are passing only a string, therefore the first error.

Ad you name your database instance also connection (conn) and 
your Connections class database (mdb) it makes the source code 
quite hard to understand :)

Kind regards
Andre


More information about the Digitalmars-d-learn mailing list