def objweb_createObjWeb(strBldFldr, rptObj):
strRoot = os.getcwd()
if(os.path.exists(strBldFldr)):
os.chdir(strBldFldr)
else:
raise Exception, "Cannot find path " + strBldFldr
# Process all idh files to produce pseudo *.idh_
os.system("mkdir src")
os.chdir('src')
strSrcRoot = os.getcwd()
os.system("mkdir interfaces")
os.chdir('interfaces')
strOutputFldr = os.getcwd()
os.chdir(strSrcRoot)
file.file_MakeSureFolderExists(strOutputFldr)
os.chdir(strRoot)
objweb_ProcessInterfaceFiles('src', strSrcRoot, strOutputFldr)
# Run Surveyor Program
strSurveyorCommand = "C:\\Progra~1\\Surveyor\\System\\GtorSur.exe"
try:
rptObj.echoItVerbose(strSurveyorCommand + " [AutoWeb(\"" + strSrcRoot + "\")] [Quit]")
misc.misc_RunExtProg(strSurveyorCommand, "[AutoWeb(" + strSrcRoot + ")] [Quit]", None, rptObj, None)
except Exception, err:
raise Exception, str(err)
def db_startServer(sqlSvrBinDir, rptObj):
# TODO:JEffG - this does not support sql server2K
# Make sure the directory name string ends with a \ (backslash)
sqlSvrBinDir = re.sub('\\\\*$', '\\\\', sqlSvrBinDir, 1)
sqlSCMCommand = os.path.join(sqlSvrBinDir, 'scm.exe')
rptObj.reopenLog()
# Make sure SQLServer is started
rptObj.echoItVerbose(sqlSCMCommand + ' -Action 3 -Silent 1')
retValue = os.system('"' + sqlSCMCommand + '"' + ' -Action 3')
print sqlSCMCommand + ' -Action 3'
if retValue == -1:
rptObj.reportProgress('Starting SQL Server...')
try:
misc.misc_RunExtProg(sqlSCMCommand, ' -Action 1', None, rptObj,
None)
# Handle exceptions of type "Exception"
# "err" is a name for the Exception object
except Exception, err:
raise Exception, str(err) + ': Failed to load SQlServer'
# Handle any other exceptions by simply raising them again
except:
def db_deleteDB(strOSQLCommand, strDBName, strOSQLStdParams, rptObj):
rptObj.reopenLog()
rptObj.echoItVerbose(strOSQLCommand + strOSQLparams + ' -dmaster -n -Q"drop database ' \
+ strDBName + '"')
try:
misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-dmaster -n -Q"drop database ' \
+ strDBName + '"', None, rptObj, None)
except Exception, err:
raise Exception, str(err) + ': Failed to delete database'
def db_detachDB(strOSQLCommand, strDBName, strOSQLStdParams, rptObj):
rptObj.reopenLog()
rptObj.echoItVerbose(strOSQLCommand + strOSQLStdParams + '-dmaster -Q"sp_detach_db ' \
+ strDBName + '"')
try:
misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-dmaster -n -Q"sp_detach_db ' \
+ strDBName + '"', 'errorlevel', rptObj, None)
except Exception, err:
raise Exception, str(err) + ': Failed to detach newly built database'
def db_deleteDB(strOSQLCommand, strDBName, strOSQLStdParams, rptObj): rptObj.reopenLog() rptObj.echoItVerbose(strOSQLCommand + strOSQLparams + ' -dmaster -n -Q"drop database ' \ + strDBName + '"') try: misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-dmaster -n -Q"drop database ' \ + strDBName + '"', None, rptObj, None) except Exception, err: raise Exception, str(err) + ': Failed to delete database'
def db_detachDB(strOSQLCommand, strDBName, strOSQLStdParams, rptObj): rptObj.reopenLog() rptObj.echoItVerbose(strOSQLCommand + strOSQLStdParams + '-dmaster -Q"sp_detach_db ' \ + strDBName + '"') try: misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-dmaster -n -Q"sp_detach_db ' \ + strDBName + '"', 'errorlevel', rptObj, None) except Exception, err: raise Exception, str(err) + ': Failed to detach newly built database'
def db_loadXML(strLoadXMLCmd, strDBFile, strXMLFile, rptObj):
rptObj.reopenLog()
rptObj.reportProgress('Loading data from ' + strXMLFile + '...')
rptObj.echoItVerbose(strLoadXMLCmd + ' -d ' + strDBFile + ' -i ' + strXMLFile)
try:
misc.misc_RunExtProg(strLoadXMLCmd, '-d ' + strDBFile + ' -i ' + strXMLFile, 0, rptObj, 0)
except Exception, err:
raise Exception, str(err) + ': Failed to load XML file, see ' + strXMLFile \
+ '-import.log'
def db_loadSchema(strOSQLCommand, strDBName, strSQLFile, strOSQLStdParams, strOSQLParam2, \
rptObj):
rptObj.reopenLog()
rptObj.echoItVerbose(strOSQLCommand + strOSQLStdParams + '-d' + strDBName + ' -i ' \
+ strSQLFile + strOSQLParam2)
rptObj.reportProgress('Loading database schema from ' + strSQLFile + '...')
try:
misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-d' + strDBName + ' -i ' \
+ strSQLFile + strOSQLParam2, 'errorlevel', rptObj, None)
except Exception, err:
raise Exception, str(err) + ': Failed to load database schema'
def db_loadSchema(strOSQLCommand, strDBName, strSQLFile, strOSQLStdParams, strOSQLParam2, \
rptObj):
rptObj.reopenLog()
rptObj.echoItVerbose(strOSQLCommand + strOSQLStdParams + '-d' + strDBName + ' -i ' \
+ strSQLFile + strOSQLParam2)
rptObj.reportProgress('Loading database schema from ' + strSQLFile + '...')
try:
misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-d' + strDBName + ' -i ' \
+ strSQLFile + strOSQLParam2, 'errorlevel', rptObj, None)
except Exception, err:
raise Exception, str(err) + ': Failed to load database schema'
def db_loadXML(strLoadXMLCmd, strDBFile, strXMLFile, rptObj):
rptObj.reopenLog()
rptObj.reportProgress('Loading data from ' + strXMLFile + '...')
rptObj.echoItVerbose(strLoadXMLCmd + ' -d ' + strDBFile + ' -i ' +
strXMLFile)
try:
misc.misc_RunExtProg(strLoadXMLCmd,
'-d ' + strDBFile + ' -i ' + strXMLFile, 0,
rptObj, 0)
except Exception, err:
raise Exception, str(err) + ': Failed to load XML file, see ' + strXMLFile \
+ '-import.log'
def bld_installer(strBldFldr, strOutputFldr, rptObj, strWiseFile, strBldType, strProduct):
# TODO: JeffG - Make the install script use the data in daly output folder so
# installer can build from the daly copy of the source.
#strInstBldrExe = "c:\\Program Files\\Wise InstallBuilder 8.1\\installbuilder.exe"
# Must use short form for all path names because won't work if path and parameters are both in double quotes
strInstBldrExe = 'c:\\Progra~1\\WiseIn~1.1\\installbuilder.exe'
strIBScriptFile = os.path.join(strBldFldr, strWiseFile)
# Build installer for the build type.
rptObj.reportProgress("Building " + strProduct + " " + strBldType + " version installer...")
strCmpVars = "/d _BUILD_TYPE_=" + strBldType + " /d _OUTPUT_DIR_=" + \
strOutputFldr + " /d _FW_ROOT_DIR_=" + strBldFldr + " /c /s "
try:
misc.misc_RunExtProg(strInstBldrExe, strCmpVars + strIBScriptFile, None, rptObj, None)
except Exception, err:
raise Exception, str(err)
def bld_buildFW(strBldFldr, rptObj, strBldType, strFlags):
strBldFldr = re.sub('\\\\*$', '\\\\', strBldFldr, 1)
strBldCmdStr = os.path.join(strBldFldr, "bin\\mkall.bat")
if(os.path.exists(strBldCmdStr)):
rptObj.reportProgress("Starting " + strBldType + " build...")
rptObj.closeLog() # Close so the external process can append to the log file
try:
misc.misc_RunExtProg(strBldCmdStr, strFlags, "FW_BUILD_ERROR", rptObj, rptObj.getLogFile())
except Exception, err:
rptObj.reopenLog()
rptObj.reportFailure(strBldType + " build failed, " + str(err), 1)
rptObj.closeLog()
raise Exception, str(err) + ":error running " + strBldCmdStr
rptObj.reopenLog() # Re-open the log file for appending
rptObj.reportProgress("Finished building " + strBldType + " build.")
def db_createDB(strOSQLCommand, strDBFile, strDBName, strOSQLStdParams, strOutputDir, rptObj):
rptObj.reopenLog()
# Make sure the directory name string ends with a \ (backslash)
strOutputDir = re.sub('\\\\*$', '\\\\', strOutputDir, 1)
# Create the database
strDBOn = " ON (NAME='" + strDBFile + "',FILENAME='" + strOutputDir + strDBFile \
+ ".mdf',SIZE=10MB,MAXSIZE=200MB,FILEGROWTH=5MB)"
strDBLogOn = " LOG ON (NAME='" + strDBFile + "_Log', FILENAME='" + strOutputDir \
+ strDBFile + "_Log.ldf',SIZE=5MB,MAXSIZE=25MB,FILEGROWTH=5MB)\""
rptObj.echoItVerbose(strOSQLCommand + strOSQLStdParams \
+ ' -dmaster -n -Q"Create database ' + strDBName + strDBOn + strDBLogOn)
rptObj.reportProgress('Creating database ' + strDBName + ' and loading schema....')
try:
misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-dmaster -n -Q"Create database ' \
+ strDBName + strDBOn + strDBLogOn, 'errorlevel', rptObj, 0)
except Exception, err: #=dmaster
raise Exc.eption, str(err) + ': Failed to create the database'
def db_createDB(strOSQLCommand, strDBFile, strDBName, strOSQLStdParams,
strOutputDir, rptObj):
rptObj.reopenLog()
# Make sure the directory name string ends with a \ (backslash)
strOutputDir = re.sub('\\\\*$', '\\\\', strOutputDir, 1)
# Create the database
strDBOn = " ON (NAME='" + strDBFile + "',FILENAME='" + strOutputDir + strDBFile \
+ ".mdf',SIZE=10MB,MAXSIZE=200MB,FILEGROWTH=5MB)"
strDBLogOn = " LOG ON (NAME='" + strDBFile + "_Log', FILENAME='" + strOutputDir \
+ strDBFile + "_Log.ldf',SIZE=5MB,MAXSIZE=25MB,FILEGROWTH=5MB)\""
rptObj.echoItVerbose(strOSQLCommand + strOSQLStdParams \
+ ' -dmaster -n -Q"Create database ' + strDBName + strDBOn + strDBLogOn)
rptObj.reportProgress('Creating database ' + strDBName +
' and loading schema....')
try:
misc.misc_RunExtProg(strOSQLCommand, strOSQLStdParams + '-dmaster -n -Q"Create database ' \
+ strDBName + strDBOn + strDBLogOn, 'errorlevel', rptObj, 0)
except Exception, err: #=dmaster
raise Exc.eption, str(err) + ': Failed to create the database'
def db_startServer(sqlSvrBinDir, rptObj):
# TODO:JEffG - this does not support sql server2K
# Make sure the directory name string ends with a \ (backslash)
sqlSvrBinDir = re.sub('\\\\*$', '\\\\', sqlSvrBinDir, 1)
sqlSCMCommand = os.path.join(sqlSvrBinDir, 'scm.exe')
rptObj.reopenLog()
# Make sure SQLServer is started
rptObj.echoItVerbose(sqlSCMCommand + ' -Action 3 -Silent 1')
retValue = os.system('"' + sqlSCMCommand + '"' + ' -Action 3')
print sqlSCMCommand + ' -Action 3'
if retValue == -1:
rptObj.reportProgress('Starting SQL Server...')
try:
misc.misc_RunExtProg(sqlSCMCommand, ' -Action 1', None, rptObj, None)
# Handle exceptions of type "Exception"
# "err" is a name for the Exception object
except Exception, err:
raise Exception, str(err) + ': Failed to load SQlServer'
# Handle any other exceptions by simply raising them again
except: