Wrap SQL schemas up so rpki-sql-setup doesn't have to be run in the

build tree (see #8).  This appears to work properly but needs more
testing, leaving ticket open for now.

Also cleaned up a few things that should have moved from scripts/ to
buildtools/ a long time ago.

svn path=/trunk/; revision=4056

1 files changed, 52 insertions, 0 deletions

diff --git a/buildtools/make-sql-schemas.py b/buildtools/make-sql-schemas.py
new file mode 100644
index 00000000..700d2b9c
--- /dev/null
+++ b/buildtools/make-sql-schemas.py
@@ -0,0 +1,52 @@
+"""
+Script to generate rpki/relaxng.py.
+
+$Id$
+
+Copyright (C) 2009-2011 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.
+
+Portions copyright (C) 2007--2008  American Registry for Internet Numbers ("ARIN")
+
+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 ARIN DISCLAIMS ALL WARRANTIES WITH
+REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
+AND FITNESS.  IN NO EVENT SHALL ARIN 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.
+"""
+
+schemas = ("rpkid", "irdbd", "pubd")
+
+format_1 = """\
+# Automatically generated, do not edit.
+"""
+
+format_2 = """\
+## @var %(name)s
+## SQL schema %(name)s
+%(name)s = '''%(sql)s'''
+"""
+
+print format_1
+
+for name in schemas:
+  print format_2 % {
+    "name" : name,
+    "sql"  : open(name + ".sql").read() }