From da290801dac50efa7d0540a4fad4cd12cf761233 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Mon, 12 Apr 2010 17:56:03 +0000 Subject: Clean out old myrpki code, step 2 svn path=/myrpki; revision=3187 --- myrpki/sql-cleaner.py | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 myrpki/sql-cleaner.py (limited to 'myrpki/sql-cleaner.py') diff --git a/myrpki/sql-cleaner.py b/myrpki/sql-cleaner.py new file mode 100644 index 00000000..d7e1a568 --- /dev/null +++ b/myrpki/sql-cleaner.py @@ -0,0 +1,35 @@ +""" +(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)) -- cgit v1.2.3