var path = require('path');
var getData = require(path.resolve(__dirname, '../..', './data/readFile'))
function recreateTable1(app) {
return new Promise((resolve, reject) => {
app.dataSources.mysqlDs.automigrate('Record', function (err) {
if (err) {
reject(err)
}
var data = getData('./data/test.xls', 'pattern1')
app.models.Record.create(data, function (err, Record) {
if (err) throw err;
resolve()
})
})
})
}
function recreateTable2(app) {
return new Promise((resolve, reject) => {
var data = getData(path.resolve(__dirname, '../..', './data/6999-9766--2011-2019.xlsx')
, 'pattern2');
data.forEach(record => {
app.models.Record.create(record, function (err, result) {
if (err) {
reject(err)
}
})
});
resolve()
})
}
async function recreateTable(app) {
await recreateTable1(app)
await recreateTable2(app)
return 1;
}
module.exports = function (app) {
recreateTable(app).then(data => { console.log(data) });
}
//查看你的 REST API http://localhost:3000/explorer
//Web server listening at: http://localhost:3000
//1
async function f() {
var v = 1;
let promise = new Promise((resolve, reject) => {
setTimeout(() => { console.log(v); v = 2; resolve('done!') }, 1000)
})
// setTimeout(() => { v = 2 }, 1000)
console.log(3)
let result = await promise;
// console.log(result)
console.log(v)
}
f()