| ## @file | |
| # This file is used to create/update/query/erase a meta file table | |
| # | |
| # 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 uuid | |
| import Common.EdkLogger as EdkLogger | |
| import EccGlobalData | |
| from MetaDataTable import Table | |
| from MetaDataTable import ConvertToSqlString | |
| from CommonDataClass.DataClass import MODEL_FILE_DSC, MODEL_FILE_DEC, MODEL_FILE_INF, \ | |
| MODEL_FILE_OTHERS | |
| class MetaFileTable(Table): | |
| ## Constructor | |
| def __init__(self, Cursor, MetaFile, FileType, TableName, Temporary = False): | |
| self.MetaFile = MetaFile | |
| self.TblFile = EccGlobalData.gDb.TblFile | |
| if (FileType == MODEL_FILE_INF): | |
| TableName = "Inf" | |
| if (FileType == MODEL_FILE_DSC): | |
| if Temporary: | |
| TableName = "_%s_%s" % ("Dsc", uuid.uuid4().hex) | |
| else: | |
| TableName = "Dsc" | |
| if (FileType == MODEL_FILE_DEC): | |
| TableName = "Dec" | |
| Table.__init__(self, Cursor, TableName, 0, Temporary) | |
| self.Create(False) | |
| ## Python class representation of table storing module data | |
| class ModuleTable(MetaFileTable): | |
| _COLUMN_ = ''' | |
| ID REAL PRIMARY KEY, | |
| Model INTEGER NOT NULL, | |
| Value1 TEXT NOT NULL, | |
| Value2 TEXT, | |
| Value3 TEXT, | |
| Usage TEXT, | |
| Scope1 TEXT, | |
| Scope2 TEXT, | |
| BelongsToItem REAL 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 | |
| ''' | |
| # used as table end flag, in case the changes to database is not committed to db file | |
| _DUMMY_ = "-1, -1, '====', '====', '====', '====', '====', -1, -1, -1, -1, -1, -1, -1" | |
| ## Constructor | |
| def __init__(self, Cursor): | |
| MetaFileTable.__init__(self, Cursor, '', MODEL_FILE_INF, "Inf", False) | |
| ## Insert a record into table Inf | |
| # | |
| # @param Model: Model of a Inf item | |
| # @param Value1: Value1 of a Inf item | |
| # @param Value2: Value2 of a Inf item | |
| # @param Value3: Value3 of a Inf item | |
| # @param Scope1: Arch of a Inf item | |
| # @param Scope2 Platform os a Inf item | |
| # @param BelongsToItem: The item belongs to which another item | |
| # @param StartLine: StartLine of a Inf item | |
| # @param StartColumn: StartColumn of a Inf item | |
| # @param EndLine: EndLine of a Inf item | |
| # @param EndColumn: EndColumn of a Inf item | |
| # @param Enabled: If this item enabled | |
| # | |
| def Insert(self, Model, Value1, Value2, Value3, Scope1='COMMON', Scope2='COMMON', | |
| BelongsToItem=-1, BelongsToFile = -1, StartLine=-1, StartColumn=-1, EndLine=-1, EndColumn=-1, Enabled=0, Usage=''): | |
| (Value1, Value2, Value3, Usage, Scope1, Scope2) = ConvertToSqlString((Value1, Value2, Value3, Usage, Scope1, Scope2)) | |
| return Table.Insert( | |
| self, | |
| Model, | |
| Value1, | |
| Value2, | |
| Value3, | |
| Usage, | |
| Scope1, | |
| Scope2, | |
| BelongsToItem, | |
| BelongsToFile, | |
| StartLine, | |
| StartColumn, | |
| EndLine, | |
| EndColumn, | |
| Enabled | |
| ) | |
| ## Query table | |
| # | |
| # @param Model: The Model of Record | |
| # @param Arch: The Arch attribute of Record | |
| # @param Platform The Platform attribute of Record | |
| # | |
| # @retval: A recordSet of all found records | |
| # | |
| def Query(self, Model, Arch=None, Platform=None): | |
| ConditionString = "Model=%s AND Enabled>=0" % Model | |
| ValueString = "Value1,Value2,Value3,Usage,Scope1,Scope2,ID,StartLine" | |
| if Arch != None and Arch != 'COMMON': | |
| ConditionString += " AND (Scope1='%s' OR Scope1='COMMON')" % Arch | |
| if Platform != None and Platform != 'COMMON': | |
| ConditionString += " AND (Scope2='%s' OR Scope2='COMMON' OR Scope2='DEFAULT')" % Platform | |
| SqlCommand = "SELECT %s FROM %s WHERE %s" % (ValueString, self.Table, ConditionString) | |
| return self.Exec(SqlCommand) | |
| ## Python class representation of table storing package data | |
| class PackageTable(MetaFileTable): | |
| _COLUMN_ = ''' | |
| ID REAL PRIMARY KEY, | |
| Model INTEGER NOT NULL, | |
| Value1 TEXT NOT NULL, | |
| Value2 TEXT, | |
| Value3 TEXT, | |
| Scope1 TEXT, | |
| Scope2 TEXT, | |
| BelongsToItem REAL 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 | |
| ''' | |
| # used as table end flag, in case the changes to database is not committed to db file | |
| _DUMMY_ = "-1, -1, '====', '====', '====', '====', '====', -1, -1, -1, -1, -1, -1, -1" | |
| ## Constructor | |
| def __init__(self, Cursor): | |
| MetaFileTable.__init__(self, Cursor, '', MODEL_FILE_DEC, "Dec", False) | |
| ## Insert table | |
| # | |
| # Insert a record into table Dec | |
| # | |
| # @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 Scope1: Arch of a Dec item | |
| # @param Scope2: Module type of a Dec item | |
| # @param BelongsToItem: The item belongs to which another item | |
| # @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, Scope1='COMMON', Scope2='COMMON', | |
| BelongsToItem=-1, BelongsToFile = -1, StartLine=-1, StartColumn=-1, EndLine=-1, EndColumn=-1, Enabled=0): | |
| (Value1, Value2, Value3, Scope1, Scope2) = ConvertToSqlString((Value1, Value2, Value3, Scope1, Scope2)) | |
| return Table.Insert( | |
| self, | |
| Model, | |
| Value1, | |
| Value2, | |
| Value3, | |
| Scope1, | |
| Scope2, | |
| BelongsToItem, | |
| BelongsToFile, | |
| StartLine, | |
| StartColumn, | |
| EndLine, | |
| EndColumn, | |
| Enabled | |
| ) | |
| ## Query table | |
| # | |
| # @param Model: The Model of Record | |
| # @param Arch: The Arch attribute of Record | |
| # | |
| # @retval: A recordSet of all found records | |
| # | |
| def Query(self, Model, Arch=None): | |
| ConditionString = "Model=%s AND Enabled>=0" % Model | |
| ValueString = "Value1,Value2,Value3,Scope1,ID,StartLine" | |
| if Arch != None and Arch != 'COMMON': | |
| ConditionString += " AND (Scope1='%s' OR Scope1='COMMON')" % Arch | |
| SqlCommand = "SELECT %s FROM %s WHERE %s" % (ValueString, self.Table, ConditionString) | |
| return self.Exec(SqlCommand) | |
| ## Python class representation of table storing platform data | |
| class PlatformTable(MetaFileTable): | |
| _COLUMN_ = ''' | |
| ID REAL PRIMARY KEY, | |
| Model INTEGER NOT NULL, | |
| Value1 TEXT NOT NULL, | |
| Value2 TEXT, | |
| Value3 TEXT, | |
| Scope1 TEXT, | |
| Scope2 TEXT, | |
| BelongsToItem REAL NOT NULL, | |
| BelongsToFile SINGLE NOT NULL, | |
| FromItem REAL NOT NULL, | |
| StartLine INTEGER NOT NULL, | |
| StartColumn INTEGER NOT NULL, | |
| EndLine INTEGER NOT NULL, | |
| EndColumn INTEGER NOT NULL, | |
| Enabled INTEGER DEFAULT 0 | |
| ''' | |
| # used as table end flag, in case the changes to database is not committed to db file | |
| _DUMMY_ = "-1, -1, '====', '====', '====', '====', '====', -1, -1, -1, -1, -1, -1, -1, -1" | |
| ## Constructor | |
| def __init__(self, Cursor, MetaFile = '', FileType = MODEL_FILE_DSC, Temporary = False): | |
| MetaFileTable.__init__(self, Cursor, MetaFile, FileType, "Dsc", Temporary) | |
| ## Insert table | |
| # | |
| # Insert a record into table Dsc | |
| # | |
| # @param Model: Model of a Dsc item | |
| # @param Value1: Value1 of a Dsc item | |
| # @param Value2: Value2 of a Dsc item | |
| # @param Value3: Value3 of a Dsc item | |
| # @param Scope1: Arch of a Dsc item | |
| # @param Scope2: Module type of a Dsc item | |
| # @param BelongsToItem: The item belongs to which another item | |
| # @param FromItem: The item belongs to which dsc file | |
| # @param StartLine: StartLine of a Dsc item | |
| # @param StartColumn: StartColumn of a Dsc item | |
| # @param EndLine: EndLine of a Dsc item | |
| # @param EndColumn: EndColumn of a Dsc item | |
| # @param Enabled: If this item enabled | |
| # | |
| def Insert(self, Model, Value1, Value2, Value3, Scope1='COMMON', Scope2='COMMON', BelongsToItem=-1, BelongsToFile = -1, | |
| FromItem=-1, StartLine=-1, StartColumn=-1, EndLine=-1, EndColumn=-1, Enabled=1): | |
| (Value1, Value2, Value3, Scope1, Scope2) = ConvertToSqlString((Value1, Value2, Value3, Scope1, Scope2)) | |
| return Table.Insert( | |
| self, | |
| Model, | |
| Value1, | |
| Value2, | |
| Value3, | |
| Scope1, | |
| Scope2, | |
| BelongsToItem, | |
| BelongsToFile, | |
| FromItem, | |
| StartLine, | |
| StartColumn, | |
| EndLine, | |
| EndColumn, | |
| Enabled | |
| ) | |
| ## Query table | |
| # | |
| # @param Model: The Model of Record | |
| # @param Scope1: Arch of a Dsc item | |
| # @param Scope2: Module type of a Dsc item | |
| # @param BelongsToItem: The item belongs to which another item | |
| # @param FromItem: The item belongs to which dsc file | |
| # | |
| # @retval: A recordSet of all found records | |
| # | |
| def Query(self, Model, Scope1=None, Scope2=None, BelongsToItem=None, FromItem=None): | |
| ConditionString = "Model=%s AND Enabled>0" % Model | |
| ValueString = "Value1,Value2,Value3,Scope1,Scope2,ID,StartLine" | |
| if Scope1 != None and Scope1 != 'COMMON': | |
| ConditionString += " AND (Scope1='%s' OR Scope1='COMMON')" % Scope1 | |
| if Scope2 != None and Scope2 != 'COMMON': | |
| ConditionString += " AND (Scope2='%s' OR Scope2='COMMON' OR Scope2='DEFAULT')" % Scope2 | |
| if BelongsToItem != None: | |
| ConditionString += " AND BelongsToItem=%s" % BelongsToItem | |
| else: | |
| ConditionString += " AND BelongsToItem<0" | |
| if FromItem != None: | |
| ConditionString += " AND FromItem=%s" % FromItem | |
| SqlCommand = "SELECT %s FROM %s WHERE %s" % (ValueString, self.Table, ConditionString) | |
| return self.Exec(SqlCommand) | |
| ## Factory class to produce different storage for different type of meta-file | |
| class MetaFileStorage(object): | |
| _FILE_TABLE_ = { | |
| MODEL_FILE_INF : ModuleTable, | |
| MODEL_FILE_DEC : PackageTable, | |
| MODEL_FILE_DSC : PlatformTable, | |
| MODEL_FILE_OTHERS : MetaFileTable, | |
| } | |
| _FILE_TYPE_ = { | |
| ".inf" : MODEL_FILE_INF, | |
| ".dec" : MODEL_FILE_DEC, | |
| ".dsc" : MODEL_FILE_DSC, | |
| } | |
| ## Constructor | |
| def __new__(Class, Cursor, MetaFile, FileType=None, Temporary=False): | |
| # no type given, try to find one | |
| if not FileType: | |
| if MetaFile.Type in self._FILE_TYPE_: | |
| FileType = Class._FILE_TYPE_[MetaFile.Type] | |
| else: | |
| FileType = MODEL_FILE_OTHERS | |
| # don't pass the type around if it's well known | |
| if FileType == MODEL_FILE_OTHERS: | |
| Args = (Cursor, MetaFile, FileType, Temporary) | |
| else: | |
| Args = (Cursor, MetaFile, FileType, Temporary) | |
| # create the storage object and return it to caller | |
| return Class._FILE_TABLE_[FileType](*Args) | |