agri-typ-c-3-db1

gistfile1.txt

    def saveSensor(self, getDat, datMc):
    	ret=False
    	clsConst = com_appConst.appConstClass()
    	connection = MySQLdb.connect(host=clsConst.mHost, db=clsConst.mDB_NAME, user=clsConst.mUser, passwd=clsConst.mPass, charset="utf8")
    	if(datMc["vnum_1"]==1):
    		cursor = connection.cursor()
    		sSql=u"INSERT INTO t_sensors (mc_id"
    		sSql=sSql+",vnum"
    		sSql=sSql+",snum"
    		sSql=sSql+",created"
    		sSql=sSql+") values ("
    		sSql=sSql+getDat["mc_id"]
    		sSql=sSql+",1"
    		sSql=sSql+","+getDat["snum_1"]
    		sSql=sSql+",now() );"
    		cursor.execute(sSql)
    		connection.commit()
    		cursor.close()