erevna-google-spreadsheet-loader
Advanced tools
Comparing version 1.0.3 to 1.0.4
{ | ||
"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 |
112
server.js
@@ -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 @@ }); |
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
Major refactor
Supply chain riskPackage has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
7
127
9764
1