Weekly report for 18 June 2010 on Project "Database Module + FuzzySQL"

This week I have implemented following Scilab-functions:

• DbConnect (with struct parameter)

• DbDisconnect

• DbLastError

• DbQuery

DbConnect

A struct for connection must contain at least data provider option named 'provider'. Other options, common for all database providers:

• host
• port
• user
• password

Other options, specific for database provider can be included into the connection struct. For complete list of specific options see QSqlDatabase::setConnectionOptions.

If unknown connection option is provided, it is ignored and a warning is displayed.

Testing

This week I have was testing the module on local PostgreSQL and SQLite databases.

Other functions

For specifications of other functions, see SEP for the project.

Debugging

I have also learned to debug a code linked to Scilab with Visual Studio.

Next Week

Next week I am going to

• Implement function DbConnect with a connection string parameter and functions DbFetchString, DbFetchAllString, DbFetchReal, DbFetchAllReal, DbAffectedRows.

• Get more providers to test the module.
• Include detailed specifications and examples for implemented functions into SEP.