piccolo user list command?

[waldner]

It would be useful to list existing users (for example, to avoid creating the admin user again if it exists; useful eg when running init containers in kbernetes).

[dantownsend]

It would be quite easy to add:

from piccolo.apps.user.tables import BaseUser

async def list_users():
    usernames = await BaseUser.select(BaseUser.username).output(as_list=True)
    print('\n'.join(usernames))

If you wanted you could add it as a custom command to your own app.

It might be worth adding to Piccolo itself as a piccolo user list command.

An alternative is to modify the piccolo user create command, so it has an if_not_exists option.

[waldner]

What about piccolo-orm/piccolo#921 ?

[waldner]

Well actually wait as I want to add more info to the output, while we're at it.

[waldner]

Ok, ready for review. Not sure how to deal with coverage, shall I add a test that creates a user and lists it?