giusepper11

from django.db import models

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

giusepper11

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

git submodule update --init --recursive

giusepper11

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

giusepper11

# 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