From 09ae65ab4d1d2442ab5e7558b03c294169707f71 Mon Sep 17 00:00:00 2001 From: Filipp Lepalaan Date: Wed, 18 Nov 2015 22:41:47 +0200 Subject: Added dumpdb --- servo/management/commands/dbdump.py | 13 ------------- servo/management/commands/dumpdb.py | 20 ++++++++++++++++++++ 2 files changed, 20 insertions(+), 13 deletions(-) delete mode 100644 servo/management/commands/dbdump.py create mode 100644 servo/management/commands/dumpdb.py (limited to 'servo/management') diff --git a/servo/management/commands/dbdump.py b/servo/management/commands/dbdump.py deleted file mode 100644 index 58651a8..0000000 --- a/servo/management/commands/dbdump.py +++ /dev/null @@ -1,13 +0,0 @@ -# -*- coding: utf-8 -*- - -import subprocess -from django.conf import settings -from django.core.management.base import BaseCommand - - -class Command(BaseCommand): - help = "Dumps DB of this instance to specified file" - - def handle(self, *args, **options): - dbname = settings.DATABASES['default']['NAME'] - #subprocess.call('pg_dump', '-Fc', dbname, '-U', 'pgsql' > "${BACKUPDIR}/${db}_$(date "+%Y%m%d_%H%M").pgdump" diff --git a/servo/management/commands/dumpdb.py b/servo/management/commands/dumpdb.py new file mode 100644 index 0000000..c319336 --- /dev/null +++ b/servo/management/commands/dumpdb.py @@ -0,0 +1,20 @@ +# -*- coding: utf-8 -*- + +import os +import os.path +import subprocess +from datetime import datetime +from django.conf import settings +from django.core.management.base import BaseCommand + + +class Command(BaseCommand): + help = "Dumps DB of this instance to specified file" + + def handle(self, *args, **options): + s = settings.DATABASES['default'] + db, user, pw = s['NAME'], s['USER'], s['PASSWORD'] + fname = datetime.now().strftime('%Y%m%d_%H%M') + '.pgdump' + path = os.path.join(settings.BACKUP_DIR, fname) + os.putenv('PGPASSWORD', pw) + subprocess.call(['pg_dump', '-Fc', db, '-U', user, '-f', path]) -- cgit v1.2.3