Commits

lakin.wecker committed 84b659d

adding a new PgLoadPlain command.

Comments (0)

Files changed (1)

baste/__init__.py

 #-------------------------------------------------------------------------------
 class PgRestore(object):
     #---------------------------------------------------------------------------
+    def __init__(self, file, db, user, format="custom"):
+        self.file = file
+        self.db = db
+        self.user = user
+        self.format = format
+
+    #---------------------------------------------------------------------------
+    def __call__(self):
+        """
+        Uses the pg_restore command to restore the database from the given file.
+        """
+        local(
+            "pg_restore --clean --no-owner --no-privileges --format=%s --host=localhost --username=%s --dbname=%s %s" % (
+                self.format, self.user, self.db, self.file
+            )
+        )
+
+#-------------------------------------------------------------------------------
+class PgLoadPlain(object):
+    #---------------------------------------------------------------------------
     def __init__(self, file, db, user):
         self.file = file
         self.db = db
 
     #---------------------------------------------------------------------------
     def __call__(self):
-        """
-        Uses the pg_restore command to restore the database from the given file.
-        """
-        local("pg_restore --clean --no-owner --no-privileges --format=custom --host=localhost --username=%s --dbname=%s %s" % (self.user, self.db, self.file))
+        """Uses psql to load a plain dump format"""
+        local(
+            "bzcat %s | psql --host=localhost --username=%s --dbname=%s" % (
+                self.file, self.user, self.db
+            )
+        )
 
 #-------------------------------------------------------------------------------
 class PgShell(object):
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.