Geolocation-IP/bdd.js at main · AndreasCottet/Geolocation-IP · GitHub

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
import { Sequelize, DataTypes } from 'sequelize';
const sequelize = new Sequelize('sqlite:./db/db.db')

export const IP = sequelize.define('IP', {
    query: {
        type: DataTypes.STRING
    },
    countryCode: {
        type: DataTypes.STRING
    },
    country: {
        type: DataTypes.STRING
    },
    region: {
        type: DataTypes.STRING
    },
    regionName: {
        type: DataTypes.STRING
    },
    city: {
        type: DataTypes.STRING
    },
    zip: {
        type: DataTypes.STRING
    },
    lat: {
        type: DataTypes.DOUBLE
    },
    lon: {
        type: DataTypes.DOUBLE
    },
    timezone: {
        type: DataTypes.STRING
    },
    isp: {
        type: DataTypes.STRING
    },
    org: {
        type: DataTypes.STRING,
    },
    as: {
        type: DataTypes.STRING,
    },
    continent: {
        type: DataTypes.STRING,
    },
    continentCode: {
        type: DataTypes.STRING,
    },
    district: {
        type: DataTypes.STRING,
    },
    asname: {
        type: DataTypes.STRING,
    },
    reverse: {
        type: DataTypes.STRING,
    },
    mobile: {
        type: DataTypes.BOOLEAN,
    },
    proxy: {
        type: DataTypes.BOOLEAN,
    },
    hosting: {
        type: DataTypes.BOOLEAN,
    },
});

export async function initBDD() {
    try {
        await sequelize.authenticate();
        console.log('Connexion à la base de données réussie !');

        await sequelize.sync({ force: true });
        console.log("Base de données créé avec succès !")
    } catch (error) {
        console.error('Unable to connect to the database:', error);
    }
}