Idea: -o could open to a more convenient location

[simonw]

Idea: if a database only has a single table, this could open straight to /db/table. If it has multiple tables but a single database it could open straight to /db.
Originally posted by @simonw in #970 (comment)

[simonw]

This is complex enough new logic that it will need test coverage - specifically covering tables or databases with strange names.

[simonw]

I used the new datasette.urls methods to handle escaping table names.

datasette/datasette/utils/__init__.py

Lines 996 to 1008 in f5dbe61

	async def initial_path_for_datasette(datasette):
	"Return suggested path for opening this Datasette, based on number of DBs and tables"
	if len(datasette.databases) == 1:
	db_name = next(iter(datasette.databases.keys()))
	path = datasette.urls.database(db_name)
	# Does this DB only have one table?
	db = next(iter(datasette.databases.values()))
	tables = await db.table_names()
	if len(tables) == 1:
	path = datasette.urls.table(db_name, tables[0])
	else:
	path = datasette.urls.instance()
	return path