Get vendor-specific data types in sqlalchemy

sqlalchemy_vendor_types.py

import importlib

class VendorType:
    """
    Return a list of vendor-specific datatype as a list.
    
    Parameters
    ----------
        vendor :str
            One of:
                -oracle
                -mysql
                -postgresql
                -sqlite
                -mssql
        """
    def __init__(self, vendor):
        self.vendor = vendor

    def type_path(self):
        return 'sqlalchemy.dialects.{}'.format(self.vendor)

    def get_types(self):
        mt = importlib.import_module(self.type_path())
        type_list =  mt.__all__
        # only return uppercase types. This step also removes non-datatypes
        # that somehow end up in __all__
        return [t for t in type_list if t.isupper()]
 
# For example :
vt = VendorType('sqlite').get_types()
print(vt)
# ['BLOB', 'BOOLEAN', 'CHAR', 'DATE', 'DATETIME', 'DECIMAL', 'FLOAT', 'INTEGER', 'NUMERIC', 'SMALLINT', 'TEXT', 'TIME', 'TIMESTAMP', 'VARCHAR', 'REAL']