source: src/sql/sqlengine.cpp

Revision Log Mode:


Copied or renamed
Diff Rev Age Author Log Message
(edit) @763b877   5 months philipp Fix bug: display_time_shift was lost when conference was reloaded.
(edit) @ffb6be7   6 months gregor Bump copyright years.
(edit) @8d47489   6 months philipp Parse and store utc_offset.
(edit) @c13a488   6 months philipp Add utc_offset and display_time_shift columns to conference database.
(edit) @af9f24b   6 months philipp Replace QHash with QMultiHash to avoid a deprecation warning.
(edit) @0816326   4 years philipp C++98 compatibility: Variable initialization in SqlEngine? class.
(edit) @0c71a07   4 years philipp Implement rollbackTransaction().
(edit) @d03ca41   4 years philipp If no day_change was given for a conference 4 AM is assumed. Fixes #53.
(edit) @7ba0378   4 years philipp Import schedules with dates attached to events correctly.
(edit) @f0f9fdc   4 years philipp Avoid duplicate code when inserting/updating a conference.
(edit) @79a7671   4 years gregor ifdef qt4 and qt5 qt5
(edit) @809b5e5   4 years gregor Merge branch 'master' into qt5 qt5
(edit) @e27a3f5   4 years philipp When no track is present, use the special name "No track" is used. … qt5
(edit) @de5d0f1   5 years gregoa Bump copyright years. qt5
(edit) @ebe26af   5 years gregoa Merge branch 'master' into qt5 qt5
(edit) @4a87a3b   7 years gregoa Bump copyright year. In anticipation of a release in 2015. qt5
(edit) @54b69e2   7 years philipp Merged changes from trunk. It still compiles successfully. :-) qt5
(edit) @11f3f87   7 years gregoa Update copyright notices. qt5
(edit) @4b6ae6b   8 years philipp Now the application compiles for QT5. Note that the location of the … qt5
(edit) @d942dc3   8 years philipp Fixed a yet unknown bug: The room name was not properly inserted in … qt5
(edit) @41c4ceb   9 years philipp Now the dayChange time is taken into account. This fixes #43. qt5
(edit) @83481c6   9 years gregoa bump copyright years qt5
(edit) @f1826af   9 years philipp Schmema update completed. Finally closing ticket #45. qt5
(edit) @e2c612c   9 years philipp Reloading a conference works now. qt5
(edit) @5e50875   9 years philipp Fixed: Forgot to call query.exec() at several places. qt5
(edit) @5293ef0   9 years gregoa Remove unsed (and removed from db) 'days' column fro xml parser and … qt5
(edit) @0ba2b59   9 years gregoa Don't insert empty string into picture column. (NOT NULL constraint … qt5
(edit) @7e45288   9 years gregoa Remove empty-city-hack. (NOT NULL removed from db schema.) qt5
(edit) @a8f8b5d   9 years gregoa One version for creating the directory is enough :) (Now tested on … qt5
(edit) @9b5a80ff   9 years philipp Added a second possibility to create the directory and removed the TODO. qt5
(edit) @1f12b6b   9 years gregoa fix .mkpath() Creating the "." path works. Is this idiomatic? At … qt5
(edit) @61346c9   9 years philipp Restructured the SqlEngine?. Not yet finished (see "TODO" in the code). qt5
(edit) @8d6798d   9 years gregoa fix some more header includes qt5
(edit) @2dffed3   9 years philipp On the way to fix #45. qt5
(edit) @4147e08   10 years gregoa Add Stefan as a copyright holder to source files, too. qt5
(edit) @8bc87d6   10 years gregoa Update copyright years. qt5
(edit) @71c3eb6   10 years philipp Fixed by gregoa: Searching for titles where the events had no person … qt5
(edit) @3655d06   10 years stef Fixed ticket #20 qt5
(edit) @a9f56bb   10 years gregoa .isEmpty() feels more Qtish then == "" qt5
(edit) @2dcbb2c   10 years gregoa Quick fix for ticket: #32: if the schedule XML doesn't contain a city, … qt5
(edit) @1dbb3bb   10 years gregoa Remove conference/room records unconditionally from EVENT_ROOMS qt5
(edit) @274f6dc   10 years gregoa SqlEngine::addRoomToDB: remove event/conference combinations from … qt5
(edit) @525e2e2   11 years philipp This commit closes ticket #12. The search terms are ANDed now and a … qt5
(edit) @53effcb   11 years philipp Fixed bug (related to ticket #12): Only the last search term is used. qt5
(edit) @e388cda   11 years philipp Undid changes to sqlengine.cpp I committed accidentally in r1318. qt5
(edit) @47eda2b   11 years gregoa Split search keyword string on whitespace. qt5
(edit) @66698a6   11 years gregoa Avoid duplicate search results by using SELECT DISTINCT when filling … qt5
(edit) @e6ab8a2   11 years philipp Removed the ability to show "pictures" (maps) of rooms and maps of … qt5
(edit) @cf385cd   11 years philipp Removed many of the qDebug() output lines (see ticket #10). qt5
(edit) @f48bf9f   11 years philipp The '%' character doesn't have to be escaped anymore. qt5
(edit) @df884b3   11 years gregoa Somewhere a slash was missing … qt5
(edit) @babe4cd   11 years gregoa Remove ULB, Campus Solbosch maps. qt5
(edit) @9f97eaf   11 years gregoa Move config and sqlite database. They are both at the xdg-specified … qt5
(edit) @dcefa71   11 years philipp Prevented SQL injections in function addPersonToDB. qt5
(edit) @68b2df2   11 years gregoa Add copyright to source. qt5
(edit) @6df32f2   11 years gregoa Update GPL blurb in source files. qt5
(edit) @dc54e87   11 years philipp Prevented SQL injection in function addLinkToDB. qt5
(edit) @a55781e   11 years philipp Fixed SQL error in searchEvent when no table was selected. Prevented … qt5
(edit) @f09a1b9   11 years philipp Fixed a bug I introduced when reparing the addRoomToDB function. qt5
(edit) @141a5c2   11 years philipp Tracks are inserted now when importing new conferences. qt5
(edit) @909ea23   11 years philipp void possible SQL injection in function addRoomToDB. qt5
(edit) @4b8ce66   11 years philipp The database is now created from the program. We don't need to copy or … qt5
(edit) @c8b84e1   11 years philipp Persons are deleted now when a conference is removed. qt5
(edit) @63b2343   11 years philipp Rooms are inserted now for additionally imported conferences. qt5
(edit) @f657e9c   11 years philipp Changed UNIQUE statements in the database table definition so that … qt5
(edit) @51529bd   11 years gregoa Insert new field xid_conference into table track, room and person. qt5
(edit) @cec47c6   12 years kirilma store path to conference map in database path stored as additional … qt5
(edit) @d97bcab   12 years kirilma implement deleting a conference pass event about it to mainwindow to … qt5
(edit) @d06ae27   12 years kirilma store URL's for conferences * use it at update * let user update the … qt5
(edit) @be9b645   12 years kirilma remove unused code qt5
(edit) @c129da26   12 years kirilma fix event insert or update * add error reporting for queries * … qt5
(edit) @f548c17   12 years kirilma use update for events when they are already exists also use only … qt5
(edit) @1bad318   12 years kirilma use transactions to make import faster qt5
(edit) @5d9409d   12 years timkoma UTC/LocalTime fix for import conference XML, DB queries for multiple … qt5
(edit) @7270ae0   12 years timkoma fix for import - ON CONFLICT REPLACE qt5
(edit) @ca90cb1   12 years uzakmat A header with the proper copyright/lincence statement was added into … qt5
(edit) @b4e9936   12 years pavelpa changed permissions for the db - TODO: check it on the device qt5
(edit) @979e5be   12 years pavelpa created resource which contains parsed schedule, so the user doesn't … qt5
(edit) @bcf67d6   12 years pavelpa search fixed - only the dates (range) which contain at least one … qt5
(edit) @412cef6   12 years pavelpa some 'delegate' drawing optimizations - removed EVENT_CONFLICT table … qt5
(edit) @0bb39f5   12 years pavelpa removed appsettings - created 'active' column in 'conference' table qt5
(edit) @9f367eb   12 years pavelpa 'conflicts' modifications - preparing for the dialog showing also … qt5
(edit) @89ff5f2   12 years timkoma unique constraints added into sql qt5
(edit) @c7b58d4   12 years timkoma search upgrade qt5
(edit) @0d4ecc2   12 years timkoma search update qt5
(edit) @005e2b7   12 years korrco caching removed qt5
(edit) @1735f55   12 years pavelpa check for existence of conference before inserting it into DB qt5
(edit) @e493054   12 years pavelpa import/search schedule dialog implemented qt5
(edit) @9d8946b   12 years timkoma update for the search qt5
(edit) @7d7659d   12 years pavelpa combined EVENT and VIRTUAL_EVENT => 'EVENT' now - Maemo sqlite … qt5
(edit) @72cd3af   12 years korrco activities tab implemented qt5
(edit) @e662750   12 years timkoma first working version of the search qt5
(edit) @4693fa6   12 years pavelpa changed 'Activity' -> 'Track' qt5
(edit) @926f106   12 years pavelpa parsing activity from xml - 'track' from xml schedule is treated as … qt5
(edit) @990afd5   12 years timkoma temp commit for search tab qt5
(edit) @cfd615d   12 years pavelpa work on alarm qt5
(edit) @b6cd05c   12 years pavelpa added 'alarm' columnt to the 'EVENT' table to signalize that the event … qt5
(edit) @151983f   12 years hanzes fixed sqlite statement qt5
(edit) @84b9c07   12 years pavelpa used 'MAEMO' define to create 'non-virtual' 'VIRUAL_EVENT' table … qt5
(edit) @27102d5   12 years fortefr Temporal virtual_event change qt5
Note: See TracRevisionLog for help on using the revision log.