Mercurial > hg > orthanc
view OrthancServer/Sources/Database/InstallTrackAttachmentsSize.sql @ 4571:9224e107d613 db-changes
simplifying IDatabaseListener::SignalChange() as IDatabaseListener::SignalResourceDeleted()
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Mon, 08 Mar 2021 16:49:34 +0100 |
parents | d9473bd5ed43 |
children | f0038043fb97 7053502fbf97 |
line wrap: on
line source
-- Orthanc - A Lightweight, RESTful DICOM Store -- Copyright (C) 2012-2016 Sebastien Jodogne, Medical Physics -- Department, University Hospital of Liege, Belgium -- Copyright (C) 2017-2021 Osimis S.A., Belgium -- -- This program is free software: you can redistribute it and/or -- modify it under the terms of the GNU General Public License as -- published by the Free Software Foundation, either version 3 of the -- License, or (at your option) any later version. -- -- In addition, as a special exception, the copyright holders of this -- program give permission to link the code of its release with the -- OpenSSL project's "OpenSSL" library (or with modified versions of it -- that use the same license as the "OpenSSL" library), and distribute -- the linked executables. You must obey the GNU General Public License -- in all respects for all of the code used other than "OpenSSL". If you -- modify file(s) with this exception, you may extend this exception to -- your version of the file(s), but you are not obligated to do so. If -- you do not wish to do so, delete this exception statement from your -- version. If you delete this exception statement from all source files -- in the program, then also delete it here. -- -- This program is distributed in the hope that it will be useful, but -- WITHOUT ANY WARRANTY; without even the implied warranty of -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU -- General Public License for more details. -- -- You should have received a copy of the GNU General Public License -- along with this program. If not, see <http://www.gnu.org/licenses/>. CREATE TABLE GlobalIntegers( key INTEGER PRIMARY KEY, value INTEGER); INSERT INTO GlobalProperties VALUES (6, 1); -- GlobalProperty_GetTotalSizeIsFast INSERT INTO GlobalIntegers SELECT 0, IFNULL(SUM(compressedSize), 0) FROM AttachedFiles; INSERT INTO GlobalIntegers SELECT 1, IFNULL(SUM(uncompressedSize), 0) FROM AttachedFiles; CREATE TRIGGER AttachedFileIncrementSize AFTER INSERT ON AttachedFiles BEGIN UPDATE GlobalIntegers SET value = value + new.compressedSize WHERE key = 0; UPDATE GlobalIntegers SET value = value + new.uncompressedSize WHERE key = 1; END; CREATE TRIGGER AttachedFileDecrementSize AFTER DELETE ON AttachedFiles BEGIN UPDATE GlobalIntegers SET value = value - old.compressedSize WHERE key = 0; UPDATE GlobalIntegers SET value = value - old.uncompressedSize WHERE key = 1; END;