Skip to main content

DjangoDBU

Tools for debugging Django

Summary

  • dorm: Pretty print models, querysets, etc.
  • ds: Search dictionaries and lists for string.
  • ago: Generate datetimes.

DORM - Debug Django ORM

Pretty print django objects with syntax highlighting, column layout and shorthands.

Dorm can handle:

  • model instances
    • attribute coloring + grouping
    • attribute values
    • print in parallel columns
  • querysets
    • print all rows in queryset
    • prints selected values (in values=[] fashion) or value from 'callable'
    • paginate, with skipt to page
  • query
    • syntax highlight
  • list / dict / tuple through pprint

Requirements

  • Python 2
  • Django
  • sqlparse

Installation

$ pip install djangodbu

Usage

Start Django shell_plus: python manage.py shell_plus

>>> from djangodbu import dorm
>>> dorm(MyModel.objects.get(id=123))
          instancemethod serializable_value
          instancemethod set_password
          instancemethod set_unusable_password
          instancemethod unique_error_message
          instancemethod validate_unique
                 unicode USERNAME_FIELD: username
                 unicode email: some.one@example.org
                 unicode first_name: Some
                 unicode last_name: One
                 unicode password: pbkdf2_sha256$20000$
                 unicode username: someone
                    list REQUIRED_FIELDS: 1
                    long id: 357
                    long pk: 357
 so.mo.na.AccountingUser accountinguser: 651 > 'Some One'
          RelatedManager additionalemail_set: 1
          RelatedManager callback_set: 0
          RelatedManager campaigncode_set: 0
          RelatedManager grouplog: 142
      ManyRelatedManager groups: 0
          RelatedManager log: 379
          RelatedManager logevent_set: 89
          RelatedManager message_set: 11
        lo.pa.to.Payment payment: 510 > 'Bob & Uncle'
          RelatedManager settings_set: 1
          RelatedManager social_auth: 0
      ManyRelatedManager user_permissions: 0
          RelatedManager worker_set: 1
                NoneType activationcode
                NoneType auth_token
                NoneType employee
                    bool is_active: True
                    bool is_superuser: False
       datetime.datetime date_joined: 2016-05-01 08:13:16+00:00
       datetime.datetime last_login: 2016-06-20 07:48:51+00:00
                    type DoesNotExist: DoesNotExist
                classobj Meta: Meta
                    type MultipleObjectsReturned: MultipleObjectsReturned

Printing QuerySets:

>>> dorm(MyModel.objects.all())
1: userA
2: userB
4: userD
20: userY
...

Selecting values for QuerySet:

>>> dorm(User.objects.all(), v='first_name, email')

    id: firstname  email
------------------------------------------------
    1: abcd       userA@example.org
    2: efghij     userB@example.org
    4: kl         userD@example.org
    20: Mnopqrst  userY@example.org
...

Print Query:

>>> dorm(User.objects.filter(email__isnull=False).exclude(first_name='kl').query)
SELECT auth_user.id,
       auth_user.password,
       auth_user.username,
       auth_user.first_name,
       auth_user.last_name,
       auth_user.email
FROM auth_user WHERE (auth_user.email IS NOT NULL
       AND NOT (auth_user.first_name = kl))

'ds' accepts dictionaries and lists.

Usage

    >>> from djangodbu import ds
    >>> ds(haystack_dict, 'needle')
    >>> from dbu.utils import ds

    >>> test = { 'a' : ['b', 'c'], 'd':3, 'e': { 'f':'g'}, 'h': 'i' }

    >>> ds(test, 'a')
    a: ['b', 'c']
    >>> ds(test, 'b')
    a > 0 : 'b'
    >>> ds(test, 'c')
    a > 1 : 'c'
    >>> ds(test, 'd')
    d: 3
    >>> ds(test, 'e')
    e: {'f': 'g'}
    >>> ds(test, 'f')
    e > f: 'g'
    >>> ds(test, 'g')
    e > f: 'g'
    >>> ds(test, 'h')
    h: 'i'
    >>> ds(test, 'i')
    h: 'i'

Project url

djangodbu on github

djangodbu on pypi

Metadata

Release files for djangodbu 0.1.8

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for djangodbu 0.1.8
File Size Uploaded Provenance Actions
djangodbu-0.1.8.tar.gz 37.3 kB Without provenance Details for djangodbu-0.1.8.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for djangodbu 0.1.8
File Interpreter ABI Platform Actions
djangodbu-0.1.8-py3-none-any.whl Python 3 none any Details for djangodbu-0.1.8-py3-none-any.whl

Total release size: 73.5 kB

Release files / djangodbu-0.1.8.tar.gz

Download URL djangodbu-0.1.8.tar.gz
Size 37.3 kB
Tags Source
SHA-256 checksum
How to use checksums
f622956bdcfe4e3fa121f155170d211117623fd9ec23eeaa91b2aef61ff9d888
BLAKE2b-256 checksum
How to use checksums
0763d40c85e20a1fb1f2a1e3cb0063000b7f07bfc23b4e4e3db8ffe5540035b3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.12.1

Release files / djangodbu-0.1.8-py3-none-any.whl

Download URL djangodbu-0.1.8-py3-none-any.whl
Size 36.2 kB
Tags Python 3
SHA-256 checksum
How to use checksums
1de688bb90208f5caf3035ef9601ec47bfbac35966afa35aba6732c12b43e94f
BLAKE2b-256 checksum
How to use checksums
aeb06777efcaf101266ea397a8c1dd8eedc63c9e2d2162b8ee8c5ce65cd0d11f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.12.1

Security for djangodbu 0.1.8

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page