tickets

1 row where "created" is on date 2008-08-19 and version = "1.1-beta" sorted by resolution

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created (date), last_pulled_from_trac (date)

version 1 ✖

  • 1.1-beta · 1 ✖
id created changetime last_pulled_from_trac stage status component type severity version resolution ▼ summary description owner reporter keywords easy has_patch needs_better_patch needs_tests needs_docs ui_ux
8412 2008-08-19 10:12:19 2009-07-28 08:07:04 2022-03-06 03:42:11.780251 Accepted closed Core (Serialization)     1.1-beta worksforme When there is a DateTimeField in, data saved with dumpdata cannot be reloaded using loaddata (on German Systems) To recreate: 1. Setup Django on a Windows XP system with the Time Format set to German (19/8/2008) 2. Save the data using manage.py dumpdata > initial_data.json<br> 3. Reload the data using manage.py loaddata initial_data.json<br> The message appears: {{{ Problem installing fixture 'initial_data.json': Traceback (most recent call last ): File "C:\Program Files\Python\Lib\site-packages\django\core\management\command s\loaddata.py", line 108, in handle for obj in objects: File "C:\Program Files\Python\Lib\site-packages\django\core\serializers\json.p y", line 42, in Deserializer for obj in PythonDeserializer(simplejson.load(stream)): File "C:\Program Files\Python\Lib\site-packages\django\core\serializers\python .py", line 93, in Deserializer data[field.name] = field.to_python(field_value) File "C:\Program Files\Python\Lib\site-packages\django\db\models\fields\__init __.py", line 631, in to_python raise validators.ValidationError, _('Enter a valid date/time in YYYY-MM-DD H H:MM format.') ValidationError: [u'Enter a valid date/time in YYYY-MM-DD HH:MM format.'] }}} nobody Mark Essien <markessien@gmail.com> loaddata dumpdata DateTimeField 0 0 0 0 0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE tickets (
        id int primary key,
        created datetime,
        changetime datetime,
        last_pulled_from_trac datetime,
        stage text,
        status text,
        component text,
        type text,
        severity text,
        version text,
        resolution text,
        summary text,
        description text,
        owner text,
        reporter text,
        keywords text,
        easy boolean,
        has_patch boolean,
        needs_better_patch boolean,
        needs_tests boolean,
        needs_docs boolean,
        ui_ux boolean
    );