0RbNkjzW

1const mysql = require('mysql');
2const connection = mysql.createConnection({
3  host     : 'localhost',
4  port     : 3306,
5  user     : 'root',
6  password : '',
7  database : 'clientes'
8});
9
10connection.connect(function(err){
11    if(err) {
12        return console.log(err);
13    } else {
14
15        createTable(connection);
16
17    }
18    
19});
20
21function createTable(conn) {
22
23    const sql = "CREATE TABLE IF NOT EXISTS Clientes (\n"+
24                "ID int NOT NULL AUTO_INCREMENT,\n"+
25                "Nome varchar(150) NOT NULL,\n"+
26                "Email varchar(150) NOT NULL,\n"+
27                "Endereço varchar(150) NOT NULL,\n"+
28                "Telefone varchar(150) NOT NULL,\n"+
29                "CPF char(11) NOT NULL,\n"+
30                "PRIMARY KEY (ID)\n"+
31                ");";
32    
33    conn.query(sql, function (error, results, fields){
34
35        if(error) {
36            return console.log(err);
37        } else {
38            console.log('criou a tabela!');
39            addCliente(conn);
40        }
41        
42    });
43}
44
45function addCliente(conn){
46  const sql = "INSERT INTO Clientes(Nome,CPF) VALUES ?";
47  const values = [
48        ['teste1', '12345678901'],
49        ['teste1', '09876543210'],
50        ['teste3', '12312312399']
51      ];
52    conn.query(sql, [values], function (error, results, fields){
53          if(error) {
54              return console.log(error);
55          } else {
56            console.log('adicionou registros!');
57            exibirClientes(conn);
58          }
59      });
60}
61
62function exibirClientes(conn) {
63
64    conn.query("SELECT * FROM Clientes", function (error, result, fields) {
65        if (error) {
66            return console.log(error);
67        } else {
68            for(var i = 0; i < result.length; i ++) {
69                console.log(result[i].Nome);
70            }
71            conn.end();
72        }
73        
74    });
75
76}