How do you determine the next ID for inserting rows manually into the Crowd DB?

[Graham Bakay]

Hi everyone,

I would like to bulk-add some user memberships in Crowd. It appears the easiest way to do that would be to just add records into the cwd_membership table with the appropriate columns. However, it looks like all the records in Crowd require a unique ID. How do I determine the next in that sequence? It doesn't appear that the ID field is auto-increment.

Thanks in advance,

Graham.

[JustinK · Accepted solution]

You can also make use of the REST API's that crowd exposes and simply write a script that makes use of these. https://developer.atlassian.com/display/CROWDDEV/Crowd+REST+APIs

[Graham Bakay]

I guess I'll go that route. Was hoping to be able to do it directly in the DB, as I'm migrating group memberships from a Crowd 1.6.x instance in a separate schema.

Thanks, Justin.

g.

[JustinK]

Yes, sorry about this Graham. All Atlassian apps use the same approach for their sequencing. The reason why we do this is because we want to be able to have a database neutral way of controling sequence numbers, and to also have a way of controlling sequences after you export the data from your Atlassian product to XML, and re-import it elsewhere.

[Graham Bakay]

Makes sense. Thanks.

g.

[Septa Cahyadiputra]

Hi Graham,

I think the next id should be stored on this table

• hibernate_unique_key

You might want to double check that. Hope it helps.

Cheers,

Septa Cahyadiputra

[Graham Bakay]

In my instance, the value of the next_hi column in hibernate_unique_key is only 49, whereas the highest ID I can find is 1474667, so I don't think that's doing it. :/

[Septa Cahyadiputra]

As describe here :

• https://developer.atlassian.com/display/CROWDDEV/Database+Schema+and+Example+SQL+for+Crowd

Crowd use ResettableTableHiLoGenerator to generate the next unique key.

Hope it helps.

Cheers,
Septa Cahyadiputra

[Graham Bakay]

So I'm assuming there is no way to properly add rows to the database manually. It has to be done inside the application.