www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.learn - Help Building DBI

reply jicman <cabrera__ __wrc.xerox.com> writes:
Greetings!  Congratulations to all of us for 1.0!  Woowoowoowoooooo!

Sorry to ask about this on this newsgroup, but I am kinda trapped
for time and the DBI forum on dsource.org is kinda slow and perhaps
I get faster response here.  Thanks.

Ok, so I want to compile this test program,

----------------
import dbi.sqlite.SqliteDatabase;
import dbi.Row;
//import dbi.all;
import std.stdio;

void main() {
  char[] sqldb  = r"C:\OpenJobs.db";
  SqliteDatabase db = new SqliteDatabase();
  db.connect(sqldb);

  Row[] rows = db.queryFetchAll("SELECT * FROM sqlite_master WHERE
type='table' AND name='LSOpenJobs'");
  foreach (Row row; rows)
  {
    writefln("username: %s Project: %s\n", row["login"], row
["proj"]);
  }

  db.close();
}

----------------

But I am getting this error,

23:24:19.89>build -clean dbitest.d
dbitest.d(1): module SqliteDatabase cannot read
file 'dbi\sqlite\SqliteDatabase.d'

I tried to build dbi, and here is what I get,

23:24:42.54>dmd -run buildme.d sqlite
Digital Mars Librarian Version 8.00n
Copyright (C) Digital Mars 2000-2002 All Rights Reserved
www.digitalmars.com
Digital Mars Librarian complete.

I took the dbi.lib and placed it on c:\dmd\lib and I get the same
thing.

Any ideas as to what to do to get this above program compiled?

Thanks so much.

jos
Jan 04 2007
parent reply Brad Anderson <brad dsource.org> writes:
jicman wrote:
 Greetings!  Congratulations to all of us for 1.0!  Woowoowoowoooooo!
 
 Sorry to ask about this on this newsgroup, but I am kinda trapped
 for time and the DBI forum on dsource.org is kinda slow and perhaps
 I get faster response here.  Thanks.
 
 Ok, so I want to compile this test program,
 
 ----------------
 import dbi.sqlite.SqliteDatabase;
 import dbi.Row;
 //import dbi.all;
 import std.stdio;
 
 void main() {
   char[] sqldb  = r"C:\OpenJobs.db";
   SqliteDatabase db = new SqliteDatabase();
   db.connect(sqldb);
 
   Row[] rows = db.queryFetchAll("SELECT * FROM sqlite_master WHERE
 type='table' AND name='LSOpenJobs'");
   foreach (Row row; rows)
   {
     writefln("username: %s Project: %s\n", row["login"], row
 ["proj"]);
   }
 
   db.close();
 }
 
 ----------------
 
 But I am getting this error,
 
 23:24:19.89>build -clean dbitest.d
 dbitest.d(1): module SqliteDatabase cannot read
 file 'dbi\sqlite\SqliteDatabase.d'
 
 I tried to build dbi, and here is what I get,
 
 23:24:42.54>dmd -run buildme.d sqlite
 Digital Mars Librarian Version 8.00n
 Copyright (C) Digital Mars 2000-2002 All Rights Reserved
 www.digitalmars.com
 Digital Mars Librarian complete.
 
 I took the dbi.lib and placed it on c:\dmd\lib and I get the same
 thing.
 
 Any ideas as to what to do to get this above program compiled?
 
 Thanks so much.
 
 jos�

Hi, I have a symlink to the dbi code so that the source can be found by the compiler. So my dbi folder would be in the same one as the dbitest.d file. You may just want to put a copy of the code there, if you can't do symlinks. Or, get a libddbi.a or ddbi.lib somewhere and send it to the linker. I then give build the following switches in a build.brf file that (for you) would look like this: dbitest -op -L-lsqlite -cleanup Then, you just type build hth, BA P.S. I still would have posted this in the ddbi forum on dsource. I'm watching it a bit...
Jan 05 2007
next sibling parent reply Marcin Kuszczak <aarti interia.pl> writes:
Brad Anderson wrote:

 I then give build the following switches in a build.brf file that (for
 you) would look like this:
 
 dbitest
 -op
 -L-lsqlite
 -cleanup

... And add -d switch to allow depreciated features, when compiling with D 1.0. Currently DDBI is a little bit broken as implicit conversion of D char arrays to char* is depreciated.... -- Regards Marcin Kuszczak (Aarti_pl) ------------------------------------- Ask me why I believe in Jesus http://zapytaj.dlajezusa.pl (en/pl) -------------------------------------
Jan 05 2007
parent jicman <cabrera__ __wrc.xerox.com> writes:
== Quote from Marcin Kuszczak (aarti interia.pl)'s article
 Brad Anderson wrote:
 I then give build the following switches in a build.brf file


 you) would look like this:

 dbitest
 -op
 -L-lsqlite
 -cleanup


 1.0. Currently DDBI is a little bit broken as implicit conversion

 arrays to char* is depreciated....

== Quote from Marcin Kuszczak (aarti interia.pl)'s article
 Brad Anderson wrote:
 I then give build the following switches in a build.brf file


 you) would look like this:

 dbitest
 -op
 -L-lsqlite
 -cleanup


 1.0. Currently DDBI is a little bit broken as implicit conversion

 arrays to char* is depreciated....

Thanks. This is even better. .-)
Jan 05 2007
prev sibling parent jicman <cabrera__ __wrc.xerox.com> writes:
== Quote from Brad Anderson's article
 jicman wrote:
 Greetings!  Congratulations to all of us for 1.0!


 Sorry to ask about this on this newsgroup, but I am kinda trapped
 for time and the DBI forum on dsource.org is kinda slow and


 I get faster response here.  Thanks.

 Ok, so I want to compile this test program,

 ----------------
 import dbi.sqlite.SqliteDatabase;
 import dbi.Row;
 //import dbi.all;
 import std.stdio;

 void main() {
   char[] sqldb  = r"C:\OpenJobs.db";
   SqliteDatabase db = new SqliteDatabase();
   db.connect(sqldb);

   Row[] rows = db.queryFetchAll("SELECT * FROM sqlite_master


 type='table' AND name='LSOpenJobs'");
   foreach (Row row; rows)
   {
     writefln("username: %s Project: %s\n", row["login"], row
 ["proj"]);
   }

   db.close();
 }

 ----------------

 But I am getting this error,

 23:24:19.89>build -clean dbitest.d
 dbitest.d(1): module SqliteDatabase cannot read
 file 'dbi\sqlite\SqliteDatabase.d'

 I tried to build dbi, and here is what I get,

 23:24:42.54>dmd -run buildme.d sqlite
 Digital Mars Librarian Version 8.00n
 Copyright (C) Digital Mars 2000-2002 All Rights Reserved
 www.digitalmars.com
 Digital Mars Librarian complete.

 I took the dbi.lib and placed it on c:\dmd\lib and I get the same
 thing.

 Any ideas as to what to do to get this above program compiled?

 Thanks so much.

 jos�

I have a symlink to the dbi code so that the source can be found

 compiler.  So my dbi folder would be in the same one as the

 You may just want to put a copy of the code there, if you can't do

 Or, get a libddbi.a or ddbi.lib somewhere and send it to the

 I then give build the following switches in a build.brf file that

 would look like this:
 dbitest
 -op
 -L-lsqlite
 -cleanup
 Then, you just type build
 hth,
 BA
 P.S.  I still would have posted this in the ddbi forum on

 watching it a bit...

Thanks Brad, but I did post it there. I posted it here after 8 or so hours after the original dsource.org post. I haven't had much luck (probably because I don't believe in it, .-)) with posts in dsource.org. I still have an unanswered build (bud) post. Anyway, thanks for this. By the way, I am trying to get D into my company. I already have about 10 utilities on our group and a few others with some of our customers. Thanks for I have tried this with trunk 40 and dmd v1.0, but I have to go and do a little clean up on the code. Since now, I get, C:\cygwin\home\us319318\source\d\dbi\sqlite\SqliteDatabase.d(63): function dbi.sqlite.imp.sqlite3_open (char*,sqlite3 **) does not match parameter types (char[],sqlite3 **) C:\cygwin\home\us319318\source\d\dbi\sqlite\SqliteDatabase.d(63): Error: cannot implicitly convert expression (params) of type char[] to char* C:\cygwin\home\us319318\source\d\dbi\sqlite\SqliteDatabase.d(92): function dbi.sqlite.imp.sqlite3_exec (sqlite3 *,char*,int(*)(void*, int, char**, char**),void*,char**) does not match parameter types (sqlite3 *,char[],void*,void*,char**) C:\cygwin\home\us319318\source\d\dbi\sqlite\SqliteDatabase.d(92): Error: cannot implicitly convert expression (sql) of type char[] to char* C:\cygwin\home\us319318\source\d\dbi\sqlite\SqliteDatabase.d(113): function dbi.sqlite.imp.sqlite3_prepare (sqlite3 *,char*,int,sqlite3_stmt **,char**) does not match parameter types (sqlite3 *,char[],uint,sqlite3_stmt **,char**) C:\cygwin\home\us319318\source\d\dbi\sqlite\SqliteDatabase.d(113): Error: cannot implicitly convert expression (sql) of type char[] to char* Let me go and clean those up. I hope these get cleaned up on trunk 41. :-) Thanks again.
Jan 05 2007