Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- export function importDataSet(filePaths, fileType) {
- return (dispatch, getState) => {
- //const {timePeriod} = getState().main;
- Promise.all(filePaths.map((item, i) => {
- return SomeFormatDataReader(item);
- })).then((results) => {
- results.map((item, i) => {
- saveDataSet(item);
- });
- console.log(results);
- });
- //const totalRows = result.columns.length * result.columns[0].length;
- }
- }
- function saveDataSet(data) {
- return Promise.all(data.columns.map((item, i) => {
- if (i > 0 && item.name !== '') {
- return db.DataSet.findOrCreate({
- where: {name: item.name},
- defaults: {
- name: item.name,
- si: item.si,
- }
- }).then((dataSet) => {
- saveDataSetValue(dataSet[0].id, data.columns[0].values, data.columns[i].values);
- }).catch((e) => {
- console.log('DataSet: ' + e.result.trace());
- });
- }
- }));
- }
- function saveDataSetValue(dataSetId, times, values) {
- db.disableLogging = true;
- return Promise.all(values.map((value, i) => {
- const time = times[i].format(formatSqlTime);
- return db.sequelize.query(`INSERT INTO DataSetValues (id, dataSetId, time, value) VALUES (NULL,${dataSetId},'${time}', ${value});`, {raw: true});
- })).then((results) => {
- db.disableLogging = false;
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement