Possible to set the ID of a new bean?

[abxccd]

I need to create a record with a certain ID (the ID is guranteed to not be in used by another existing row.

 

I have tried:

$bean = R::dispense('mytable);

$bean-> id = 20;

$bean->property = "some property";

R::store($bean);

 

The problem is that the bean never gets saved. Is this something that we can do in redbean?

[gabor]

Unfortunately this is not possible because RedBeanPHP uses
autoincrement IDs.
If the id > 0 RedBeanPHP thinks the bean has already been inserted and
it will try to update the record.
I recommend to use another id-field for this, I guess this is for
external system interaction?

[abxccd]

Hi Gabor,

 

Thanks for your help :)

 

Actually, it's just to make sure that a certain record has a certain ID in a permission authorization system. Because I am inserting some default permissions, where the ordering is important.

 

But that's alright, because I have written my script to insert data in order. The setting the ID was just to try and make it foolproof, incase the insertion order were changed. :)

[Anton A.]

What is the sense to have 2 IDs if the external ID is just a BIGINT and perfectly fits as a default PK that RedBean would understand?

RedBean concept and approach is so nice, but this simple issue makes it really non-applicable to many cases.

[Jake Chapa]

R::exec(‘UPDATE table SET id=NEW_ID where id=OLD_ID’);

--
You received this message because you are subscribed to the Google Groups "redbeanphp" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redbeanorm+...@googlegroups.com.
To post to this group, send email to redbe...@googlegroups.com.
Visit this group at http://groups.google.com/group/redbeanorm.
For more options, visit https://groups.google.com/d/optout.

[Anton Andriyevskyy]

It is a workaround and has its own drawbacks and limitations:

1. 1+ query - not good for daily inputs of million records with long transaction bodies.

2. ID collisions

3. ID still needs to be autoincrement

You received this message because you are subscribed to a topic in the Google Groups "redbeanphp" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/redbeanorm/tQk_eY1K3pQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to redbeanorm+...@googlegroups.com.