23 lines
660 B
JavaScript
23 lines
660 B
JavaScript
'use strict'
|
|
// Database Configuration and Initialization
|
|
const sqlite3 = require('sqlite3').verbose()
|
|
const sdb = require('./states.json')
|
|
const cdb = require('./cities.json')
|
|
const { createStmts, insertStmts } = require('../utils/sql.js')
|
|
|
|
const db = new sqlite3.Database(
|
|
'./db/metro_stats.db',
|
|
sqlite3.OPEN_READWRITE | sqlite3.OPEN_CREATE,
|
|
err => {
|
|
if (err) return console.error(err.message)
|
|
console.log('connected to in-memory sqlite database.')
|
|
},
|
|
)
|
|
|
|
db.serialize(() => {
|
|
createStmts.forEach(stmt => db.run(stmt))
|
|
insertStmts.populateStates(sdb, db)
|
|
insertStmts.populateCities(cdb, db)
|
|
})
|
|
|
|
module.exports = db
|