[maemo-developers] QtSql and Debian package probelm

[From: Daniil Ivanov]

Hi Sascha!

   Can you change your code like this:
   QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
   QString name = QDir::homePath() + "/CurrencyConverter";
   db.setDatabaseName(name);
    if (!db.open()) {
        qDebug() << name << db.lastError();
        return false;
    } else
        return true;

   and then run your application from the console?

Thanks, Daniil.

On Fri, Jun 11, 2010 at 11:11 AM, Sascha Mäkelä <sascha.makela at gmail.com> wrote:
> I have now like this:
> QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
> QString name = QDir::homePath() + "/CurrencyConverter";
> db.setDatabaseName(name);
> return db.open();
> It works fine directly from Qt Creator, but it doesn't work when installing
> the Debian package. Any ides?
>
> On Thu, Jun 10, 2010 at 16:39, Daniil Ivanov <daniil.ivanov at gmail.com>
> wrote:
>>
>>   It's actually better to use getenv("HOME"), instead of /home/user.
>>
>> Thanks, Daniil.
>>
>> On Thu, Jun 10, 2010 at 4:37 PM, Daniil Ivanov <daniil.ivanov at gmail.com>
>> wrote:
>> > Ok, no need for directory:
>> >
>> >  QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
>> >  db.setDatabaseName("/home/user/.AppName");
>> >  if (!db.open())
>> >      qDebug() << db.lastError();
>> >
>> > Thanks, Daniil.
>> >
>> > On Thu, Jun 10, 2010 at 4:33 PM, Sascha Mäkelä <sascha.makela at gmail.com>
>> > wrote:
>> >> Ehr... no. And how would I do that? Sorry for these silly questions...
>> >> Thanks,
>> >> Sascha
>> >> PS. As such it didn't work in the package. But then again, I did not
>> >> create
>> >> the directory...
>> >>
>> >> On Thu, Jun 10, 2010 at 16:31, Daniil Ivanov <daniil.ivanov at gmail.com>
>> >> wrote:
>> >>>
>> >>>  Did you create /home/user/.somedir/?
>> >>>
>> >>> Thanks, Daniil.
>> >>>
>> >>> On Thu, Jun 10, 2010 at 4:28 PM, Sascha Mäkelä
>> >>> <sascha.makela at gmail.com>
>> >>> wrote:
>> >>> > OK, let me try that. But at least it doesn't like it when running
>> >>> > from
>> >>> > Qt
>> >>> > Creator (I'm using Nokia Qt SDK). The database stops working and
>> >>> > behaves
>> >>> > the
>> >>> > same way as in the package.
>> >>> >
>> >>> > On Thu, Jun 10, 2010 at 16:08, Daniil Ivanov
>> >>> > <daniil.ivanov at gmail.com>
>> >>> > wrote:
>> >>> >>
>> >>> >> Hi!
>> >>> >>
>> >>> >>   You should be using something like this:
>> >>> >>
>> >>> >>   QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
>> >>> >>   db.setDatabaseName("/home/user/.somedir/AppName");
>> >>> >>
>> >>> >>
>> >>> >>   return db.open();
>> >>> >>
>> >>> >> Thanks, Daniil.
>> >>> >>
>> >>> >> On Thu, Jun 10, 2010 at 4:01 PM, Sascha Mäkelä
>> >>> >> <sascha.makela at gmail.com>
>> >>> >> wrote:
>> >>> >> > I'm just getting:
>> >>> >> > QSqlQuery::value: not positioned on a valid record
>> >>> >> > It's like the app is unable to write any data to the SQLite
>> >>> >> > database.
>> >>> >> > As
>> >>> >> > I
>> >>> >> > said, it does work fine when running it from Qt Creator or MADDE.
>> >>> >> >
>> >>> >> > On Thu, Jun 10, 2010 at 15:57, David King <davidk at openismus.com>
>> >>> >> > wrote:
>> >>> >> >>
>> >>> >> >> On 2010-06-10 15:47, Sascha Mäkelä <sascha.makela at gmail.com>
>> >>> >> >> wrote:
>> >>> >> >>>
>> >>> >> >>> This how it looks now:
>> >>> >> >>>
>> >>> >> >>> Depends: ${shlibs:Depends}, ${misc:Depends}, libqt4-network,
>> >>> >> >>> libqt4-sql,
>> >>> >> >>> libqt4-sql-sqlite
>> >>> >> >>>
>> >>> >> >>> But still it doesn't work. Am I missing something? The app
>> >>> >> >>> works
>> >>> >> >>> fine
>> >>> >> >>> when I
>> >>> >> >>> run it in N900 from Qt Creator.
>> >>> >> >>
>> >>> >> >> Which database provider do you use, I guess SQLite? If so, your
>> >>> >> >> Depends:
>> >>> >> >> line looks correct. When you say that the SQL parts of the
>> >>> >> >> application
>> >>> >> >> do
>> >>> >> >> not work, what is the problem? You could try starting your
>> >>> >> >> program
>> >>> >> >> from
>> >>> >> >> the
>> >>> >> >> terminal to check for clues in the output. Either that, or
>> >>> >> >> report
>> >>> >> >> any
>> >>> >> >> error
>> >>> >> >> messages that the application gives you.
>> >>> >> >>
>> >>> >> >>> Thanks for all your help,
>> >>> >> >>> Sascha
>> >>> >> >>>
>> >>> >> >>> On Thu, Jun 10, 2010 at 15:12, David King
>> >>> >> >>> <davidk at openismus.com>
>> >>> >> >>> wrote:
>> >>> >> >>>
>> >>> >> >>>> On 2010-06-10 15:01, Sascha Mäkelä <sascha.makela at gmail.com>
>> >>> >> >>>> wrote:
>> >>> >> >>>>
>> >>> >> >>>>> Hi,
>> >>> >> >>>>>
>> >>> >> >>>>> I just made a Debian package of my app. I'm using QtSql in
>> >>> >> >>>>> it.
>> >>> >> >>>>> But
>> >>> >> >>>>> for
>> >>> >> >>>>> some
>> >>> >> >>>>> reason when I install the package, all the SQL things don't
>> >>> >> >>>>> work.
>> >>> >> >>>>> My
>> >>> >> >>>>> guess
>> >>> >> >>>>> is that I'm missing something in the Build-Depends line in
>> >>> >> >>>>> the
>> >>> >> >>>>> control
>> >>> >> >>>>> file.
>> >>> >> >>>>> How can I check what libs I need to add there and what are
>> >>> >> >>>>> their
>> >>> >> >>>>> correct
>> >>> >> >>>>> names?
>> >>> >> >>>>>
>> >>> >> >>>>> Cheers,
>> >>> >> >>>>> Sascha
>> >>> >> >>>>>
>> >>> >> >>>>> PS. Currently it's like this: Build-Depends: dephelper (>5),
>> >>> >> >>>>> libqt4-dev,
>> >>> >> >>>>> libqt4-network
>> >>> >> >>>>>
>> >>> >> >>>>
>> >>> >> >>>> You need to add the relevant Qt SQL provider packages to the
>> >>> >> >>>> ‘Depends:’
>> >>> >> >>>> line, not the ‘Build-Depends:’ line, as the SQL providers are
>> >>> >> >>>> plugins
>> >>> >> >>>> that
>> >>> >> >>>> are not required at build time, but at runtime. You probably
>> >>> >> >>>> want
>> >>> >> >>>> libqt4-sql-mysql or libqt4-sql-sqlite in Depends, depending on
>> >>> >> >>>> which
>> >>> >> >>>> database provider you are using.
>> >>> >> >>
>> >>> >> >> --
>> >>> >> >> David King | http://amigadave.com/
>> >>> >> >> _______________________________________________
>> >>> >> >> maemo-developers mailing list
>> >>> >> >> maemo-developers at maemo.org
>> >>> >> >> https://lists.maemo.org/mailman/listinfo/maemo-developers
>> >>> >> >
>> >>> >> >
>> >>> >> > _______________________________________________
>> >>> >> > maemo-developers mailing list
>> >>> >> > maemo-developers at maemo.org
>> >>> >> > https://lists.maemo.org/mailman/listinfo/maemo-developers
>> >>> >> >
>> >>> >> >
>> >>> >
>> >>> >
>> >>
>> >>
>> >
>
>