def __update_devices(): '''updating devices''' pkl_notebooks = ptd.computers(workpass, workconfig) for c in pkl_notebooks: del c['id'] db.session.query(workdevice).filter_by(id=id).update(c) db.session.commit()
def __insert_computers(): ''' inserts .pkl devices to notebooks, as it setted in config file''' pkldevices = ptd.computers(workpass, workconfig) for pkldevice in pkldevices: device = workdevice(**pkldevice) db.session.add(device) db.session.commit()
def __insert_computers(only_new=True, existed_names=[]): ''' Inserts .pkl devices to notebooks, as it setted in config file. Inserts only computers with new urls if only_new = True ''' existed_urls = [d.url for d in db.session.query(workdevice).all()] pkldevices = ptd.computers(workpass, workconfig) i = 0 for pkldevice in pkldevices: if not pkldevice['name'] + '$$$' + pkldevice['model'] in existed_names: if not pkldevice['url'] in existed_urls: device = workdevice(**pkldevice) i = i + 1 db.session.add(device) else: print 'dublicate' db.session.commit()
def __insert_computers(only_new=True, existed_names=[]): """ Inserts .pkl devices to notebooks, as it setted in config file. Inserts only computers with new urls if only_new = True """ existed_urls = [d.url for d in db.session.query(workdevice).all()] pkldevices = ptd.computers(workpass, workconfig) i = 0 for pkldevice in pkldevices: if not pkldevice["name"] + "$$$" + pkldevice["model"] in existed_names: if not pkldevice["url"] in existed_urls: device = workdevice(**pkldevice) i = i + 1 db.session.add(device) else: print "dublicate" db.session.commit()