My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 568: Batch user import
4 people starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  ----


Sign in to add a comment
 
Reported by pkufra...@gmail.com, May 11, 2010
As an adminstrator, I want to add tons of users at once and assign their 
group membership (and add ssh keys, for example). However, with current 
gerrit, i can't assign the groupship all at once because i have to wait for 
all users registered by signing in with their openids. It is a painful thing 
for me.
May 11, 2010
#1 sop@google.com
For some types of OpenID providers we can't assign users, because
the provider uses an encrypted, unique token for each website.  E.g.
Yahoo! and Google both do this.

But, there are other providers that use a predictable username as
part of their URL.  So you could batch insert those users.  But I just
don't see enough value in writing this code myself.

For now you can do bulk inserts into accounts, account_external_ids,
and account_group_members to get what you want.  Just make sure
you use nextval('account_id') to bump the counter used to assign new
unique surrogate keys to the accounts.
May 11, 2010
#2 pkufra...@gmail.com
> For some types of OpenID providers we can't assign users, because
> the provider uses an encrypted, unique token for each website.  E.g.
> Yahoo! and Google both do this.

So the reason is the username is not predictable from url?

In a company environment, i can provide the username and the openid together.
May 11, 2010
#3 sop@google.com
Its hard to get a predictable URL from some providers.

But I just don't need to batch insert users.  If someone else
writes the code, it can get accepted.
May 20, 2011
Project Member #4 nas...@grainawi.org
(No comment was entered for this change.)
Status: Accepted
Sign in to add a comment

Powered by Google Project Hosting