Beispiel #1
0
def populate_items_sets(list_of_ids):

    db = model.connect_db()

    for item_id in list_of_ids:

        model.enter_new_items_sets(db, item_id)

    db.close()
Beispiel #2
0
def populate_database_item_set_level3():

    success_count = 0
    error_count = 0

    for item_id in list_items_level3:

        try:
            model.enter_new_items_sets(db, item_id, 3)
            print item_id
            success_count += 1
        except KeyError:
            print "+++++++++++++++++++"
            print "This item was not included in any sets. Don't enter into database."
            print item_id
            print "++++++++++++++++++++"
            error_count += 1

    print "Successfully entered: " + str(success_count)
    print "Errors: " + str(error_count)
    print "Error rate: " + str(round(error_count / success_count * 100, 2)) + "%"