1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
import sqlalchemy
metadata = sqlalchemy.MetaData()
package = sqlalchemy.Table("package", metadata,
sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column('name', sqlalchemy.Text, unique=True),
sqlalchemy.Column('version', sqlalchemy.Text),
sqlalchemy.Column('architecture', sqlalchemy.Text),
sqlalchemy.Column('source', sqlalchemy.Text))
content = sqlalchemy.Table("content", metadata,
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
sqlalchemy.Column("pid", None, sqlalchemy.ForeignKey("package.id")),
sqlalchemy.Column("filename", sqlalchemy.Text),
sqlalchemy.Column("size", sqlalchemy.Integer))
|
