Socket
Socket
Sign inDemoInstall

erevna-google-spreadsheet-loader

Package Overview
Dependencies
206
Maintainers
1
Versions
5
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

Comparing version 1.0.3 to 1.0.4

jobLoader.js

2

package.json
{
"name": "erevna-google-spreadsheet-loader",
"version": "1.0.3",
"version": "1.0.4",
"description": "erevna api Node.js on Docker",

@@ -5,0 +5,0 @@ "author": "opetstudio@gmail.com",

@@ -8,11 +8,11 @@ Erevna Dictionary Location Data Loader

docker build -t opetstudio/erevna_dictionary_locationdata_loader:version1.0.0 .
docker build -t opetstudio/erevna-google-spreadsheet-loader:version1.0.0 .
####Docker pull command
docker pull opetstudio/erevna_dictionary_locationdata_loader
docker pull opetstudio/erevna-google-spreadsheet-loader
####Docker start/stop
docker run -d -p 4000:8080 opetstudio/erevna_dictionary_locationdata_loader:version1.0.0
docker run -d -p 4000:8080 opetstudio/erevna-google-spreadsheet-loader:version1.0.0

@@ -19,0 +19,0 @@ docker container stop <hash> # Gracefully stop the specified container

@@ -5,2 +5,3 @@ 'use strict';

const erevna = require('erevna-services');
const job_loader = require('./jobLoader');

@@ -17,112 +18,3 @@ // Constants

app.get('/datalocationv2', (req, res) => {
var datalocationv2 = function(cells, currentDataRow){
//npm run gdocsync -- -minrow=1 -maxrow=3 -sheetnumber=0 -gdoc=1PyMqH5ts4g-I_19q8awi09yL00iFk404RdtRTXX-OEE -storagekey=localstorage-locationv2 -job=datalocationv2
var list=[];
var tempRow = '';
var theKey = '';
var dataJson = {};
var dataRow = currentDataRow || {};
var lang = '';
var keyLevel1='';
var keyLevel2='';
var keyLevel3='';
var keyLevel4='';
var level1_lat='';
var level2_lat='';
var level3_lat='';
var level4_lat='';
var level1_long='';
var level2_long='';
var level3_long='';
var level4_long='';
cells.forEach(function(v,k){
if(v.col < 17 && v.row > 1 && v.value!=''){
// if(tempRow != v.row){
if(v.col==1 && keyLevel1 != v.value && v.value != ''){
keyLevel1 = v.value;
keyLevel1 = keyLevel1.toLowerCase();
dataRow[keyLevel1] = dataRow[''+keyLevel1] || {};
dataRow[keyLevel1]['name'] = keyLevel1;
}
if(v.col==3){
if(v.value != '') level1_lat = v.value;
// dataRow[keyLevel1] = dataRow[''+keyLevel1] || {};
dataRow[keyLevel1]['lat'] = level1_lat;
}
if(v.col==4){
if(v.value != '') level1_long = v.value;
// dataRow[''+keyLevel1] = dataRow[''+keyLevel1] || {};
dataRow[''+keyLevel1]['long'] = level1_long;
}
if(v.col==5 && keyLevel2 != v.value && v.value != ''){
keyLevel2 = v.value;
keyLevel2 = keyLevel2.toLowerCase();
dataRow[keyLevel1+'-'+keyLevel2] = dataRow[keyLevel1+'-'+keyLevel2] || {};
dataRow[keyLevel1+'-'+keyLevel2]['name'] = keyLevel2;
}
if(v.col==7){
if(v.value != '') level2_lat = v.value;
// dataRow[keyLevel1][keyLevel2] = dataRow[keyLevel1][keyLevel2] || {};
dataRow[keyLevel1+'-'+keyLevel2]['lat'] = level2_lat;
}
if(v.col==8){
if(v.value != '') level2_long = v.value;
// dataRow[keyLevel1][''+keyLevel2] = dataRow[keyLevel1][''+keyLevel2] || {};
dataRow[keyLevel1+'-'+keyLevel2]['long'] = level2_long;
}
if(v.col==9 && keyLevel3 != v.value && v.value != ''){
keyLevel3 = v.value;
keyLevel3 = keyLevel3.toLowerCase();
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3] = dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3] || {};
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3]['name'] = keyLevel3;
}
if(v.col==11){
if(v.value != '') level3_lat = v.value;
// dataRow[keyLevel1][''+keyLevel2][keyLevel3] = dataRow[keyLevel1][''+keyLevel2][keyLevel3] || {};
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3]['lat'] = level3_lat;
}
if(v.col==12){
if(v.value != '') level3_long = v.value;
// dataRow[keyLevel1][''+keyLevel2][keyLevel3] = dataRow[keyLevel1][''+keyLevel2][keyLevel3] || {};
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3]['long'] = level3_long;
}
if(v.col==13 && keyLevel4 != v.value && v.value != ''){
keyLevel4 = v.value;
keyLevel4 = keyLevel4.toLowerCase();
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4] = dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4] || {};
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4]['name'] = keyLevel4;
}
if(v.col==15){
if(v.value != '') level4_lat = v.value;
// dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] = dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] || {};
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4]['lat'] = level4_lat;
}
if(v.col==16){
if(v.value != '') level4_long = v.value;
// dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] = dataRow[keyLevel1][''+keyLevel2][keyLevel3][keyLevel4] || {};
dataRow[keyLevel1+'-'+keyLevel2+'-'+keyLevel3+'-'+keyLevel4]['long'] = level4_long;
}
if(tempRow != v.row && v.value != ''){
tempRow = v.row;
theKey = v.value;
theKey = theKey.toLowerCase();
}
// if(v.col==3) lang = 'en';
// var val = v.value;
//// val = val.toLowerCase();
console.log('Cell R'+v.row+' C'+v.col+' = '+v.value);
}
});
dataJson = dataRow;
return dataJson;
}
var datalocation = req.query.datalocation;

@@ -136,3 +28,3 @@ erevna.gdocsync.execute([

`-datalocation=${datalocation}`,
], require('./service-account-creds.json'), datalocationv2);
], require('./service-account-creds.json'), job_loader.datalocationv2);
res.send('Hello world\n');

@@ -139,0 +31,0 @@ });

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc