Newer
Older
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
import {readFileSync} from "node:fs";
const matches = {
"01": "Auvergne-Rhône-Alpes",
"02": "Hauts-de-France",
"03": "Auvergne-Rhône-Alpes",
"04": "Provence-Alpes-Côte d'Azur",
"05": "Provence-Alpes-Côte d'Azur",
"06": "Provence-Alpes-Côte d'Azur",
"07": "Auvergne-Rhône-Alpes",
"08": "Grand Est",
"09": "Occitanie",
"10": "Grand Est",
"11": "Occitanie",
"12": "Occitanie",
"13": "Provence-Alpes-Côte d'Azur",
"14": "Normandie",
"15": "Auvergne-Rhône-Alpes",
"16": "Nouvelle-Aquitaine",
"17": "Nouvelle-Aquitaine",
"18": "Centre-Val de Loire",
"19": "Nouvelle-Aquitaine",
"2A": "Corse",
"2B": "Corse",
"21": "Bourgogne-Franche-Comté",
"22": "Bretagne",
"23": "Nouvelle-Aquitaine",
"24": "Nouvelle-Aquitaine",
"25": "Bourgogne-Franche-Comté",
"26": "Auvergne-Rhône-Alpes",
"27": "Normandie",
"28": "Centre-Val de Loire",
"29": "Bretagne",
"30": "Occitanie",
"31": "Occitanie",
"32": "Occitanie",
"33": "Nouvelle-Aquitaine",
"34": "Occitanie",
"35": "Bretagne",
"36": "Centre-Val de Loire",
"37": "Centre-Val de Loire",
"38": "Auvergne-Rhône-Alpes",
"39": "Bourgogne-Franche-Comté",
"40": "Nouvelle-Aquitaine",
"41": "Centre-Val de Loire",
"42": "Auvergne-Rhône-Alpes",
"43": "Auvergne-Rhône-Alpes",
"44": "Pays de la Loire",
"45": "Centre-Val de Loire",
"46": "Occitanie",
"47": "Nouvelle-Aquitaine",
"48": "Occitanie",
"49": "Pays de la Loire",
"50": "Normandie",
"51": "Grand Est",
"52": "Grand Est",
"53": "Pays de la Loire",
"54": "Grand Est",
"55": "Grand Est",
"56": "Bretagne",
"57": "Grand Est",
"58": "Bourgogne-Franche-Comté",
"59": "Hauts-de-France",
"60": "Hauts-de-France",
"61": "Normandie",
"62": "Hauts-de-France",
"63": "Auvergne-Rhône-Alpes",
"64": "Nouvelle-Aquitaine",
"65": "Occitanie",
"66": "Occitanie",
"67": "Grand Est",
"68": "Grand Est",
"69": "Auvergne-Rhône-Alpes",
"70": "Bourgogne-Franche-Comté",
"71": "Bourgogne-Franche-Comté",
"72": "Pays de la Loire",
"73": "Auvergne-Rhône-Alpes",
"74": "Auvergne-Rhône-Alpes",
"75": "Île-de-France",
"76": "Normandie",
"77": "Île-de-France",
"78": "Île-de-France",
"79": "Nouvelle-Aquitaine",
"80": "Hauts-de-France",
"81": "Occitanie",
"82": "Occitanie",
"83": "Provence-Alpes-Côte d'Azur",
"84": "Provence-Alpes-Côte d'Azur",
"85": "Pays de la Loire",
"86": "Nouvelle-Aquitaine",
"87": "Nouvelle-Aquitaine",
"88": "Grand Est",
"89": "Bourgogne-Franche-Comté",
"90": "Bourgogne-Franche-Comté",
"91": "Île-de-France",
"92": "Île-de-France",
"93": "Île-de-France",
"94": "Île-de-France",
"95": "Île-de-France",
"971": "Guadeloupe",
"972": "Martinique",
"973": "Guyane",
"974": "La Réunion",
"976": "Mayotte"
};
const argv = process.argv.slice(2);
if (argv.length !== 1) {
console.error(`Usage : node script.mjs <only-one-argument>`);
process.exit(1);
}
const file = argv[0];
const fileContent = readFileSync(file, {
encoding: "utf8",
flag: "r"
}).split("\n");
let str = `INSERT INTO ma_table(date, value, region, surface) VALUES\n`;
let idx = 0;
for (const line of fileContent.slice(1, fileContent.length - 1)) {
const data = line.split("|");
const date = data[8].split("/").reverse().join("-");
if (data[9] === "Vente" && data[10] !== "" && data[38] !== "" && (data[36] === "Maison" || data[36] === "Appartement")) {
str += `('${date}', ${data[10].replace(",", ".")}, '${matches[data[18]].replace("'", "''")}', ${data[38]})${idx < fileContent.length - 3 ? ",\n" : ";"}`;
}
++idx;
}
console.log(str);