hfyQrP4S

1C:UsersAlejandroDocumentsProyectosexpressnode_modulessqlite3libbindingelectron-v1.4-win32-ia32node_sqlite3.node
2	
3const express = require('./resources/express')
4const electron = require('electron')
5
6// Module to control application life.
7const app = electron.app
8
9// Module to create native browser window.
10const BrowserWindow = electron.BrowserWindow
11
12const path = require('path')
13const url = require('url')
14
15// Keep a global reference of the window object, if you don't, the window will be closed automatically when the JavaScript object is garbage collected.
16
17let mainWindow 
18
19function createWindow () {
20 // Create the browser window.
21 mainWindow = new BrowserWindow({width: 800, height: 600})
22 // and load the index.html of the app.
23 mainWindow.loadURL('http://localhost:8080/')
24
25// Emitted when the window is closed.
26
27mainWindow.on('closed', function () {
28 console.log('app server is closing')
29 express.closeServer()
30 mainWindow = null
31 })
32}
33	
34const http = require('http')
35const express = require('express')
36const dbmanager = require('./dbmanager.js')
37
38app = express()
39
40app.set('view engine', 'pug')
41
42app.get('/',function(request, response){
43 console.log('server started :D')
44 response.end()
45})
46
47app.get('/checktable',function(request, response){
48 dbmanager.createTable()
49 response.redirect('/receive')
50})
51
52app.get('/receive',function(request, response){
53 dbmanager.selectAll(function(err,data){
54  data.forEach(function(row){
55   console.log(row.id + " " + row.name + "Edad: " + row.age)
56  })
57 response.render('index', { title: 'Usuario', message: data[0].name + " " + data[0].last })
58 response.end()
59 })
60})
61
62var server = http.createServer(app).listen(8080)
63
64var serverManager = {}
65
66serverManager.closeServer = function(){// This executes
67 console.log('This is executing')
68 console.log('Server should close now')
69 server.close()
70}
71
72module.exports = serverManager
73	
74var sqlite3 = require('sqlite3').verbose()
75var db = new sqlite3.Database('memory')
76
77var queryManager = {}
78
79queryManager.createTable = function(){
80 db.run("CREATE TABLE IF NOT EXISTS students (id int, name TEXT,last TEXT, age int)")
81}
82
83queryManager.deleteTable = function(){
84 db.run('DROP TABLE students')
85}
86
87queryManager.insertStudent = function(student){
88 var stmt = db.prepare("INSERT INTO students VALUES (?,?,?,?)")
89 stmt.run(student.id,student.name,student.last,student.age)
90 stmt.finalize()
91 console.log('Insert Successful')
92}
93
94queryManager.selectAll = function(callback){
95 db.all('SELECT * FROM students', function(err,rows){
96  if(err)
97  {
98   throw err;
99  }
100  else
101  {
102   callback(null, rows);
103  }
104 })
105}
106
107module.exports= queryManager
108	
109html
110  head
111 title= title
112body
113 table#table
114 h1= message
115	
116'C:UsersAlejandroDocumentsProyectosexpressnode_modulessqlite3libbindingelectron-v1.4-win32-ia32node_sqlite3.node'