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