1 #!/usr/bin/env python 2 3 """ 4 A PostgreSQL database store of calendar data. 5 6 Copyright (C) 2016 Paul Boddie <paul@boddie.org.uk> 7 8 This program is free software; you can redistribute it and/or modify it under 9 the terms of the GNU General Public License as published by the Free Software 10 Foundation; either version 3 of the License, or (at your option) any later 11 version. 12 13 This program is distributed in the hope that it will be useful, but WITHOUT 14 ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 15 FOR A PARTICULAR PURPOSE. See the GNU General Public License for more 16 details. 17 18 You should have received a copy of the GNU General Public License along with 19 this program. If not, see <http://www.gnu.org/licenses/>. 20 """ 21 22 from imiptools.stores.database.common import DatabaseStore, DatabaseJournal 23 import psycopg2 24 25 class Store(DatabaseStore): 26 27 "A PostgreSQL database store of calendar objects and free/busy data." 28 29 def __init__(self, store_dir): 30 31 "Interpret 'store_dir' as a connection string." 32 33 connection = psycopg2.connect(store_dir) 34 connection.autocommit = True 35 DatabaseStore.__init__(self, connection, psycopg2.paramstyle) 36 37 def acquire_lock(self, user, timeout=None): 38 query = "select pg_advisory_lock(20160311)" 39 self.cursor.execute(query) 40 41 def release_lock(self, user): 42 query = "select pg_advisory_unlock(20160311)" 43 self.cursor.execute(query) 44 45 class Journal(DatabaseJournal): 46 47 "A PostgreSQL journal system supporting quotas." 48 49 def __init__(self, store_dir): 50 51 "Interpret 'store_dir' as a connection string." 52 53 connection = psycopg2.connect(store_dir) 54 connection.autocommit = True 55 DatabaseJournal.__init__(self, connection, psycopg2.paramstyle) 56 57 def acquire_lock(self, user, timeout=None): 58 query = "select pg_advisory_lock(20160312)" 59 self.cursor.execute(query) 60 61 def release_lock(self, user): 62 query = "select pg_advisory_unlock(20160312)" 63 self.cursor.execute(query) 64 65 # vim: tabstop=4 expandtab shiftwidth=4