32 lines
1.1 KiB
Python
32 lines
1.1 KiB
Python
from base_utils.common.constantsbase import ConstantsBase
|
|
|
|
|
|
class SqlCommands:
|
|
@staticmethod
|
|
def getSQLCommandForInplaceUpgradeBackup(port, database=ConstantsBase.DEFAULT_DB_NAME,
|
|
gsqlBin="gsql"):
|
|
"""
|
|
function: get SQL command for Inplace Upgrade backupOneInstanceOldClusterDBAndRel
|
|
input: port, database
|
|
output: cmd
|
|
"""
|
|
cmd = ConstantsBase.SQL_EXEC_COMMAND_WITHOUT_HOST_WITHOUT_USER % (
|
|
gsqlBin, port, database)
|
|
return cmd
|
|
|
|
@staticmethod
|
|
def getSQLCommand(port, database=ConstantsBase.DEFAULT_DB_NAME,
|
|
gsqlBin="gsql", user_name="", user_pwd=""):
|
|
"""
|
|
function : get SQL command
|
|
input : port, database
|
|
output : cmd
|
|
"""
|
|
if user_name and user_pwd:
|
|
cmd = ConstantsBase.SQL_EXEC_COMMAND_WITHOUT_HOST_WITH_USER % (
|
|
gsqlBin, str(port), database, user_name, user_pwd)
|
|
return cmd
|
|
cmd = ConstantsBase.SQL_EXEC_COMMAND_WITHOUT_HOST_WITHOUT_USER % (
|
|
gsqlBin, str(int(port) + 1), database)
|
|
return cmd
|