## @file | |
# This file is used to create/update/query/erase table for dec datas | |
# | |
# Copyright (c) 2008, Intel Corporation. All rights reserved.<BR> | |
# This program and the accompanying materials | |
# are licensed and made available under the terms and conditions of the BSD License | |
# which accompanies this distribution. The full text of the license may be found at | |
# http://opensource.org/licenses/bsd-license.php | |
# | |
# THE PROGRAM IS DISTRIBUTED UNDER THE BSD LICENSE ON AN "AS IS" BASIS, | |
# WITHOUT WARRANTIES OR REPRESENTATIONS OF ANY KIND, EITHER EXPRESS OR IMPLIED. | |
# | |
## | |
# Import Modules | |
# | |
import Common.EdkLogger as EdkLogger | |
import CommonDataClass.DataClass as DataClass | |
from Table import Table | |
from Common.String import ConvertToSqlString | |
## TableDec | |
# | |
# This class defined a table used for data model | |
# | |
# @param object: Inherited from object class | |
# | |
# | |
class TableDec(Table): | |
def __init__(self, Cursor): | |
Table.__init__(self, Cursor) | |
self.Table = 'Dec' | |
## Create table | |
# | |
# Create table Dec | |
# | |
# @param ID: ID of a Dec item | |
# @param Model: Model of a Dec item | |
# @param Value1: Value1 of a Dec item | |
# @param Value2: Value2 of a Dec item | |
# @param Value3: Value3 of a Dec item | |
# @param Arch: Arch of a Dec item | |
# @param BelongsToItem: The item belongs to which another item | |
# @param BelongsToFile: The item belongs to which dsc file | |
# @param StartLine: StartLine of a Dec item | |
# @param StartColumn: StartColumn of a Dec item | |
# @param EndLine: EndLine of a Dec item | |
# @param EndColumn: EndColumn of a Dec item | |
# @param Enabled: If this item enabled | |
# | |
def Create(self): | |
SqlCommand = """create table IF NOT EXISTS %s (ID INTEGER PRIMARY KEY, | |
Model INTEGER NOT NULL, | |
Value1 VARCHAR NOT NULL, | |
Value2 VARCHAR, | |
Value3 VARCHAR, | |
Arch VarCHAR, | |
BelongsToItem SINGLE NOT NULL, | |
BelongsToFile SINGLE NOT NULL, | |
StartLine INTEGER NOT NULL, | |
StartColumn INTEGER NOT NULL, | |
EndLine INTEGER NOT NULL, | |
EndColumn INTEGER NOT NULL, | |
Enabled INTEGER DEFAULT 0 | |
)""" % self.Table | |
Table.Create(self, SqlCommand) | |
## Insert table | |
# | |
# Insert a record into table Dec | |
# | |
# @param ID: ID of a Dec item | |
# @param Model: Model of a Dec item | |
# @param Value1: Value1 of a Dec item | |
# @param Value2: Value2 of a Dec item | |
# @param Value3: Value3 of a Dec item | |
# @param Arch: Arch of a Dec item | |
# @param BelongsToItem: The item belongs to which another item | |
# @param BelongsToFile: The item belongs to which dsc file | |
# @param StartLine: StartLine of a Dec item | |
# @param StartColumn: StartColumn of a Dec item | |
# @param EndLine: EndLine of a Dec item | |
# @param EndColumn: EndColumn of a Dec item | |
# @param Enabled: If this item enabled | |
# | |
def Insert(self, Model, Value1, Value2, Value3, Value4, Value5, Arch, BelongsToItem, BelongsToFile, StartLine, StartColumn, EndLine, EndColumn, Enabled): | |
self.ID = self.ID + 1 | |
(Value1, Value2, Value3, Arch) = ConvertToSqlString((Value1, Value2, Value3, Arch)) | |
SqlCommand = """insert into %s values(%s, %s, '%s', '%s', '%s', '%s', %s, %s, %s, %s, %s, %s, %s)""" \ | |
% (self.Table, self.ID, Model, Value1, Value2, Value3, Arch, BelongsToItem, BelongsToFile, StartLine, StartColumn, EndLine, EndColumn, Enabled) | |
Table.Insert(self, SqlCommand) | |
return self.ID | |
## Query table | |
# | |
# @param Model: The Model of Record | |
# | |
# @retval: A recordSet of all found records | |
# | |
def Query(self, Model): | |
SqlCommand = """select ID, Value1, Value2, Value3, Arch, BelongsToItem, BelongsToFile, StartLine from %s | |
where Model = %s | |
and Enabled > -1""" % (self.Table, Model) | |
EdkLogger.debug(4, "SqlCommand: %s" % SqlCommand) | |
self.Cur.execute(SqlCommand) | |
return self.Cur.fetchall() |