1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
## DISCLAIMER: this file is not normally maintained
import os
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Table, Column, String, Date, Integer, Float, \
Boolean, Numeric, ForeignKey, Unicode
from sqlalchemy.orm import relation
from sqlkit.db.utils import Descr
from sqlkit.db import proxy
from model import engine
Base = declarative_base()
db = proxy.DbProxy(engine=engine, metadata=Base.metadata)
movie_casting = Table('movie_casting' , Base.metadata, autoload=True)
movie_genre = Table('movie_genre' , Base.metadata, autoload=True )
class Director(Base):
__table__ = Table('director', Base.metadata, autoload=True)
def __repr__(self):
return u'<Director: %s (%s)>' % (self.last_name, self.nation)
class Movie(Base):
__table__ = Table('movie', Base.metadata, autoload=True)
director = relation('Director', backref='movies')
genres = relation('Genre', backref='movies', secondary=movie_genre)
actors = relation('Actor', backref='movies', secondary=movie_casting)
def __repr__(self):
return u'<Movie: %s>' % self.title
class Genre(Base):
__table__ = Table('genre', Base.metadata, autoload=True)
# name = Column(Unicode(15), primary_key=True)
def __repr__(self):
return u'<Genre "%s">' % self.name
class Actor(Base):
__table__ = Table('actor', Base.metadata, autoload=True)
def __repr__(self):
return u'<Actor "%s">' % self.last_name
class Nation(Base):
__table__ = Table('nation', Base.metadata, autoload=True)
# cod = Column(String(4), primary_key=True)
# nation = Column(String(20))
class AllTypes(Base):
__table = Table('all_types', Base.metadata, autoload=True)
|
