Should detect collections.OrderedDict as a regular dictionary

[simonw]

  File "...python3.7/site-packages/sqlite_utils/db.py", line 292, in create_table
    column_type=COLUMN_TYPE_MAPPING[column_type],
KeyError: <class 'collections.OrderedDict'>

[simonw]

Here's the code:

sqlite-utils/sqlite_utils/utils.py

Lines 18 to 24 in 5e00006

	for key, types in all_column_types.items():
	if len(types) == 1:
	t = list(types)[0]
	# But if it's list / tuple / dict, use str instead as we
	# will be storing it as JSON in the table
	if t in (list, tuple, dict):
	t = str

[simonw]

OrderedDict is actually a subclass of dict - so a smart fix would be for this logic to check and see if the type t is a subclass of one of list, tuple or dict.