Skip to content

Instantly share code, notes, and snippets.

Created January 30, 2014 09:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/8705382 to your computer and use it in GitHub Desktop.
Save anonymous/8705382 to your computer and use it in GitHub Desktop.
/home/romster/version-sort-initalise-db.py
from sqlalchemy import *
db = create_engine('sqlite:///tmp/version-sort.db')
db.echo = False
metadata = BoundMetaData(db)
files = Table('files', metadata,
Column('url_id', Integer, primary_key=True),
Column('file', String(40)),
Column('version', Integer),
)
files.create()
urls = Table('urls', metadata,
Column('url_id', Integer, primary_key=True),
Column('url', String(100)),
)
urls.create()
i = files.insert()
i.execute({'file': 'galculator-2.1.2.tar.bz2', 'version' :'2.1.2'},
'file': 'galculator-2.1.tar.bz2', 'version': '2.1'},
'file': 'galculator-1.3.4.tar.bz2', 'version': '1.3.4'},
'file': 'galculator-1.3.1.tar.bz2', 'version': '1.3.1'},
'file': 'galculator-1.2.5.2.tar.bz2', 'version': '1.2.5.2'})
s = files.select()
rs = s.execute()
row = rs.fetchone()
print 'File:', row['file']
print 'Version:', row['version']
for row in rs:
print 'File:', row.file, 'Version:', row.version,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment