similar to: migrations on multi-database app

I have a DB2 schema with many ''views'' and table partitions defined in it. As per our new project requirement we have to support multiple databases (DB2,Oracle and MYSQL to be specific). The frontend application is implemented using Ruby on Rails. I am interested in exploring the possibility of using Rails Migrations to abstract out the schema to a DB independent layer. I could

Hi All, Which is the best way to handle multi-user applications in Rails (think backpack)? Let me try to explain what I am trying to do: I wrote an application and sold it to different companies. For every company I sold the app to, I deployed a fresh Rails app to a fresh 256MB VPS and provided a superuser account (to the app, not the server). Customers handle their own users from there as

Does anyone have MySQL replication set up for a Rails App that uses migrations? I''m having an issue where every time I run a migration Rails is trying to create the schema_info table. Mysql::Error: Table ''schema_info'' already exists: CREATE TABLE schema_info (version int(11)) This causes a problem on the slave databases where the replicated create table statement

The one thing I don''t like about migrations is the security, and I''d like to know if anyone is interested in working with me to improve it (or knows an existing way to accomplish the same thing). Here''s the scenario: - I always create specific database users that only have CRUD priveleges, and run my web apps with these users - I need to log in with a

Now that we have the big Rails 2.0 release out the door, it''s a lot easier to push out smaller updates more frequently. So that''s what we''re going to do. Rails 2.0.2 contains a bunch of smaller fixes to various bugs, no show-stopping action, just further polish. But it also contains a few new defaults:

Rails/Postgres Gurus, Question: Is it possible to use Postgres schemas within a Rails app to separate tables and data between two different apps? Problem Set: I am thinking of combining two apps. I want to share some data (certain tables) between them, but I want the migrations and other activities to be separated. I don''t want any table changes in one app to impact the other.

hello all, Is there some way to generate migrations from an existing database structure? I have the schema.rb file, but it isn''t enough for me. I need the migration files.... Please help! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send

Hello, Is it possible to declare the version of Rails used with the seminal "rails /path/to/my_app" command? For example, I now have 1.2.1 and 1.1.6 installed on my machine. If I run "rails my_app" I get 1.2.1 produced skeleton code. Is there a way to get 1.1.6 results? Regards, Andy Koch --~--~---------~--~----~------------~-------~--~----~ You received this

I just put a new plugin named branchable_migrations on Github. Branchable migrations lets you separate your migrations into "branches" (i.e., a director under db/migrate) that each have their own version. Using the forthcoming UTC timestamped migrations and this plugin, you can separate migrations by table or feature. Doing so should alleviate many of the problems that seem to pike up

I''m sure people have encountered this before, but I''ve been unsuccessful at finding anything about it. Basically, I got a rails app that uses postgres and tsearch2 for some full text indexing and I''d like to be performing unit tests. Now, there''s the whole deal of how to get the test database to load all the tsearch2 information properly. I tried to come up

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:

Hi. I''m using a migration to extract data from one table, to another. In the process I also convert ip-adresses to integers, for insertion in the new table. Problem is that migrations doesn''t seem to handle large numbers very well. The conversion works fine from the script/console, but when running it from migrations only very low IP-ranges "make it thru".

Hi, I wrote a custom migrator which I think is helpful in multi-developer environment. Please try it out and let me know if you have any feedback and/or features to be added. Here''s the link to the project and doc. http://rubyforge.org/projects/custommigrator/ http://custommigrator.rubyforge.org/svn/plugins/custom_migrator/README Thanks Babu

Folks, What is the convention for primary key fields in joining tables in RoR? I have a model representing a joining table, and I can''t seem to prevent ActiveRecord''s find method from looking for an id column. I don''t have an auto-incremented field in my table (happy to add one if that is the convention), and therefore my primary key is the combination of the 2 foreign

Hey guys. Per my IT department''s policies, I need to have two separate database users for my rails database - one for public intarweb functionality, one for authenticated users'' functionality. The naive way to accomodate this would be to break the app up into two separate apps, but since they share the same models and resources, DRY suggests this isn''t the proper thing

Hey Folks, I can''t really glean this from the documentation. Is there a way to do: add_index(table_name, column_name, index_type) within my migration for an index that spans multiple columns? Ie: A covering index on FIRST_NAME, LAST_NAME or something like that? Best, Brian --------------------------- Brian Corrigan ---------------------------

I have a migration "x" that when it runs self.up it adds a new column to a table, and of course when self. down is run it deletes said table... After I ran this migration I continued to work and in the process added a couple other migrations. After a while I realized that the column migration "x" created was a mistake and I no longer need it. So I ran rake db:migrate:down

I''m writing a bloggish/CMSish thing. I had been using simple_format, but my users requested a rich editor, so I added TinyMCE. Anyway, I was trying to migrate the existing content (since TinyMCE assumes it''s reading HTML-formatted text), and realized that I couldn''t call simple_format (or other helper methods) from Migrations. Can someone enlighten me here?

Rails 2.3 How does one identify the adapter that a migration is using? I have some SQL code that only applies if the postgresql adapter is involved and I wish to put my execute method inside a suitable conditional. However, I cannot see a way to get this information from an instance of ActiveRecord::Migration. Nonetheless, some means must exist for migrations to work. How do I ID the DBMS

Hi, I am trying to figure out an approach to load in our initial data into our database. I have written some load_data migrations which populate a lot of the stuff, how some of the database items are images etc and I am trying to figure out how to approach added them to the database during a rake db:migrate I am thinking if I store the files in a folder off the RAILS_ROOT I should be able to