--- /tmp/python-sqlalchemy-utils-0.36.8-4lu5r03_u/debian/python-sqlalchemy-utils-doc_0.36.8-4_all.deb +++ python-sqlalchemy-utils-doc_0.36.8-4_all.deb ├── file list │ @@ -1,3 +1,3 @@ │ -rw-r--r-- 0 0 0 4 2021-02-06 15:05:20.000000 debian-binary │ -rw-r--r-- 0 0 0 3012 2021-02-06 15:05:20.000000 control.tar.xz │ --rw-r--r-- 0 0 0 116636 2021-02-06 15:05:20.000000 data.tar.xz │ +-rw-r--r-- 0 0 0 116640 2021-02-06 15:05:20.000000 data.tar.xz ├── control.tar.xz │ ├── control.tar │ │ ├── ./md5sums │ │ │ ├── ./md5sums │ │ │ │┄ Files differ ├── data.tar.xz │ ├── data.tar │ │ ├── file list │ │ │ @@ -74,16 +74,16 @@ │ │ │ -rw-r--r-- 0 root (0) root (0) 28 2021-01-01 06:53:29.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/_static/default.css │ │ │ -rw-r--r-- 0 root (0) root (0) 356 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/_static/documentation_options.js │ │ │ -rw-r--r-- 0 root (0) root (0) 286 2021-01-01 06:53:29.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/_static/file.png │ │ │ -rw-r--r-- 0 root (0) root (0) 90 2021-01-01 06:53:29.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/_static/minus.png │ │ │ -rw-r--r-- 0 root (0) root (0) 90 2021-01-01 06:53:29.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/_static/plus.png │ │ │ -rw-r--r-- 0 root (0) root (0) 4780 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/_static/pygments.css │ │ │ -rw-r--r-- 0 root (0) root (0) 45836 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/aggregates.html │ │ │ --rw-r--r-- 0 root (0) root (0) 120190 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/data_types.html │ │ │ --rw-r--r-- 0 root (0) root (0) 38648 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/database_helpers.html │ │ │ +-rw-r--r-- 0 root (0) root (0) 120193 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/data_types.html │ │ │ +-rw-r--r-- 0 root (0) root (0) 38649 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/database_helpers.html │ │ │ -rw-r--r-- 0 root (0) root (0) 24933 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/foreign_key_helpers.html │ │ │ -rw-r--r-- 0 root (0) root (0) 24094 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/generic_relationship.html │ │ │ -rw-r--r-- 0 root (0) root (0) 29887 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/genindex.html │ │ │ -rw-r--r-- 0 root (0) root (0) 18282 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/index.html │ │ │ -rw-r--r-- 0 root (0) root (0) 8058 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/installation.html │ │ │ -rw-r--r-- 0 root (0) root (0) 17668 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/internationalization.html │ │ │ -rw-r--r-- 0 root (0) root (0) 5263 2021-02-06 15:05:20.000000 ./usr/share/doc/python-sqlalchemy-utils-doc/html/license.html │ │ ├── ./usr/share/doc/python-sqlalchemy-utils-doc/html/data_types.html │ │ │ @@ -86,19 +86,19 @@ │ │ │
│ │ │

ChoiceType

│ │ │
│ │ │
│ │ │ class sqlalchemy_utils.types.choice.ChoiceType(choices, impl=None)[source]
│ │ │

ChoiceType offers way of having fixed set of choices for given column. It │ │ │ could work with a list of tuple (a collection of key-value pairs), or │ │ │ -integrate with enum in the standard library of Python 3.4+ (the │ │ │ +integrate with enum in the standard library of Python 3.4+ (the │ │ │ enum34 backported package on PyPI is compatible too for < 3.4).

│ │ │

Columns with ChoiceTypes are automatically coerced to Choice objects while │ │ │ a list of tuple been passed to the constructor. If a subclass of │ │ │ -enum.Enum is passed, columns will be coerced to enum.Enum │ │ │ +enum.Enum is passed, columns will be coerced to enum.Enum │ │ │ objects instead.

│ │ │
class User(Base):
│ │ │      TYPES = [
│ │ │          (u'admin', u'Admin'),
│ │ │          (u'regular-user', u'Regular user')
│ │ │      ]
│ │ ├── ./usr/share/doc/python-sqlalchemy-utils-doc/html/database_helpers.html
│ │ │ @@ -278,15 +278,15 @@
│ │ │  constraint = list(table.foreign_keys)[0].constraint
│ │ │  
│ │ │  has_unique_index(constraint)  # True
│ │ │  
│ │ │
│ │ │
│ │ │
Raises
│ │ │ -

TypeError – if given column does not belong to a Table object

│ │ │ +

TypeError – if given column does not belong to a Table object

│ │ │
│ │ │
│ │ │
│ │ │ │ │ │
│ │ │
│ │ │

json_sql