-
Notifications
You must be signed in to change notification settings - Fork 5k
Expand file tree
/
Copy pathcreate-database.ts
More file actions
147 lines (127 loc) · 4.28 KB
/
create-database.ts
File metadata and controls
147 lines (127 loc) · 4.28 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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
import * as path from 'path';
import * as dotenv from 'dotenv';
import * as fs from 'fs';
import { ExecFileSyncOptions, execFileSync } from 'child_process';
import { buildAndValidateDatabaseConfig } from './database-config-utils';
import { isEmpty } from 'lodash';
import { populateSampleData } from './populate-sample-db';
async function createDatabaseFromFile(envPath: string): Promise<void> {
const result = dotenv.config({ path: envPath });
if (process.env.PG_DB_OWNER === 'false') {
console.log('Skipping database creation');
return;
}
if (result.error) {
throw result.error;
}
await createDatabase();
}
async function createDatabase(): Promise<void> {
const { value: envVars, error } = buildAndValidateDatabaseConfig();
if (error) {
throw new Error(`Config validation error: ${error.message}`);
}
if (envVars.PG_DB_OWNER === 'false') {
console.log('Skipping database creation');
return;
}
const dbNameFromArg = process.argv[2];
if (dbNameFromArg) {
await createDb(envVars, dbNameFromArg);
} else {
await createDb(envVars, envVars.PG_DB);
await createTooljetDb(envVars, envVars.TOOLJET_DB);
createSampleDb(envVars, envVars.SAMPLE_DB);
populateSampleData(envVars);
}
}
function checkCommandAvailable(command: string) {
try {
const options = { env: process.env } as ExecFileSyncOptions;
execFileSync('which', [command], options);
} catch {
throw `Error: ${command} not found. Make sure it's installed and available in the system's PATH.`;
}
}
function executeCreateDb(host: string, port: string, user: string, password: string, dbName: string) {
const env = Object.assign({}, process.env, { PGPASSWORD: password });
const createDbArgs = ['-h', host, '-p', port, '-U', user, dbName];
const options = { env, stdio: 'pipe' } as ExecFileSyncOptions;
execFileSync('createdb', createDbArgs, options);
}
async function createDb(envVars, dbName): Promise<void> {
if (isEmpty(dbName)) {
throw new Error('Database name cannot be empty');
}
try {
executeCreateDb(envVars.PG_HOST, envVars.PG_PORT, envVars.PG_USER, envVars.PG_PASS, dbName);
console.log(`Created database ${dbName}\n`);
} catch (error) {
if (error.message.includes(`database "${dbName}" already exists`)) {
console.log(`Using Application database\nPG_DB: ${dbName}\nPG_HOST: ${envVars.PG_HOST}\n`);
} else {
throw error;
}
}
}
async function createTooljetDb(envVars, dbName): Promise<void> {
if (isEmpty(dbName)) {
throw new Error('Database name cannot be empty');
}
if (envVars.PG_DB === dbName)
throw new Error(`The name of the App database and the ToolJet database must not be identical.`);
try {
executeCreateDb(
envVars.TOOLJET_DB_HOST,
envVars.TOOLJET_DB_PORT,
envVars.TOOLJET_DB_USER,
envVars.TOOLJET_DB_PASS,
dbName
);
} catch (error) {
if (error.message.includes(`database "${dbName}" already exists`)) {
console.log(`Using Tooljet database\nTOOLJET_DB: ${dbName}\nTOOLJET_DB_HOST: ${envVars.TOOLJET_DB_HOST}\n`);
} else {
throw error;
}
}
}
// eslint-disable-next-line @typescript-eslint/no-unused-vars
async function createSampleDb(envVars, dbName): Promise<void> {
if (isEmpty(dbName)) {
throw new Error('Database name cannot be empty');
}
try {
executeCreateDb(
envVars.SAMPLE_PG_DB_HOST,
envVars.SAMPLE_PG_DB_PORT,
envVars.SAMPLE_PG_DB_USER,
envVars.SAMPLE_PG_DB_PASS,
dbName
);
} catch (error) {
if (error.message.includes(`database "${dbName}" already exists`)) {
console.log(
`Already present Sample database\n${dbName}\n HOST: ${envVars.SAMPLE_PG_DB_HOST}\n PORT: ${envVars.SAMPLE_PG_DB_PORT}`
);
} else {
throw error;
}
}
}
try {
checkCommandAvailable('createdb');
const nodeEnvPath = path.resolve(process.cwd(), process.env.NODE_ENV === 'test' ? '../.env.test' : '../.env');
const fallbackPath = path.resolve(process.cwd(), '../.env');
if (fs.existsSync(nodeEnvPath)) {
createDatabaseFromFile(nodeEnvPath);
} else if (fs.existsSync(fallbackPath)) {
createDatabaseFromFile(fallbackPath);
} else {
console.log('Picking up config from the environment');
createDatabase();
}
} catch (error) {
console.error(error);
process.exit(1);
}