Title: [648] trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb: Some fixes for postgres
- Revision
- 648
- Author
- olabini
- Date
- 2007-06-22 04:31:05 -0400 (Fri, 22 Jun 2007)
Log Message
Some fixes for postgres
Modified Paths
Diff
Modified: trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb (647 => 648)
--- trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb 2007-06-21 11:38:02 UTC (rev 647)
+++ trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_postgre.rb 2007-06-22 08:31:05 UTC (rev 648)
@@ -1,8 +1,14 @@
module JdbcSpec
module PostgreSQL
module Column
+
def simplified_type(field_type)
return :integer if field_type =~ /^serial/i
+ return :string if field_type =~ /\[\]$/i || field_type =~ /^interval/i
+ return :string if field_type =~ /^(?:point|lseg|box|"?path"?|polygon|circle)/i
+ return :datetime if field_type =~ /^timestamp/i
+ return :float if field_type =~ /^real|^money/i
+ return :binary if field_type =~ /^bytea/i
super
end
@@ -153,6 +159,10 @@
%("#{name}")
end
+ def quoted_date(value)
+ value.strftime("%Y-%m-%d %H:%M:%S.#{sprintf("%06d", value.usec)}")
+ end
+
def rename_table(name, new_name)
execute "ALTER TABLE #{name} RENAME TO #{new_name}"
end
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
