diff options
| author | Geo Halkiadakis <gchalkiadakis@sklavenitis.co.gr> | 2023-03-28 13:16:05 +0300 |
|---|---|---|
| committer | Geo Halkiadakis <gchalkiadakis@sklavenitis.co.gr> | 2023-03-28 13:16:05 +0300 |
| commit | d943b74a843b7cfa9e2d393942bd0b3791d56daf (patch) | |
| tree | c783527d81a4c18664799c5df03c3f17a8fca81e /javascript/freq.js | |
| parent | 4517e6eb1ab2eba210698749c05e02fe27fe50ee (diff) | |
| download | linkeysearch-d943b74a843b7cfa9e2d393942bd0b3791d56daf.tar.gz linkeysearch-d943b74a843b7cfa9e2d393942bd0b3791d56daf.tar.bz2 linkeysearch-d943b74a843b7cfa9e2d393942bd0b3791d56daf.zip | |
linkeysearch:/javascript new async functions for parallel run of slow proccesses
Diffstat (limited to 'javascript/freq.js')
| -rw-r--r-- | javascript/freq.js | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/javascript/freq.js b/javascript/freq.js index 86bba22..bf52008 100644 --- a/javascript/freq.js +++ b/javascript/freq.js @@ -19,13 +19,9 @@ // REQUIREMENTS //////////////////////////////////////////////////////////////////////////////// - var mysql = require('mysql'); - const fs = require('fs'); - const os = require('os'); - const {Storage} = require('@google-cloud/storage'); // import Google Cloud client library require('dotenv').config({ path: '../auth/.env' }) @@ -166,7 +162,7 @@ var main = () => { console.log("Connected!"); // SQL to get needed data - var sql = "SELECT count(pl.eys_code) as FREQuency,\ + var sql = "SELECT count(pl.eys_code)*5+SUM(dop.quantity) as FREQuency,\ pl.product_id as product_id,\ pb.brand_name,\ pl.barcode, pl.skl_code, pl.eys_code,\ |