I'm thinking that there might not be a way to do this with existing heroku commands, and if I'm wrong I hope someone says so. However, you can extend the heroku commands with a plugin.
http://herocutter.heroku.com/ I didn't se one that applies. You may have to write your own. -j On Wed, Aug 25, 2010 at 7:23 AM, Scott LaBounty <[email protected]> wrote: > Josh, > > Yes, that's the sequel I'm referring to. Sorry I didn't make it clearer. > > What I'm looking for is the what would go into the rake db:migrate task. > When I run locally, I do something like: > > sequel -m dbMigration -M 1 sqlite://db.sqlite > > which does the database migrations in the directory "dbMigration" to > version "1" and creates the sqlite database "db.sqlite" in the current > directory. > > When I try to just do a "system 'sequel --version'" in the heroku console, > I just get "false" returned which I assume means that "sequel" is not > available. > > I can do a "heroku db:push sqlite://db.sqlite" and make everything work > fine, but I'd like to be able to do migrations (and use the postgresql > database provided) and that's what I'm currently stuck on. > > Thanks again, > > Scott > > > On Wed, Aug 25, 2010 at 7:12 AM, Josh Coffman <[email protected]>wrote: > >> ..hoping someone smarter than me will jump in here... >> >> At first I though you meant sql; so I searched and found this: >> http://sequel.rubyforge.org/ >> >> Is that what you are using? I'm just using sqlite, and have used mysql. It >> should work about the same for any supported db. Here's what I do for >> migrations in a rake task: >> `heroku db:migrate --app timesheettoaster` >> >> That calls the command line to migrate on heroku and specifies the app to >> use because I have 2; one for live, one for test. >> >> What happens when you try? error? >> >> >> >> On Wed, Aug 25, 2010 at 6:14 AM, Scott LaBounty <[email protected]>wrote: >> >>> Josh, >>> >>> Thanks for the idea, but it still doesn't work. I stripped it down a bit >>> further and tried to just run it from a Heroku console (figuring to add it >>> to rake later) with >>> >>> # heroku console >>> >> system "sequel --version" # Hoping here to get something back showing >>> that sequel is available >>> => false # Looking like sequel, the command, is not available at least >>> not in this way >>> >>> Am I totally missing something here or is this just not doable with >>> Sequel and Heroku? >>> >>> Thanks again, >>> >>> Scott >>> >>> >>> On Tue, Aug 24, 2010 at 4:04 PM, Josh Coffman <[email protected]>wrote: >>> >>>> call the heroku cli from your rake task. >>>> http://docs.heroku.com/heroku-command >>>> >>>> <http://docs.heroku.com/heroku-command> >>>> >>>> >>>> On Mon, Aug 23, 2010 at 6:33 AM, Scott LaBounty <[email protected]>wrote: >>>> >>>>> All, >>>>> >>>>> I'm trying to figure out how to have run a sequel migration on Heroku. >>>>> Here's the rake task that I can use locally ... >>>>> >>>>> << >>>>> namespace :db do >>>>> task :migrate do >>>>> version = ENV['VERSION'] ? "-M #{ENV['VERSION']}" : "" >>>>> system "sequel -m dbMigration #{version} #{ENV['DATABASE_URL'] >>>>> || 'sqlite://library.sqlite'} " >>>>> end >>>>> end >>>>> >> >>>>> >>>>> Does anyone have any good way to use Sequel migrations on Heroku? >>>>> Hints? Anything? >>>>> >>>>> -- >>>>> Scott >>>>> http://steamcode.blogspot.com/ >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Heroku" group. >>>>> To post to this group, send email to [email protected]. >>>>> To unsubscribe from this group, send email to >>>>> [email protected]<heroku%[email protected]> >>>>> . >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/heroku?hl=en. >>>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Heroku" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]<heroku%[email protected]> >>>> . >>>> For more options, visit this group at >>>> http://groups.google.com/group/heroku?hl=en. >>>> >>> >>> >>> >>> -- >>> Scott >>> http://steamcode.blogspot.com/ >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Heroku" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]<heroku%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/heroku?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Heroku" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<heroku%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/heroku?hl=en. >> > > > > -- > Scott > http://steamcode.blogspot.com/ > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<heroku%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
