similar to: Creating DB from within Rails

I''m working on an existing global database running on MS SQL Server. The appropriate primary key is uniqueidentifier, so I want to set ActiveRecord::ConnectionAdapters::SQLServerAdapter#native_database_types[:primary_key] = "uniqueidentifier NOT NULL newid() PRIMARY KEY". Obviously, I need to override the native_database_types definition, but I really don''t know where

I''ve got a bunch of table creations in the schema.rb file and all is well. However, I have to manually go and create the db first. Is there a way (something like a create_database method) to get this to work? (execute "create database ..." didn''t seem to cut it either.) _______________________ Brad Eck Sr. Software Engineer Pelco 3500 Pelco Way Clovis, CA 93612

Hello everyone, I am needing to resolve an error on sqlserveradapter revolving around a trigger on a table. When the AR object is saved, AR throws Cannot create new connection because in manual or distributed transaction mode. at from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log'' In order to resolve this, I

Hi, I''m trying to run the "validates_inclusion_of" method in a before_save hook, because the range is dependant on the related data. But I can''t figure out how to call it. When calling it normally, it says it can''t find it. I''ve tried several combinations like "ActiveRecord::Validations.validates_inclusion_of", but I can''t seem to

Is it possible to execute a DML statement against a MySQL database from within Rails? I have a table I''m using for batch processing. It needs to be truncated to reset the primary key before each batch insert statement. I looked at the API here: http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/DatabaseStatements.html#M000532 and didn''t notice anything that

Here''s what I have: Ruby 1.8.7 Rails 2.3.3 (activerecord 2.3.3, etc) activerecord-sybase-adapter ( http://itsignals.cascadia.com.au/?p=23 ) Here is the base code (login info was changed to protect me) require ''rubygems'' require ''activerecord'' a = ActiveRecord::Base.establish_connection( :adapter => "sybase", :host =>

Hi,all I am developing a Rails application supporting both Mysql and Oracle. I have to use Native SQL statements some place. While we know the SQL grammar is quite different for Mysql and Oracle, so I have to get database adapter type programmatically in my codes to process different native SQL statements. I haven''t found any document for this situation. After some research, I have found

Hi everyone, First of all, I''m running Mac OS X Snow Leopard. Trying to set up a new SQLite database, but when I run rake db:create, I get the following huge message: unable to open database file /System/Library/Frameworks/Ruby.framework/Versions/1.8/usr/lib/ruby/ gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/ sqlite3_adapter.rb:13:in `initialize''

Hi all, Just starting with Rails and working through the early chapters of the Pragmatic Programmers Agile Development with Rails book (2nd addition). When doing a "rake db:migrate" to add a column to a table I get this: undefined method `default'' for #<ActiveRecord::ConnectionAdapters::MysqlAdapter:0xb7517ec8> Any ideas? thanks, David PS: Here''s the full

I still want to get this into Rails for all connection adaptors, but for now I''ve hacked my own addition on for just PostgreSQL. The following code extends every Column object returned by MyModel.columns to support a new #required? method, which indicates if the column may or may not be null. The following is a huge hack - suggestions on a cleaner way to add this functionality

Folks, I am using ruby 1.8.5 with rails 1.2.3 and have made changes to mysql_adapter.rb based on recommendations made here http://wiki.rubyonrails.org/rails/pages/StoredProceduresInMySql to be able to use stored procs in my code. I have changed this call in mysql_adapter.rb ConnectionAdapters::MysqlAdapter.new(mysql, logger, [host, username, password, database, port, socket], config) to

Dear Gurus on Rails! How do I change the behaviour of one method in ActiveRecord::ConnectionAdapters::SchemaStatements ? Full story: I''d like to mangle ActiveRecord::ConnectionAdapters::SchemaStatements so when it creates a new sql table, it also (optionally) creates my created_at, deleted, key_id, session_id etc columns that I use on basically all tables. It would not be DRY to repeat

The build failed. CHANGES ------- Revision 8649 committed by gbuesing on 2008-01-16 20:07:10 Introducing DateTime #utc, #utc? and #utc_offset, for duck-typing compatibility with Time. Closes #10002 M /trunk/activesupport/CHANGELOG M /trunk/activesupport/lib/active_support/core_ext/date_time/calculations.rb M /trunk/activesupport/test/core_ext/date_time_ext_test.rb TEST FAILURES AND

If you use ActiveRecord::Base.connection.create_database you''ll notice that by default the created db will use latin1 encoding. I created a plugin to handle different charset and collations (on top of helping you with other boring DB tasks). You can check out the early version of the plugin svn checkout svn://rubyforge.org/var/svn/raketasks/db_tasks (I really need to move my projects out

Hi, I really need help to understand what is happening while Rails connect to a database, (we area actually using postgresql, so my example will be with postgresql) What I understand is Rails is able to connect to different DB. Actually, this is what we want, and we have made some tests, everything is juste fine. However, all these tests lead us to some important questions that we did find the

Hi all, This is my first post to the forum, and I''ll point out right away that I''m a noob to everything, Ruby, Rails, MySQL, etc., so I expect that I''m wrong here, but is the ''year'' datatype missing from ActiveRecord in 2.0.2? According to my MySQL 5.0 reference manual, ''year'' is a datatype, but when I try to run a migration that has

Dear all I have a rails project which database connection is defined in database.yml. There is a table call "servers" which have about 40 records, which is a collection of database setting (i.e. Server.name, Server.port, Server.host) I know the way to establish multiple connection as below... class A < ActiveRecord::Base end A.establish_connection(a) # a is the database config

Hi all. I keep having the following error when I invoke the rake db:migrate command for Rails 1.1 (Ruby 1.8.2 -- Windows 2000) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate == Realtorex: migrating ======================================================= -- create() rake aborted! undefined method `create'' for

> -----Original Message----- > From: rails-bounces@lists.rubyonrails.org > [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Lori Olson > Sent: Tuesday, April 11, 2006 8:04 PM > To: rails@lists.rubyonrails.org > Subject: [Rails] Re: Re: Oracle unit test problem in Rails > 1.1.2/Ruby-OCI 0.1 > > > Wilson Bilkovich wrote: > > On 4/11/06, Lori Olson

Trying to use backgroundrb to process and insert a large list of bulk records, but when I try to use it with the batched_sql_fu plugin installed in vendor/plugins, I get the following error: ---SNIP--- /Users/jdonalds/Sites/3dial_ads/config/../vendor/plugins/ batched_sql_fu/lib/batched_sql_fu/active_record.rb:22:in `alias_insert_sql_to_batched_version!'': undefined method