sqlalchemy and geomet

[jGaboardi]

Both sqlalchemy and geomet were removed from requirements in #579, sqlalchemy by accident and geomet on purpose.

• For sqlalchemy we simply need to add that back into pyproject.toml and in the appropriate ci/* environment.
• For geomet it's a bit more complicated since we need to address some functionality and testing:
  • libpysal/io/iohandlers/db.py
  • libpysal/io/iohandlers/__init__.py
  • libpysal/io/iohandlers/tests/test_db.py

[jGaboardi]

@martinfleis I think this whole block below can go, no? shapley is now a hard dependency and geomet is gone.

libpysal/libpysal/io/iohandlers/db.py

Lines 5 to 13 in 0ea928a

	try:
	try:
	from geomet import wkb
	except ImportError:
	from shapely import wkb
	except ImportError:
	wkb = None
	errmsg += "No WKB parser found. Please install one of the following packages "
	errmsg += "to enable this functionality: [geomet, shapely].\n"

[martinfleis]

Yes, we should use shapely by default.

[jGaboardi]

The Test_sqlite_reader test is causing trouble due to this helper fucntion. Going to refactor the test to ensure passing.