vim ~/.aws/config
[profile dev]
sso_session = dev
sso_account_id = XXXXXXXXXXXX
CREATE TABLE user ( | |
user_id INT(7), | |
user_prefix VARCHAR(16), | |
name VARCHAR (255), | |
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | |
PRIMARY KEY(user_id, user_prefix) | |
); | |
DELIMITER $$ | |
CREATE PROCEDURE prepare_data() |
# Download Files from remote to local | |
scp -r user@host:/path/to/remote/folder /path/to/local/folder | |
# MYSQL | |
#log to mysql cli | |
mysql -u {username}-p | |
#List all databases | |
SHOW DATABASES; |
# Install Postman | |
wget https://dl.pstmn.io/download/latest/linux64 -O postman.tar.gz | |
sudo tar -xzf postman.tar.gz -C /opt | |
rm postman.tar.gz | |
sudo rm /usr/bin/postman | |
sudo ln -s /opt/Postman/Postman /usr/bin/postman |
sudo apt-get update | |
sudo apt-get upgraed | |
wget http://packages.erlang-solutions.com/ubuntu/erlang_solutions.asc | |
sudo apt-key add erlang_solutions.asc | |
sudo apt-get update | |
sudo apt-get install erlang | |
sudo apt-get install erlang-nox | |
#make a folder for your app | |
mkdir /var/www | |
mkdir /var/www/laravel | |
#nginx config for laravel app | |
server { | |
listen 80 default_server; | |
root /var/www/laravel/public/; | |
index index.php index.html index.htm; |
#create a public key base on the link bellow | |
https://www.digitalocean.com/community/tutorials/how-to-set-up-ssh-keys--2 | |
#the local public key has to be added on bitbucket.com and the remote server | |
https://help.github.com/articles/generating-ssh-keys/ | |
#if you added a pass phrase to the key you need to add your public key to the remote server | |
http://capistranorb.com/documentation/getting-started/authentication-and-authorisation/#toc_3 | |
#set up the public ssh to your account |
<?xml version="1.0" encoding="UTF-8"?> | |
<project name="{Project Name}" default="dev" basedir="."> | |
<property name="basedir" value="${project.basedir}" /> | |
<property name="vendorBinDir" value="${basedir}/vendor/bin" /> | |
<property name="source" value="${basedir}/app" /> | |
<property name="exclude" value="${source}/cache,${source}/config,${source}/language,${source}/third_party,${source}/views,${source}/libraries" /> | |
<target name="dev" depends="clean,lint,pdepend,phpmd,phpcpd,phploc,phpcs,phpunit,phpcb" /> | |
<target name="full" depends="clean,lint,phpdoc,pdepend,phpmd,phpcpd,phploc,phpcs,phpunit,phpcb" /> |
### Config ### | |
git config --global core.autocrlf input | |
### Create remote branch ### | |
git push origin <branchName> | |
### Delete remote branch ### | |
git push origin --delete <branchName> | |
###Start developing new feature### |