File: CHANGELOG.rst

package info (click to toggle)
python-agate-sql 0.5.5-4
  • links: PTS, VCS
  • area: main
  • in suites: bullseye, sid
  • size: 236 kB
  • sloc: python: 461; makefile: 123
file content (75 lines) | stat: -rw-r--r-- 2,547 bytes parent folder | download
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
0.5.5 - July 7, 2020
--------------------

* Set type to ``DATETIME`` for datetime (MS SQL).
* Drop support for Python 2.7 (EOL 2020-01-01), 3.4 (2019-03-18), 3.5 (2020-09-13).

0.5.4 - March 16, 2019
----------------------

* Add ``min_col_len`` and ``col_len_multiplier`` options to :meth:`.Table.to_sql` to control the length of text columns.
* agate-sql is now tested against Python 3.7.
* Drop support for Python 3.3 (end-of-life was September 29, 2017).

Dialect-specific:

* Add support for CrateDB.
* Set type to ``BIT`` for boolean (MS SQL).
* Eliminate SQLite warning about Decimal numbers.

0.5.3 - January 28, 2018
------------------------

* Add ``chunk_size`` option to :meth:`.Table.to_sql` to write rows in batches.
* Add ``unique_constraint`` option to :meth:`.Table.to_sql` to include in a UNIQUE constraint.

Dialect-specific:

* Specify precision and scale for ``DECIMAL`` (MS SQL, MySQL, Oracle).
* Set length of ``VARCHAR`` to ``1`` even if maximum length is ``0`` (MySQL).
* Set type to ``TEXT`` if maximum length is greater than 21,844 (MySQL).

0.5.2 - April 28, 2017
----------------------

* Add ``create_if_not_exists`` flag to :meth:`.Table.to_sql`.

0.5.1 - February 27, 2017
-------------------------

* Add ``prefixes`` option to :func:`.to_sql` to add expressions following the INSERT keyword, like OR IGNORE or OR REPLACE.
* Use ``TIMESTAMP`` instead of ``DATETIME`` for DateTime columns.

0.5.0 - December 23, 2016
-------------------------

* ``VARCHAR`` columns are now generated with proper length constraints (unless explicilty disabled).
* Tables can now be created from query results using :func:`.from_sql_query`.
* Add support for running queries directly on tables with :func:`.sql_query`.
* When creating tables, ``NOT NULL`` constraints will be created by default.
* SQL create statements can now be generated without being executed with :func:`.to_sql_create_statement`

0.4.0 - December 19, 2016
-------------------------

* Modified ``example.py`` so it no longer depends on Postgres.
* It is no longer necessary to run :code:`agatesql.patch()` after importing agatesql.
* Upgrade required agate to ``1.5.0``.

0.3.0 - November 5, 2015
------------------------

* Add ``overwrite`` flag to :meth:`.Table.to_sql`.
* Removed Python 2.6 support.
* Updated agate dependency to version 1.1.0.
* Additional SQL types are now supported. (#4, #10)

0.2.0 - October 22, 2015
------------------------

* Add explicit patch function.

0.1.0 - September 22, 2015
--------------------------

* Initial version.