Dean
/
Bookdata-tools
mirror of https://github.com/BoiseState/bookdata-tools


  
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

	
            CREATE TABLE IF NOT EXISTS stage_status (
    stage_name VARCHAR PRIMARY KEY,
    started_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    finished_at TIMESTAMP NULL,
    stage_key VARCHAR NULL
);

CREATE TABLE IF NOT EXISTS source_file (
    filename VARCHAR NOT NULL PRIMARY KEY,
    reg_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    checksum VARCHAR NOT NULL
);

CREATE TABLE IF NOT EXISTS stage_file (
    stage_name VARCHAR NOT NULL REFERENCES stage_status,
    filename VARCHAR NOT NULL REFERENCES source_file,
    checksum VARCHAR NULL,
    PRIMARY KEY (stage_name, filename)
);

CREATE TABLE IF NOT EXISTS stage_dep (
    stage_name VARCHAR NOT NULL REFERENCES stage_status,
    dep_name VARCHAR NOT NULL REFERENCES stage_status,
    dep_key VARCHAR NULL
);

INSERT INTO stage_status (stage_name, started_at, finished_at, stage_key)
VALUES ('init', NOW(), NOW(), uuid_generate_v4())
ON CONFLICT (stage_name) DO NOTHING;