[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue-appserver/samples setup-mysql.sh setup-pgs...
From: |
Reinhard Mueller |
Subject: |
gnue-appserver/samples setup-mysql.sh setup-pgs... |
Date: |
Wed, 10 Sep 2003 15:09:30 -0400 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue-appserver/samples setup-mysql.sh setup-pgs...,
Reinhard Mueller <=