SQLServer

README

b'=======================\nSQLServer Device Server\n=======================\n\nDescription\n-----------\n\nDevice Server for SQLServer Database Access\n\nDeveloped at ALBA by Sergi Rubio: http://www.tango-controls.org/Members/srubio\nThis device server requires fandango: http://www.tango-controls.org/Documents/tools/fandango\nIt is based on DynamicAttributes: http://www.tango-controls.org/howtos/dynamicattributes\n\n\nUsage\n-----\n\nTo use the device you must initialize the following properties: \n\n Host, Port, DataBase, User, Password\n\n\nThen, you can use the device directly executing the Query() command:\n\n value1 = PyTango.DeviceProxy(\'my/sql/server\').Query("select TOP 1 value from db.table1 where name in (\'value1\') order by ts DESC")</pre>\n\n\nOr create a DynamicAttributes property that read attribute values from the database using the QUERY keyword:\n\n Value1=QUERY("select TOP 1 value from db.table1 where name in (\'value1\') order by ts DESC")[0][0]\n\n\nYou can define intermediate variables to have shorter syntax or string substitution:\n\n QLAST=str("select TOP 1 value from db.table1 where name in (\'%s\') order by ts DESC")\n Value1=QUERY(str(QLAST)%\'Value1\')[0][0]</pre>\n\n\nThe T_ATTR keyword allows to set both timestamp and value for the attribute from a time,value row:\n\n Value1=DevDouble(T_ATTR(QUERY("select TOP 1 ts,value from db.table1 where name in (\'value1\') order by ts DESC")[0]))\n'