Difference between revisions of "Modules/ODBC"

Revision as of 21:15, 26 February 2025

Waiting to form

Module	Name	Version	License	Source	Languages	Platforms	Type	Author
ODBC	DB by ODBC Features: SQL, LIST	0.2	GPL2	bd_ODBC.so	en,uk,ru,de	x86,x86_64,ARM	DB	Roman Savochenko
Description
BD module. Provides support of different databases by the ODBC connectors and drivers to the databases. To Do: - specific DBMS properties: quotes for names and values (there are generic and standard ones), ... ; - OpenSCADA internal DB's layer function fieldStruct() implementation for generic SQL dialects and DBMS specific; - OpenSCADA internal DB's layer functions fieldSeek(), fieldGet(), fieldDel() implementation for generic SQL dialects and DBMS specific; - OpenSCADA internal DB's layer functions fieldDel() implementation for generic SQL dialects and DBMS specific; - generic tests passing for: SQLite(there are some problems in allowed connectors), MySQL, PostgreSQL, FireBird; - testing an ODBC connector for DBMS Oracle.

@@ Line 16: / Line 16: @@
 * '''To Do:'''
 <section begin=ToDo />
-:+ main functions implementation for generic SQL requests, testing for: SQLite, MySQL, PostgreSQL, FireBird;
 :- specific DBMS properties: quotes for names and values (there are generic and standard ones), ... ;
 :- OpenSCADA internal DB's layer function fieldStruct() implementation for generic SQL dialects and DBMS specific;