summaryrefslogtreecommitdiffstats
path: root/src/VBox/ValidationKit/testmanager/db/Makefile.kmk
blob: 6808e71e3a424ce7969ddf7fd9b29e166f6d7e6f (plain)
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
# $Id: Makefile.kmk $
## @file
# VirtualBox Validation Kit - Makefile for generating .html from .txt.
#

#
# Copyright (C) 2006-2019 Oracle Corporation
#
# This file is part of VirtualBox Open Source Edition (OSE), as
# available from http://www.virtualbox.org. This file is free software;
# you can redistribute it and/or modify it under the terms of the GNU
# General Public License (GPL) as published by the Free Software
# Foundation, in version 2 as it comes in the "COPYING" file of the
# VirtualBox OSE distribution. VirtualBox OSE is distributed in the
# hope that it will be useful, but WITHOUT ANY WARRANTY of any kind.
#
# The contents of this file may alternatively be used under the terms
# of the Common Development and Distribution License Version 1.0
# (CDDL) only, as it comes in the "COPYING.CDDL" file of the
# VirtualBox OSE distribution, in which case the provisions of the
# CDDL are applicable instead of those of the GPL.
#
# You may elect to license modified versions of this file under the
# terms and conditions of either the GPL or the CDDL or both.
#


# Need proper shell on windows.
DEPTH = ../../../../..
ifneq ($(wildcard $(DEPTH)/Config.kmk),)
 include $(KBUILD_PATH)/header.kmk
else
 VBOX_BLD_PYTHON ?= python
endif


GENERATED_FILES = TestManagerDatabaseComments.pgsql
PSQL := $(firstword $(which $(foreach pgver, 95 94 93 92,psql$(pgver)) ) psql)
PSQL_OPTS = -U postgres --set=ON_ERROR_STOP=1

all: $(GENERATED_FILES)

clean:
	kmk_builtin_rm -f -- $(GENERATED_FILES)


TestManagerDatabaseComments.pgsql: TestManagerDatabaseInit.pgsql gen-sql-comments.py
	LC_ALL=C $(VBOX_BLD_PYTHON) gen-sql-comments.py $< > $@


load-testmanager-db: \
		TestManagerDatabaseInit.pgsql \
		TestManagerDatabaseComments.pgsql \
		../core/useraccount.pgsql \
		../core/testcase.pgsql \
		../core/testbox.pgsql \
		../core/globalresource.pgsql
	@kmk_builtin_echo "Creating testmanager database: For script verification only!"
	$(PSQL) $(PSQL_OPTS) -f TestManagerDatabaseInit.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f TestManagerDatabaseComments.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/useraccount.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/testcase.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/testbox.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/globalresource.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f TestManagerDatabaseDefaultUserAccounts.pgsql

reload-testmanager-db-dunctions: \
		../core/useraccount.pgsql \
		../core/testcase.pgsql \
		../core/testbox.pgsql \
		../core/globalresource.pgsql
	@kmk_builtin_echo "Reloading testmanager database functions"
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/useraccount.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/testcase.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/testbox.pgsql
	$(PSQL) $(PSQL_OPTS) -d testmanager -f ../core/globalresource.pgsql

# Only for prettier graphs:
#	$(PSQL) $(PSQL_OPTS) -d testmanager -f TestManagerDatabaseForeignKeyErHacks.pgsql