Heroku db id Starting with 1000

Hello All,

How do I change the heroku database( already existed ) table id to start
from say 1000?

I tried with a fresh database on local & it works with this:-
execute “ALTER users orders AUTO_INCREMENT = 1000”

Thanks,
Avinash

On Tuesday, March 12, 2013 4:28:59 PM UTC+5:30, Avi wrote:

Hello All,

How do I change the heroku database( already existed ) table id to start
from say 1000?

I tried with a fresh database on local & it works with this:-
execute “ALTER users orders AUTO_INCREMENT = 1000”

Sorry - this query - execute “SELECT setval(‘users_id_seq’, 1000)”

The above query is db already existed.

On 12 March 2013 10:58, Avi [email protected] wrote:

Hello All,

How do I change the heroku database( already existed ) table id to start
from say 1000?

Don’t bother. You should never care what the id is for a record, it
will just make life difficult if you do. If you want a column with a
meaningful number in it then add an extra column rather than using the
id.

Colin

The main reason I am doing this is :-
I am uploading some images to s3 amazon.
I am saving those images in s3 through rake script.
I have two tables having images.
Both are saving in one folder in s3.
I want to save those based on ids, so that there will not be any
conflict.

On Tue, Mar 12, 2013 at 4:35 PM, Colin L. [email protected]
wrote:


Thanks & Regards,
Avinash Behera
M-09538712979

On 12 March 2013 12:58, avinash behera [email protected]
wrote:

The main reason I am doing this is :-
I am uploading some images to s3 amazon.
I am saving those images in s3 through rake script.
I have two tables having images.
Both are saving in one folder in s3.
I want to save those based on ids, so that there will not be any conflict.

I don’t understand what you mean, do you mean you have two tables and
want to keep the ids of the two tables distinct from each other? If
so then that is a bad idea, it will be sure to cause you problems at
some time in the future. A better idea might be to have a third table
(images) that manages all the images and has a relationship to the
other tables. Possibly polymorphic (see
http://guides.rubyonrails.org/association_basics.html#polymorphic-associations
).

Colin

On Tue, Mar 12, 2013 at 7:58 AM, avinash behera
[email protected] wrote:

The main reason I am doing this is :-
I am uploading some images to s3 amazon.
I am saving those images in s3 through rake script.
I have two tables having images.
Both are saving in one folder in s3.

Do you mean they are being saved to the same bucket? Or do you mean a
path under the bucket? S3 has it’s own very unique method of storage.
But you can easily store things in the same bucket, but specify a
path-like prefix:

s3://mybucket/table1/image-n.jpg
s3://mybucket/table2/image-n.jpg

table1 and table2 aren’t really folders in S3, but they’re good enough
emulation to consider that for most uses.

I want to save those based on ids, so that there will not be any conflict.

As stated, don’t rely on the record ID in your database. Create a
unique id for each image if you’d like, and use that to tag it, if
that’s how you want to go.

So, my requirement is :-

I have an Image table & a related_image table.
image has_many related_images.
& related_images belongs to many images.
Those images in both the tables are in sequence(we can change the
sequence-
That will be a problem in case of belongs to many images).

So, this seems to be a better option to save images as id.
In s3, I am saving both the images(images & related_images) in one
folder
as .png or .jpg

After saving into s3, there are some other process to do like creating
.plist file from the json objects & others. Here I require those data
from
s3.

I was getting an interesting issue with heroku.
I was doing a db:reset & set the default id to start with 1000 & 10000
respectively.
It was working for the first time. If I do again a db:reset it goes. It
starts from 1.

I fixed it by adding migration file with :-
def change
execute “SELECT setval(‘images_id_seq’, 1000)”
end
def change
execute “SELECT setval(‘related_images_id_seq’, 10000)”
end

& on console by :- heroku pg:reset DATABASE --confirm MY_APP_NAME

So, now every time I reset, I need to run the migration & it works.

On Wed, Mar 13, 2013 at 2:16 AM, tamouse mailing lists <
[email protected]> wrote:

But you can easily store things in the same bucket, but specify a

For more options, visit https://groups.google.com/groups/opt_out.


Thanks,
Avinash

On Mar 14, 2013 1:58 AM, “avinash behera” [email protected]
wrote:

So, my requirement is :-

I have an Image table & a related_image table.
image has_many related_images.
& related_images belongs to many images.
Those images in both the tables are in sequence(we can change the
sequence- That will be a problem in case of belongs to many images).

So, this seems to be a better option to save images as id.
In s3, I am saving both the images(images & related_images) in one folder
as .png or .jpg

After saving into s3, there are some other process to do like creating
.plist file from the json objects & others. Here I require those data
from
s3.

I was getting an interesting issue with heroku.
I was doing a db:reset & set the default id to start with 1000 & 10000
respectively.
It was working for the first time. If I do again a db:reset it goes. It
starts from 1.

So, now every time I reset, I need to run the migration & it works.

On Wed, Mar 13, 2013 at 2:16 AM, tamouse mailing lists <
[email protected]> wrote:

path under the bucket? S3 has it’s own very unique method of storage.
But you can easily store things in the same bucket, but specify a
path-like prefix:

s3://mybucket/table1/image-n.jpg
s3://mybucket/table2/image-n.jpg

table1 and table2 aren’t really folders in S3, but they’re good enough
emulation to consider that for most uses.

I want to save those based on ids, so that there will not be any
conflict.

As stated, don’t rely on the record ID in your database. Create a
unique id for each image if you’d like, and use that to tag it, if
that’s how you want to go.


You received this message because you are subscribed to the Google
Groups “Ruby on Rails: Talk” group.

To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]


You received this message because you are subscribed to the Google G.
“Ruby on Rails: Talk” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to [email protected]
To post to this group, send email to [email protected]
For more options, visit https://groups.google.com/groups/opt_out.

Are images also capable of being related images? And vice versa?

On 14 March 2013 06:57, avinash behera [email protected]
wrote:

.png or .jpg

After saving into s3, there are some other process to do like creating
.plist file from the json objects & others. Here I require those data from
s3.

I was getting an interesting issue with heroku.
I was doing a db:reset & set the default id to start with 1000 & 10000
respectively.
It was working for the first time. If I do again a db:reset it goes. It
starts from 1.

I can’t say I exactly follow what you want, but I still suggest not to
use the id. Using the id causes problems as you have found out.
Instead simply add another field (image_id for example) and set it to
whatever values you want, independent of the id.

Colin

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs