source: confclerk_git/src/sql

Revision Log Mode:


Legend:

Added
Modified
Copied or renamed
Diff Rev Age Author Log Message
(edit) @d942dc3   9 years philipp Fixed a yet unknown bug: The room name was not properly inserted in … qt5
(edit) @41c4ceb   10 years philipp Now the dayChange time is taken into account. This fixes #43. qt5
(edit) @83481c6   10 years gregoa bump copyright years qt5
(edit) @908b4ce   10 years philipp Changed int to string converstion method because the old method gave … qt5
(edit) @f1826af   10 years philipp Schmema update completed. Finally closing ticket #45. qt5
(edit) @e2c612c   10 years philipp Reloading a conference works now. qt5
(edit) @5e50875   10 years philipp Fixed: Forgot to call query.exec() at several places. qt5
(edit) @5293ef0   10 years gregoa Remove unsed (and removed from db) 'days' column fro xml parser and … qt5
(edit) @0ba2b59   10 years gregoa Don't insert empty string into picture column. (NOT NULL constraint … qt5
(edit) @7e45288   10 years gregoa Remove empty-city-hack. (NOT NULL removed from db schema.) qt5
(edit) @a8f8b5d   11 years gregoa One version for creating the directory is enough :) (Now tested on … qt5
(edit) @9b5a80ff   11 years philipp Added a second possibility to create the directory and removed the TODO. qt5
(edit) @1f12b6b   11 years gregoa fix .mkpath() Creating the "." path works. Is this idiomatic? At … qt5
(edit) @61346c9   11 years philipp Restructured the SqlEngine?. Not yet finished (see "TODO" in the code). qt5
(edit) @8d6798d   11 years gregoa fix some more header includes qt5
(edit) @253ad0e   11 years gregoa fix typo in comment qt5
(edit) @2dffed3   11 years philipp On the way to fix #45. qt5
(edit) @4147e08   11 years gregoa Add Stefan as a copyright holder to source files, too. qt5
(edit) @d466553   11 years gregoa More output on errors. qt5
(edit) @8bc87d6   11 years gregoa Update copyright years. qt5
(edit) @71c3eb6   11 years philipp Fixed by gregoa: Searching for titles where the events had no person … qt5
(edit) @3655d06   12 years stef Fixed ticket #20 qt5
(edit) @a9f56bb   12 years gregoa .isEmpty() feels more Qtish then == "" qt5
(edit) @2dcbb2c   12 years gregoa Quick fix for ticket: #32: if the schedule XML doesn't contain a city, … qt5
(edit) @09a5663   12 years gregoa emit the parsingScheduleBegin() signal earlier, so we get the … qt5
(edit) @1dbb3bb   12 years gregoa Remove conference/room records unconditionally from EVENT_ROOMS qt5
(edit) @274f6dc   12 years gregoa SqlEngine::addRoomToDB: remove event/conference combinations from … qt5
(edit) @118b982   12 years gregoa Reorganize CLEAN and DISTCLEAN targets. qt5
(edit) @525e2e2   12 years philipp This commit closes ticket #12. The search terms are ANDed now and a … qt5
(edit) @53effcb   12 years philipp Fixed bug (related to ticket #12): Only the last search term is used. qt5
(edit) @e388cda   12 years philipp Undid changes to sqlengine.cpp I committed accidentally in r1318. qt5
(edit) @47eda2b   12 years gregoa Split search keyword string on whitespace. qt5
(edit) @66698a6   12 years gregoa Avoid duplicate search results by using SELECT DISTINCT when filling … qt5
(edit) @e6ab8a2   12 years philipp Removed the ability to show "pictures" (maps) of rooms and maps of … qt5
(edit) @cf385cd   12 years philipp Removed many of the qDebug() output lines (see ticket #10). qt5
(edit) @f48bf9f   12 years philipp The '%' character doesn't have to be escaped anymore. qt5
(edit) @df884b3   12 years gregoa Somewhere a slash was missing … qt5
(edit) @babe4cd   12 years gregoa Remove ULB, Campus Solbosch maps. qt5
(edit) @9f97eaf   12 years gregoa Move config and sqlite database. They are both at the xdg-specified … qt5
(edit) @dcefa71   12 years philipp Prevented SQL injections in function addPersonToDB. qt5
(edit) @68b2df2   12 years gregoa Add copyright to source. qt5
(edit) @6df32f2   12 years gregoa Update GPL blurb in source files. qt5
(edit) @dc54e87   12 years philipp Prevented SQL injection in function addLinkToDB. qt5
(edit) @a55781e   12 years philipp Fixed SQL error in searchEvent when no table was selected. Prevented … qt5
(edit) @f09a1b9   12 years philipp Fixed a bug I introduced when reparing the addRoomToDB function. qt5
(edit) @141a5c2   12 years philipp Tracks are inserted now when importing new conferences. qt5
(edit) @909ea23   12 years philipp void possible SQL injection in function addRoomToDB. qt5
(edit) @4b8ce66   12 years philipp The database is now created from the program. We don't need to copy or … qt5
(edit) @c8b84e1   12 years philipp Persons are deleted now when a conference is removed. qt5
(edit) @63b2343   12 years philipp Rooms are inserted now for additionally imported conferences. qt5
(edit) @f657e9c   12 years philipp Changed UNIQUE statements in the database table definition so that … qt5
(edit) @51529bd   12 years gregoa Insert new field xid_conference into table track, room and person. qt5
(edit) @58eb7cc   13 years kirilma store room map in database show it if it's available, otherwise show … qt5
(edit) @cec47c6   13 years kirilma store path to conference map in database path stored as additional … qt5
(edit) @f299a08   13 years kirilma remove obsoleted code also fix some types qt5
(edit) @b431d47   13 years kirilma reworked UI for conference editing underlying representation of … qt5
(edit) @a61c5f5   13 years kirilma CC: fix endlines qt5
(edit) @3329d39   13 years kirilma use visible notifications of errors also early detect parsing errors qt5
(edit) @d97bcab   13 years kirilma implement deleting a conference pass event about it to mainwindow to … qt5
(edit) @d06ae27   13 years kirilma store URL's for conferences * use it at update * let user update the … qt5
(edit) @be9b645   13 years kirilma remove unused code qt5
(edit) @c129da26   13 years kirilma fix event insert or update * add error reporting for queries * … qt5
(edit) @f548c17   13 years kirilma use update for events when they are already exists also use only … qt5
(edit) @1bad318   13 years kirilma use transactions to make import faster qt5
(edit) @5d9409d   13 years timkoma UTC/LocalTime fix for import conference XML, DB queries for multiple … qt5
(edit) @7270ae0   13 years timkoma fix for import - ON CONFLICT REPLACE qt5
(edit) @ca90cb1   13 years uzakmat A header with the proper copyright/lincence statement was added into … qt5
(edit) @b4e9936   13 years pavelpa changed permissions for the db - TODO: check it on the device qt5
(edit) @979e5be   13 years pavelpa created resource which contains parsed schedule, so the user doesn't … qt5
(edit) @bcf67d6   13 years pavelpa search fixed - only the dates (range) which contain at least one … qt5
(edit) @412cef6   13 years pavelpa some 'delegate' drawing optimizations - removed EVENT_CONFLICT table … qt5
(edit) @0bb39f5   13 years pavelpa removed appsettings - created 'active' column in 'conference' table qt5
(edit) @9f367eb   13 years pavelpa 'conflicts' modifications - preparing for the dialog showing also … qt5
(edit) @3a8dc71   13 years pavelpa SqlEngine? made STATIC qt5
(edit) @05afe5f   13 years pavelpa implemented 'tab container' widget, which groups daynavigator with … qt5
(edit) @89ff5f2   13 years timkoma unique constraints added into sql qt5
(edit) @c15be10   13 years pavelpa import schedule dialog - changed to widget - moved to 'conference' tab qt5
(edit) @c7b58d4   13 years timkoma search upgrade qt5
(edit) @0d4ecc2   13 years timkoma search update qt5
(edit) @005e2b7   13 years korrco caching removed qt5
(edit) @d336730   13 years pavelpa modifications to import-schedule dialog - closed automatically after … qt5
(edit) @1735f55   13 years pavelpa check for existence of conference before inserting it into DB qt5
(edit) @30e2bdf   13 years pavelpa added 'Conference' tab - to list conference details - implemented … qt5
(edit) @e493054   13 years pavelpa import/search schedule dialog implemented qt5
(edit) @9d8946b   13 years timkoma update for the search qt5
(edit) @7d7659d   13 years pavelpa combined EVENT and VIRTUAL_EVENT => 'EVENT' now - Maemo sqlite … qt5
(edit) @72cd3af   13 years korrco activities tab implemented qt5
(edit) @e662750   13 years timkoma first working version of the search qt5
(edit) @4693fa6   13 years pavelpa changed 'Activity' -> 'Track' qt5
(edit) @926f106   13 years pavelpa parsing activity from xml - 'track' from xml schedule is treated as … qt5
(edit) @990afd5   13 years timkoma temp commit for search tab qt5
(edit) @cfd615d   13 years pavelpa work on alarm qt5
(edit) @b6cd05c   13 years pavelpa added 'alarm' columnt to the 'EVENT' table to signalize that the event … qt5
(edit) @151983f   13 years hanzes fixed sqlite statement qt5
(edit) @84b9c07   13 years pavelpa used 'MAEMO' define to create 'non-virtual' 'VIRUAL_EVENT' table … qt5
(edit) @27102d5   13 years fortefr Temporal virtual_event change qt5
(edit) @680a4da   13 years pavelpa work on favourite - created 'favourite' column in EVENT table - … qt5
(edit) @6a624f7   13 years pavelpa minor fix qt5
(edit) @69393c0   13 years pavelpa implemented 'conference' record for accessing info about the … qt5
(add) @72f6fe4   13 years pavelpa implemented xml parser - parsing Schedule qt5
Note: See TracRevisionLog for help on using the revision log.