
var objDB;

event OnInitialize()
{
	::SvsDump("OnInitialize:" + ::SvsGetActionName());
	objDB = new DirectQueryDB;
	::SetTimer(0, 5000, -1);
}

event OnTerminate()
{
	objDB.DisConnect();
	::SvsDump("OnTerminate:" + ::SvsGetActionName());
}

event OnTimer(timerid,counter)
{
	::SvsDump("OnTimer Id:" + ::CStr(timerid) + " counter:" + ::CStr(counter));

	if(!mConnectDB()){
		 return;
	}
	var vFieldNum, vRecordNum, vFieldName, vFieldType, vData;
	if(!objDB.QuerySQL("SELECT * FROM LOGTABLE", vFieldNum, vRecordNum, vFieldName, vFieldType, vData)){
		::SvsDump("Fail to query sql. Msg:" + objDB.GetLastError());
		objDB.DisConnect();
		return;
	}

	::SvsDump("FieldName:" + ::CArrayToStr(vFieldName, ",", F));
	::SvsDump("Data:" + ::CScript(vData));
}

function mConnectDB()
{
	var vDSN = "LOGGERDB";
	var vDbName = "LOGGERDB";
	var vDbUser = "user";
	var vDbPass = "password";

	if(!objDB.Connect(vDSN, vDbName, vDbUser, vDbPass)){
		::SvsDump(objDB.GetLastError());
		return F;
	}
	return T;
}
