def getDb(self):
if(not self._db or self._db is None):
self._db = Db.DB(host='10.1.11.88', username='******', password='******', dbname='bkqw_estate', port = 3309)
return self._db
import Db
import ip
db = Db.DB()
sn = 1000000000000599
sensor_name_pre = 'test'
num = 599
for x in range(20000):
sn += 1
num += 1
mac = ip.randomMAC()
sensor_name = sensor_name_pre + str(num)
sql = "INSERT INTO `WIPS`.`device` (`sn`, `ip`, `mac`, `server_id`, `vid`, `coords`, `sensor_name`, `version`, `hard_version`, `update_status`, `vpn_ip`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
valu = (str(sn), '10.18.209.217', mac, '1', '1001', '', sensor_name, '2.0.1.3523', '3', '2', '')
scanNum = db.insert(sql, valu)
