def getFeatureNCategoryFromDB(): sql = "select id,feature,category from m_feature" result = databaseOperation(sql) response = [] if result: for row in result: feature = Feature(row[2], row[0], None, row[1], None, None) response.append(json.dumps(feature.__dict__)) return response
def getAllFeaturesFromDB(): sql = "select * from m_feature" result = databaseOperation(sql) response = [] if result: for row in result: feature = Feature(row[4], row[0], row[3], row[1], row[5], row[2]) response.append(json.dumps(feature.__dict__)) return response
def getAllCriteriaFromDB(): sql = "select * from m_criteria" result = databaseOperation(sql) response = [] if result: for row in result: # id 0, product 3, category 2, datasource 4, sqlapi 5, keyvalue 6, feature 1) criteria = Criteria(row[0], row[3], row[2], row[4], row[5], row[6], row[1]) response.append(json.dumps(criteria.__dict__)) return response
def getByFeatureId(id): sql = "select * from m_feature where id = '%d'" % id result = databaseOperation(sql) if result: for row in result: feature = Feature(row[4], id, row[3], row[1], row[5], row[2]) return feature else: return None
def getByCriteriaId(): sql = "select * from m_criteria where id = '%d'" % id result = databaseOperation(sql) if result: for row in result: # id, product, category, datasource, sqlapi, keyvalue, feature criteria = Criteria(row[0], row[3], row[2], row[4], row[5], row[6], row[1]) return criteria else: return None
def getByConfigId(id): sql = "select * from m_configuration where id = '%d'" % id result = databaseOperation(sql) if result: for row in result: configuration = Configuration(row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10]) return configuration else: return None
def getAllConfigurationFromDB(): sql = "select * from m_configuration" result = databaseOperation(sql) response = [] if result: for row in result: configuration = Configuration(row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10]) response.append(json.dumps(configuration.__dict__)) return response
def getByGender(gender): sql = "SELECT cs.criteria, (CONVERT(cs.score, DECIMAL(10,2)) * CONVERT(a.weightage , DECIMAL(10,2))) as mul " \ "FROM mifostenant.m_criteriascore as cs, mifostenant.m_configuration a " \ "where cs.cscriteriatableid = a.id and Upper(a.feature)= 'GENDER' and cs.cscriteriatableid=2" result = databaseOperation(sql) score = 0 if(result): for row in result: criteria = row[0] if(criteria.upper() == gender): score = float(row[1]) break return score
def getByAge(age): sql = "SELECT cs.criteria, (CONVERT(cs.score, DECIMAL(10,2)) * CONVERT(a.weightage , DECIMAL(10,2))) as mul " \ "FROM mifostenant.m_criteriascore as cs, mifostenant.m_configuration a " \ "where cs.cscriteriatableid = a.id and a.feature = 'Age' and cs.cscriteriatableid=1" result = databaseOperation(sql) score = 0 if(result): for row in result: criteria = row[0] minage, maxage = criteria.split('-') if(age >= int(minage) and age <= int(maxage)): score = float(row[1]) break return score