similar to: a list of current databases

This is a question regarding ActiveRecord outside of Rails. I have several databases that have absolutely identical table structure. I have a ActiveRecord::Base.establish_connection( :adapter => "mysql", :host => "localhost", :username => "user", :password => "password", :database

Where can I obtain list of databases supported by Ruby on Rails? Thanks TheR -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe

Hi, I am trying to use a CGI service (Pubchem PUG) via RCurl and am running into a problem where the data must be supplied via POST - but I don't know the keyword for the argument. The data to be sent is an XML fragment. I can do this via the command line using curl: I save the XML string to a file called query.xml and then do curl -d @query.xml

So, I was looking for a setup that would allow me to easily query multiple databases and not have to re-write my customer finder type queries. Here is what I came up with and it seems to be working for me in my very basic tests so I thought I''d share. Just posting it in case this helps anyone else trying to do the same thing. I''m using this with activerecord, but not rails, so

Hello all. I am still having fun with multiple databases. In this case it is the unless connected? statement. ActiveRecord::Base establishes a connection that is inherited by the majority of my models. However one Model (Componentlog) that uses a separate DB is coded as: unless Componentlog.connected? establish_connection( :adapter => "oci", :database =>

I have two databases in SQLite with the same schema. The other database was populated by an external customer and then returned. I want to use ActiveRecord to do the comparison. I am not sure of the best way to access the tables in each database with ActiveRecord models. I could change the connection dynamically whenever I want to switch between the databases, but this would seem to be clumsy

Hi! The page http://www.xiph.org/archives/vorbis/masterindex.html links to http://www.xiph.org/archives/vorbis/date.html , whic gives a 404 error ( not found ). Just like last time ( begin of november ), when I reported it just like now. And I was ignored, just like now (?). -- David Balazic -------------- "Be excellent to each other." - Bill S. Preston, Esq., & "Ted"

Hi everyone, I was wondering what the common practice for handling multiple db users with fine grained privileges on multiple databases is. Against the often read guideline for rails users to keep with a single db as "more dbs don''t really make sense anyway", my opinion is that it DOES make sense to use more than one db schema for a number of reasons that I won''t

Hello, I have an application that access two different DBMS - Firebird and Postgres. So far, that''s ok. The problem is, depending on the customer logged, a different database (Firebird) must be selected. To make the things clearer: Postgres: 1 database shared by all customers with these tables: - user - vehicle - driver Firebird: several databases with different names and identical

Hi all - I have a need to have my models write to one database and read from another. From what I''ve read, Rails doesn''t do this out of the box. I came up with something that does work, but I''m wondering if there is something I''m missing in the code below that''s going to bite me, such as establish_connection creating a huge number of objects as

Hi, My application spans 2 (or more) databases for some very specific reasons... My models are working fine, even dynamically establishing connections as needed at runtime, and spanning relationships across the databases (which really impressed me). The problem is, I can''t seem to force Units for these models (that use a secondary db) to load their fixtures into and use the

Hello Rails community I cannot seem to find via Google what I had hoped would be a simple issue On a single DB system (currently, postgres 8.1.4), I have two databases, each containing multiple tables. I would like to configure my app and database.yml to recognize these two databases. What is the corrrect config for the database.yml ? Is it something like: > production: > adapter:

Hiall, I''m wondering what''s common practice when dealing with money values stored in databases. I like the idea of storing all the values as integers, i.e. all the values in eurocents not euros. Then I need to multiply all values the users enter by 100 before storing them in the database. Now the question is, what''s the most efficient and dryest way to do this?

I am trying to connect to multiple databases, and have setup an abstract class with a call to establish_connection: class TestBase < ActiveRecord::Base self.abstract_class = true end TestBase.establish_connection( :adapter => "mysql", :host => "host", :username => "user", :password => "pass", :database

Hi all, your thoughts appreciated: I''d like to encrypt one of my databases, as described in the first Rails book, by putting encrypt and decrypt methods on the :after_find, :before_save, and :after_save hooks in my model (what a lovely transparent way rails does things!). But unlike the book, I actually want to use real encryption, perhaps something from the OpenSSL library, something

I have a rails application that connects to two different databases. The first (primary) database is MySQL and the second is Oracle. I have followed the example in the Rails Recipes book and I have created a base class for the models connecting to oracle like this: class ConferenceBase < ActiveRecord::Base establish_connection :conference end :conference is setup in the database.yml. A

hi, I am experiencing a very strange problem with my Rails installation. I''m using ruby 1.8.6 on Debian Linux, with edge rails. Whenever I try to start mongrel, I get an exception about "can''t modify frozen string". I get a similar exception when I try to do "rake db:migrate". In this case, the exception seems to pop up *after* the migrations do succesfully

This seems like it must have been asked before - I really _did_ try to find it in the archives, so my apologies if it''s already out there. Utilizing ActiveRecord, I would like to specify a prefix for the column names in my table. For example, in ''Recipe 16 Integrating with Legacy Databases'' (Rails Recipes, from PragProg, by Fowler) they deal with integration with a

Hi, Is there a recommended way of creating a new database from within rails? (or is the recommended way not to do it?) In my application I wish to be able to create a new database structure for each user who signs up, but there doesn''t seem to be a way of doing this using ActiveRecord. At present I can create it by establishing a new connection to the database dbh =

Hi, I have a legacy database ''old'' and a new database ''new'' which rails uses. I set up models using old with establish_connection(old), and this works well, except for include: class OldModel < ActiveRecord::Base establish_connection(old) end class NewModel < ActiveRecord::Base has_one :old_model end a = OldModel.find :first NewModel.find(:all,