4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This file is used to create a database used by ECC tool
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# Copyright (c) 2007 - 2008, Intel Corporation. All rights reserved.<BR>
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This program and the accompanying materials
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# are licensed and made available under the terms and conditions of the BSD License
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# which accompanies this distribution. The full text of the license may be found at
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# THE PROGRAM IS DISTRIBUTED UNDER THE BSD LICENSE ON AN "AS IS" BASIS,
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# WITHOUT WARRANTIES OR REPRESENTATIONS OF ANY KIND, EITHER EXPRESS OR IMPLIED.
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# Import Modules
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsyncfrom String import *
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsyncfrom DataType import *
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This class defined the build databse
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# During the phase of initialization, the database will create all tables and
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# insert all records of table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# @param object: Inherited from object class
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# @param DbPath: A string for the path of the ECC database
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# @var Conn: Connection of the ECC database
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# @var Cur: Cursor of the connection
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# @var TblDataModel: Local instance for TableDataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync self.Conn = sqlite3.connect(DbPath, isolation_level = 'DEFERRED')
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Initialize build database
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # 1. Delete all old existing tables
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # 2. Create new tables
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # 3. Initialize table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync EdkLogger.verbose("\nInitialize ECC database started ...")
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Drop all old existing tables
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# self.TblDataModel.Drop()
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# self.TblDsc.Drop()
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# self.TblFile.Drop()
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Create new tables
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Initialize table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync EdkLogger.verbose("Initialize ECC database ... DONE!")
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Query a table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param Table: The instance of the table to be queried
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Close entire database
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Commit all first
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Close the connection and cursor
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This acts like the main() function for the script, unless it is 'import'ed into another