[typo] plugins that alter the database

[Matt Rose]

I've been working on a plugin that uses the ruby feed_tools module to  
create a little mini-planet in the sidebar.  This is actually the  
blog plugin that I've always wanted, and thanks to ruby, rails and  
typo, I was able to code it up relatively easily.

        However, feed tools uses a database feed cache to store feeds, so  
that it doesn't fetch the feeds every time the page loads.  On my  
development database, I have added a cached_feeds table.  So now I'm  
worried that if I make the same alterations to my production db,  
It'll strand my typo install at whatever rev I'm at, without being  
able to upgrade.

Is there any way I can incorporate my database changes so that it'll  
co-operate with the rails migration process nicely.

I just installed the database migration by hand like this, on r946

[EMAIL PROTECTED]:~/rails/typo$ script/generate migration  
add_feed_tools_tables
       exists  db/migrate
       create  db/migrate/041_add_feed_tools_tables.rb

and edited db/migrate/041_add_feed_tools_tables.rb to look like this

[EMAIL PROTECTED]:~/rails/typo$ cat db/migrate/ 
041_add_feed_tools_tables.rb
class AddFeedToolsTables < ActiveRecord::Migration
   def self.up
     create_table :cached_feeds do |t|
       t.column :href, :string
       t.column :title, :string
       t.column :link, :string
       t.column :feed_data, :text
       t.column :feed_data_type, :string
       t.column :http_headers, :text
       t.column :last_retrieved, :datetime
     end
   end

   def self.down
     drop_table :cached_feeds
   end
end

Now when I try to log in, I get an error updating the db

To fix it I have to issue:

mv db/migrate/041_add_feed_tools_tables.rb db/migrate/ 
41_add_feed_tools_tables.rb

and then my update proceeds.

Now I can go ahead and install the sidebar plugin

Now, that you know what I'm doing, can anyone tell me how to

a)  Make this process easier?
b) Make sure it co-operates with later db migrations

TIA

Matt
_______________________________________________
Typo-list mailing list
Typo-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/typo-list