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
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
import os
import tempfile
import atexit
import shutil
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Table, Column, ForeignKey
from sqlalchemy.types import *
from sqlalchemy.orm import relation, backref
from sqlkit.db.utils import Descr
from sqlkit.db import proxy
Base = declarative_base()
DB_DIR = tempfile.mkdtemp()
DB_FILE = os.path.join(DB_DIR, 'db-%s.sqlite' % os.environ.get('USERNAME'))
engine = "sqlite:///%s" % DB_FILE
db = proxy.DbProxy(engine=engine, metadata=Base.metadata)
movie_casting = Table(
'movie_casting' , Base.metadata,
Column('movie_id', Integer, ForeignKey('movie.id'), primary_key=True),
Column('actor_id', Integer, ForeignKey('actor.id'), primary_key=True),
)
movie_genre = Table(
'movie_genre' , Base.metadata,
Column('movie_id', Integer, ForeignKey('movie.id'), primary_key=True),
Column('genre_name', Integer, ForeignKey('genre.name'), primary_key=True),
)
SCORE_VALUES = (
(1, 'Nice'),
(2, 'Beautifull'),
(3, 'Great'),
)
class Director(Base):
__tablename__ = 'director'
id = Column(Integer, primary_key=True)
last_name = Column(String(60), nullable=False)
first_name = Column(String(60), nullable=False)
nation = Column(String(6))
movies = relation('Movie', backref='director', cascade='all, delete-orphan',)
def __str__(self):
return u'%s (%s)' % (self.last_name, self.nation)
def __repr__(self):
return u'<Director: %s (%s)>' % (self.last_name, self.nation)
class Movie(Base):
__tablename__ = 'movie'
id = Column(Integer, primary_key=True)
title = Column(String(60), nullable=False)
image = Column(String(250), info={'render' : 'image',
'base_dir' : './images',
'thumbnail_size' : (30,30)})
description = Column(String(512))
year = Column(Integer())
date_release = Column(Date())
director_id = Column(Integer, ForeignKey('director.id'), nullable=False,
info={'attach_instance': 'director'})
score = Column(Integer, info={'render' :'enum',
'values' : SCORE_VALUES})
actors = relation('Actor', backref='movies', secondary=movie_casting)
genres = relation('Genre', backref='movies', secondary=movie_genre)
def __str__(self):
return u'%s' % self.title
def __repr__(self):
return u'<Movie: %s>' % self.title
class Genre(Base):
__tablename__ = 'genre'
name = Column(Unicode(55, assert_unicode=False), primary_key=True)
def __repr__(self):
return u'<Genre "%s">' % self.name
class Actor(Base):
__tablename__ = 'actor'
id = Column(Integer, primary_key=True)
first_name = Column(String(60), nullable=False)
last_name = Column(String(60))
nation_cod = Column(String(4), ForeignKey('nation.cod'))
nation = relation('Nation', backref='actors')
def __repr__(self):
return u'<Actor %s %s>' % (self.first_name, self.last_name)
class Nation(Base):
__tablename__ = 'nation'
cod = Column(String(4), primary_key=True)
nation = Column(String(20))
class AllTypes(Base):
__tablename__ = 'all_types'
id = Column(Integer(), primary_key=True)
varchar10 = Column(String(10), nullable=False)
varchar200 = Column(String(200))
text = Column(Text())
uni = Column(Unicode(10, assert_unicode=False))
uni_text = Column(UnicodeText(assert_unicode=False), nullable=False)
date = Column(Date())
datetime = Column(DateTime(timezone=False))
datetime_tz = Column(DateTime(timezone=True))
interval = Column(Interval())
time = Column(Time(timezone=False))
time_tz = Column(Time(timezone=True))
integer = Column(Integer())
float = Column(Float())
numeric = Column(Numeric(8,2))
bool = Column(Boolean, nullable=False)
bool_null = Column(Boolean, nullable=True)
# pickle = Column(PickleType())
def rm_tmpdir():
shutil.rmtree( DB_DIR )
atexit.register( rm_tmpdir )
|
