<feed xmlns='http://www.w3.org/2005/Atom'>
<title>clandmeter/patchwork/lib/sql/migration, branch master</title>
<subtitle>Mirror of git://ozlabs.org/home/jk/git/patchwork
</subtitle>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/'/>
<entry>
<title>Add patch tag infrastructure</title>
<updated>2015-05-28T01:05:45+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2015-05-27T01:56:36+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=3b8a61c68fa61eadebf7b19329e8d3bffde9e6b4'/>
<id>3b8a61c68fa61eadebf7b19329e8d3bffde9e6b4</id>
<content type='text'>
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 &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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 &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>migration: Add cleanup-people migration script</title>
<updated>2014-05-08T03:05:33+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2014-05-07T05:06:35+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=81a65cc81d151cbb412d2a833abab24dfc133a49'/>
<id>81a65cc81d151cbb412d2a833abab24dfc133a49</id>
<content type='text'>
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 &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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 &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>lib/sql/migration: Fix column names for MySQL/MariaDB</title>
<updated>2013-10-13T06:55:59+00:00</updated>
<author>
<name>Ralf Baechle</name>
<email>ralf@linux-mips.org</email>
</author>
<published>2013-07-29T14:46:33+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=4d7fcc9062659aa74377b39dd87de35c07973ec2'/>
<id>4d7fcc9062659aa74377b39dd87de35c07973ec2</id>
<content type='text'>
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 &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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 &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>bundles: Don't allow slashes in bundle names</title>
<updated>2013-04-20T14:45:20+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2013-04-20T14:34:28+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=8fd9086f337a09125ddcfaa616e762a4d85c6000'/>
<id>8fd9086f337a09125ddcfaa616e762a4d85c6000</id>
<content type='text'>
Because bundle names are used in URLs, we don't want slashes in them.

Include a SQL migration script.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Because bundle names are used in URLs, we don't want slashes in them.

Include a SQL migration script.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>Add URL and SCM data to projects</title>
<updated>2012-11-15T06:35:59+00:00</updated>
<author>
<name>Simo Sorce</name>
<email>idra@samba.org</email>
</author>
<published>2012-10-26T12:51:42+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=c30c03312041c24c39b6a986882aae6189096c2f'/>
<id>c30c03312041c24c39b6a986882aae6189096c2f</id>
<content type='text'>
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 &lt;idra@samba.org&gt;
Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
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 &lt;idra@samba.org&gt;
Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>sql: remove development migration script</title>
<updated>2011-12-08T14:28:22+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2011-12-08T14:28:22+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=0f3b76430ad276e8956ac388452e007d501cc54d'/>
<id>0f3b76430ad276e8956ac388452e007d501cc54d</id>
<content type='text'>
The projectmaintainer heirachy hasn't been implemented, so we don't need
the migration script yet.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
The projectmaintainer heirachy hasn't been implemented, so we don't need
the migration script yet.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>models: Add PatchChangeNotification and record patch state changes</title>
<updated>2011-04-14T09:24:03+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2011-03-29T03:58:39+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=798a73b8bfb41f742e78e481ab9c961556e117b3'/>
<id>798a73b8bfb41f742e78e481ab9c961556e117b3</id>
<content type='text'>
Add a PatchChangeNotification model to keep track of changes to a
patch's state. Hook this up to Patch's pre_save signal.

Requires a DB schema upgrade.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Add a PatchChangeNotification model to keep track of changes to a
patch's state. Hook this up to Patch's pre_save signal.

Requires a DB schema upgrade.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>Add email opt-out system</title>
<updated>2011-04-14T09:23:04+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2010-08-11T06:16:28+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=41f19b6643b44768dc06561c992c04ed6148477d'/>
<id>41f19b6643b44768dc06561c992c04ed6148477d</id>
<content type='text'>
We're going to start generating emails on patchwork updates, so firstly
allow people to opt-out of all patchwork communications.

We do this with a 'mail settings' interface, allowing non-registered
users to set preferences on their email address. Logged-in users can do
this through the user profile view.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
We're going to start generating emails on patchwork updates, so firstly
allow people to opt-out of all patchwork communications.

We do this with a 'mail settings' interface, allowing non-registered
users to set preferences on their email address. Logged-in users can do
this through the user profile view.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>registration: use EmailConfimation rather than separate registration app</title>
<updated>2011-04-14T09:21:04+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2010-10-31T23:29:29+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=c2c6a408c7764fa29389ce160f52776c9308d50a'/>
<id>c2c6a408c7764fa29389ce160f52776c9308d50a</id>
<content type='text'>
Since we have infrastructure for email confirmations, we no longer need
the separate registration app.

Requires a migration script, which will delete all inactive users,
including those newly added and pending confirmation. Use carefully.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Since we have infrastructure for email confirmations, we no longer need
the separate registration app.

Requires a migration script, which will delete all inactive users,
including those newly added and pending confirmation. Use carefully.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>Use generic email confirmation object</title>
<updated>2011-04-14T08:44:53+00:00</updated>
<author>
<name>Jeremy Kerr</name>
<email>jk@ozlabs.org</email>
</author>
<published>2010-08-12T04:15:48+00:00</published>
<link rel='alternate' type='text/html' href='https://git-old.alpinelinux.org/user/clandmeter/patchwork/commit/?id=56e2243f3be7e859666ce0e4e1a8b8b94444f8d4'/>
<id>56e2243f3be7e859666ce0e4e1a8b8b94444f8d4</id>
<content type='text'>
Rather than having a UserPerson-specific confirmation, add an
EmailConfirmation object to allow multiple types of confirmations (eg,
opt-out requests in future).

To do this, we use a view (patchwork.views.confirm) that will call the
type-specific view with the confirmation object.

Also, add tests to check that the User/Person linkage system works.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Rather than having a UserPerson-specific confirmation, add an
EmailConfirmation object to allow multiple types of confirmations (eg,
opt-out requests in future).

To do this, we use a view (patchwork.views.confirm) that will call the
type-specific view with the confirmation object.

Also, add tests to check that the User/Person linkage system works.

Signed-off-by: Jeremy Kerr &lt;jk@ozlabs.org&gt;
</pre>
</div>
</content>
</entry>
</feed>
