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
45 class Migration(object):
46 def __init__(self, db):
47 self.engine = create_engine(db)
48 self.metadata = MetaData(self.engine)
49 #self.engine.echo = True
50 self.conn = self.engine.connect()
52 options = getattr(settings, 'BACKEND', None)[1]
53 self.backend = ModularBackend(*options)
60 def __init__(self, db):
61 self.engine = create_engine(db)
62 metadata = MetaData(self.engine)
65 columns.append(Column('path', String(2048), primary_key=True))
66 columns.append(Column('hash', String(255)))
67 self.files = Table('files', metadata, *columns)
68 self.conn = self.engine.connect()
69 self.engine.echo = True
70 metadata.create_all(self.engine)
72 def put(self, path, hash):
74 s = self.files.delete().where(self.files.c.path == path)
75 r = self.conn.execute(s)
77 s = self.files.insert()
78 r = self.conn.execute(s, {'path': path, 'hash': hash})
82 s = select([self.files.c.hash], self.files.c.path == path)
83 r = self.conn.execute(s)