Code Snippets

Code snippets which I use more often in projects

MYSQL STORE PRODCEDURE

DELIMITER $$
CREATE PROCEDURE `insert_into_order_contents_tables`(
    IN `pref_id` INT,
    IN `item_quantity_booker` VARCHAR(100)
)
BEGIN
    insert into order_contents (
        pref_id,
        item_quantity_booker
    ) values (
        pref_id,
        item_quantity_booker
    );
END$$
DELIMITER ;

POSTGRESQL DB Export Windows Command Line

Open Powershell.
Go to Postgres bin folder. For example: cd "C:\Program Files\PostgreSQL\9.6\bin"
Enter the command to dump your database. For example: ./pg_dump.exe -U postgres -d my_database_name -f D:\Backup\<backup-file-name>.sql.
Type password for your postgres user.

CORS ISSUE

The CORS issue should be fixed in the backend. Temporary workaround uses this option.
Go to C:\Program Files\Google\Chrome\Application
Open command prompt
Execute the command chrome.exe --disable-web-security --user-data-dir="c:/ChromeDevSession"

Transfer data from one server to another

Copy files from one SSH to another SSH server

scp /path/to/file username@a:/path/to/destination

Step 1:
Zip the product

zip -r product.zip /var/www/product

Step 2:
Take db dump on host server

mysqldump -u root -p spencer > /var/www/exported.sql

Step 3:
Transfer it to new server

scp /var/www/spencer.zip root@{ipaddresss}:/var/www/product-destination-on-remote-server

Import Export MySQL DB Command Line

Export Dump.sql WITH/WITHOUT SCHEMA
mysqldump -u root -p DB_NAME > /var/www/exported.sql

mysqldump -u root -p --no-data DB_NAME > /var/www/exported.sql

Import Dump.sql
mysql -u root -p database_name < file.sql

Find string/substring linux

grep -rnw '/var/www/project' -e 'stringtosearch'

NodeJS Worker Threads

main.js

const { Worker } = require('worker_threads');
const worker = new Worker('./wthread.js');
worker.on('message', (msg) => {
    console.log(`Msg: ${JSON.stringify(msg)}`);
});
// worker.on('error', reject);
worker.on('exit', (code) => {
    if (code !== 0)
        throw new Error(`stopped with  ${code} exit code`)
})

wthread.js

const { workerData, parentPort } = require('worker_threads')

parentPort.postMessage({ "StartedAt": workerData })
------ Code Logic ------
parentPort.postMessage({ result: result })