DbStorageDS - device-server

Designed to store data in database and extract data from database.

Hosts on nuclotango.jinr.ru.

Uses database server MySQL.

Device Properties:
- host - ip adress ofthe host
- database - name of database to store data

Comands:
- SetRow
- GetList
- GetRow
- Init



=====SetRow command =====
Inserts the pair ClientName-data and current timestamp to the specified table.
=== Input parameter (Tango::DevVarStringArray) ===
- string - Table name
- string - Client name
- string - Data

The delimeter should be the ','. For example: settings, client1, “Init data1 = 12”
=== Output parameters ===
none


=====GetList command =====
Selects the list of (id, timestamps, client names) that consists with specified conditions from specified table.
=== Input parameter (Tango::DevVarStringArray) ===
- string - Conditions for sql select query. (String, that willl be placed after “WHERE” in sql query). (“Client=client1”)
- string - Table name
The delimeter should be the ','. For example: settings, client1, “Init data1 = 12”
=== Output parameter (Tango::DevVarLongStringArray) ===
- lvalue - long id
- svalue - string (DateTime + “ ” + Client)


=====GetRow command =====
Selects the row with specified id from specified table.
=== Input parameter (Tango::DevVarLongStringArray) ===
- lvalue - long id
- svalue - string Table name

The format should be the [lvalue][svalue] For example: [12][settings]

=== Output parameter (Tango::DevVarStringArray) ===
- string id
- string DateTime
- string Client
- string Data
—-
=====Init command =====
Initialisation of the device-server.
=== Input parameter ===
none
=== Output parameter ===
none



Documentation
Source
Linux EXE

You could leave a comment if you were logged in.