From OpenSCADAWiki
Jump to: navigation, search
Line 8: Line 8:
 
<section end=info />
 
<section end=info />
 
| DB || Roman Savochenko || BD module. Provides support of different databases by the ODBC connectors and drivers to the databases.
 
| DB || Roman Savochenko || BD module. Provides support of different databases by the ODBC connectors and drivers to the databases.
 +
* '''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;
 +
:- 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.
 +
<section end=ToDo />
 
|}
 
|}

Revision as of 07:59, 21 May 2020

Constr.png Waiting to form
Module Name Version License Source Languages Platforms Type Author Description
ODBC DB by ODBC 0.2 GPL2 bd_ODBC.so en,uk,ru,de x86,x86_64,ARM DB Roman Savochenko BD module. Provides support of different databases by the ODBC connectors and drivers to the databases.
  • To Do:
+ 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;
- 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.