4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync## @file
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This file is used to create/update/query/erase table for data models
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync#
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# http://opensource.org/licenses/bsd-license.php
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync#
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#
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync##
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# Import Modules
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync#
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsyncimport Common.EdkLogger as EdkLogger
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsyncimport CommonDataClass.DataClass as DataClass
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsyncfrom Table import Table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsyncfrom Common.String import ConvertToSqlString
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync## TableDataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync#
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# This class defined a table used for data model
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync#
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync# @param object: Inherited from object class
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync#
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync#
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsyncclass TableDataModel(Table):
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync def __init__(self, Cursor):
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync Table.__init__(self, Cursor)
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync self.Table = 'DataModel'
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Create table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Create table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
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 #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync def Create(self):
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 )""" % self.Table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync Table.Create(self, SqlCommand)
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Insert table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Insert a record into table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
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 #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync def Insert(self, CrossIndex, Name, Description):
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync self.ID = self.ID + 1
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync (Name, Description) = ConvertToSqlString((Name, Description))
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync SqlCommand = """insert into %s values(%s, %s, '%s', '%s')""" % (self.Table, self.ID, CrossIndex, Name, Description)
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync Table.Insert(self, SqlCommand)
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync return self.ID
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Init table
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Create all default records of table DataModel
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync def InitTable(self):
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync EdkLogger.verbose("\nInitialize table DataModel started ...")
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync for Item in DataClass.MODEL_LIST:
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync CrossIndex = Item[1]
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync Name = Item[0]
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync Description = Item[0]
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync self.Insert(CrossIndex, Name, Description)
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync EdkLogger.verbose("Initialize table DataModel ... DONE!")
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync ## Get CrossIndex
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # Get a model's cross index from its name
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @param ModelName: Name of the model
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync # @retval CrossIndex: CrossIndex of the model
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync #
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync def GetCrossIndex(self, ModelName):
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync CrossIndex = -1
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync SqlCommand = """select CrossIndex from DataModel where name = '""" + ModelName + """'"""
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync self.Cur.execute(SqlCommand)
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync for Item in self.Cur:
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync CrossIndex = Item[0]
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync
4fd606d1f5abe38e1f42c38de1d2e895166bd0f4vboxsync return CrossIndex