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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
from elixir import *
from elixir.ext.versioned import acts_as_versioned
from datetime import datetime, timedelta
import time
nextOneValue = 0
def nextOne():
global nextOneValue
nextOneValue += 2
return nextOneValue
def setup():
global Director, Movie, Actor
class Director(Entity):
name = Field(String(60))
movies = OneToMany('Movie', inverse='director')
using_options(tablename='directors')
class Movie(Entity):
id = Field(Integer, primary_key=True)
title = Field(String(60), primary_key=True)
description = Field(String(512))
releasedate = Field(DateTime)
ignoreme = Field(Integer, default=0)
autoupd = Field(Integer, default=nextOne, onupdate=nextOne)
director = ManyToOne('Director', inverse='movies')
actors = ManyToMany('Actor', inverse='movies',
tablename='movie_casting')
using_options(tablename='movies')
acts_as_versioned(ignore=['ignoreme', 'autoupd'])
class Actor(Entity):
name = Field(String(60))
movies = ManyToMany('Movie', inverse='actors',
tablename='movie_casting')
using_options(tablename='actors')
setup_all()
metadata.bind = 'sqlite:///'
def teardown():
cleanup_all()
class TestVersioning(object):
def setup(self):
create_all()
def teardown(self):
drop_all()
session.close()
def test_versioning(self):
gilliam = Director(name='Terry Gilliam')
monkeys = Movie(id=1, title='12 Monkeys',
description='draft description', director=gilliam)
bruce = Actor(name='Bruce Willis', movies=[monkeys])
session.commit(); session.clear()
time.sleep(1)
after_create = datetime.now()
time.sleep(1)
movie = Movie.get_by(title='12 Monkeys')
assert movie.version == 1
assert movie.title == '12 Monkeys'
assert movie.director.name == 'Terry Gilliam'
assert movie.autoupd == 2, movie.autoupd
movie.description = 'description two'
session.commit(); session.clear()
time.sleep(1)
after_update_one = datetime.now()
time.sleep(1)
movie = Movie.get_by(title='12 Monkeys')
movie.description = 'description three'
session.commit(); session.clear()
# Edit the ignored field, this shouldn't change the version
monkeys = Movie.get_by(title='12 Monkeys')
monkeys.ignoreme = 1
session.commit(); session.clear()
time.sleep(1)
after_update_two = datetime.now()
time.sleep(1)
movie = Movie.get_by(title='12 Monkeys')
assert movie.autoupd == 8, movie.autoupd
oldest_version = movie.get_as_of(after_create)
middle_version = movie.get_as_of(after_update_one)
latest_version = movie.get_as_of(after_update_two)
initial_timestamp = oldest_version.timestamp
assert oldest_version.version == 1
assert oldest_version.description == 'draft description'
assert oldest_version.ignoreme == 0
assert oldest_version.autoupd is not None
assert oldest_version.autoupd > 0
assert middle_version.version == 2
assert middle_version.description == 'description two'
assert middle_version.autoupd > oldest_version.autoupd
assert latest_version.version == 3, \
'version=%i' % latest_version.version
assert latest_version.description == 'description three'
assert latest_version.ignoreme == 1
assert latest_version.autoupd > middle_version.autoupd
differences = latest_version.compare_with(oldest_version)
assert differences['description'] == \
('description three', 'draft description')
assert len(movie.versions) == 3
assert movie.versions[0] == oldest_version
assert movie.versions[1] == middle_version
assert [v.version for v in movie.versions] == [1, 2, 3]
movie.description = 'description four'
movie.revert_to(2)
session.commit(); session.clear()
movie = Movie.get_by(title='12 Monkeys')
assert movie.version == 2, "version=%i, should be 2" % movie.version
assert movie.description == 'description two', movie.description
movie.description = "description 3"
session.commit(); session.clear()
movie = Movie.get_by(title='12 Monkeys')
movie.description = "description 4"
session.commit(); session.clear()
movie = Movie.get_by(title='12 Monkeys')
assert movie.version == 4
movie.revert_to(movie.versions[-2])
movie.description = "description 5"
session.commit(); session.clear()
movie = Movie.get_by(title='12 Monkeys')
assert movie.version == 4
assert movie.versions[-2].description == "description 3"
|
