def _createSession(pid, index): ''' Creates a session for the given uname and password and updates the db with sessionid @return: sessionid, None ''' colsuffix = "" if index == 1: colsuffix = '2' sessionPrefix = '2' elif index == 2: colsuffix = '3' sessionPrefix = '3' else: colsuffix = "" sessionPrefix = '1' columnName = 'sessionid'+colsuffix sessionId = sessionPrefix+UTIL.createSessionId() group = DBINT.DBFieldGroup('DB1','credentials') sid1 = DBINT.DBFieldItem('sessionid'+colsuffix, [sessionId]) group.addItem(sid1) queryGroup = DBINT.QueryGroupAnd() item = DBINT.DBFieldItem('uname', [pid]) queryGroup.addItem(item) group.setQueryGroup(queryGroup) ret = group.update() if ret == False: return None return sessionId
def _AddInfo(form): uname = None sessid = None group = DBINT.DBFieldGroup('DB1','credentials') item = DBINT.DBFieldItem('uname') item.addValue(form.getvalue(_gWns.getAltId('PROFID'))) item.setValidateFunction(VALD.validateUsername) group.addItem(item) uname = item.getValue(0) item = DBINT.DBFieldItem('name') item.addValue(_removeExtraSpace(form.getvalue(_gWns.getAltId('NAME')))) item.setValidateFunction(VALD.validateFullname) group.addItem(item) item = DBINT.DBFieldItem('pwd') item.addValue(form.getvalue(_gWns.getAltId('PASSWORD'))) item.setValidateFunction(VALD.validatePassword) group.addItem(item) item = DBINT.DBFieldItem('email') item.addValue(form.getvalue(_gWns.getAltId('EMAIL'))) item.setValidateFunction(VALD.validateEmail) group.addItem(item) item = DBINT.DBFieldItem('status') item.addValue(NCONST.REGISTERED) group.addItem(item) sessid = '1'+UTIL.createSessionId(); item = DBINT.DBFieldItem('sessionid') item.addValue(sessid) group.addItem(item) item = DBINT.DBFieldItem('langid') item.addValue('eng') group.addItem(item) now = datetime.datetime.now() item = DBINT.DBFieldItem('doj') item.addValue(now) group.addItem(item) item = DBINT.DBFieldItem('doll') item.addValue(now) group.addItem(item) try: dobVal = datetime.date(int(form.getvalue(_gWns.getAltId('DOB_YEAR'))), int(form.getvalue(_gWns.getAltId('DOB_MONTH'))),int(form.getvalue(_gWns.getAltId('DOB_DAY')))) except: dobVal = None item = DBINT.DBFieldItem('dob') item.addValue(dobVal) item.setValidateFunction(VALD.validateDob) group.addItem(item) item = DBINT.DBFieldItem('sex') item.addValue(UTIL.toInt(form.getvalue(_gWns.getAltId('SEX')))) item.setValidateFunction(VALD.validateSex) group.addItem(item) _setSessionInfo(uname, sessid) return group.write()