gnue-appserver/samples setup-mysql.sh setup-pgs...

[Reinhard Mueller]

CVSROOT:        /cvsroot/gnue
Module name:    gnue-appserver
Branch:         
Changes by:     Reinhard Mueller <address@hidden>       03/09/10 15:09:30

Modified files:
        samples        : setup-mysql.sh setup-pgsql.sh 

Log message:
        Use .gsd-created sql scripts in setup scripts.

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-appserver/samples/setup-mysql.sh.diff?tr1=1.1&tr2=1.2&r1=text&r2=text
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-appserver/samples/setup-pgsql.sh.diff?tr1=1.9&tr2=1.10&r1=text&r2=text

Patches:
Index: gnue-appserver/samples/setup-mysql.sh
diff -c gnue-appserver/samples/setup-mysql.sh:1.1 
gnue-appserver/samples/setup-mysql.sh:1.2
*** gnue-appserver/samples/setup-mysql.sh:1.1   Sat Aug 16 19:53:23 2003
--- gnue-appserver/samples/setup-mysql.sh       Wed Sep 10 15:09:30 2003
***************
*** 2,46 ****
  # Set up sample database for MySQL
  # The current user must have permission to create databases
  
! mysql -p << EOF
! create database gnue;
! Create Table gnue_class (gnue_id varchar(32) NULL, gnue_module varchar(32) 
NULL, gnue_name varchar(35) NULL, gnue_comment varchar(70) NULL);
! Create Table gnue_module (gnue_id varchar(32) NULL, gnue_name varchar(35) 
NULL, gnue_comment varchar(70) NULL);
! Create Table gnue_property (gnue_id varchar(32) NULL, gnue_class varchar(32) 
NULL, gnue_module varchar(32) NULL, gnue_name varchar(35) NULL, gnue_type 
varchar(35) NULL, gnue_length integer NULL, gnue_scale smallint NULL, 
gnue_comment varchar(70) NULL);
! Insert into gnue_module values ('00000000000000000000000000000000', 'gnue', 
'GNU Enterprise System Module');
! Insert into gnue_class values ('00000000000000000000000000000010', 
'00000000000000000000000000000000', 'module', 'GNU Enterprise Business Object 
Module');
! Insert into gnue_class values ('00000000000000000000000000000020', 
'00000000000000000000000000000000', 'class', 'GNU Enterprise Business Object 
Class');
! Insert into gnue_class values ('00000000000000000000000000000030', 
'00000000000000000000000000000000', 'property', 'GNU Enterprise Business Object 
Property');
! Insert into gnue_property values ('00000000000000000000000000000011', 
'00000000000000000000000000000010', '00000000000000000000000000000000', 'id', 
'id', '0', '0', 'Object ID');
! Insert into gnue_property values ('00000000000000000000000000000012', 
'00000000000000000000000000000010', '00000000000000000000000000000000', 'name', 
'string', '35', '0', 'Name');
! Insert into gnue_property values ('00000000000000000000000000000013', 
'00000000000000000000000000000010', '00000000000000000000000000000000', 
'comment', 'string', '70', '0', 'Comment');
! Insert into gnue_property values ('00000000000000000000000000000021', 
'00000000000000000000000000000020', '00000000000000000000000000000000', 'id', 
'id', '0', '0', 'Object ID');
! Insert into gnue_property values ('00000000000000000000000000000022', 
'00000000000000000000000000000020', '00000000000000000000000000000000', 
'module', 'gnue_module', '0', '0', 'Module that defined this class');
! Insert into gnue_property values ('00000000000000000000000000000023', 
'00000000000000000000000000000020', '00000000000000000000000000000000', 'name', 
'string', '35', '0', 'Classname without modulename');
! Insert into gnue_property values ('00000000000000000000000000000024', 
'00000000000000000000000000000020', '00000000000000000000000000000000', 
'comment', 'string', '70', '0', 'Comment');
! Insert into gnue_property values ('00000000000000000000000000000031', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 'id', 
'id', '0', '0', 'Object ID');
! Insert into gnue_property values ('00000000000000000000000000000032', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 
'class', 'gnue_class', '0', '0', 'Class the property belongs to');
! Insert into gnue_property values ('00000000000000000000000000000033', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 
'module', 'gnue_module', '0', '0', 'Module that defined this property');
! Insert into gnue_property values ('00000000000000000000000000000034', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 'name', 
'string', '35', '0', 'Propertyname without modulename');
! Insert into gnue_property values ('00000000000000000000000000000035', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 'type', 
'string', '35', '0', 'Data type');
! Insert into gnue_property values ('00000000000000000000000000000036', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 
'length', 'number', '6', '0', 'Data length');
! Insert into gnue_property values ('00000000000000000000000000000037', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 
'scale', 'number', '4', '0', 'Scale for numeric properties');
! Insert into gnue_property values ('00000000000000000000000000000038', 
'00000000000000000000000000000030', '00000000000000000000000000000000', 
'comment', 'string', '70', '0', 'Comment');
! Create Table gnue_useraccess (gnue_id varchar(32) NULL, gnue_username 
varchar(20) NULL, gnue_password varchar(20) NULL, gnue_accesslist varchar(100) 
NULL);
! Insert into gnue_class values ('00000000000000000000000000000060', 
'00000000000000000000000000000000', 'useraccess', 'GNU Enterprise User 
Authentication');
! Insert into gnue_property values ('00000000000000000000000000000061', 
'00000000000000000000000000000060', '00000000000000000000000000000000', 'id', 
'id', '0', '0', 'Object ID');
! Insert into gnue_property values ('00000000000000000000000000000062', 
'00000000000000000000000000000060', '00000000000000000000000000000000', 
'username', 'string', '20', '0', 'Username');
! Insert into gnue_property values ('00000000000000000000000000000063', 
'00000000000000000000000000000060', '00000000000000000000000000000000', 
'password', 'string', '70', '0', 'Password');
! Insert into gnue_property values ('00000000000000000000000000000063', 
'00000000000000000000000000000060', '00000000000000000000000000000000', 
'accesslist', 'string', '100', '0', 'List of classes with access allowed');
! Create Table address_person (gnue_id varchar(32) NULL, address_name 
varchar(35) NULL, address_street varchar(35) NULL, address_zip varchar(17) 
NULL, address_city varchar(35) NULL);
! Insert into gnue_module values ('00000000000000000000000000001000', 
'address', 'Address Management');
! Insert into gnue_class values ('00000000000000000000000000001010', 
'00000000000000000000000000001000', 'person', 'Person');
! Insert into gnue_property values ('00000000000000000000000000001011', 
'00000000000000000000000000001010', '00000000000000000000000000000000', 'id', 
'id', '0', '0', 'Object ID');
! Insert into gnue_property values ('00000000000000000000000000001011', 
'00000000000000000000000000001010', '00000000000000000000000000001000', 'name', 
'string', '35', '0', 'Name of the person');
! Insert into gnue_property values ('00000000000000000000000000001011', 
'00000000000000000000000000001010', '00000000000000000000000000001000', 
'street', 'string', '35', '0', 'Street where the person lives');
! Insert into gnue_property values ('00000000000000000000000000001011', 
'00000000000000000000000000001010', '00000000000000000000000000001000', 'zip', 
'string', '35', '0', 'Zip code of the city where the person lives');
! Insert into gnue_property values ('00000000000000000000000000001011', 
'00000000000000000000000000001010', '00000000000000000000000000001000', 'city', 
'string', '35', '0', 'City where the person lives');
! Insert into address_person values ('James T. Kirk', 'Enterprise Road 17', 
'2002', 'Gnutown');
! Insert into gnue_useraccess values ('00000000000000000000001000000001', 
'test', 'test', 'address_person');
! Insert into gnue_useraccess values ('00000000000000000000001000000002', 
'hacker', 'secret', 'address_person');
! EOF
--- 2,11 ----
  # Set up sample database for MySQL
  # The current user must have permission to create databases
  
! if [ ! -f pgsql/full.sql ]; then
!   make mysql
! fi
! 
! echo "create database gnue;" | mysql -p
! 
! mysql -p < mysql/full.sql
Index: gnue-appserver/samples/setup-pgsql.sh
diff -c gnue-appserver/samples/setup-pgsql.sh:1.9 
gnue-appserver/samples/setup-pgsql.sh:1.10
*** gnue-appserver/samples/setup-pgsql.sh:1.9   Sat Aug 16 13:07:16 2003
--- gnue-appserver/samples/setup-pgsql.sh       Wed Sep 10 15:09:30 2003
***************
*** 2,467 ****
  # Set up sample database for PostgreSQL
  # The current user must have permission to create databases
  
! createdb gnue
! createuser gnue
! psql gnue << EOF
! 
! -- 
============================================================================
! -- Class Repository - TODO: Should be done by classrep
! -- 
============================================================================
! 
! create table gnue_module
! (
!   gnue_id      character         (32),
!   gnue_name    character varying (35),
!   gnue_comment character varying (70)
! );
! 
! create table gnue_class
! (
!   gnue_id      character         (32),
!   gnue_module  character         (32),
!   gnue_name    character varying (35),
!   gnue_comment character varying (70)
! );
! 
! create table gnue_property
! (
!   gnue_id      character         (32),
!   gnue_class   character         (32),
!   gnue_module  character         (32),
!   gnue_name    character varying (35),
!   gnue_type    character varying (35),
!   gnue_length  numeric           ( 6),
!   gnue_scale   numeric           ( 4),
!   gnue_comment character varying (70)
! );
! 
! insert into gnue_module values
! (
!   '00000000000000000000000000000000',
!   'gnue',
!   'GNU Enterprise System Module'
! );
! 
! -- 
----------------------------------------------------------------------------
! -- Business Object Module
! -- 
----------------------------------------------------------------------------
! 
! insert into gnue_class values
! (
!   '00000000000000000000000000000010',
!   '00000000000000000000000000000000',
!   'module',
!   'GNU Enterprise Business Object Module'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000011',
!   '00000000000000000000000000000010',
!   '00000000000000000000000000000000',
!   'id',
!   'id',
!   '0',
!   '0',
!   'Object ID'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000012',
!   '00000000000000000000000000000010',
!   '00000000000000000000000000000000',
!   'name',
!   'string',
!   '35',
!   '0',
!   'Name'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000013',
!   '00000000000000000000000000000010',
!   '00000000000000000000000000000000',
!   'comment',
!   'string',
!   '70',
!   '0',
!   'Comment'
! );
! 
! -- 
----------------------------------------------------------------------------
! -- Business Object Class
! -- 
----------------------------------------------------------------------------
! 
! insert into gnue_class values
! (
!   '00000000000000000000000000000020',
!   '00000000000000000000000000000000',
!   'class',
!   'GNU Enterprise Business Object Class'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000021',
!   '00000000000000000000000000000020',
!   '00000000000000000000000000000000',
!   'id',
!   'id',
!   '0',
!   '0',
!   'Object ID'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000022',
!   '00000000000000000000000000000020',
!   '00000000000000000000000000000000',
!   'module',
!   'gnue_module',
!   '0',
!   '0',
!   'Module that defined this class'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000023',
!   '00000000000000000000000000000020',
!   '00000000000000000000000000000000',
!   'name',
!   'string',
!   '35',
!   '0',
!   'Classname without modulename'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000024',
!   '00000000000000000000000000000020',
!   '00000000000000000000000000000000',
!   'comment',
!   'string',
!   '70',
!   '0',
!   'Comment'
! );
! 
! -- 
----------------------------------------------------------------------------
! -- Business Object Property
! -- 
----------------------------------------------------------------------------
! 
! insert into gnue_class values
! (
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'property',
!   'GNU Enterprise Business Object Property'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000031',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'id',
!   'id',
!   '0',
!   '0',
!   'Object ID'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000032',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'class',
!   'gnue_class',
!   '0',
!   '0',
!   'Class the property belongs to'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000033',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'module',
!   'gnue_module',
!   '0',
!   '0',
!   'Module that defined this property'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000034',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'name',
!   'string',
!   '35',
!   '0',
!   'Propertyname without modulename'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000035',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'type',
!   'string',
!   '35',
!   '0',
!   'Data type'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000036',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'length',
!   'number',
!   '6',
!   '0',
!   'Data length'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000037',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'scale',
!   'number',
!   '4',
!   '0',
!   'Scale for numeric properties'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000038',
!   '00000000000000000000000000000030',
!   '00000000000000000000000000000000',
!   'comment',
!   'string',
!   '70',
!   '0',
!   'Comment'
! );
  
! -- 
============================================================================
! -- Authentication and Trigger Test Stuff - TODO: Remove this
! -- 
============================================================================
! 
! -- 
----------------------------------------------------------------------------
! -- useraccess
! -- 
----------------------------------------------------------------------------
! 
! insert into gnue_class values
! (
!   '00000000000000000000000000000060',
!   '00000000000000000000000000000000',
!   'useraccess',
!   'GNU Enterprise User Authentication'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000061',
!   '00000000000000000000000000000060',
!   '00000000000000000000000000000000',
!   'id',
!   'id',
!   '0',
!   '0',
!   'Object ID'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000062',
!   '00000000000000000000000000000060',
!   '00000000000000000000000000000000',
!   'username',
!   'string',
!   '20',
!   '0',
!   'Username'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000062',
!   '00000000000000000000000000000060',
!   '00000000000000000000000000000000',
!   'password',
!   'string',
!   '20',
!   '0',
!   'Password'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000000063',
!   '00000000000000000000000000000060',
!   '00000000000000000000000000000000',
!   'accesslist',
!   'string',
!   '255',
!   '0',
!   'List of classes with access allowed'
! );
! 
! create table gnue_useraccess 
! ( 
!   gnue_id character          (32),
!   gnue_username character varying (20),
!   gnue_password character varying (20),
!   gnue_accesslist text
! );
! insert into gnue_useraccess values 
('00000000000000000000000010000001','test','test','address_person');
! insert into gnue_useraccess values 
('00000000000000000000000010000002','hacker','secret','address_person');
! 
! 
! create table appserver_pytrigger 
! (
!    gnue_id character      (32),
!    name character varying(30),
!    event character varying(30),
!    code text
! );
! 
! insert into appserver_pytrigger values ('testtrigger1',
! 'person:pre_new_list', 'print "TestTrigger 1 ausgefuehrt"');
! 
! insert into appserver_pytrigger values ('testtrigger2',
! 'person:pre_first_inst', 'print "TestTrigger 2 ausgefuehrt"');
! 
! insert into appserver_pytrigger values ('person:checkAreaRichness',
! 'person:checkAreaRichness','print "standard"');
! 
! -- 
============================================================================
! -- Address Module - TODO: Should be imported via XML into Appserver
! -- 
============================================================================
! 
! insert into gnue_module values
! (
!   '00000000000000000000000000001000',
!   'address',
!   'Address Management'
! );
! 
! -- 
----------------------------------------------------------------------------
! -- Person
! -- 
----------------------------------------------------------------------------
! 
! insert into gnue_class values
! (
!   '00000000000000000000000000001010',
!   '00000000000000000000000000001000',
!   'person',
!   'Person'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000001011',
!   '00000000000000000000000000001010',
!   '00000000000000000000000000000000',
!   'id',
!   'id',
!   '0',
!   '0',
!   'Object ID'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000001011',
!   '00000000000000000000000000001010',
!   '00000000000000000000000000001000',
!   'name',
!   'string',
!   '35',
!   '0',
!   'Name of the person'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000001011',
!   '00000000000000000000000000001010',
!   '00000000000000000000000000001000',
!   'street',
!   'string',
!   '35',
!   '0',
!   'Street where the person lives'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000001011',
!   '00000000000000000000000000001010',
!   '00000000000000000000000000001000',
!   'zip',
!   'string',
!   '35',
!   '0',
!   'Zip code of the city where the person lives'
! );
! 
! insert into gnue_property values
! (
!   '00000000000000000000000000001011',
!   '00000000000000000000000000001010',
!   '00000000000000000000000000001000',
!   'city',
!   'string',
!   '35',
!   '0',
!   'City where the person lives'
! );
! 
! -- TODO: Should be done by appserver upon import of schema
! 
! create table address_person
! (
!   gnue_id        character         (32),
!   address_name   character varying (35),
!   address_street character varying (35),
!   address_zip    character varying (17),
!   address_city   character varying (35)
! );
! 
! insert into address_person values
! (
!   '00000000000000000000000000001100',
!   'James T. Kirk',
!   'Enterprise Road 17',
!   '2002',
!   'Gnutown'
! );
! 
! insert into address_person values
! (
!   '00000000000000000000000000001101',
!   'Mr. Spock',
!   'Vulc Lane 1',
!   '4711',
!   'Vulcane'
! );
! 
! EOF
--- 2,11 ----
  # Set up sample database for PostgreSQL
  # The current user must have permission to create databases
  
! if [ ! -f pgsql/full.sql ]; then
!   make pgsql
! fi
  
! createuser --createdb --adduser gnue
! createdb gnue
! psql gnue < pgsql/full.sql