Added dumpdb

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])