Hi Robert, Review Board really wasn't designed to do that. There's more than database IDs at stake. We also have JSON blobs referencing IDs in various places that would all need to be updated as well, and there just isn't a tool to do any of this.
A possible approach would be to generate a database dump using the existing dumpdata command, then post-processing this to choose new IDs (keeping a mapping of all ID transitions), post-processing any JSON blobs, and replicating that in the database. It's likely very error-prone. I wouldn't do it with the primary server running, since you won't want the database to be modified at all when this is happening. There isn't an easy way for this, though. Translating IDs in a database is not an easy task. Christian -- Christian Hammond - [email protected] Review Board - http://www.reviewboard.org Beanbag, Inc. - http://www.beanbaginc.com On Fri, May 1, 2015 at 10:53 AM, Robert Orr <[email protected]> wrote: > We created a new reviewboard server after using an old one for a while, > and after a few hundred reviews were done on the new server, realized that > we'd have to make room for porting old reviews to the new server. So - we > need to move reviews ID < 600 to above id = 100000. I've been munging > around with a python sqlalchemy script to do this, but I keep running into > the integrity checks you've got in place. Is there any easier way to do > this ? Its not like we need to do it more than once, just once to get the > new items out of the way, and once again to port the old database entries. > > -- > Supercharge your Review Board with Power Pack: > https://www.reviewboard.org/powerpack/ > Want us to host Review Board for you? Check out RBCommons: > https://rbcommons.com/ > Happy user? Let us know! https://www.reviewboard.org/users/ > --- > You received this message because you are subscribed to the Google Groups > "reviewboard" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/ Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/ Happy user? Let us know! https://www.reviewboard.org/users/ --- You received this message because you are subscribed to the Google Groups "reviewboard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
