SQL-Queries are now stored in a resource. The bashscript
authorMarcus Eggenberger <egs@quassel-irc.org>
Mon, 7 Jan 2008 20:25:50 +0000 (20:25 +0000)
committerMarcus Eggenberger <egs@quassel-irc.org>
Mon, 7 Jan 2008 20:25:50 +0000 (20:25 +0000)
commit4b41d8800c38aa3bc4e88a76289b45bc888ba088
treedd5ba3e8dc6cc809a63c047eb07eafb0dbe032ce
parent6447ec038a9553427fb729f5889c69e0f2f247a8
SQL-Queries are now stored in a resource. The bashscript
src/core/UPDATE_SQL_RESOURCES.sh adds all known sql query files to the
resource file. SqliteStorage derives from AbstractSqlStorage which
should make the integration of future sql engines way simpler. In
addition it features an automatic upgrade to newer schema versions.
48 files changed:
build/targets/core.pri
build/targets/core.pro
build/targets/monolithic.pro
dev-notes/ROADMAP
src/common/settings.cpp
src/core/SQL/SQLite/1/delete_backlog_by_uid.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/delete_buffers_by_uid.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/delete_networks_by_uid.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/delete_quasseluser.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/insert_buffer.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/insert_message.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/insert_network.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/insert_quasseluser.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/insert_sender.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_authuser.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_bufferByName.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_buffers.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_lastMessage.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_messageRange.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_messages.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_messagesOffset.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_messagesSince.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_messagesSinceOffset.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/select_userid.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_000_quasseluser.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_010_sender.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_020_network.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_040_buffer.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_050_buffer_idx.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_060_backlog.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_070_coreinfo.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/setup_080_version.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/update_username.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/update_userpassword.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/upgrade_000_drop_coreinfo.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/upgrade_010_create_coreinfo.sql [new file with mode: 0644]
src/core/SQL/SQLite/1/upgrade_020_update_schemaversion.sql [new file with mode: 0644]
src/core/UPDATE_SQL_RESOURCE.sh [new file with mode: 0755]
src/core/abstractsqlstorage.cpp [new file with mode: 0644]
src/core/abstractsqlstorage.h [new file with mode: 0644]
src/core/core.cpp
src/core/core.h
src/core/core.pri
src/core/sql.qrc [new file with mode: 0644]
src/core/sqlitestorage.cpp
src/core/sqlitestorage.h
src/core/storage.cpp
src/core/storage.h