clandmeter/patchwork/lib/sql, branch master

Add patch tag infrastructure

2015-05-28T01:05:45+00:00

This change add patch 'tags', eg 'Acked-by' / 'Reviewed-by', etc., to
patchwork.

Tag parsing is implemented in the patch parser's extract_tags function,
which returns a Counter object of the tags in a comment. These are
stored in the PatchTag (keyed to Tag) objects associated with each
patch.

We need to ensure that the main patch lists do not cause per-patch
queries on the Patch.tags ManyToManyField (this would result in ~500
queries per page), so we introduce a new QuerySet (and Manager) for
Patch, adding a with_tag_counts() method to populate the tag counts in a
single query.

As users may be migrating from previous patchwork versions (ie, with no
tag counts in the database), we add a 'retag' management command.

Signed-off-by: Jeremy Kerr

migration: Add cleanup-people migration script

2014-05-08T03:05:33+00:00

Now that we only create Person object once the User has been confirmed,
we can clean up unused Person objects from the database.

Signed-off-by: Jeremy Kerr

lib/sql: remove references to auth_message model

2014-04-22T13:05:47+00:00

The Message model was deprecated in 1.4, and removed in 1.6

Signed-off-by: Jeremy Kerr

lib/sql/migration: Fix column names for MySQL/MariaDB

2013-10-13T06:55:59+00:00

The first issue is that patchwork was no longer accepting new patches via
the apps/patchwork/bin/parsemail.sh script.  When I was trying to invoke
it manually, it only printed "no project found".  I was able to figure
out that this was caused by changes to the database scheme which are taken
care of by the two SQL scripts:

  lib/sql/migration/012-project-add-columns.sql
  lib/sql/migration/013-bundle-names.sql

The catch - these first script don't run with MySQL - or rather MariaDB that
Fedora has switched to.  MariaDB doesn't like the quotes around the table
and column names.  Patch below.

Signed-off-by: Jeremy Kerr

sql: remove non-existing auth_message table

2013-10-04T06:15:14+00:00

During a recent installation the grant-all MySQL script was erroring out
because the "auth_message" table does not exist, remove it.

Signed-off-by: Florian Fainelli 
Signed-off-by: Jeremy Kerr

sql: update grant-all.mysql.sql

2013-10-04T06:15:14+00:00

The MySQL grant all script has a typo on the table
"patchwork_bundle_patches" vs "patchwork_bundlepatch" update that.

Signed-off-by: Florian Fainelli 
Signed-off-by: Jeremy Kerr

bundles: Don't allow slashes in bundle names

2013-04-20T14:45:20+00:00

Because bundle names are used in URLs, we don't want slashes in them.

Include a SQL migration script.

Signed-off-by: Jeremy Kerr

Add URL and SCM data to projects

2012-11-15T06:35:59+00:00

This allows us to display friendly links to the project website,
web SCM UI and SCM URL.

For example for the patchwork project these could be set to:
web_url: http://jk.ozlabs.org/projects/patchwork/
scm_url: git://ozlabs.org/home/jk/git/patchwork
webscm_url: http://git.ozlabs.org/?p=patchwork;a=tree

Requires a DB schema upgrade

Signed-off-by: Simo Sorce 
Signed-off-by: Jeremy Kerr

Fix grant script

2012-10-25T03:14:52+00:00

patchwork_patchchangenotification_id_seq does not exist,
so running this script simply fails with a rollback

Signed-off-by: Simo Sorce 
Signed-off-by: Jeremy Kerr

sql: remove development migration script

2011-12-08T14:28:22+00:00

The projectmaintainer heirachy hasn't been implemented, so we don't need
the migration script yet.

Signed-off-by: Jeremy Kerr