]
WSGI_APPLICATION = 'WebServer.wsgi.application'
# Database
# https://docs.djangoproject.com/en/1.8/ref/settings/#databases
"""
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
}
}
"""
ip = Global.get_ip()
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
'NAME': 'postgres', # Or path to database file if using sqlite3.
'USER': '******', # Not used with sqlite3.
'PASSWORD': '******', # Not used with sqlite3.
'HOST': ip, # Set to empty string for localhost. Not used with sqlite3.
'PORT': '5432', # Set to empty string for default. Not used with sqlite3.
}
}
# Internationalization
# https://docs.djangoproject.com/en/1.8/topics/i18n/
LANGUAGE_CODE = 'en-us'
import DataBaseUtilities as DB
import Global
# ---------------- CUSTOM CODE ---------------#
# import CommonUtil
ip = Global.get_ip(True)
def GetConnection():
Conn = DB.ConnectToDataBase(sDbname="postgres", sUser="******", sPswd="password", sHost=ip)
return Conn
def GetData(sTableName):
Conn = GetConnection()
Get_Data = DB.GetData(Conn, "Select * from %s" % sTableName, False)
Conn.close()
return Get_Data
def GetQueryData(sQuery):
Conn = GetConnection()
GetQueryData = DB.GetData(Conn, sQuery, False)
Conn.close()
return GetQueryData
def GetColumnNames(sTableName):
Conn = GetConnection()
ColumnNames = DB.GetData(
Conn, "SELECT column_name FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = '%s'" % sTableName
__author__ = 'Raju'
import Global
user='******'
password_user='******'
db_name='postgres'
server=Global.get_ip()
port=Global.get_port()
import DataBaseUtilities as DB
def Check_TestCase(test_case):
test_type = [u'automated', u'manual', u'performance']
type_selector = []
for item in test_type:
sQuery = "select count(*) from test_steps_list where step_id in(select step_id from test_steps where tc_id='" + test_case + "') and steptype='" + item + "'"
conn = DB.ConnectToDataBase(db_name,user,password_user,server)
result = DB.GetData(conn, sQuery, False)
conn.close()
type_selector.append(result[0])
conn=DB.ConnectToDataBase(db_name,user,password_user,server)
query="select tc_type from test_cases where tc_id='%s'"%(test_case.strip())
tc_type=DB.GetData(conn,query)[0]
conn.close()
b = type_selector[1]
c = type_selector[2]
if tc_type=='Forc':
return "Manual"
else:
if b[0]>0:
return "Manual"
else:
if c[0]>0:
return "Performance"
