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 __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()