root/livinglogic.python.orasql/NEWS.rst @ 238:3f1cc30e13f5

Revision 238:3f1cc30e13f5, 15.7 KB (checked in by Walter Doerwald <walter@…>, 12 years ago)

Fix typo.

Line 
1Changes in 1.21 (released 03/13/2008)
2-------------------------------------
3
4*   :class:`Connection` has a new method :meth:`getobject`, which returns the
5    schema object with a specified name.
6
7*   :class:`Synonym` has a new method :meth:`getobject`, that returns the object
8    for which the :class:`Synonym` object is a synonym.
9
10*   The name of :class:`Procedure` and :class:`Function` objects now is case
11    sensitive when calling the procedure or function.
12
13
14
15Changes in 1.20 (released 02/07/2008)
16-------------------------------------
17
18*   The fancy fetch methods have been renamed to :meth:`xfetchone`,
19    :meth:`xfetchmany`, :meth:`xfetchall` and :meth:`xfetch`. :meth:`__iter__`
20    no longer gets overwritten. New methods :meth:`xexecute` and
21    :meth:`xexecutemany` have been added, that support passing unicode
22    parameters.
23
24
25Changes in 1.19 (released 02/01/2008)
26-------------------------------------
27
28*   All docstrings use ReST now.
29
30
31Changes in 1.18 (released 01/07/2008)
32-------------------------------------
33
34*   Updated the docstrings to XIST 3.0.
35
36*   Added ReST versions of the documentation.
37
38
39Changes in 1.17.5 (released 08/09/2007)
40---------------------------------------
41
42*   Fixed a bug in the error handling of wrong arguments when calling
43    functions or procedures.
44
45
46Changes in 1.17.4 (released 04/30/2007)
47---------------------------------------
48
49*   The threshold for string length for procedure and function arguments has
50    been reduced to 4000.
51
52
53Changes in 1.17.3 (released 03/08/2007)
54---------------------------------------
55
56*   ``BLOB`` arguments for procedures and functions are always passed as
57    variables now.
58
59
60Changes in 1.17.2 (released 03/07/2007)
61---------------------------------------
62
63*   Arguments for procedures and functions that are longer that 32000 characters
64    are passed as variables now (the threshold was 32768 before and didn't work).
65
66
67Changes in 1.17.1 (released 03/02/2007)
68---------------------------------------
69
70*   Fix an inverted logic bug in :meth:`Record.fromdata` that surfaced in unicode
71    mode: ``BLOB``\s were treated as string and ``CLOB``\s as binary data.
72
73
74Changes in 1.17 (released 02/23/2007)
75-------------------------------------
76
77*   The :var:`readlobs` and :var:`unicode` parameters are now honored when
78    calling procedures and functions via :class:`Procedure` and
79    :class:`Function` objects.
80
81
82Changes in 1.16 (released 02/21/2007)
83-------------------------------------
84
85*   A parameter :var:`unicode` has been added to various constructors and methods.
86    This parameter can be used to get strings (i.e. ``VARCHAR2`` and ``CLOB``\s)
87    as :class:`unicode` object instead of :class:`str` objects.
88
89
90Changes in 1.15 (released 02/17/2007)
91-------------------------------------
92
93*   Fixed an output bug in ``oradiff.py`` when running in full output mode.
94
95*   A parameter :var:`readlobs` has been added to various constructors and
96    methods that can be used to get small (or all) ``LOB`` values as strings in
97    cursor fetch calls.
98
99
100Changes in 1.14 (released 02/01/2007)
101-------------------------------------
102
103*   A new method :meth:`iterprivileges` has been added to :class:`Connection`.
104
105*   A script ``oragrant.py`` has been added for copying privileges.
106
107
108Changes in 1.13 (released 11/06/2006)
109-------------------------------------
110
111*   Two new methods (:meth:`itertables` and :meth:`iterfks`) have been added to
112    :class:`Connection`. They yield all table definitions or all foreign keys
113    respectively.
114
115*   A new method :meth:`isenabled` has been added to :class:`ForeignKey`.
116
117*   A :meth:`__str__` method has been added to :class:`Object`.
118
119*   A bug in ``oramerge.py`` has been fixed: In certain situations ``oramerge.py``
120    used merging actions that were meant to be used for the preceeding object.
121
122
123Changes in 1.12.2 (released 10/18/2006)
124---------------------------------------
125
126*   Fixed a bug that showed up when an index and a foreign key of the same name
127    existed.
128
129
130Changes in 1.12.1 (released 09/19/2006)
131---------------------------------------
132
133*   Fixed a bug in :meth:`Index.__xattrs__`.
134
135
136Changes in 1.12 (released 09/06/2006)
137-------------------------------------
138
139*   :class:`Function` objects are now callable too. They return the return value
140    and a :class:`Record` containing the modified input parameters.
141
142
143Changes in 1.11.1 (released 08/29/2006)
144---------------------------------------
145
146*   Fixed a bug in :meth:`Column.modifyddl`.
147
148
149Changes in 1.11 (released 08/22/2006)
150-------------------------------------
151
152*   The class :class:`Column` has gained a few new methods: :meth:`datatype`,
153    :meth:`default`, :meth:`nullable` and :meth:`comment`.
154
155*   Calling a procedure will now raise a :class:`SQLObjectNotFoundError` error,
156    if the procedure doesn't exist.
157
158
159Changes in 1.10 (released 08/11/2006)
160-------------------------------------
161
162*   The classes :class:`Proc` and :class:`LLProc` have been removed. The
163    functionality of :class:`Proc` has been merged into
164    :class:`ProcedureDefinition` (with has been renamed to :class:`Procedure`).
165    Information about the procedure arguments is provided by the
166    :meth:`iteraguments` method.
167
168*   All other subclasses of :class:`Definition` have been renamed to remove the
169    "Definition" for the name to reduce typing. (Methods have been renamed
170    accordingly too.)</li>
171
172*   :func:`oramerge.main` and :func:`oradiff.main` now accept option arrays as
173    arguments.
174
175*   ``oradiff.py`` has finally been fixed.
176
177
178Changes in 1.9.4 (released 08/09/2006)
179--------------------------------------
180
181*   Fixed a bug in ``oradiff.py``.
182
183
184Changes in 1.9.3 (released 08/08/2006)
185--------------------------------------
186
187*   Fixed a bug in ``oramerge.py``.
188
189
190Changes in 1.9.2 (released 08/04/2006)
191--------------------------------------
192
193*   Fixed a bug in :meth:`TableDefinition.iterdefinitions`.
194
195
196Changes in 1.9.1 (released 08/02/2006)
197--------------------------------------
198
199*   Fixed a bug in ``oracreate.py``.
200
201
202Changes in 1.9 (released 07/24/2006)
203------------------------------------
204
205*   Dependencies involving :class:`MaterializedViewDefinition` and
206    :class:`IndexDefinition` objects generated by constraints work properly now,
207    so that iterating all definitions in create order really results in a
208    working SQL script.
209
210*   A method :meth:`table` has been added to :class:`PKDefinition`,
211    :class:`FKDefinition`, :class:`UniqueDefinition` and
212    :class:`IndexDefinition`. This method returns the :class:`TableDefinition` to
213    object belongs to.
214
215*   A method :meth:`pk` has been added to :class:`FKDefinition`. It returns the
216    primary key that this foreign key references.
217
218*   Indexes and constraints belonging to skipped tables are now skipped too in
219    ``oracreate.py``.
220
221*   Arguments other than ``sys.argv[1:]`` can now be passed to the
222    ``oracreate.py`` and ``oradrop.py`` :func:`main` functions.
223
224
225Changes in 1.8.1 (released 07/17/2006)
226--------------------------------------
227
228*   :mod:`ll.orasql` can now handle objects name that are not in uppercase.
229
230
231Changes in 1.8 (released 07/14/2006)
232------------------------------------
233
234*   :meth:`Connection.iterobjects` has been renamed to :meth:`iterdefinitions`.
235
236*   Each :class:`Definition` subclass has a new classmethod
237    :meth:`iterdefinitions` that iterates through all definitions of this type
238    in a schema (or all schemas).
239
240*   Each :class:`Definition` subclass has new methods :meth:`iterreferences` and
241    :meth:`iterreferencedby` that iterate through related definitions. The
242    methods :meth:`iterreferencesall` and :meth:`iterreferencedbyall` do this
243    recursively. The method :meth:`iterdependent` is gone now.
244
245*   The method :meth:`iterschema` of :class:`Connection` now has an additional
246    parameter :var:`schema`. Passing ``"all"`` for :var:`schema` will give you
247    statistics for the complete database not just one schema.
248
249*   A new definition class :class:`MaterializedViewDefinition` has been added
250    that handles materialized views. Handling of create options is rudimentary
251    though. Patches are welcome.
252
253*   :class:`TableDefinition` has a three new methods: :meth:`ismview` returns
254    whether the table is a materialized view; :meth:`itercomments` iterates
255    through comments and :meth:`iterconstraints` iterates through primary keys,
256    foreign keys and unique constraints.
257
258*   The method :meth:`getcursor` will now raise a :class:`TypeError` if it can't
259    get a cursor.
260
261
262Changes in 1.7.2 (released 07/05/2006)
263--------------------------------------
264
265*   ``RAW`` fields in tables are now output properly in
266    :meth:`TableDefinition.createddl`.
267
268*   A class :class:`PackageBodyDefinition` has been added. ``oracreate.py`` will
269    output package body definitions and ``oradrop.py`` will drop them.
270
271
272Changes in 1.7.1 (released 07/04/2006)
273--------------------------------------
274
275*   Duplicate code in the scripts has been removed.
276
277*   Fixed a bug in ``oramerge.py``: If the source to be diffed was long enough
278    the call to ``diff3`` deadlocked.
279
280
281Changes in 1.7 (released 06/29/2006)
282------------------------------------
283
284*   The method :meth:`iterobjects` has been moved from :class:`Cursor` to
285    :class:`Connection`.
286
287*   The method :meth:`itercolumns` has been moved from :class:`Cursor` to
288    :class:`TableDefinition`.
289
290*   :class:`LLProc` now recognizes the ``c_out`` parameter used by
291    :mod:`ll.toxic` 0.8.
292
293*   Support for positional arguments has been added for :class:`Proc` and
294    :class:`LLProc`. Error messages for calling procedures have been enhanced.
295
296*   :class:`SequenceDefinition` now has a new method :meth:`createddlcopy` that
297    returns code that copies the sequence value. ``oracreate.py`` has a new
298    option :option:`-s`/:option:`--seqcopy` that uses this feature.
299
300*   :mod:`setuptools` is now supported for installation.
301
302
303Changes in 1.6 (released 04/26/2006)
304------------------------------------
305
306*   Added a :class:`SessionPool` (a subclass of :class:`SessionPool` in
307    :mod:`cx_Oracle`) whose :meth:`acquire` method returns
308    :mod:`ll.orasql.Connection` objects.
309
310
311Changes in 1.5 (released 04/05/2006)
312------------------------------------
313
314*   Added a class :class:`IndexDefinition` for indexes. ``oracreate.py`` will
315    now issue create statements for indexes.
316
317
318Changes in 1.4.3 (released 12/07/2005)
319--------------------------------------
320
321*   Fixed a bug with empty lines in procedure sources.
322
323*   Remove spurious spaces at the start of procedure and function definitions.
324
325
326Changes in 1.4.2 (released 12/07/2005)
327--------------------------------------
328
329*   Fixed a bug that the DDL output of Java source.
330
331*   Trailing whitespace in each line of procedures, functions etc. is now stripped.
332
333
334Changes in 1.4.1 (released 12/06/2005)
335--------------------------------------
336
337*   Fixed a bug that resulted in omitted field lengths.
338
339
340Changes in 1.4 (released 12/05/2005)
341------------------------------------
342
343*   The option :option:`-m`/:option:`--mode` has been dropped from the script
344    ``oramerge.py``.
345
346*   A new class :class:`ColumnDefinition` has been added to :mod:`ll.orasql`.
347    The :class:`Cursor` class has a new method :meth:`itercolumns` that iterates
348    the :class:`ColumnDefinition` objects of a table.
349
350*   ``oramerge.py`` now doesn't output a merged ``create table`` statement, but
351    the appropriate ``alter table`` statements.
352
353
354Changes in 1.3 (released 11/24/2005)
355------------------------------------
356
357*   Added an option :option:`-i` to ``oracreate.py`` and ``oradrop.py`` to
358    ignore errors.
359
360*   The argument :var:`all` of the cursor method :meth:`iterobjects` is now
361    named :var:`schema` and may have three values: ``"own"``, ``"dep"`` and
362    ``"all"``.
363
364*   Added an script ``oramerge.py`` that does a three way merge of three database
365    schemas and outputs the resulting script.
366
367*   DB links are now copied over in :class:`SynonymDefinition` objects.
368
369
370Changes in 1.2 (released 10/24/2005)
371------------------------------------
372
373*   Added a argument to :meth:`createddl` and :meth:`dropddl` to specify if
374    terminated or unterminated DDL is wanted (i.e. add ``;`` or ``/`` or not).
375
376*   :class:`CommentsDefinition` has been renamed to :class:`CommentDefinition`
377    and holds the comment for one field only.
378
379*   :class:`JavaSourceDefinition` has been added.
380
381*   The scripts ``oracreate.py``, ``oradrop.py`` and ``oradiff.py`` now skip
382    objects with ``"$"`` in their name by default. This can be changed with the
383    :option:`-k` option (but this will lead to unexecutable scripts).
384
385*   ``oradiff.py`` has a new options :option:`-b`: This allows you to specify
386    how whitespace should be treated.
387
388*   Added an option :option:`-x` to ``oracreate.py`` to make it possible to
389    directly execute the DDL in another database.
390
391*   Fixed a bug in :class:`SequenceDefinition` when the ``CACHE`` field was ``0``.
392
393
394Changes in 1.1 (released 10/20/2005)
395------------------------------------
396
397*   A script ``oradiff.py`` has been added which can be used for diffing Oracle
398    schemas.
399
400*   Definition classes now have two new methods :meth:`cdate` and :meth:`udate`
401    that give the creation and modification time of the schema object
402    (if available).
403
404*   A ``"flat"`` iteration mode has been added to :meth:`Cursor.iterobjects` that
405    returns objects unordered.
406
407*   :class:`Connection` has a new method :meth:`connectstring`.
408
409*   A class :class:`LibraryDefinition` has been added.
410
411*   :meth:`CommentsDefinition.createddl` returns ``""`` instead of ``"\n"`` now
412    if there are no comments.
413
414*   :class:`SQLObjectNotfoundError` has been renamed to
415    :class:`SQLObjectNotFoundError`.
416
417
418Changes in 1.0 (released 10/13/2005)
419------------------------------------
420
421*   :mod:`ll.orasql` requires version 1.0 of the core package now.
422
423*   A new generator method :func:`iterobjects` has been added to the
424    :class:`Cursor` class. This generator returns "definition objects" for all
425    the objects in a schema in topological order (i.e. if the name of an object
426    (e.g. a table) is generated it will only depend on objects whose name has
427    been yielded before). SQL for recreating and deleting these SQL objects can
428    be generated from the definition objects.
429
430*   Two scripts (``oracreate.py`` and ``oradrop.py``) have been added, that
431    create SQL scripts for recreating or deleting the content of an Oracle schema.
432
433
434Changes in 0.7 (released 08/09/2005)
435------------------------------------
436
437*   The commands generated by :func:`iterdrop` no longer have a terminating ``;``,
438    as this seems to confuse Oracle/cx_Oracle.
439
440
441Changes in 0.6 (released 06/20/2005)
442------------------------------------
443
444*   Two new functions have been added: :func:`iterdrop` is a generator that
445    yields information about how to clear the schema (i.e. drop all table,
446    sequences, etc.). :func:`itercreate` yields information about how to recreate
447    a schema.
448
449
450Changes in 0.5 (released 06/07/2005)
451------------------------------------
452
453*   Date values are now supported as ``OUT`` parameters.
454
455
456Changes in 0.4.1 (released 03/22/2005)
457--------------------------------------
458
459*   Added a note about the package init file to the installation documentation.
460
461
462Changes in 0.4 (released 01/03/2005)
463------------------------------------
464
465*   :mod:`ll.orasql` now requires ll-core.
466
467*   Procedures can now be called with string arguments longer that 32768
468    characters. In this case the argument will be converted to a variable before
469    the call. The procedure argument must be a ``CLOB`` in this case.
470
471*   Creating :class:`Record` instances from database data is now done by the
472    class method :meth:`Record.fromdata`. This means it's now possible to use any
473    other class as long as it provides this method.
474
475
476Changes in 0.3 (released 12/09/2004)
477------------------------------------
478
479*   :mod:`ll.orasql` requires cx_Oracle 4.1 now.
480
481
482Changes in 0.2.1 (released 09/09/2004)
483--------------------------------------
484
485*   Fixed a regression bug in :meth:`Proc._calcrealargs` as cursors will now
486    always return :class:`Record` objects.
487
488
489Changes in 0.2 (released 09/08/2004)
490------------------------------------
491
492*   Now generating :class:`Record` object is done automatically in a subclass of
493    :class:`cx_Oracle.Cursor`. So now it's possible to use :mod:`ll.orasql` as an
494    extended :mod:`cx_Oracle`.
495
496
497Changes in 0.1 (released 07/15/2004)
498------------------------------------
499
500*   Initial release.
Note: See TracBrowser for help on using the browser.