Missing support for datatypes and missing list of supported types

[jh-RLI]

As part of the development of the oem2orm tool (creation of sqlalchemy tables from oemetadata) and also for the validation of the oemetada JSON strings it is necessary to document the required PostgreSQL data types as requirements.
Can you provide an overview? @Ludee

For the development of tools that use the oedialect it is also important to have an overview of the currently supported datatypes. For example, I noticed that "DOUBLE_PRECISION" is not supported (yet?). The same applies to "float('inf')" as described in this issue #13 .
Which data types are supported by the oedialect? @MGlauer

[Ludee]

Here is a list of (postgres) data types I already used in the oedb:

postgres	python	SQLA
serial
text
varchar
integer
double precision		float(15)/numeric
decimal		numeric/decimal
hstore
geometry (Point, Line, MultiLine, Polygon, MultiPolygon)

[MGlauer]

This is rather hard to answer - due to the way types are implemented in sqlalchemy - more precisely the infamous love triangle between python types, sqlalchemy classes and postgresql types. There is no comprehensive list of types that are supported.

[jh-RLI]

Okay, then we have to try and error until all required data types are supported? In general, the oedialect supports all data types that sqlalchemy supports?

[MGlauer]

BTW: I worked on a full(-ish) coverage of SQLAlchemy's tests on feature/travis. This includes sqlalchemy.testing.suite.test_types, which should already cover a decent amount of SQLAlchemy's type functionalities.