• Search by Module
• Search by Words
• Search Projects

• Java
• Python
• JavaScript
• TypeScript
• C++
• Scala
• Blog

• django-datatables-view-master
  • requirements_test.txt
  • LICENSE
  • README.rst
  • setup.py
  • CHANGELOG.rst
  • runtests.py
  • setup.cfg
  • datatables_view
    • apps.py
    • exceptions.py
    • app_settings.py
    • templates
      • base.html
      • datatables_view
        • row_tools.html
        • datatable.html
    • templatetags
      • datatables_view_tags.py
      • __init__.py
    • views.py
    • columns.py
    • filters.py
    • __init__.py
    • utils.py
    • tests
      • test_autofilter.py
      • test_datatables_qs.py
      • test_columndefs.py
      • __init__.py
      • test_date_filters.py
      • test_choices_filters.py
    • static
      • datatables_view
        • images
        • js
          • utils.js
        • css
          • style.css
  • tests
    • test_models.py
    • urls.py
    • __init__.py
    • settings.py
  • screenshots
  • .gitignore
  • MANIFEST.in

import pprint
import datetime
from django.utils import timezone
from django.conf import settings
from django.utils import formats

import pytz

try:
    import sqlparse
except ImportError:
    class sqlparse:
        @staticmethod
        def format(text, *args, **kwargs):
            return text


def trace(message, prompt=''):
    print('\n\x1b[1;36;40m', end='')
    if prompt:
        print(prompt + ':')
    pprint.pprint(message)
    print('\x1b[0m\n', end='')


def prettyprint_queryset(qs):
    print('\x1b[1;33;40m', end='')
    # https://code.djangoproject.com/ticket/22973 !!!
    try:
        message = sqlparse.format(str(qs.query), reindent=True, keyword_case='upper')
    except Exception as e:
        message = str(e)
        if not message:
            message = repr(e)
        message = 'ERROR: ' + message
    print(message)
    print('\x1b[0m\n')


def format_datetime(dt, include_time=True):
    """
    Here we adopt the following rule:
    1) format date according to active localization
    2) append time in military format
    """
    if dt is None:
        return ''

    if isinstance(dt, datetime.datetime):
        try:
            dt = timezone.localtime(dt)
        except:
            local_tz = pytz.timezone(getattr(settings, 'TIME_ZONE', 'UTC'))
            dt = local_tz.localize(dt)
    else:
        assert isinstance(dt, datetime.date)
        include_time = False

    use_l10n = getattr(settings, 'USE_L10N', False)
    text = formats.date_format(dt, use_l10n=use_l10n, format='SHORT_DATE_FORMAT')
    if include_time:
        text += dt.strftime(' %H:%M:%S')
    return text


def parse_date(formatted_date):
    parsed_date = None
    for date_format in formats.get_format('DATE_INPUT_FORMATS'):
        try:
            parsed_date = datetime.datetime.strptime(formatted_date, date_format)
        except ValueError:
            continue
        else:
            break
    if not parsed_date:
        raise ValueError
    return parsed_date.date()