1 # Copyright 2011 GRNET S.A. All rights reserved.
3 # Redistribution and use in source and binary forms, with or
4 # without modification, are permitted provided that the following
7 # 1. Redistributions of source code must retain the above
8 # copyright notice, this list of conditions and the following
11 # 2. Redistributions in binary form must reproduce the above
12 # copyright notice, this list of conditions and the following
13 # disclaimer in the documentation and/or other materials
14 # provided with the distribution.
16 # THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS
17 # OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
18 # WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
19 # PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL GRNET S.A OR
20 # CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
21 # SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
22 # LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
23 # USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
24 # AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
25 # LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
26 # ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
27 # POSSIBILITY OF SUCH DAMAGE.
29 # The views and conclusions contained in the software and
30 # documentation are those of the authors and should not be
31 # interpreted as representing official policies, either expressed
32 # or implied, of GRNET S.A.
34 from sqlalchemy import Table, Column, String, MetaData
35 from sqlalchemy.sql import select
36 from dbworker import DBWorker
39 class Policy(DBWorker):
40 """Paths can be assigned key, value pairs, representing policy."""
42 def __init__(self, **params):
43 DBWorker.__init__(self, **params)
46 #columns.append(Column('path', String(2048), primary_key=True))
47 columns.append(Column('path', String(255), primary_key=True))
48 columns.append(Column('key', String(255), primary_key=True))
49 columns.append(Column('value', String(255)))
50 self.policies = Table('policy', metadata, *columns)
51 metadata.create_all(self.engine)
52 metadata.bind = self.engine
54 def policy_set(self, path, policy):
55 s = self.policies.insert()
56 values = [{'path':path, 'key':k, 'value':v} for k,v in policy.iteritems()]
57 r = self.conn.execute(s, values)
60 def policy_unset(self, path):
61 s = self.policies.delete().where(self.policies.c.path==path)
62 r = self.conn.execute(s)
65 def policy_get(self, path):
66 s = select([self.policies.c.key, self.policies.c.value],
67 self.policies.c.path==self.policies.c.path==path)
68 r = self.conn.execute(s)
69 d = dict(r.fetchall())