BaseTools: Replace BSD License with BSD+Patent License

[mirror_edk2.git] / BaseTools / Source / Python / Table / TableQuery.py

## @file\r
# This file is used to create/update/query/erase table for Queries\r
#\r
# Copyright (c) 2008, Intel Corporation. All rights reserved.<BR>\r
# SPDX-License-Identifier: BSD-2-Clause-Patent\r
#\r
\r
##\r
# Import Modules\r
#\r
from __future__ import absolute_import\r
import Common.EdkLogger as EdkLogger\r
from Common.StringUtils import ConvertToSqlString\r
from Table.Table import Table\r
\r
## TableQuery\r
#\r
# This class defined a table used for Query\r
#\r
# @param object:       Inherited from object class\r
#\r
#\r
class TableQuery(Table):\r
    def __init__(self, Cursor):\r
        Table.__init__(self, Cursor)\r
        self.Table = 'Query'\r
\r
    ## Create table\r
    #\r
    # Create table Query\r
    #\r
    # @param ID:                 ID of a Query\r
    # @param Name:               Name of a Query\r
    # @param Modifier:           Modifier of a Query\r
    # @param Value:              Type of a Query\r
    # @param Model:              Model of a Query\r
    #\r
    def Create(self):\r
        SqlCommand = """create table IF NOT EXISTS %s(ID INTEGER PRIMARY KEY,\r
                                                      Name TEXT DEFAULT '',\r
                                                      Modifier TEXT DEFAULT '',\r
                                                      Value TEXT DEFAULT '',\r
                                                      Model INTEGER DEFAULT 0\r
                                                     )""" % self.Table\r
        Table.Create(self, SqlCommand)\r
\r
    ## Insert table\r
    #\r
    # Insert a record into table Query\r
    #\r
    # @param ID:                 ID of a Query\r
    # @param Name:               Name of a Query\r
    # @param Modifier:           Modifier of a Query\r
    # @param Value:              Value of a Query\r
    # @param Model:              Model of a Query\r
    #\r
    def Insert(self, Name, Modifier, Value, Model):\r
        self.ID = self.ID + 1\r
        SqlCommand = """insert into %s values(%s, '%s', '%s', '%s', %s)""" \\r
                                           % (self.Table, self.ID, Name, Modifier, Value, Model)\r
        Table.Insert(self, SqlCommand)\r
\r
        return self.ID\r