Giuseppe Rosa giusepper11

🎯

Focusing

Data Engineer/Python Developer

giusepper11 / gist:5dd1ebc6913871a6ab67dc6ccb20dfd7

Created November 12, 2019 13:42

Auto Created e Update Django

	from django.db import models

	class Task(models.Model):
	created = models.DateTimeField(auto_now_add=True)
	updated = models.DateTimeField(auto_now=True)

giusepper11 / gist:22ff19b3c2499b0e39675da02bf4a756

Created July 19, 2019 15:16

SQL Server Disk Size

	select *
	from (SELECT sys.databases.name,
	CONVERT(integer, SUM(size) * 8 / 1024) AS size_mb
	FROM sys.databases
	JOIN sys.master_files
	ON sys.databases.database_id = sys.master_files.database_id
	GROUP BY sys.databases.name) size
	order by size_mb desc ;

giusepper11 / gist:a965399de6791e5caaa27063ef02c1ce

Created July 19, 2019 13:52

Submodules pull

git submodule update --init --recursive

giusepper11 / gist:c64fb145958b668c40b4381781f32f91

Created March 29, 2019 13:23

Ver mais colunas e linhas no pandas

	pd.set_option('display.max_rows', 500)
	pd.set_option('display.max_columns', 500)

giusepper11 / restore.sh

Created January 13, 2019 19:05 — forked from jgillman/restore.sh

pg_restore a local db dump into Docker

	# Assumes the database container is named 'db'

	DOCKER_DB_NAME="$(docker-compose ps -q db)"
	DB_HOSTNAME=db
	DB_USER=postgres
	LOCAL_DUMP_PATH="path/to/local.dump"

	docker-compose up -d db
	docker exec -i "${DOCKER_DB_NAME}" pg_restore -C --clean --no-acl --no-owner -U "${DB_USER}" -d "${DB_HOSTNAME}" < "${LOCAL_DUMP_PATH}"
	docker-compose stop db