Changeset 9182

Timestamp:

04/01/08 05:01:10 (3 months ago)

Author:

bitsweat

Message:

PostgreSQL: create_ and drop_database support. Closes #9042.

Files:

• trunk/activerecord/CHANGELOG (modified) (1 diff)
• trunk/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb (modified) (1 diff)
• trunk/activerecord/test/cases/active_schema_test_postgresql.rb (added)

trunk/activerecord/CHANGELOG

@@ -1 +1 @@
-*SVN*
+
+* PostgreSQL: create_ and drop_database support.  #9042 [ez, pedz, nicksieger]
-
-* Ensure that validates_uniqueness_of works with with_scope. Closes #9235. [nik.wakelin, cavalle]

trunk/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb

@@ -475 +475 @@
-      # SCHEMA STATEMENTS ========================================
-
+      def recreate_database(name) #:nodoc:
+        drop_database(name)
+        create_database(name)
+      end
+
+      # Create a new PostgreSQL database.  Options include :owner, :template,
+      # :encoding, :tablespace, and :connection_limit (note that MySQL uses
+      # :charset while PostgreSQL uses :encoding).
+      #
+      # Example:
+      #   create_database config[:database], config
+      #   create_database 'foo_development', :encoding => 'unicode'
+      def create_database(name, options = {})
+        options = options.reverse_merge(:encoding => "utf8")
+
+        option_string = options.symbolize_keys.sum do |key, value|
+          case key
+          when :owner
+            " OWNER = '#{value}'"
+          when :template
+            " TEMPLATE = #{value}"
+          when :encoding
+            " ENCODING = '#{value}'"
+          when :tablespace
+            " TABLESPACE = #{value}"
+          when :connection_limit
+            " CONNECTION LIMIT = #{value}"
+          else
+            ""
+          end
+        end
+
+        execute "CREATE DATABASE #{name}#{option_string}"
+      end
+
+      # Drops a PostgreSQL database
+      #
+      # Example:
+      #   drop_database 'matt_development'
+      def drop_database(name) #:nodoc:
+        execute "DROP DATABASE IF EXISTS #{name}"
+      end
+
+
-      # Returns the list of all tables in the schema search path or a specified schema.
-      def tables(name = nil)