Sakol Assawasagool koobitor

NPM Publish Package

npm login
npm init --scope=@my-org
npm publish

Version

npm version [ | major | minor | patch | premajor | preminor | prepatch | prerelease [--preid=]

Limit By Row

SELECT * FROM [TABLE] WHERE ROWNUM <= [NUMBER];

SELECT by DATE

SELECT * FROM [TABLE] WHERE [DATA_DATE] = TO_DATE('2020-04-10','yyyy-mm-dd')

Oracle Instant Client MacOS

cd ~/
mkdir lib
unzip instantclient-basic-macos.x64-19.3.0.0.0dbru.zip
cd instantclient_19_3
mv * ~/lib/

Export Path .zshrc

Tar Exclude

tar cvf product.tar.gz --exclude='product/cache/*' product

New Branch

git branch
git checkout develop
git pull origin develop
git checkout -B feature/#1-styled

Update Branch Feature = Branch Develop

pre-download development binaries

flutter precache

Dependencies

flutter doctor

git clone git@gitlab.com:unicode-corporate/[project].git
cd [project]/app/
vi .env
npm i
pm2 list
cd /home/ubuntu/[project]/app
NODE_ENV=production pm2 start index.js

	-- DB Schema
	SELECT COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE, EXTRA, COLUMN_DEFAULT, COLUMN_COMMENT, COLUMN_KEY from information_schema.columns
	WHERE table_schema = 'database_name'
	AND table_name = 'table_name';

	-- Example Data
	SELECT * FROM table_name LIMIT 10;

	### INIT
	```
	conda init zsh
	```

	### Create Virtual Environment
	```
	conda create -n AIML python=3.7
	conda activate AIML
	conda install numpy scipy matplotlib pandas mayavi cvxopt

	### CMD
	```
	export AIRFLOW_HOME=/home/medvine/airflow
	airflow webserver -D
	airflow scheduler -D
	lsof -i tcp:80
	```

	### RUN
	```