root/branch/ggpolo/umitDBUpdates/insert-changes-into-db.py @ 1431

#!/usr/bin/env python
# Script for updating umitng database for new event storing schema.
# Author: Guilherme Polo <ggpolo@gmail.com>

"""
Run this as: python insert-changes-into-db.py /path/to/my/umitng.db
"""

import sys
from umitDB.InventoryChanges import ConnectToUpdate, UpdateChanges

def perform_update(database):
    """
    Update changes for each inventory.
    """
    db_conn = ConnectToUpdate(database)

    uc_instance = UpdateChanges(db_conn)
    inv_ids = db_conn.get_inventories_ids()
    inv_ids = [i_id[0] for i_id in inv_ids]
    
    for i_id in inv_ids:
        uc_instance.do_update(i_id)

    db_conn.conn.commit()

if __name__ == "__main__":
    if len(sys.argv) < 2:
        print "You need to especify a database"
        raise SystemExit

    db = sys.argv[1]
    perform_update(db)