] 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"