diff options
Diffstat (limited to 'servo/management/commands')
-rw-r--r-- | servo/management/commands/dbdump.py | 13 | ||||
-rw-r--r-- | servo/management/commands/dumpdb.py | 20 |
2 files changed, 20 insertions, 13 deletions
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]) |