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
92
93
94
95
96
97
98
99
|
## ----------------------------------------------------------------------------
## --
## GNADE : GNu Ada Database Environment --
## --
## Filename : $Source: /cvsroot/gnade/gnade/samples/sample_db/Makefile.postgres,v $
## Description : Makefile for the PostgreSQL sample database
## Author : Juergen Pfeifer <juergen.pfeifer@gmx.net>
## Created On : 03-Jan-2001
## Last Modified By: $Author: merdmann $
## Last Modified On: $Date: 2003/04/05 07:00:56 $
## Status : $State: Exp $
##
## Copyright (C) 2000-2001
##
## GNADE is copyrighted by the persons and institutions enumerated in the --
## AUTHORS file. This file is located in the root directory of the --
## GNADE distribution. --
## --
## GNADE is free software; you can redistribute it and/or modify it under --
## terms of the GNU General Public License as published by the Free Soft- --
## ware Foundation; either version 2, or (at your option) any later ver- --
## sion. GNAT is distributed in the hope that it will be useful, but WITH- --
## OUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY --
## or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License --
## for more details. You should have received a copy of the GNU General --
## Public License distributed with GNAT; see file COPYING. If not, write --
## to the Free Software Foundation, 59 Temple Place - Suite 330, Boston, --
## MA 02111-1307, USA. --
## --
## As a special exception, if other files instantiate generics from --
## GNADE Ada units, or you link GNADE Ada units or libraries with other --
## files to produce an executable, these units or libraries do not by --
## itself cause the resulting executable to be covered by the GNU --
## General Public License. This exception does not however invalidate --
## any other reasons why the executable file might be covered by the --
## GNU Public License. --
## --
## GNADE is implemented to work with GNAT, the GNU Ada compiler. --
## --
## ----------------------------------------------------------------------------
##
## Functional Description
## ======================
## This makefile creates the PostgreSQL sample database used in the
## various GNADE samples and tests. The database is populated with
## sample data.
##
## This targets have to be executed as unix user postgres.
##
## createuser - create a new data base user
## removeuser - remove the user
##
## createdb - add the data base
## removedb - remove the data base
##
## Restrictions
## ============
## The user running this makefile must have proper PostgreSQL rights to be
## able to delete the database, create a new one and to create the demo
## user.
## The createuser and deleteuser has to be executed as postgres superuser.
##
## References
## ==========
##
sinclude ../conf.local
sinclude ../../make.conf
##
## Configure a new data base user
##
##
createuser:
su - postgres -c "createuser --createdb --no-adduser $(DBUSER)"
##
## Remove the user from the data base
##
removeuser:
dropuser $(DBUSER)
##
## create a database
##
createdb: .database
.database : $(SAMPLEDB).postgres.sql
-dropdb $(SAMPLEDB) 2>/dev/null
createdb $(SAMPLEDB)
psql $(SAMPLEDB) < $(SAMPLEDB).postgres.sql
@touch .database
##
## remove the data base
##
removedb ::
-dropdb $(SAMPLEDB) 2>/dev/null
rm -f .database
|
