[sr-dev] git:master: sr: add 'make dbschema' target, compatibility to kamailio
Henning Westerholt
henning.westerholt at 1und1.de
Thu Oct 1 18:44:05 CEST 2009
Module: sip-router
Branch: master
Commit: 1f36a7beaaac6eacdc5bebd76e0830aba9af7f55
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1f36a7beaaac6eacdc5bebd76e0830aba9af7f55
Author: Henning Westerholt <henning.westerholt at 1und1.de>
Committer: Henning Westerholt <henning.westerholt at 1und1.de>
Date: Thu Oct 1 18:32:34 2009 +0200
sr: add 'make dbschema' target, compatibility to kamailio
---
Makefile | 6 +++++
lib/srdb1/schema/Makefile | 47 +++++++++++++++++++++++----------------------
2 files changed, 30 insertions(+), 23 deletions(-)
diff --git a/Makefile b/Makefile
index dfe5ea3..3a399a6 100644
--- a/Makefile
+++ b/Makefile
@@ -949,3 +949,9 @@ clean_cfg clean-cfg:
.PHONY: clean_modules_cfg clean-modules-cfg
clean_modules_cfg clean-modules-cfg:
rm -f modules.lst
+
+.PHONY: dbschema
+dbschema:
+ - at echo "Build database schemas"
+ $(MAKE) -C lib/srdb1/schema
+ - at echo "Done"
diff --git a/lib/srdb1/schema/Makefile b/lib/srdb1/schema/Makefile
index 05cbae1..354bb4e 100644
--- a/lib/srdb1/schema/Makefile
+++ b/lib/srdb1/schema/Makefile
@@ -5,8 +5,9 @@
# Kamailio database descriptions for modules
TABLES := $(patsubst kamailio-%.xml,%,$(wildcard kamailio-*.xml))
-ROOT=../..
-STYLESHEETS=$(ROOT)/doc/dbschema/xsl
+ROOT=../../../
+STYLESHEETS=$(ROOT)/doc/stylesheets/dbschema_k/xsl
+SCHEME=$(ROOT)/tools/kamctl/
# Stylesheet used to generate MySQL database schema
MYSQL_XSL = $(STYLESHEETS)/mysql.xsl
@@ -42,7 +43,7 @@ VALIDATE = 0
VERBOSE = 0
# XML Catalog used to resolve entities
-CATALOG = $(ROOT)/doc/dbschema/catalog.xml
+CATALOG = $(ROOT)/docbook/catalog.xml
XSLTPROC = /usr/bin/xsltproc
XSLTPROC_FLAGS = --xinclude
@@ -61,56 +62,56 @@ all: mysql postgres dbtext db_berkeley docbook oracle #modules dbdoc
mysql:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/scripts/mysql" \
+ --stringparam dir "$(SCHEME)/mysql" \
--stringparam prefix "$$FILE-" \
--stringparam db "mysql" \
$(MYSQL_XSL) kamailio-"$$FILE".xml ; \
done
mysql_clean:
- - at rm -f $(ROOT)/scripts/mysql/*
+ - at rm -f $(SCHEME)/mysql/*
.PHONY: postgres postgres_clean
postgres:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/scripts/postgres" \
+ --stringparam dir "$(SCHEME)/postgres" \
--stringparam prefix "$$FILE-" \
--stringparam db "postgres" \
$(POSTGRES_XSL) kamailio-"$$FILE".xml ; \
done
postgres_clean:
- - at rm -f $(ROOT)/scripts/postgres/*
+ - at rm -f $(SCHEME)/postgres/*
.PHONY: oracle oracle_clean
oracle:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/scripts/oracle" \
+ --stringparam dir "$(SCHEME)/oracle" \
--stringparam prefix "$$FILE-" \
--stringparam db "oracle" \
$(ORACLE_XSL) kamailio-"$$FILE".xml ; \
done
oracle_clean:
- - at rm -f $(ROOT)/scripts/oracle/*.sql
+ - at rm -f $(SCHEME)/oracle/*.sql
.PHONY: dbtext dbtext_clean
dbtext:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/scripts/dbtext/kamailio" \
+ --stringparam dir "$(SCHEME)/dbtext/kamailio" \
--stringparam prefix "" \
--stringparam db "dbtext" \
$(DBTEXT_XSL) kamailio-"$$FILE".xml ; \
done
TMPFILE=`mktemp -t kamailio-test.XXXXXXXXXX`
# small hack to create the version table entries, this is here easier as with XSL
- for FILE in $(wildcard $(ROOT)/scripts/dbtext/kamailio/*) ; do \
+ for FILE in $(wildcard $(SCHEME)/dbtext/kamailio/*) ; do \
if [ -f "$$FILE" ]; then \
- if [ "$$FILE" != "$(ROOT)/scripts/dbtext/kamailio/version" ]; then \
- tail -n 1 "$$FILE" >> "$(ROOT)/scripts/dbtext/kamailio/version" ; \
+ if [ "$$FILE" != "$(SCHEME)/dbtext/kamailio/version" ]; then \
+ tail -n 1 "$$FILE" >> "$(SCHEME)/dbtext/kamailio/version" ; \
head -n 1 "$$FILE" > $TMPFILE ; \
cp $TMPFILE "$$FILE" ; \
fi ; \
@@ -119,23 +120,23 @@ dbtext:
rm -f $TMPFILE
dbtext_clean:
- - at rm -f $(ROOT)/scripts/dbtext/kamailio/*
+ - at rm -f $(SCHEME)/dbtext/kamailio/*
.PHONY: db_berkeley db_berkeley_clean
db_berkeley:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/scripts/db_berkeley/kamailio" \
+ --stringparam dir "$(SCHEME)/db_berkeley/kamailio" \
--stringparam prefix "" \
--stringparam db "db_berkeley" \
$(DB_BERKELEY_XSL) kamailio-"$$FILE".xml ; \
done
TMPFILE=`mktemp -t kamailio-test.XXXXXXXXXX`
# small hack to create the version table entries, this is here easier as with XSL
- for FILE in $(wildcard $(ROOT)/scripts/db_berkeley/kamailio/*) ; do \
+ for FILE in $(wildcard $(SCHEME)/db_berkeley/kamailio/*) ; do \
if [ -f "$$FILE" ]; then \
- if [ "$$FILE" != "$(ROOT)/scripts/db_berkeley/kamailio/version" ]; then \
- tail -n 2 "$$FILE" >> "$(ROOT)/scripts/db_berkeley/kamailio/version" ; \
+ if [ "$$FILE" != "$(SCHEME)/db_berkeley/kamailio/version" ]; then \
+ tail -n 2 "$$FILE" >> "$(SCHEME)/db_berkeley/kamailio/version" ; \
head -n 10 "$$FILE" > $TMPFILE ; \
cp $TMPFILE "$$FILE" ; \
fi ; \
@@ -144,7 +145,7 @@ db_berkeley:
rm -f $TMPFILE
db_berkeley_clean:
- - at rm -f $(ROOT)/scripts/db_berkeley/kamailio/*
+ - at rm -f $(SCHEME)/db_berkeley/kamailio/*
.PHONY: docbook docbook_clean
@@ -168,7 +169,7 @@ docbook:
echo " <!ENTITY % docentities SYSTEM \"../entities.xml\"> %docentities;" >> "$(ROOT)/doc/database/tables.sgml" ; \
echo "]>" >> "$(ROOT)/doc/database/tables.sgml"
# add bookinfo
- cat "$(ROOT)/doc/dbschema/bookinfo.xml" >> "$(ROOT)/doc/database/tables.sgml"
+ cat "$(ROOT)/doc/stylesheets/dbschema_k/bookinfo.xml" >> "$(ROOT)/doc/database/tables.sgml"
# actually include the entities
for FILE in $(wildcard $(ROOT)/doc/database/*.xml); do \
echo " &`basename "$$FILE" | sed -e 's#_#-#g'`" >> "$(ROOT)/doc/database/tables.sgml" ; \
@@ -183,7 +184,7 @@ docbook_clean:
modules:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/modules/$$FILE/" \
+ --stringparam dir "$(ROOT)/modules_k/$$FILE/" \
--stringparam prefix "$$FILE" \
--stringparam db "modules" \
$(MODULES_H_XSL) kamailio-"$$FILE".xml ; \
@@ -191,7 +192,7 @@ modules:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/modules/$$FILE/" \
+ --stringparam dir "$(ROOT)/modules_k/$$FILE/" \
--stringparam prefix "$$FILE" \
--stringparam db "modules" \
$(MODULES_C_XSL) kamailio-"$$FILE".xml ; \
@@ -206,7 +207,7 @@ modules_clean:
dbdoc:
for FILE in $(TABLES); do \
XML_CATALOG_FILES=$(CATALOG) $(XSLTPROC) $(XSLTPROC_FLAGS) \
- --stringparam dir "$(ROOT)/modules/$$FILE/doc/" \
+ --stringparam dir "$(ROOT)/modules_k/$$FILE/doc/" \
--stringparam prefix "$$FILE" \
--stringparam db "modules" \
$(DBDOC_XSL) kamailio-"$$FILE".xml ; \
More information about the sr-dev
mailing list