[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue-appserver/samples sample.gsd Makefile auth...
From: |
Jan Ischebeck |
Subject: |
gnue-appserver/samples sample.gsd Makefile auth... |
Date: |
Sat, 16 Aug 2003 19:53:23 -0400 |
CVSROOT: /cvsroot/gnue
Module name: gnue-appserver
Branch:
Changes by: Jan Ischebeck <address@hidden> 03/08/16 19:53:23
Modified files:
samples : sample.gsd Makefile
Added files:
samples : auth.gsd base.gsd setup-mysql.sh
Log message:
- split database population scripts in 3 parts (base, auth, sample)
- add mysql population script
- update Makefile (sql creation via XSLT)
CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-appserver/samples/auth.gsd?rev=1.1
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-appserver/samples/base.gsd?rev=1.1
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-appserver/samples/setup-mysql.sh?rev=1.1
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-appserver/samples/sample.gsd.diff?tr1=1.3&tr2=1.4&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-appserver/samples/Makefile.diff?tr1=1.4&tr2=1.5&r1=text&r2=text
Patches:
Index: gnue-appserver/samples/Makefile
diff -c gnue-appserver/samples/Makefile:1.4 gnue-appserver/samples/Makefile:1.5
*** gnue-appserver/samples/Makefile:1.4 Sun Jul 28 06:42:41 2002
--- gnue-appserver/samples/Makefile Sat Aug 16 19:53:23 2003
***************
*** 1,39 ****
# this Makefile creates sql scripts for different databases
# at the moment it requires the sablotron XSLT processor
xsltcmd = sabcmd
! xslpath = ../../common/utils/xml2sql/
! src = sample.gsd
!
all: mysql pgsql mssql sybase interbase html
mysql:
! ${xsltcmd} ${xslpath}mysql.xsl ${src} mysql.xml
! ${xsltcmd} ${xslpath}strip.command.xsl mysql.xml mysql.sql
pgsql:
! ${xsltcmd} ${xslpath}pgsql.xsl ${src} pgsql.xml
! ${xsltcmd} ${xslpath}strip.command.xsl pgsql.xml pgsql.sql
mssql:
! ${xsltcmd} ${xslpath}mssql.xsl ${src} mssql.xml
! ${xsltcmd} ${xslpath}strip.command.xsl mssql.xml mssql.sql
sybase:
! ${xsltcmd} ${xslpath}sybase.xsl ${src} sybase.xml
! ${xsltcmd} ${xslpath}strip.command.xsl sybase.xml sybase.sql
interbase:
! ${xsltcmd} ${xslpath}interbase.xsl ${src} interbase.xml
! ${xsltcmd} ${xslpath}strip.command.xsl interbase.xml interbase.sql
!
html:
! ${xsltcmd} ${xslpath}display.xsl ${src} sample.html
setup-pgsql: pgsql
# createdb gnue
! psql gnue < pgsql.sql
! rm pgsql.sql pgsql.xml
clean:
! rm mssql.xml mysql.xml pgsql.xml sybase.xml *.sql sample.html
--- 1,56 ----
# this Makefile creates sql scripts for different databases
# at the moment it requires the sablotron XSLT processor
xsltcmd = sabcmd
! xslpath = ../../gnue-common/utils/xml2sql/
! xslstrip = ${xslpath}strip.command.xsl
! src1 = base.gsd
! src2 = auth.gsd
! src3 = sample.gsd
! out1 = base
! out2 = auth
! out3 = sample
all: mysql pgsql mssql sybase interbase html
mysql:
! ${xsltcmd} ${xslpath}mysql.xsl ${src1} | ${xsltcmd} ${xslstrip} >
mysql-${out1}.sql
! ${xsltcmd} ${xslpath}mysql.xsl ${src2} | ${xsltcmd} ${xslstrip} >
mysql-${out2}.sql
! ${xsltcmd} ${xslpath}mysql.xsl ${src3} | ${xsltcmd} ${xslstrip} >
mysql-${out3}.sql
! cat mysql-${out1}.sql mysql-${out2}.sql mysql-${out3}.sql >
mysql-full.sql
pgsql:
! ${xsltcmd} ${xslpath}pgsql.xsl ${src1} | ${xsltcmd} ${xslstrip} >
pgsql-${out1}.sql
! ${xsltcmd} ${xslpath}pgsql.xsl ${src2} | ${xsltcmd} ${xslstrip} >
pgsql-${out2}.sql
! ${xsltcmd} ${xslpath}pgsql.xsl ${src3} | ${xsltcmd} ${xslstrip} >
pgsql-${out3}.sql
! cat pgsql-${out1}.sql pgsql-${out2}.sql pgsql-${out3}.sql >
pgsql-full.sql
!
mssql:
! ${xsltcmd} ${xslpath}mssql.xsl ${src1} | ${xsltcmd} ${xslstrip} >
mssql-${out1}.sql
! ${xsltcmd} ${xslpath}mssql.xsl ${src2} | ${xsltcmd} ${xslstrip} >
mssql-${out2}.sql
! ${xsltcmd} ${xslpath}mssql.xsl ${src3} | ${xsltcmd} ${xslstrip} >
mssql-${out3}.sql
! cat mssql-${out1}.sql mssql-${out2}.sql mssql-${out3}.sql >
mssql-full.sql
sybase:
! ${xsltcmd} ${xslpath}sybase.xsl ${src1} | ${xsltcmd} ${xslstrip} >
sybase-${out1}.sql
! ${xsltcmd} ${xslpath}sybase.xsl ${src2} | ${xsltcmd} ${xslstrip} >
sybase-${out2}.sql
! ${xsltcmd} ${xslpath}sybase.xsl ${src3} | ${xsltcmd} ${xslstrip} >
sybase-${out3}.sql
! cat sybase-${out1}.sql sybase-${out2}.sql sybase-${out3}.sql >
sybase-full.sql
interbase:
! ${xsltcmd} ${xslpath}interbase.xsl ${src1} | ${xsltcmd} ${xslstrip} >
interbase-${out1}.sql
! ${xsltcmd} ${xslpath}interbase.xsl ${src2} | ${xsltcmd} ${xslstrip} >
interbase-${out2}.sql
! ${xsltcmd} ${xslpath}interbase.xsl ${src3} | ${xsltcmd} ${xslstrip} >
interbase-${out3}.sql
! cat interbase-${out1}.sql interbase-${out2}.sql interbase-${out3}.sql >
interbase-full.sql
!
html:
! ${xsltcmd} ${xslpath}display.xsl ${src1} ${out1}.html
! ${xsltcmd} ${xslpath}display.xsl ${src2} ${out2}.html
! ${xsltcmd} ${xslpath}display.xsl ${src3} ${out3}.html
setup-pgsql: pgsql
# createdb gnue
! psql gnue < pgsql-full.sql
clean:
! rm *.sql ${out1}.html ${out2}.html ${out3}.html
Index: gnue-appserver/samples/sample.gsd
diff -c gnue-appserver/samples/sample.gsd:1.3
gnue-appserver/samples/sample.gsd:1.4
*** gnue-appserver/samples/sample.gsd:1.3 Wed Aug 13 18:44:54 2003
--- gnue-appserver/samples/sample.gsd Sat Aug 16 19:53:23 2003
***************
*** 4,42 ****
<schema title="Appserver example">
<tables>
- <table name="gnue_class">
- <fields>
- <field name="gnue_id" length="32" type="string"/>
- <field name="gnue_module" length="32" type="string"/>
- <field name="gnue_name" length="35" type="string"/>
- <field name="gnue_comment" length="70" type="string"/>
- </fields>
- <constraints/>
- <indexes/>
- </table>
- <table name="gnue_module">
- <fields>
- <field name="gnue_id" length="32" type="string"/>
- <field name="gnue_name" length="35" type="string"/>
- <field name="gnue_comment" length="70" type="string"/>
- </fields>
- <constraints/>
- <indexes/>
- </table>
- <table name="gnue_property">
- <fields>
- <field name="gnue_id" length="32" type="string"/>
- <field name="gnue_class" length="32" type="string"/>
- <field name="gnue_module" length="32" type="string"/>
- <field name="gnue_name" length="35" type="string"/>
- <field name="gnue_type" length="35" type="string"/>
- <field name="gnue_length" length="6" type="number"/>
- <field name="gnue_scale" length="4" type="number"/>
- <field name="gnue_comment" length="70" type="string"/>
- </fields>
- <constraints/>
- <indexes/>
- </table>
<table name="address_person">
<fields>
<field name="gnue_id" length="32" type="string"/>
--- 4,9 ----
***************
*** 50,90 ****
</table>
</tables>
<data>
! <tabledata name="sample_modules" tablename="gnue_module">
<rows>
<row>
- <value>'00000000000000000000000000000000'</value>
- <value>'gnue'</value>
- <value>'GNU Enterprise System Module'</value>
- </row>
- <row>
<value>'00000000000000000000000000001000'</value>
<value>'address'</value>
<value>'Address Management'</value>
</row>
</rows>
</tabledata>
! <tabledata name="sample_classes" tablename="gnue_class">
<rows>
<row>
- <value>'00000000000000000000000000000010'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'module'</value>
- <value>'GNU Enterprise Business Object Module'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000020'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'class'</value>
- <value>'GNU Enterprise Business Object Class'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'property'</value>
- <value>'GNU Enterprise Business Object Property'</value>
- </row>
- <row>
<value>'00000000000000000000000000001010'</value>
<value>'00000000000000000000000000001000'</value>
<value>'person'</value>
--- 17,34 ----
</table>
</tables>
<data>
! <tabledata name="sample_module" tablename="gnue_module">
<rows>
<row>
<value>'00000000000000000000000000001000'</value>
<value>'address'</value>
<value>'Address Management'</value>
</row>
</rows>
</tabledata>
! <tabledata name="sample_class" tablename="gnue_class">
<rows>
<row>
<value>'00000000000000000000000000001010'</value>
<value>'00000000000000000000000000001000'</value>
<value>'person'</value>
***************
*** 95,250 ****
<tabledata name="sample_properties" tablename="gnue_property">
<rows>
<row>
- <value>'00000000000000000000000000000011'</value>
- <value>'00000000000000000000000000000010'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'id'</value>
- <value>'id'</value>
- <value>'0'</value>
- <value>'0'</value>
- <value>'Object ID'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000012'</value>
- <value>'00000000000000000000000000000010'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'name'</value>
- <value>'string'</value>
- <value>'35'</value>
- <value>'0'</value>
- <value>'Name'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000013'</value>
- <value>'00000000000000000000000000000010'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'comment'</value>
- <value>'string'</value>
- <value>'70'</value>
- <value>'0'</value>
- <value>'Comment'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000021'</value>
- <value>'00000000000000000000000000000020'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'id'</value>
- <value>'id'</value>
- <value>'0'</value>
- <value>'0'</value>
- <value>'Object ID'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000022'</value>
- <value>'00000000000000000000000000000020'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'module'</value>
- <value>'gnue_module'</value>
- <value>'0'</value>
- <value>'0'</value>
- <value>'Module that defined this class'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000023'</value>
- <value>'00000000000000000000000000000020'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'name'</value>
- <value>'string'</value>
- <value>'35'</value>
- <value>'0'</value>
- <value>'Classname without modulename'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000024'</value>
- <value>'00000000000000000000000000000020'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'comment'</value>
- <value>'string'</value>
- <value>'70'</value>
- <value>'0'</value>
- <value>'Comment'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000031'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'id'</value>
- <value>'id'</value>
- <value>'0'</value>
- <value>'0'</value>
- <value>'Object ID'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000032'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'class'</value>
- <value>'gnue_class'</value>
- <value>'0'</value>
- <value>'0'</value>
- <value>'Class the property belongs to'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000033'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'module'</value>
- <value>'gnue_module'</value>
- <value>'0'</value>
- <value>'0'</value>
- <value>'Module that defined this property'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000034'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'name'</value>
- <value>'string'</value>
- <value>'35'</value>
- <value>'0'</value>
- <value>'Propertyname without modulename'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000035'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'type'</value>
- <value>'string'</value>
- <value>'35'</value>
- <value>'0'</value>
- <value>'Data type'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000036'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'length'</value>
- <value>'number'</value>
- <value>'6'</value>
- <value>'0'</value>
- <value>'Data length'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000037'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'scale'</value>
- <value>'number'</value>
- <value>'4'</value>
- <value>'0'</value>
- <value>'Scale for numeric properties'</value>
- </row>
- <row>
- <value>'00000000000000000000000000000038'</value>
- <value>'00000000000000000000000000000030'</value>
- <value>'00000000000000000000000000000000'</value>
- <value>'comment'</value>
- <value>'string'</value>
- <value>'70'</value>
- <value>'0'</value>
- <value>'Comment'</value>
- </row>
- <row>
<value>'00000000000000000000000000001011'</value>
<value>'00000000000000000000000000001010'</value>
<value>'00000000000000000000000000000000'</value>
--- 39,44 ----
***************
*** 296,308 ****
</row>
</rows>
</tabledata>
! <tabledata name="sample_persons" tablename="person">
<rows>
<row>
<value>'James T. Kirk'</value>
<value>'Enterprise Road 17'</value>
<value>'2002'</value>
<value>'Gnutown'</value>
</row>
</rows>
</tabledata>
--- 90,118 ----
</row>
</rows>
</tabledata>
! <tabledata name="sample_persons" tablename="address_person">
<rows>
<row>
<value>'James T. Kirk'</value>
<value>'Enterprise Road 17'</value>
<value>'2002'</value>
<value>'Gnutown'</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="sample_accounts" tablename="gnue_useraccess">
+ <rows>
+ <row>
+ <value>'00000000000000000000001000000001'</value>
+ <value>'test'</value>
+ <value>'test'</value>
+ <value>'address_person'</value>
+ </row>
+ <row>
+ <value>'00000000000000000000001000000002'</value>
+ <value>'hacker'</value>
+ <value>'secret'</value>
+ <value>'address_person'</value>
</row>
</rows>
</tabledata>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue-appserver/samples sample.gsd Makefile auth...,
Jan Ischebeck <=