[Python-checkins] r85164 - in tracker/instances/python-dev: detectors/rietveldreactor.py scripts/initrietveld

Sat Oct 2 09:46:34 CEST 2010

Author: martin.v.loewis
Date: Sat Oct 2 09:46:34 2010
New Revision: 85164
Log:
Import existing users and issues into rietveld.
Added:
 tracker/instances/python-dev/scripts/initrietveld (contents, props changed)
Modified:
 tracker/instances/python-dev/detectors/rietveldreactor.py
Modified: tracker/instances/python-dev/detectors/rietveldreactor.py
==============================================================================

--- tracker/instances/python-dev/detectors/rietveldreactor.py	(original)
+++ tracker/instances/python-dev/detectors/rietveldreactor.py	Sat Oct 2 09:46:34 2010
@@ -6,6 +6,8 @@
 def create_django_user(db, cl, nodeid, oldvalues):
 username = cl.get(nodeid, 'username')
 email = cl.get(nodeid, 'address')
+ if email is None:
+ email = ''
 c = db.cursor
 # django.contrib.auth.models.UNUSABLE_PASSWORD=='!'
 c.execute("insert into auth_user(id, username, email, password, first_name, last_name, "
Added: tracker/instances/python-dev/scripts/initrietveld
==============================================================================
--- (empty file)
+++ tracker/instances/python-dev/scripts/initrietveld	Sat Oct 2 09:46:34 2010
@@ -0,0 +1,32 @@
+#!/usr/bin/python
+# Create Rietveld users and issues
+import rietveldreactor
+import roundup.instance
+tracker = roundup.instance.open('.')
+db = tracker.open('admin')
+
+# Need to widen username, as some roundup names are too long
+widen_username = """
+begin;
+alter table auth_user add username2 varchar(50);
+update auth_user set username2=username;
+alter table auth_user drop username;
+alter table auth_user add username varchar(50);
+update auth_user set username=username2;
+commit;
+"""
+
+c = db.cursor
+for userid in db.user.getnodeids():
+ c.execute("select count(*) from auth_user where id=%s", (userid,))
+ if c.fetchone()[0] == 1:
+ continue
+ rietveldreactor.create_django_user(db, db.user, userid, None)
+ db.commit()
+
+for issue in db.issue.list():
+ c.execute("select count(*) from codereview_issue where id=%s", (issue,))
+ if c.fetchone()[0] == 1:
+ continue
+ rietveldreactor.create_rietveld_issue(db, db.issue, issue, None)
+ db.commit()
