Hi,
I had some errors when using XbrlDB plugin store to semanticDBs, mostly on first time creation of the database, suggested fixes
here and patch files attached.
Errors descriptions as follows:
mmsql: "Can't find procedure GO" --> GO is only recognized by ssms
orcl: cannot establish connection with db --> db variable not included in connection string
mysql: fails on insert with "Field 'report_id' doesn't have a default value" --> triggers/sequences do not get created, also pymysql does not recognize 'DELIMITER'
jsonFile: error "Type not supported" when fact.xmlLang is missing and disclosureSystem validation is not enabled when on ModelValue objects.
Also included some updates for industry classifications tables.