summaryrefslogtreecommitdiff
path: root/javascript/keygen.js
diff options
context:
space:
mode:
authorGeo Halkiadakis <gchalkiadakis@sklavenitis.co.gr>2023-03-28 14:49:54 +0300
committerGeo Halkiadakis <gchalkiadakis@sklavenitis.co.gr>2023-03-28 14:49:54 +0300
commit9846c696692eaa2b06fece6eda2ddc9df9d03d86 (patch)
tree6536a64f052bdc7afadbe5abfa539a30576e5523 /javascript/keygen.js
parentd943b74a843b7cfa9e2d393942bd0b3791d56daf (diff)
downloadlinkeysearch-9846c696692eaa2b06fece6eda2ddc9df9d03d86.tar.gz
linkeysearch-9846c696692eaa2b06fece6eda2ddc9df9d03d86.tar.bz2
linkeysearch-9846c696692eaa2b06fece6eda2ddc9df9d03d86.zip
linkeysearch:/javascript updated deployed cloud functions
Diffstat (limited to 'javascript/keygen.js')
-rw-r--r--javascript/keygen.js53
1 files changed, 0 insertions, 53 deletions
diff --git a/javascript/keygen.js b/javascript/keygen.js
index dbd5717..45362d0 100644
--- a/javascript/keygen.js
+++ b/javascript/keygen.js
@@ -309,59 +309,6 @@ function freq_of(id) {
-/* ---
-// connect;
-// get records to proccess;
-// call main proccess function;
-// save dictionary;
-// end script;
-// -----------------------------------------------------------------------------
-var main = () => {
-
- con.connect(function(err) {
- // connect;
- if (err) throw err;
- console.log("Connected!");
-
- var sql = "SELECT count(pl.eys_code) as FREQuency,\
- pl.product_id as product_id,\
- pb.brand_name,\
- pl.barcode, pl.skl_code, pl.eys_code,\
- IF( pd.description IS NOT NULL , pd.description , pl.product_description ) AS product_description,\
- pl.bpcs_code,\
- pd.image_path\
- FROM product_list as pl\
- LEFT JOIN delivery_orders_products AS dop ON dop.product_id = pl.eys_code\
- LEFT JOIN product_details AS pd ON pl.eys_code = pd.eys_code\
- LEFT JOIN product_brands pb ON pl.brand_id = pb.id\
- WHERE pl.active = 1 AND pl.sap_code IS NOT NULL AND pl.product_category_sap_4 NOT LIKE '72%'\
- GROUP BY pl.product_id\
- ORDER BY FREQuency DESC";
-
- // query sql
- con.query(sql, function (err, result) {
- if (err) throw err;
- console.log('Records from database received!');
-
- do_proccess(result); // proccess
- console.log('Keywords proccesed!');
-
- save_local(kwlinks_, '../results/keywords.json'); // save
- // production (GFunctions): upload_file('pythia-files', os.tmpdir()+'/keywords.json', 'uploads/orders/keywords.json');
- upload_file('pythia-files', '../results/keywords.json', 'uploads/orders/emarket-keywords.json');
- console.log('Results saved! Exiting.');
-
- // echo memory stats
- const used = process.memoryUsage();
- for (let key in used) {
- console.log(`${key} ${Math.round(used[key] / 1024 / 1024 * 100) / 100} MB`);
- }
- });
- });
-}
---- */
-
-
// proccess data
// The MAIN proccess
// -----------------------------------------------------------------------------