mfvp9p8F

1onst createInstallation = function() {
2    return new Promise(function (resolve, reject) {
3        const sqlRequest = "CREATE TABLE IF NOT EXISTS installation (" +
4            "numero_de_l_installation TEXT NOT NULL, " +
5            "nom_usuel_de_l_installation TEXT NOT NULL, " +
6            "code_postal TEXT NOT NULL, " +
7            "nom_de_la_commune TEXT NOT NULL, " +
8            "nom_du_lieu_dit TEXT, " +
9            "nom_de_la_voie TEXT, " +
10            "numero_de_la_voie TEXT ," +
11            "PRIMARY KEY (numero_de_l_installation))";
12
13        db.run(sqlRequest,[], (err) => {
14
15            if (err) {
16                console.log(err);
17                reject(err);
18            }
19            else {
20                console.log("Installation créée");
21                resolve(this);
22            }
23        });
24
25    })
26};
27
28const createEquipement = function() {
29    return new Promise(function (resolve, reject) {
30        const sqlRequest = "CREATE TABLE IF NOT EXISTS equipement (" +
31            "numero_de_la_fiche_equipement TEXT NOT NULL," +
32            "numero_de_l_installation TEXT NOT NULL," + 
33            "equipement TEXT NOT NULL, " +
34            "type_d_equipement TEXT NOT NULL, " +
35            "batiment TEXT, " +
36            "PRIMARY KEY (numero_de_la_fiche_equipement)," +
37            "FOREIGN KEY (numero_de_l_installation) REFERENCES installation(numero_de_l_installation))";
38
39        db.run(sqlRequest, [], (err) => {
40
41            if (err) {
42                console.log(err);
43                reject(err);
44            }
45            else {
46                console.log("Equipement créée");
47                resolve(this);
48            }
49
50        });
51
52    });
53};
54const createActivite = function () {
55    return new Promise(function (resolve, reject) {
56        const sqlRequest = "CREATE TABLE IF NOT EXISTS activite (" +
57            "activite_code TEXT NOT NULL," +
58            "activite_libelle TEXT NOT NULL," +
59            "numero_de_la_fiche_equipement TEXT NOT NULL," +
60            "PRIMARY KEY (activite_code, numero_de_la_fiche_equipement)," +
61            "FOREIGN KEY (numero_de_la_fiche_equipement) REFERENCES equipement(numero_de_la_fiche_equipement))";
62        db.run(sqlRequest, [], (err) => {
63
64            if (err) {
65                console.log(err);
66                reject(err);
67            }
68            else {
69                console.log("Activité créée");
70                resolve(this);
71            }
72        });
73
74    });
75};