And that's a good thought to look into what sequel itself is actually doing and maybe I can move it (or a simple version anyway) out to the rake task.
Thanks again, Scott On Wed, Aug 25, 2010 at 7:46 AM, Scott LaBounty <[email protected]> wrote: > 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/ > -- 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.
