diff options
author | Rob Austein <sra@hactrn.net> | 2010-04-12 17:56:03 +0000 |
---|---|---|
committer | Rob Austein <sra@hactrn.net> | 2010-04-12 17:56:03 +0000 |
commit | da290801dac50efa7d0540a4fad4cd12cf761233 (patch) | |
tree | 4e2506daaf21d8a5e7affccda5de03f3aefe2370 /myrpki.rototill/sql-cleaner.py | |
parent | 019d79c4ab69d368f4d48c8ba22811ddf03916c1 (diff) |
Clean out old myrpki code, step 2
svn path=/myrpki; revision=3187
Diffstat (limited to 'myrpki.rototill/sql-cleaner.py')
-rw-r--r-- | myrpki.rototill/sql-cleaner.py | 35 |
1 files changed, 0 insertions, 35 deletions
diff --git a/myrpki.rototill/sql-cleaner.py b/myrpki.rototill/sql-cleaner.py deleted file mode 100644 index d7e1a568..00000000 --- a/myrpki.rototill/sql-cleaner.py +++ /dev/null @@ -1,35 +0,0 @@ -""" -(Re)Initialize SQL tables used by these programs. - -$Id$ - -Copyright (C) 2009-2010 Internet Systems Consortium ("ISC") - -Permission to use, copy, modify, and distribute this software for any -purpose with or without fee is hereby granted, provided that the above -copyright notice and this permission notice appear in all copies. - -THE SOFTWARE IS PROVIDED "AS IS" AND ISC DISCLAIMS ALL WARRANTIES WITH -REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY -AND FITNESS. IN NO EVENT SHALL ISC BE LIABLE FOR ANY SPECIAL, DIRECT, -INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM -LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE -OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR -PERFORMANCE OF THIS SOFTWARE. -""" - -import subprocess, rpki.config - -cfg = rpki.config.parser("yamltest.conf", "yamltest", allow_missing = True) - -for name in ("rpkid", "irdbd", "pubd"): - - username = cfg.get("%s_sql_username" % name, name[:4]) - password = cfg.get("%s_sql_password" % name, "fnord") - - databases = [name[:4]] - databases.extend("%s%d" % (name[:4], i) for i in xrange(12)) - - for db in databases: - subprocess.check_call(("mysql", "-u", username, "-p" + password, db), - stdin = open("../rpkid/%s.sql" % name)) |