Skip to content

Instantly share code, notes, and snippets.

View koobitor's full-sized avatar
😁

Sakol Assawasagool koobitor

😁
View GitHub Profile

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

-- 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;

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
@koobitor
koobitor / conda.sh
Last active February 22, 2020 15:07
### 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
```
git clone [email protected]: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