VSCP Helper library API - Table handling

tableCreate

    int tableCreate( const unsigned char *pTableData );

Create table from XML data.

pTableData

Pointer to string containing UTF8 XML definition of table.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableDelete

    int tableDelete( const unsigned char *pName, int bDeleteFile );

Delete named table.

tblName

Name of an existing table.

bDeleteFile

If TRUE (!=0) the database file also should be deleted. If not it will be reused if a table with the same name is created later.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableList

    int tableList( unsigned char **pLists );

Get a list of all defined tables.

pLists

List of null terminated strings that will get filled with table names. The list is allocated on the heap and must be freed by the user. If no result is returned set to a NULL pointer.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableListInfo

    int tableListInfo( const unsigned char *pName, 
                            unsigned char *pTableInfo, 
                            int bXML );

Delete named table.

tblName

Name of an existing table.

pTableInfo

Pointer to string that contain information about the table. The list is allocated on the heap and must be freed by the user. If no result is returned set to a NULL pointer.

bXML

If TREU (!=0) info will be returned as BASE64 encoded XML data.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGet

    int tableGet( const unsigned char *pName, 
                                const char *pFrom, 
                                const char *pTo,
                                unsigned char **pResultArray,
                                BOOL bFull );

Get data from a named table in a range to-from. One can fetch all columns of the table (bFull) or just datetime and value (default).

tblName

Name of an existing table.

from

Datetime from which data should be fetched. Should be given on ISO 8601 format YY-MM-DDTHH:MM:SS.

to

Datetime up to which data is fetched. Should be given on ISO 8601 format YY-MM-DDTHH:MM:SS.

pResultArray

List of null terminated strings that will get filled with rows (if any) from the table. The list is allocated on the heap and must be freed by the user. If no result is returned set to a NULL pointer.

YY-MM-DDTHH:MM:SSsss, value1[,other fields]<CR><LF>
YY-MM-DDTHH:MM:SSsss, value2[,other fields]<CR><LF>
YY-MM-DDTHH:MM:SSsss, value3[,other fields]<CR><LF>
...
YY-MM-DDTHH:MM:SS, valuen[,other fields]<CR><LF>

bFull

If TREU (!=0) all fields of a table row is returned (other fields above) in a comma separated list. Note that datetime is always listed first followed by value regardless of how the columns of the table is arranged.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetRaw

    int tableGetRaw( const unsigned char *pName, 
                         const char *pFrom, 
                         const char *pTo,
                         unsigned char **pResultArray );

Get data from a named table in a range to-from. All columns of the table is always returned.

tblName

Name of an existing table.

from

Datetime from which data should be fetched. Should be given on ISO 8601 format YY-MM-DDTHH:MM:SS.

to

Datetime up to which data is fetched. Should be given on ISO 8601 format YY-MM-DDTHH:MM:SS.

resultArray

List of null terminated strings that will get filled with rows (if any) from the table. The list is allocated on the heap and must be freed by the user. If no result is returned set to a NULL pointer.

comma separated row of database columns<CR><LF>
comma separated row of database columns<CR><LF>
comma separated row of database columns<CR><LF>
...
comma separated row of database columns<CR><LF>

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableLog

    int tableLog( const unsigned char *pName, 
                        double value, 
                        char *pdt );

Log a value, date/time pair to a table.

tblName

Name of an existing table.

value

Value to log.

pdt

Pointer to date/time value. Can be NULL (or empty) and in which case the current date/time is used.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableLogSQL

    int tableLogSQL( const unsigned char *pName, 
                        const unsigned char *psql );

Log data to with a SQL expression.

tblName

Name of an existing table.

psql

Pointer to string that contain SQL expression used to log data.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetNumRecords

    int tableGetNumRecords( const unsigned char *pName, 
                                const char *pFrom, 
                                const char *pTo,
                                size_t *pRecords );

Get number of records for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pRecords

size_t that will get number of records in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetFirstDate

    int tableGetFirstDate( const unsigned char pName, 
                                const char *pFrom, 
                                const char *pTo,
                                char *pFirst );

Get the first data/time for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pFirst

A string buffer that will get the first date/time in the interval on success. The buffer is supposed to hold a ISO formatted date/time value (YYYY-MM-DDTHH:MM:SS) so it should be able to hold at least twenty characters.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetLastDate

    int tableGetLastDate( const unsigned char *pName, 
                                const char *pFrom, 
                                const char *pTo,
                                char *pLast );

Get the last data/time for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pLast

A string buffer that will get the last date/time in the interval on success. The buffer is supposed to hold a ISO formatted date/time value (YYYY-MM-DDTHH:MM:SS) so it should be able to hold at least twenty characters.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetSum

    int tableGetSum( const unsigned char *pName, 
                        const char *pFrom, 
                        const char *pTo,
                        double *pSum );

Get the sum of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pSum

Pointer to a double that will get the sum of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetMin

    int tableGetMin( const unsigned char *pName, 
                        const char *pFrom, 
                        const char *pTo,
                        double *pMin );

Get the minimum of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pMin

Pointer to a double that will get the minimum of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetMax

    int tableGetMax( const unsigned char *pName, 
                        const char *pFrom, 
                        const char *pTo,
                        double *pMax );

Get the maximum of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pMax

Pointer to a double that will get the maximum of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetAverage

    int tableGetAverage( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo,
                            double *pAverage );

Get the average of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pAverage

Pointer to a double that will get the average of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetMedian

    int tableGetMedian( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo,
                            double *pMedian );

Get the median (middle/second quartile) of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pMedian

Pointer to a double that will get the median of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetStdDev

    int tableGetStdDev( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo,
                            double *pStdDev );

Get the standard deviation of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pStdDev

Pointer to a double that will get the standard deviation of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetVariance

    int tableGetVariance( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo,
                            double *pVariance );

Get the variance of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pVariance

Pointer to a double that will get the variance of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetMode

    int tableGetMode( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo,
                            double *pMode );

Get the mode of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pMode

Pointer to a double that will get the mode of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetLowerQ

    int tableGetLowerQ( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo,
                            double *pLowerQ );

Get the lower/first quartile of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pLowerQ

Pointer to a double that will get the lower quartile of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableGetUpperQ

    int tableGetUpperQ( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo,
                            double *pUpperQ );

Get the upper/third quartile of all values for an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

pUpperQ

Pointer to a double that will get the upper quartile of all values in the interval on success.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

tableClear

    int tableClear( const unsigned char *pName, 
                            const char *pFrom, 
                            const char *pTo );

Remove all records in an interval in a named table.

tblName

Name of an existing table.

from

Date/time from which resulting data should be fetched. Set to “0000-01-01T00:00:00” for beginning of time.

to

Date/time to which resulting data should be fetched. Set to “9999-12-31T23:59:59” for end of time.

Return Value

CANAL_ERROR_SUCCESS on success or an error code on failure.

VSCP Helper Libraries

User Tools

Site Tools

Sidebar

VSCP Helper Library

Table of Contents

VSCP Helper library API - Table handling

tableCreate

pTableData

Return Value

tableDelete

tblName

bDeleteFile

Return Value

tableList

pLists

Return Value

tableListInfo

tblName

pTableInfo

bXML

Return Value

tableGet

tblName

from

to

pResultArray

bFull

Return Value

tableGetRaw

tblName

from

to

resultArray

Return Value

tableLog

tblName

value

pdt

Return Value

tableLogSQL

tblName

psql

Return Value

tableGetNumRecords

tblName

from

to

pRecords

Return Value

tableGetFirstDate

tblName

from

to

pFirst

Return Value

tableGetLastDate

tblName

from

to

pLast

Return Value

tableGetSum

tblName

from

to

pSum

Return Value

tableGetMin

tblName

from

to

pMin

Return Value

tableGetMax

tblName

from

to

pMax

Return Value