Never used this tool, but I would suggest you look at the source of the 'sequel' script and see what it's doing. If it's running those migrations with some ruby code, then that code is what you need to have in your db:migrate task.
Also, you may have better luck describing the heroku environment to people in the sequel project's community and asking how they would get it to work, since there doesn't seem to be anybody else on this group using it. On Aug 25, 2010, at 9:23 AM, Scott LaBounty 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 > > > > > 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]. > 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. > > > > -- > 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. > > > -- > 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. > > > > -- > 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. -- 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.
