From 9846c696692eaa2b06fece6eda2ddc9df9d03d86 Mon Sep 17 00:00:00 2001
From: Geo Halkiadakis <gchalkiadakis@sklavenitis.co.gr>
Date: Tue, 28 Mar 2023 14:49:54 +0300
Subject: linkeysearch:/javascript updated deployed cloud functions

---
 javascript/keygen.js | 53 ----------------------------------------------------
 1 file changed, 53 deletions(-)

(limited to 'javascript/keygen.js')

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 
 // -----------------------------------------------------------------------------
-- 
cgit v1.2.3