forked from hit9/skylark
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CHANGES
164 lines (102 loc) · 3.28 KB
/
CHANGES
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
153
154
155
156
157
158
159
160
161
162
163
164
version 0.9.0 (**not backward compatiable**)
--------------------------------------------
Add:
- Support for field/function/sql on the right side of an expression
- Support for custom operator (like bitwise operators)
- Support for sqlite3.
- Ability to set DBAPI.
- Transaction
- join methods: `User.join(Post)`, ..
- method `Database.set_autocommit`
Non-compatiable Changes:
- select-result.one()/all() return only instances of models
- fetch function/expression result from selectresult by method tuples()
- remove method dicts() from select-result
version 0.7.1
--------------
- Close cursor on each execution
- Close connection on Database deled
version 0.7.0
-------------
- Rename `curd.py` to `skylark`
version 0.6.0
-------------
- Prefer to use the C DBAPI(MySQLdb), then PyMySQL
- Support for Python3.x (>=3.3)
version 0.5.0 (**not backward compatiable**)
--------------------------------------------
- Fix bug: issue#12, select statement with where syntax without priority
- SelectResult: `findall()` => `all()`, `findone()` => `one()`
- SelectResults: add `tuples()`, `dicts()`
- Removed `distinct()`, add keyword `distinct` (implemented as a type)
- Retrieving data way: inst; inst, func; func
- Add class `sql`, to declare a literal sql
- Lots of minor bugs fixed.
version 0.4.1
-------------
- fix bug: issue#9, active connection wasn't closed when database configs was updated
- table_name: add ability to define custom table_name; default table_name: User=>'user', CuteCat=>'cute_cat'
version 0.4.0
-------------
No changes in API.
- fix, improve docstrings, document, readme..
version 0.3.6
-------------
Added:
- support for ``group by``
- support for ``having``
- support for keyword ``distinct``
version 0.3.5
-------------
No changes in API.
- use tuple format of MySQLdb return result instead of dict
- some typofixed
version 0.3.4
-------------
**not backward compatiable changes:**
Reomved:
- Removed method ``select_without_primarykey``
Changes:
- method ``select`` now won't select primarykeys automatically
- subquery parsing result now was wrapped with ``()``
version 0.3.3
--------------
Types supporting:
- string, unicode
- numbers: float, int, long
- datetime: datetime, date, time, timedelta
- bool
- Nonetype
- sequence: list, tuple
- dict
version 0.3.2
-------------
Added:
- support for datetime
sample::
>>> Post.at(1).update(update_at=datetime.now())
<UpdateQuery "update post set post.update_at = '2013-11-21 16:45:57' where post.post_id = 1">
version 0.3.1
-------------
Added:
- Ability to use SQL functions
Supported SQL functions: `count`, `sum`, `max`, `min`, `lcase`, `ucase`
version 0.3.0 (**not backward compatiable**)
--------------------------------------------
- A lot of features are changed.
version 0.2.5 (**not backward compatiable**)
--------------------------------------------
Removed:
- `Database.debug`
- `Database.SQL`
- `Database.query_times`
Changes:
- `Database.execute()` now return `rows_affected`, not `rows_matched`
- `model.save()` now return `0` for 'data not changed'
- `select_result.count` return long int now, no `cast to int`
Added:
- Exceptions: `UnSupportedType`, `ForeignKeyNotFound`
version 0.2.2
-------------
- fix: unicode supporting in process parsing expr string
- fix: remove "avoid primary in set"