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()
