extraccionDatos/servicioMssql.ts at develop · condorpiedra/extraccionDatos · 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
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 * as sql from 'mssql';
import {libString} from './libString'


export class servicioMssql {

    obtenerConexion(usuario, password, server, db) {
        let connection = {
            user: usuario,
            password: password,
            server: server,
            database: db,
            stream: true,
        };
        return connection;

    }

    obtenerDatosSql(inicio: number, fin: number, usuario, password, server, db, consulta) {
        var connection = {
            user: usuario,
            password: password,
            server: server,
            database: db,
            //connectionTimeout: config.connectionTimeout,
            requestTimeout: 190000,
            stream: true,
        };
        var listaRegistros = [];
        console.log("Conexion", connection);

        return new Promise((resolve, reject) => {
            sql.connect(connection, function(err) {
                if (err) {
                    console.log("Error de Conexión", err);
                    reject(err);
                }

                var request = new sql.Request();
                request.stream = true;
                request.input('inicio', sql.VarChar(20), inicio.toString());
                request.input('fin', sql.VarChar(20), fin.toString());
                request.query(consulta);
                // Puede ser una consulta a una vista que tenga toda la información

                request.on('row', function(row) {
                    // Emitted for each row in a recordset
                    listaRegistros.push(row);
                });

                request.on('error', function(err) {
                    // May be emitted multiple times
                });

                request.on('done', function(affected) {
                    // Always emitted as the last one
                    console.log(listaRegistros.length);
                    sql.close();
                    resolve(listaRegistros);
                });

            })
            sql.on('error', function(err) {
                console.log("Error de conexión", err);
                reject(err);
            })
        })  //Fin Promise

    }

    obtenerDatosSql2(usuario, password, server, db, consulta) {
        var connection = {
            user: usuario,
            password: password,
            server: server,
            database: db,
            //connectionTimeout: config.connectionTimeout,
            requestTimeout: 190000,
            stream: true,
          //  applicationIntent: 'readOnly'
        };
        var listaRegistros = [];
        console.log("Conexion", connection);

        return new Promise((resolve, reject) => {
            sql.connect(connection, function(err) {
                if (err) {
                    console.log("Error de Conexión", err);
                    reject(err);
                }

                var request = new sql.Request();
                request.stream = true;
                request.query(consulta);
                // Puede ser una consulta a una vista que tenga toda la información

                request.on('row', function(row) {
                    // Emitted for each row in a recordset
                    listaRegistros.push(row);
                });

                request.on('error', function(err) {
                    // May be emitted multiple times
                });

                request.on('done', function(affected) {
                    // Always emitted as the last one
                    console.log(listaRegistros.length);
                    sql.close();
                    resolve(listaRegistros);
                });

            })
            sql.on('error', function(err) {
                console.log("Error de conexión", err);
                reject(err);
            })
        })  //Fin Promise

    }

    obtenerFecha(fechaStr) {
        let numbers = fechaStr.match(/\d+/g);
        let date = new Date(numbers[2], numbers[1] - 1, numbers[0]);
        return date;

    }
}