var brain = require('brain.js');
const sqlite3 = require('sqlite3').verbose();
var table = [];



  let db = new sqlite3.Database('./history/binance_0.1.db', sqlite3.OPEN_READWRITE, (err) => {
    if (err) {
      console.error(err.message);
    }
    console.log('Connected to the Crypto database.');
  });

  db.serialize(() => {
    db.each(`SELECT * FROM candles_USDT_BTC`, (err, sql_row) => {
      if (err) {
        console.error(err.message);
      }
      table.push(sql_row);
    });
  });

  db.close((err) => {
    if (err) {
      console.error(err.message);
    }
    console.log('Close the database connection.');
    console.log(table.length);
    return table;
  });


console.log(table);