Skip to content

Instantly share code, notes, and snippets.

View leeeandroo's full-sized avatar
👀

Leandro leeeandroo

👀
View GitHub Profile
ElasticSearch
curl -L -O https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-6.1.1.tar.gz
tar -xvf elasticsearch-6.1.1.tar.gz
cd elasticsearch-6.1.1/bin
./elasticsearch
http://localhost:9200
Kibana
@leeeandroo
leeeandroo / gist:ca10d8dfee0e8734bb10836ebd2d35c4
Created February 6, 2019 08:57
Backup PSQL from docker container
Backup:
docker exec -t -u postgres your-db-container pg_dumpall -c > your_dump.sql
Restore:
cat your_dump.sql | docker exec -i your-db-container psql -U postgres
@leeeandroo
leeeandroo / run.py
Created July 10, 2018 08:14
run serve into specific folder
cd FOLDER
# If Python version returned above is 3.X
python -m http.server
# If Python version returned above is 2.X
python -m SimpleHTTPServer
@leeeandroo
leeeandroo / pg_dump_restore
Created March 15, 2018 11:12
dump & restore psql
sudo su - postgres
pg_dump -Fc mydatabase > /tmp/mydatabase.sql
sudo su - postgres
pg_restore --verbose --clean -d mydatabase /tmp/mydatabase.sql
@leeeandroo
leeeandroo / weasyprint_complex_headers.py
Created January 7, 2018 09:42 — forked from pikhovkin/weasyprint_complex_headers.py
Repeat on each page of complex headers (eg, tables) except the first page
# coding: utf-8
from weasyprint import HTML, CSS
def get_page_body(boxes):
for box in boxes:
if box.element_tag == 'body':
return box
@leeeandroo
leeeandroo / clean_database_magento.sql
Created January 30, 2013 10:19
Clean database of magento to run admin local after change/relocate URL.
SET FOREIGN_KEY_CHECKS=0;
UPDATE `core_store` SET store_id = 0 WHERE code='admin';
UPDATE `core_store_group` SET group_id = 0 WHERE name='Default';
UPDATE `core_website` SET website_id = 0 WHERE code='admin';
UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;