-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinstallDatabases.sh
More file actions
executable file
·91 lines (63 loc) · 2.75 KB
/
installDatabases.sh
File metadata and controls
executable file
·91 lines (63 loc) · 2.75 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
#!/bin/sh
# TODO:
#
# Should I have a "-force" option? When this is present, and the database exists, delete and recreate the database.
# Otherwise, should the install do nothing if the database exists? Or echo a warning and do nothing?
db_home=/Developer/Examples/JavaWebObjects/Databases
db_lib=$db_home/db-derby-10.3.2.1-bin/lib
if [ ! -d $db_lib ]; then
echo "\nERROR: Cannot find Derby database files at \"$db_lib\".\n"
echo $usage"\n"
exit 1
fi
if [ ! -f $db_home/movies_create.sql ]; then
echo "\nERROR: Cannot find example database import files at, for example, \"$db_home/movies_create.sql\".\n"
echo $usage"\n"
exit 1
fi
usage="Usage: installDatabases <username>"
if [ `id -u` != 0 ]; then
echo "\nERROR: Please run this script as root.\n"
echo $usage"\n"
exit 1
fi
user=$1
if [ "$user" = "" ]; then
echo "\nERROR: Please give a username as a parameter.\n"
echo $usage"\n"
exit 1
fi
data_home=/Users/$user/Library/Databases/derby-10.3.2.1
/bin/mkdir -p $data_home
if [ "$JAVA_HOME" = "" ]; then
java="/usr/bin/java"
else
java="$JAVA_HOME/bin/java"
fi
/bin/rm -rf $data_home/data
out=/tmp/derby_$$.log
/usr/bin/touch $out
opts="-classpath $db_lib/derby.jar:$db_lib/derbytools.jar -Dderby.system.home=$data_home/data"
$java $opts org.apache.derby.tools.ij < $db_home/bug_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/bug_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/discussion_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/discussion_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/inherit_horizontal_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/inherit_horizontal_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/inherit_singletable_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/inherit_singletable_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/inherit_vertical_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/inherit_vertical_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/movies_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/movies_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/petstore_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/petstore_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/realestate_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/realestate_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/school_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/school_insert.sql
$java $opts org.apache.derby.tools.ij < $db_home/vendor_create.sql
$java $opts org.apache.derby.tools.ij < $db_home/vendor_insert.sql
chown -R $user $data_home
$java $opts org.apache.derby.tools.sysinfo
echo "Ok"