3 # Copyright 2011-2012 GRNET S.A. All rights reserved.
5 # Redistribution and use in source and binary forms, with or
6 # without modification, are permitted provided that the following
9 # 1. Redistributions of source code must retain the above
10 # copyright notice, this list of conditions and the following
13 # 2. Redistributions in binary form must reproduce the above
14 # copyright notice, this list of conditions and the following
15 # disclaimer in the documentation and/or other materials
16 # provided with the distribution.
18 # THIS SOFTWARE IS PROVIDED BY GRNET S.A. ``AS IS'' AND ANY EXPRESS
19 # OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
20 # WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
21 # PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL GRNET S.A OR
22 # CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
23 # SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
24 # LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
25 # USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
26 # AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
27 # LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
28 # ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
29 # POSSIBILITY OF SUCH DAMAGE.
31 # The views and conclusions contained in the software and
32 # documentation are those of the authors and should not be
33 # interpreted as representing official policies, either expressed
34 # or implied, of GRNET S.A.
36 from sqlalchemy import create_engine
37 from sqlalchemy import Table, Column, String, MetaData
38 from sqlalchemy.sql import select
40 from django.conf import settings
42 from pithos.backends.modular import ModularBackend
44 class Migration(object):
45 def __init__(self, db):
46 self.engine = create_engine(db)
47 self.metadata = MetaData(self.engine)
48 #self.engine.echo = True
49 self.conn = self.engine.connect()
51 options = getattr(settings, 'BACKEND', None)[1]
52 self.backend = ModularBackend(*options)
58 def __init__(self, db):
59 self.engine = create_engine(db)
60 metadata = MetaData(self.engine)
63 columns.append(Column('path', String(2048), primary_key=True))
64 columns.append(Column('hash', String(255)))
65 self.files = Table('files', metadata, *columns)
66 self.conn = self.engine.connect()
67 self.engine.echo = True
68 metadata.create_all(self.engine)
70 def put(self, path, hash):
72 s = self.files.delete().where(self.files.c.path==path)
73 r = self.conn.execute(s)
75 s = self.files.insert()
76 r = self.conn.execute(s, {'path': path, 'hash': hash})
80 s = select([self.files.c.hash], self.files.c.path == path)
81 r = self.conn.execute(s)