diff options
| author | Rob Austein <sra@hactrn.net> | 2007-12-22 17:10:57 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2007-12-22 17:10:57 +0000 |
| commit | 0d72c2b7b4f95049ba08c9b39e3d46b710008dab (patch) | |
| tree | 1c8ef1a673af146901f765819396987aa4fada0c /scripts/testdb.py | |
| parent | dd3bb389110e757506a0996fd72adc99fed133de (diff) | |
Whack SQL usage to let MySQLdb handle the quoting, per the Python DB API.
svn path=/scripts/irbe-setup.py; revision=1421
Diffstat (limited to 'scripts/testdb.py')
| -rw-r--r-- | scripts/testdb.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/testdb.py b/scripts/testdb.py index d8f3a146..f88af790 100644 --- a/scripts/testdb.py +++ b/scripts/testdb.py @@ -283,7 +283,7 @@ class allocation(object): cur.execute("DELETE FROM asn") cur.execute("DELETE FROM net") for kid in self.kids: - cur.execute("SELECT registrant_id FROM registrant WHERE IRBE_mapped_id = %s", kid.name) + cur.execute("SELECT registrant_id FROM registrant WHERE IRBE_mapped_id = %s", (kid.name,)) registrant_id = cur.fetchone()[0] for as_range in kid.resources.as: cur.execute("INSERT asn (start_as, end_as, registrant_id) VALUES (%s, %s, %s)", (as_range.min, as_range.max, registrant_id)) |