Well, that was the first place I asked ;-). Scott
On Wed, Aug 25, 2010 at 7:36 AM, Robert Eanes <[email protected]> wrote: > 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]<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]<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.
