====== Shortcuts ======

===== Docker =====
Start Postgres
<code>
docker run --rm -d -p 5432:5432 -v /home/alfred/tmp/postgresdata:/var/lib/postgresql/data -v /tmp:/tmp --name postgres -e POSTGRES_PASSWORD=mysecretpassword postgres
</code>

Logs:
<code>
docker logs --since 30s -f <container_name_or_id>
docker logs --tail 20 -f <container_name_or_id>
</code>
===== Git =====
<code>
git config credential.helper store
</code>

===== Linux =====

==== Links ====

  * [[wiki2:linux_commands#apt]]-get install|reinstall|update

=== Date ===
Format date in the way you like it:
<code>
$(date +%y%m%d)
</code>
==== Cheat ====
You can define the next alias:
<code>
function cheat() { curl cht.sh/$1 }
</code>
With it you can launch something like ''cheat rename'' to see its examples.


==== Find in files ====
''grep -iRl "your-text-to-find" ./'' \\ 
Here are the switches: **-i** ignore text case, **-R** recursively search files in subdirectories, **-l** show file names instead of file contents portions.

==== Rename ====
<code>
rename 's/perl/pl/' *.perl
# Sample outputs:
# 'bar.perl' renamed to 'bar.pl'
# 'foo.perl' renamed to 'foo.pl'
# Lowercase all files and folders in current directory
rename 'y/A-Z/a-z/' *
</code>
==== tar ====
<code>
# Compress a folder
tar -zcvf archive-name.tar.gz directory-name

# Extract it
tar -xzf bar.tar.gz
</code>

==== zip & unzip ====
<code>
zip -r folder.zip ./folder
</code>
==== HTTP Local server in python ====
<code>
python3 -m http.server 8000
</code>

==== Merge two folders ====
<code>
rsync -a /path/to/source/ /path/to/destination
</code>
===== PostgreSQL =====
<code>
\q: exit.
\list or \l: list all databases
\dt: list all tables in the current database
\connect database_name to switch database
$ export PGPASSWORD=mysecretpassword && psql -h 127.0.0.1 -U postgres
$ export PGPASSWORD=mysecretpassword && dropdb -h 127.0.0.1 -U postgres fok
$ export PGPASSWORD=mysecretpassword && createdb -T template0 -h 127.0.0.1 -U postgres fok
$ psql restored_database < database.bak
$ pg_dump postgres > postgres_db.bak
$ pg_dumpall > backup_file
</code>

===== SQL =====
Update
<code>
UPDATE T
   SET C1 = 9,
       C3 = 4
 WHERE C2 = 'a'
</code>
===== Mongo =====
<code>docker run -p  27017:27017 -v /home/alfred/mongodata:/data/db  -d mongo</code>

====== Python Gotchas ======

  * [[wiki2:python3#venv_para_crear_entornos_virtuales|Creación de entornos virtuales con venv]]
===== Serving your current directory by HTTP =====
For Python 3 run:
<code>
python3 -m http.server
</code>
For Python 2 run:
<code>
python -m SimpleHTTPServer
</code>

===== Prettify JSON =====
<code>
cat file.json | python -m json.tool
</code>