-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpopulateDatabase.js
22 lines (21 loc) · 3.73 KB
/
populateDatabase.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('./Commands.db');
//Perform INSERT operation.
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LKHD56FGH','20 RUE DU TEST',2017-04-07,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LFHD56FGH','20 RUE DU TEST',2017-04-01,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LGHD56FGH','20 RUE DU TEST',2017-04-02,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LHHD56FGH','20 RUE DU TEST',2017-04-03,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LIHD56FGH','20 RUE DU TEST',2017-04-04,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LJHD56FGH','20 RUE DU TEST',2017-04-05,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LLHD56FGH','20 RUE DU TEST',2017-04-06,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LMHD56FGH','20 RUE DU TEST',2017-04-07,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LNHD56FGH','20 RUE DU TEST',2017-04-08,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LOHD56FGH','20 RUE DU TEST',2017-04-08,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LPHD56FGH','20 RUE DU TEST',2017-04-08,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LQHD56FGH','20 RUE DU TEST',2017-03-30,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LRHD56FGH','20 RUE DU TEST',2017-03-30,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LSHD56FGH','20 RUE DU TEST',2017-04-07,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id,id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LTHD56FGH','20 RUE DU TEST',2017-04-07,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LUHD56FGH','20 RUE DU TEST',2017-04-07,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LVHD56FGH','20 RUE DU TEST',2017-04-07,NULL,NULL,NULL,NULL)");
db.run("INSERT into Commands(id_command,address,delivery_date,delivery_progress,progress_update_date,error,error_descripion) VALUES ('ER78LWHD56FGH','20 RUE DU TEST',2017-04-07,NULL,NULL,NULL,NULL)");