Re: Heroku and Sequel Migrations

[Scott LaBounty]

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  wrote:

> Well, that was the first place I asked ;-).
>
> Scott
>
>
> On Wed, Aug 25, 2010 at 7:36 AM, Robert Eanes  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 
>> 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 
>> 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 
>> 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 
>> 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 her...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> heroku+unsubscr...@googlegroups.com
>> .
>> > 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 her...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> heroku+unsubscr...@googlegroups.com
>> .
>> > 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 her...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> heroku+unsubscr...@googlegroups.com
>> .
>> > For more options, visit this group at
>> http://group

Re: Heroku and Sequel Migrations

[Scott LaBounty]

Well, that was the first place I asked ;-).

Scott

On Wed, Aug 25, 2010 at 7:36 AM, Robert Eanes  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 
> 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 
> 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 
> 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 
> 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 her...@googlegroups.com.
> > To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> > 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 her...@googlegroups.com.
> > To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> > 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 her...@googlegroups.com.
> > To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> > 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 her...@googlegroups.com.
> > To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> > For more options, visit this group at
> http://groups.google.com/group/heroku?hl=e

Re: Heroku and Sequel Migrations

[Steve Smith]

If you aren't using bundler then it probably won't make a difference. I was 
just wondering why the sequel binary was not being found and the only reason I 
could think of was that it was installed with bundler rather than the normal 
gem process?

Bundle exec simply loads your bundled environment before running the command 
you pass after the exec but if you are not using bundler this probably won't 
help.

I just had a look and was able to access other binaries such as haml -v without 
having to use bundler from my console so it really looks like you need to 
discover why the sequel binary isn't found once the gem is installed.

Steve

--
http://cloudmailin.com
@cloudmailin
Incoming email for your web app



On 25 Aug 2010, at 15:24, Scott LaBounty wrote:

> Steve, 
> 
> I'm not using bundler. Would I do this (bundle exec ...) from the heroku 
> console?
> 
> Scott
> 
> On Wed, Aug 25, 2010 at 7:20 AM, Steve Smith  wrote:
> I'm afraid I only have one idea then I'm out as I've not used sequel.
> Does system 'bundle exec sequel -v' make any difference if you are
> using bundler?
> 
> Steve
> 
> --
> http://cloudmailin.com
> @cloudmailin
> Incoming email for your web app
> 
> On Aug 25, 2:14 pm, Scott LaBounty  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  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 
> > > 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 her...@googlegroups.com.
> > >> To unsubscribe from this group, send email to
> > >> heroku+unsubscr...@googlegroups.com
> > >> .
> > >> 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 her...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > heroku+unsubscr...@googlegroups.com
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/heroku?hl=en.
> >
> > --
> > Scotthttp://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 her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> 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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Heroku and Sequel Migrations

[Robert Eanes]

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  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  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  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  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 her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku+unsubscr...@googlegroups.com.
> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to 
> heroku

Re: Heroku and Sequel Migrations

[Josh Coffman]

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  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 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 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 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 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> 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 her...@googlegroups.com.
 To unsubscribe from this group, send email to
 heroku+unsubscr...@googlegroups.com
 .
 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 her...@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> heroku+unsubscr...@googlegroups.com
>>> .
>>> 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 her...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> heroku+unsubscr...@googlegroups.com
>> .
>> 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 t

Re: Heroku and Sequel Migrations

[Scott LaBounty]

Steve,

I'm not using bundler. Would I do this (bundle exec ...) from the heroku
console?

Scott

On Wed, Aug 25, 2010 at 7:20 AM, Steve Smith  wrote:

> I'm afraid I only have one idea then I'm out as I've not used sequel.
> Does system 'bundle exec sequel -v' make any difference if you are
> using bundler?
>
> Steve
>
> --
> http://cloudmailin.com
> @cloudmailin
> Incoming email for your web app
>
> On Aug 25, 2:14 pm, Scott LaBounty  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 
> 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  >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 her...@googlegroups.com.
> > >> To unsubscribe from this group, send email to
> > >> heroku+unsubscr...@googlegroups.com
> 
> >
> > >> .
> > >> 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 her...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > heroku+unsubscr...@googlegroups.com
> 
> >
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/heroku?hl=en.
> >
> > --
> > Scotthttp://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 her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> 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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Heroku and Sequel Migrations

[Scott LaBounty]

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  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 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 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 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 her...@googlegroups.com.
 To unsubscribe from this group, send email to
 heroku+unsubscr...@googlegroups.com
 .
 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 her...@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> heroku+unsubscr...@googlegroups.com
>>> .
>>> 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 her...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> heroku+unsubscr...@googlegroups.com
>> .
>> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> 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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Heroku and Sequel Migrations

[Steve Smith]

I'm afraid I only have one idea then I'm out as I've not used sequel.
Does system 'bundle exec sequel -v' make any difference if you are
using bundler?

Steve

--
http://cloudmailin.com
@cloudmailin
Incoming email for your web app

On Aug 25, 2:14 pm, Scott LaBounty  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  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 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 her...@googlegroups.com.
> >> To unsubscribe from this group, send email to
> >> heroku+unsubscr...@googlegroups.com
> >> .
> >> 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 her...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > heroku+unsubscr...@googlegroups.com
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/heroku?hl=en.
>
> --
> Scotthttp://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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Heroku and Sequel Migrations

[Josh Coffman]

..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  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 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 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 her...@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> heroku+unsubscr...@googlegroups.com
>>> .
>>> 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 her...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> heroku+unsubscr...@googlegroups.com
>> .
>> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> 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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Heroku and Sequel Migrations

[Scott LaBounty]

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  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 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 her...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> heroku+unsubscr...@googlegroups.com
>> .
>> 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 her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> 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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Re: Heroku and Sequel Migrations

[Josh Coffman]

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  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 her...@googlegroups.com.
> To unsubscribe from this group, send email to
> heroku+unsubscr...@googlegroups.com
> .
> 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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.

Heroku and Sequel Migrations

[Scott LaBounty]

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 her...@googlegroups.com.
To unsubscribe from this group, send email to 
heroku+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en.