SQLITE Database in Project
-
Hi All,
I have tried in the same way.But i didnt get it.
Basically i am developing the meego application in windows dev enviornment using Qt creator.Following are my pro file contents,
@
QT += core gui sql
TARGET = AppName
TEMPLATE = app
target.path=/usr/local/bin
INSTALLS=target
SOURCES += ---
---
HEADERS += ---
---
FORMS += ---
---
RESOURCES +=
assests.qrc
addFiles.sources =test.sqlite
addFiles.path = .
DEPLOYMENT += addFiles
@So when i tried to build the file, automatically the other folde is added into my project directory and showing test.sqlite inside it;
But when i tried with the following code
@
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(dbname);
if(db.open())
{
// ITs always true;in the sense it automatically creates a new database name test.sqlite in the /usr/local/bin folder
}
@Please give some suggestions over this issue.
Thanks,
Vsh.Vshnu[EDIT: code formatting, please use @-tags, not stars (*), Volker]
-
Hi Vsh.Vshnu,
Follow the SQLite examples given in Forum Nokia:
"Creating an SQLite database in Qt":http://wiki.forum.nokia.com/index.php/CS001504_-Creating_an_SQLite_database_in_Qt
"Searching for data in a database in Qt":http://wiki.forum.nokia.com/index.php/CS001507-_Searching_for_data_in_a_database_in_QtBest regards,
Leon -
[quote author="leon.anavi" date="1305634618"]Hi Vsh.Vshnu,
Follow the SQLite examples given in Forum Nokia:
"Creating an SQLite database in Qt":http://wiki.forum.nokia.com/index.php/CS001504_-Creating_an_SQLite_database_in_Qt
"Searching for data in a database in Qt":http://wiki.forum.nokia.com/index.php/CS001507-_Searching_for_data_in_a_database_in_QtBest regards,
Leon[/quote]Hi leon.anavi,
My problem is different.Its becasuse i am not able to open a existing sqlite database inside project main folder.
I want the sqlite files to be inside my application package file?? -
the target path of your app is /usr/local/bin, the path of your db is test.sqlite - so the complete path is /usr/local/bin/test.sqlite. Sounds quite ok for me (in regard to the setup, a database file in /usr/local/bin is a no-go!).
Do you have a test.sqlite that actually is packed in your setup?
And be aware, the packing options are Symbian only!. It is ignored for any other operating systems, including Meego! It is for reason, that Matze5590 has put them into the symbian scope!
-
[quote author="vsh.vshnu" date="1305635099"]Hi Volker,
Its simply
QString dbName="test.sqlite";Iam developing for meego in windows developement enviorment using Qt creator[/quote]
Try to use the absolute path. You can get the file path of the application executable using "QCoreApplication::applicationFilePath":http://doc.qt.nokia.com/latest/qcoreapplication.html#applicationFilePath
Cheers,
Leon -
[quote author="leon.anavi" date="1305635864"]
[quote author="vsh.vshnu" date="1305635099"]Hi Volker,
Its simply
QString dbName="test.sqlite";Iam developing for meego in windows developement enviorment using Qt creator[/quote]
Try to use the absolute path. You can get the file path of the application executable using "QCoreApplication::applicationFilePath":http://doc.qt.nokia.com/latest/qcoreapplication.html#applicationFilePath
Cheers,
Leon[/quote]
Hi Leon,
Thanks for the support ,
I have tried using the QCoreApplication::applicationFilePath
@QString dbName=QCoreApplication::applicationFilePath()+“\test.sqlite”;@
But it seems not opening the database.
All I wanted to pack the sqlite database inside my application so that i can install the applications as a single unit. -
[quote author="Volker" date="1305635745"]Do you have a test.sqlite that actually is packed in your setup?
[/quote][quote author="vsh.vshnu" date="1305636668"]
All I wanted to pack the sqlite database inside my application so that i can install the applications as a single unit.
[/quote]I think you should follow Volker's hint :) Please read "MeeGo Packaging/Guidelines":http://wiki.meego.com/Packaging/Guidelines As you probably know MeeGo apps are distributed as rpm so you have to include your database into the rpm.
-
[quote author="leon.anavi" date="1305637109"][quote author="Volker" date="1305635745"]Do you have a test.sqlite that actually is packed in your setup?
[/quote][quote author="vsh.vshnu" date="1305636668"]
All I wanted to pack the sqlite database inside my application so that i can install the applications as a single unit.
[/quote]I think you should follow Volker's hint :) Please read "MeeGo Packaging/Guidelines":http://wiki.meego.com/Packaging/Guidelines As you probably know MeeGo apps are distributed as rpm so you have to include your database into the rpm.
[/quote]
Thanks for the help.. i will look into it..
Thanks & Regards,
Vsh.Vshnu -
@goetz
some time , we need store a read-only database file in the QRC file. just need read no need change.
store in qrc file will avoid use change ,delete....etc it. and use database file (qsqlite3 ) will be fast get query result.now qt version is 5.8. can we do it ?
best regards,
-
-
@cawlfj
Well its not impossible to still dig it out using a hex editor.
For dbs, something like
https://www.zetetic.net/sqlcipher/about/
might be better.
Maybe you can use the dump trick to upload to a :mem based db.
http://stackoverflow.com/questions/3826552/in-python-how-can-i-load-a-sqlite-db-completely-to-memory-before-connecting-to
Disclaimer: i never tried this.
