django_tickets: tickets: 8 rows where "created" is on date 2005-07-13 and stage = "Unreviewed" sorted by needs_better

8 rows where "created" is on date 2005-07-13 and stage = "Unreviewed" sorted by needs_better_patch

descending

id	created	changetime	last_pulled_from_trac	stage	status	component	type	severity	resolution	summary	description	owner	reporter	has_patch
1	2005-07-13 19:03:27	2012-05-20 15:12:37	2022-03-06 03:19:23.152286	Unreviewed	closed	Core (Other)	enhancement	normal	fixed	Create architecture for anonymous sessions	We need an architecture for anonymous sessions. Right now we have django.models.auth.sessions, but that only handles registered users' sessions. We need a system that automatically creates and manages sessions for anonymous users. Here's one idea for this: * In the settings file, you define a {{{SESSION_MODULE}}} string, like the {{{AUTH_PROFILE_MODULE}}}, which points to the model to use for sessions. * Using this, httpwrappers automatically creates a request.session object which is persistant across requests based on cookies, etc.	jacob	adrian	0
6	2005-07-13 19:13:41	2006-10-07 21:25:13	2022-03-06 03:19:23.963614	Unreviewed	closed	Metasystem	defect	minor	fixed	Remove has_related_links option from models	The current (undocumented) {{{has_related_links}}} code is too Ellington-specific and doesn't belong in Django. Let's remove it. We'll have to come up with a more generic way of associating content_type_id/object_id relationships, such as related links, to a model.	adrian	adrian	0
8	2005-07-13 19:15:25	2007-07-03 23:03:55	2022-03-06 03:19:24.252139	Unreviewed	closed	contrib.admin	defect	minor	fixed	Date and time fields should accept multiple formats	Date and time fields should be able to adapt to multiple formats of user input (a la Simon's [http://simon.incutio.com/archive/2003/10/06/betterDateInput date parser]). As a basic example, a user should be able to enter "Today" or "Wednesday" for the date and have it converted to the correct format for today's date or this Wednesday's. For time fields, a user should be able to enter 6pm instead of 18:00.	jacob	adrian	0
10	2005-07-13 19:16:42	2007-01-19 17:00:10	2022-03-06 03:19:24.535662	Unreviewed	closed	Validators	task	minor	invalid	Ordered objects should have API access to their order number	The specific problem is that photos within photo galleries need to know their place within the gallery (1st, 2nd, etc.). In order to solve this, we'll need ordered objects to give API access to their order number.	adrian	adrian	0
12	2005-07-13 19:19:38	2007-07-03 23:03:44	2022-03-06 03:19:24.890200	Unreviewed	closed	Metasystem		normal	fixed	Add metasystem database-check functionality	We should automate the checking of whether everything is properly installed in the database for a particular app. For instance, a command such as {{{django-admin.py dbcheck news}}} would: * Check that the package exists in the DB. * Check that all the permissions exist in the DB. * Check that there aren't any extra permissions in the DB that the model doesn't know about. * Check that all the content types exist in the DB. * Check that there aren't any extra content types in the DB for this app. * Check that there aren't any missing fields. * Check that the fields are in the correct data type.	adrian	adrian	0
15	2005-07-13 19:22:11	2006-08-29 10:03:03	2022-03-06 03:19:25.461869	Unreviewed	closed	Metasystem	defect	normal	duplicate	Metasystem unique_together doesn't work for an object that's related inline	See {{{unique_together}}} in {{{music.MusicianInBand}}}, which causes this when ManipulatorAdd is instantiated: {{{ Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/worldonline/cms/core/handler.py", line 123, in get_response return callback(request, *param_dict) File "/usr/lib/python2.3/site-packages/worldonline/cms/views/admin/main_new.py", line 608, in change_stage manipulator = mod.ChangeManipulator(object_id) File "/usr/lib/python2.3/site-packages/worldonline/cms/models/meta.py", line 77, in _curried return args[0]((args[1:]+moreargs), **dict(kwargs.items() + morekwargs.items())) File "/usr/lib/python2.3/site-packages/worldonline/cms/models/meta.py", line 1008, in manipulator_init self.fields.extend(f.get_manipulator_fields(rel_opts, self, name_prefix='%s.%d.' % (rel_opts.object_name.lower(), i), rel=True)) File "/usr/lib/python2.3/site-packages/worldonline/cms/models/meta.py", line 1279, in get_manipulator_fields params['validator_list'].append(getattr(manipulator, 'isUnique%sFor%s' % (i, j))) AttributeError: BandManipulatorChange instance has no attribute 'isUniquemusician_idForband_id' }}}	adrian	adrian	0
18	2005-07-13 19:26:27	2007-07-03 23:03:51	2022-03-06 03:19:27.157564	Unreviewed	closed	Database layer (models, ORM)	enhancement	normal	wontfix	Metasystem optimization: Don't select duplicate fields	In the following query, "poll_choices.poll_id" and "polls.id" are the same value. Only one of them needs to be selected: {{{ SELECT poll_choices.id,poll_choices.poll_id,poll_choices.choice, poll_choices.votes, polls.id,polls.slug,polls.question,polls.pub_date, polls.expire_date FROM poll_choices, polls WHERE poll_choices.poll_id = polls.id }}}	adrian	adrian	0
22	2005-07-13 19:33:33	2008-10-06 03:46:01	2022-03-06 03:19:29.513777	Unreviewed	closed	contrib.admin	defect	normal	duplicate	[patch] FileUploadField should allow for clearing the field	It's currently not possible to clear the value of a FileUploadField.	adrian	adrian	1

Advanced export

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

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
    );