1 # Copyright 2011-2012 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 dbworker import DBWorker
37 class Public(DBWorker):
38 """Paths can be marked as public."""
40 def __init__(self, **params):
41 DBWorker.__init__(self, **params)
42 execute = self.execute
44 execute(""" create table if not exists public
45 ( public_id integer primary key autoincrement,
47 active boolean not null default 1 ) """)
48 execute(""" create unique index if not exists idx_public_path
51 def public_set(self, path):
52 q = "insert or ignore into public (path) values (?)"
53 self.execute(q, (path,))
54 q = "update public set active = 1 where path = ?"
55 self.execute(q, (path,))
57 def public_unset(self, path):
58 q = "update public set active = 0 where path = ?"
59 self.execute(q, (path,))
61 def public_get(self, path):
62 q = "select public_id from public where path = ? and active = 1"
63 self.execute(q, (path,))
69 def public_list(self, prefix):
70 q = "select path, public_id from public where path like ? escape '\\' and active = 1"
71 self.execute(q, (self.escape_like(prefix) + '%',))
72 return self.fetchall()
74 def public_path(self, public):
75 q = "select path from public where public_id = ? and active = 1"
76 self.execute(q, (public,))