Mercurial > molko
changeset 173:cd69c8791dac
core: forgot to add .sql files
| author | David Demelier <markand@malikania.fr> |
|---|---|
| date | Wed, 21 Oct 2020 12:50:11 +0200 |
| parents | 6250883b81f0 |
| children | 6992085d47fd |
| files | libcore/core/assets/sql/init.sql libcore/core/assets/sql/property-get.sql libcore/core/assets/sql/property-remove.sql libcore/core/assets/sql/property-set.sql |
| diffstat | 4 files changed, 98 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/libcore/core/assets/sql/init.sql Wed Oct 21 12:50:11 2020 +0200 @@ -0,0 +1,30 @@ +-- +-- init.sql -- initialize database +-- +-- Copyright (c) 2020 David Demelier <markand@malikania.fr> +-- +-- Permission to use, copy, modify, and/or distribute this software for any +-- purpose with or without fee is hereby granted, provided that the above +-- copyright notice and this permission notice appear in all copies. +-- +-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES +-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF +-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR +-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES +-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN +-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF +-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. +-- + +BEGIN EXCLUSIVE TRANSACTION; + +CREATE TABLE IF NOT EXISTS property( + id INTEGER PRIMARY KEY AUTOINCREMENT, + key TEXT NOT NULL UNIQUE, + value TEXT NOT NULL +); + +INSERT OR IGNORE INTO property(key, value) VALUES ('molko.create-date', strftime('%s','now')); +INSERT OR IGNORE INTO property(key, value) VALUES ('molko.update-date', strftime('%s','now')); + +COMMIT;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/libcore/core/assets/sql/property-get.sql Wed Oct 21 12:50:11 2020 +0200 @@ -0,0 +1,21 @@ +-- +-- property-get.sql -- get a property +-- +-- Copyright (c) 2020 David Demelier <markand@malikania.fr> +-- +-- Permission to use, copy, modify, and/or distribute this software for any +-- purpose with or without fee is hereby granted, provided that the above +-- copyright notice and this permission notice appear in all copies. +-- +-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES +-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF +-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR +-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES +-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN +-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF +-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. +-- + +SELECT value + FROM property + WHERE key = ?
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/libcore/core/assets/sql/property-remove.sql Wed Oct 21 12:50:11 2020 +0200 @@ -0,0 +1,21 @@ +-- +-- property-remove.sql -- remove a property +-- +-- Copyright (c) 2020 David Demelier <markand@malikania.fr> +-- +-- Permission to use, copy, modify, and/or distribute this software for any +-- purpose with or without fee is hereby granted, provided that the above +-- copyright notice and this permission notice appear in all copies. +-- +-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES +-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF +-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR +-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES +-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN +-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF +-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. +-- + +DELETE + FROM property + WHERE key = ?
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/libcore/core/assets/sql/property-set.sql Wed Oct 21 12:50:11 2020 +0200 @@ -0,0 +1,26 @@ +-- +-- property-set.sql -- set a property +-- +-- Copyright (c) 2020 David Demelier <markand@malikania.fr> +-- +-- Permission to use, copy, modify, and/or distribute this software for any +-- purpose with or without fee is hereby granted, provided that the above +-- copyright notice and this permission notice appear in all copies. +-- +-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES +-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF +-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR +-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES +-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN +-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF +-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. +-- + +INSERT OR REPLACE INTO property( + key, + value +) +VALUES( + ?, + ? +)