[Phpmyadmin-devel] batch user & db creation

[Marc Delisle]

Robin Johnson wrote:
> On Tue, Jan 07, 2003 at 08:41:00AM -0500, Marc Delisle wrote:
> 
>>- A new batch user and db creation mecanism. Starting
>>from a local file like this:
>>	user1, password1
>>	user2, password2
>>	user3, password3
>>	...
>>
>>we could upload this file.  There would be a radio button:
>>	() just create users
>>	() create users and generate a db named after the user
>>	() create users and generate a privilege that enables users to 
>>	create their dbs,
>>	   with the username as a prefix
> 
> extend the format slightly
> user1, host1, pwd1, db1
> user2, host2, pwd2, db2
> 
> and the "generate a db named after the user" can instead use the
> specified dbname if given, else it can use the username as the dbname.
> 
> I think the file should have quotes in it, since space and comma
> characters could be found in usernames/passwords/dbnames.
> so:
> 'user1', 'host1', 'pwd1', 'db1'
> 'user2', 'host2', 'pwd2', 'db2'

OK for me.  Should we use also the last field as the db prefix for
the case when we create only the privilege, not the db?
'user1', 'host1', 'pwd1', 'db1%'
> 
> maybe swap the order of host and password for easier use.
> data like this can be generated in Excel easily as CSV format with
> quotes.
> 
> 
>>On the "Add a new user" new page, there are some dialogs that could be used
>>also for the batch:
>>	- the host
>>	- the global privileges
> 
> Just abstract them to a function so that we can display identical
> dialogues on both the creation page and the batch page.
> 
> 
>>But I am not sure if the batch mecanism should be on the same page.
> 
> I think the batch stuff should definetly be on a sepearate page, as it
> could get very confusing for some people.
> 

Agreed.

> 
>>Of course, we need some validation to avoid creating databases that already 
>>exist.
> 
> Display an error if the username or db already exists and continue with
> the rest of the data.
> 

OK

Marc