Displaying 20 results from an estimated 1000 matches similar to: "How to get database adapter type programmatically in rails?"
2008 Jan 04
2
oracle adapter + activerecord sessions do not work
Anyone know what''s up with the activerecord session store when using
the oracle adapter in Rails 2.0.2 ?
I can set a session variable and can then see it''s actually set using
the debugger, but after the request completes the session is empty
(the @data member is nil). The session_id is staying the same and the
updated_at field is being updated but nothing I put in a session
2009 Sep 28
5
Multi-databases support
Hi,
While I was hacking ovirt-server, I have found that it's currently
restricted to Postgres DB. Even if I like postgres for serious work on a
server, I really prefer to hack/dev locally on a Sqlite or MySQL DB.
I have googled on rails in order to find a good answer for the "foreign
key problem" which forces OVirt to stay on pg. I have found a plugin on
this particular
2008 Mar 20
0
Mixing stored procedure call with RoR db calls in the same function gives errors
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
2009 Mar 11
1
How to dummy a DB adapter?
I am writing a library module to handle certain StatementInvalid type AR
exceptions. I wish to catch the case where the db adapter in use is not
supported by the module. I would like to test this situation and have
only a vague idea as to how to proceed.
My exception handling method selects the parsing method based on the
adapter_name value.
def hll_ar_exception(exception)
raise
2006 Mar 21
2
Migration ~ Create
In one of my migration files I have the following:
===========
def self.up
User.create :name => ''John Kopanas'', :email =>
''john@kopanas.com'', :password => ''test''
end
===========
When I run it I get the following error:
===========
undefined method `create'' for
2006 Mar 28
4
Problem with ActiveRecord, create, save, and Oracle adapter?
Hi all,
Ruby 1.8.4
Rails 1.1
OCI8 0.1.14
I think I''m hitting an issue with ActiveRecord::Base#save and the Oracle
adapter. Line 158 in the schedules_controller.rb file is simply:
158: if @schedule.save
159: flash[:notice] = ''Schedule was successfully created.''
160: redirect_to :action => ''list''
161: else
162: render :action =>
2007 Mar 25
1
Can't use models in migrations
Hi there,
This always used to work for me... but not now. I want to blame Rails
1.2 but I''m sure its not.
I can''t use AR models in my migrations. To make sure its not just my
dodgy code I tried to do the same with a well known plugin..
acts_as_versioned.
A migration such as the one below (taken from acts_as_versioned) is
giving the error
undefined method
2008 Jun 24
9
ActiveRecord 2.1 Migration support
Hi all,
I am in the process of adding Migration support to the Ingres
ActiveRecord adapter and have run in to a problem. During the call to
create_table the Ingres adapter some how causes ruby to blow the stack
and coredump/segv. I have tracked down the problem down to
"add_column_options!" in
"lib/active_record/connection_adapters/abstract/schema_statements.rb".
2008 Jun 24
9
ActiveRecord 2.1 Migration support
Hi all,
I am in the process of adding Migration support to the Ingres
ActiveRecord adapter and have run in to a problem. During the call to
create_table the Ingres adapter some how causes ruby to blow the stack
and coredump/segv. I have tracked down the problem down to
"add_column_options!" in
"lib/active_record/connection_adapters/abstract/schema_statements.rb".
2010 Nov 09
2
Undefined method
I am very new to ROR. (Ruby 1.8.7, rails 2.1.1, rack
0.8.7, mysql 5.1.41)
I has my_app/lib/migration_helpers.rb file:
module MigrationHelpers
def self.foreign_key(from_table, from_column, to_table)
constraint_name = "fk_#{from_table}_#{to_table}"
execute %{alter table #{from_table}
add constraint #{constraint_name}
foreign key (#{from_column})
2006 Jun 23
2
Rails and Oracle
I have a potential client who is interested in employing
my services to Web 2.0 their Web 1.0 perl+oracle app.
I''ve only used rails with MySql so far.
Are their any gotchas I should be aware of?
Guy
2008 Dec 05
1
ActiveRecord Oracle and nvarchar2 or nclob datatype
Hi,
I ve got oracle database which exists prior to my rails app... :-(
I ve got trouble when I am updating/inserting records of a table which
includes nvarchar2 attributes.
These have a specific maximum length.
I often get an error Value too long for column when doing my inserts/
updates, but in fact that is not the case.
I ve taken a look at the generated sql statements....
As far as I know
2006 Aug 19
7
Impossible to get stable?
I have concluded that it is impossible to get this background process
stable. I am out of ideas and could really use some help.
Here is what I have:
50 workers, just running an infinite loop that constantly calls save!
on a model. Keep in mind this is just for testing purposes. I catch
all exceptions and put them in the log.
I am tried setting allow_concurrency to true and false. Neither
2008 Apr 04
0
Can''t get backgroundrb to work with rails plugin ''batched_sql_fu''
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
2007 Aug 03
2
my number column returns boolean values
Hi everyone,
I''m working on a new rails project and have to build it on top of a
legacy oracle database. I''m trying to figure out how to get the
number value from a NUMBER(1) datatype. So far I''m only getting a
"true" value for 1 and "false" for any other number. From the console
I can print out my object values and can see that there are number
2007 Jan 21
6
rake db:migrate "undefined method `default'" error
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
2008 Aug 28
2
1 or true in TINYINT(1) column?
Hello, there is a table that has a column TINYINT(1) called status.
Through mysql console I see its value as 1 (when is true) but if I do
this in Rails console:
Mytable.status
=> true
give me "true" rather "1".
How could I change 1 to true using some method?
Or true to 1?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are
2006 Jun 23
0
Multiparameter error
Hello,
What''s the best way to deal with dates prior to 1970 using Rails. I''ve
seen some suggestions for hacks to fallback to the Date class if Time
fails, but I''m not sure exactly how to implement them.
This is from the wiki
require ''date''
# It''s necessary to do this, because Time doesn''t
# support dates before 1970...
class
2006 Mar 29
2
Rake Migrations for Rails 1.1
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
2006 Aug 02
2
mangle ActiveRecord
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