4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This file is used to create/update/query/erase table for data models
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# Copyright (c) 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
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync## TableDataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This class defined a table used for data model
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# @param object: Inherited from object class
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Create table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Create table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param ID: ID of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param CrossIndex: CrossIndex of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param Name: Name of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param Description: Description of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync SqlCommand = """create table IF NOT EXISTS %s (ID INTEGER PRIMARY KEY,
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync CrossIndex INTEGER NOT NULL,
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync Name VARCHAR NOT NULL,
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync Description VARCHAR
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Insert table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Insert a record into table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param ID: ID of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param CrossIndex: CrossIndex of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param Name: Name of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param Description: Description of a ModelType
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync (Name, Description) = ConvertToSqlString((Name, Description))
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync SqlCommand = """insert into %s values(%s, %s, '%s', '%s')""" % (self.Table, self.ID, CrossIndex, Name, Description)
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Init table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Create all default records of table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync EdkLogger.verbose("\nInitialize table DataModel started ...")
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync EdkLogger.verbose("Initialize table DataModel ... DONE!")
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Get CrossIndex
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Get a model's cross index from its name
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param ModelName: Name of the model
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @retval CrossIndex: CrossIndex of the model
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync SqlCommand = """select CrossIndex from DataModel where name = '""" + ModelName + """'"""