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]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
