Skip to content

Instantly share code, notes, and snippets.

@danielverissimo
Last active December 18, 2018 02:10
Show Gist options
  • Save danielverissimo/d9aefb17c95b5e658ccb1aa031aa2aaf to your computer and use it in GitHub Desktop.
Save danielverissimo/d9aefb17c95b5e658ccb1aa031aa2aaf to your computer and use it in GitHub Desktop.
Desenvolvimento, utilidades
FTP/SFTP
Criar FTP/SFTP Mac
http://osxdaily.com/2011/09/29/start-an-ftp-or-sftp-server-in-mac-os-x-lion/
Habilitar ZSH Ubuntu
apt-get install zsh
echo "DEBIAN_PREVENT_KEYBOARD_CHANGES=yes" >> ~/.zshenv
SSHFS Ubuntu
Instalar:
sudo apt install sshfs
Montar diretório remoto:
sshfs user@ip:/ /path_mount_dir
@danielverissimo
Copy link
Author

CSV

  • Remover coluna CSV

    cut -d, -f2,3 input.csv > out.csv // Remove a primeira coluna de um CSV e salva em out.csv

  • Importar CSV para MySQL

LOAD DATA LOCAL INFILE '/path/file.csv' 
	INTO TABLE table_name    
    FIELDS TERMINATED BY '\t' ENCLOSED BY '\b' LINES TERMINATED BY '\n' IGNORE 1 LINES 
    (id, column1, column2);

@danielverissimo
Copy link
Author

danielverissimo commented Jul 13, 2017

HABILITAR DEBUG PELO CONSOLE

export XDEBUG_CONFIG="idekey=PHPSTORM remote_host=192.168.15.24"
export PHP_IDE_CONFIG="serverName=Homestead"

https://medium.com/@michalisantoniou6/set-up-xdebug-with-homestead-phpstorm-and-php7-85b5ac8f0c79

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment