def post(self,category_id=0):
c.alive = alive()
if not c.alive:
return redirect_to(controller='topics',action='index',category_id=None)
db = Session()
if request.method == 'POST':
#valid the form
schema = PostForm()
try:
form_result = schema.to_python(request.params)
except formencode.Invalid, error:
return 'Invalid: %s' % error
else:
db.execute('insert into LUM_Discussion (Name,CategoryID,DateCreated,DateLastActive,AuthUserID,LastUserID) values(%s,%s,%s,%s,%s,%s)',
(form_result.get('Name').encode('utf-8'),form_result.get('CategoryID'),datetime.now(),datetime.now(),session['user_id'],session['user_id']))
result = db.execute('select * from LUM_Discussion order by DiscussionID desc')
discussion_id = result.fetchone()[0]
#add topic content
db.execute('insert into LUM_Comment (Body,DiscussionID,DateCreated,AuthUserID) values(%s,%s,%s,%s)',
(form_result.get('Body').encode('utf-8'),discussion_id,datetime.now(),session['user_id']))
Session.commit()
log.debug('post submit')
return redirect_to(controller='categories', action='view', category_id=form_result.get('CategoryID'))
def comment(self,id):
log.debug('comment')
if alive() and request.method == 'POST':
#vaild form
db = Session()
db.execute('insert into LUM_Comment (DiscussionID, AuthUserID, Body) values(%s,%s,%s)',(str(id), session['user_id'], request.POST['Body'].encode('utf-8')))
db.execute('update LUM_Discussion set CountComments = (select count(*) from LUM_Comment where DiscussionID=%s),LastUserID=%s,DateLastActive=%s where DiscussionID=%s', (str(id),session['user_id'],datetime.now(), str(id)))
Session.commit()
log.debug('comment submit')
return redirect_to(controller='topics',action='view',id=id)
def post(self, category_id=0):
c.alive = alive()
if not c.alive:
return redirect_to(controller='topics',
action='index',
category_id=None)
db = Session()
if request.method == 'POST':
#valid the form
schema = PostForm()
try:
form_result = schema.to_python(request.params)
except formencode.Invalid, error:
return 'Invalid: %s' % error
else:
db.execute(
'insert into LUM_Discussion (Name,CategoryID,DateCreated,DateLastActive,AuthUserID,LastUserID) values(%s,%s,%s,%s,%s,%s)',
(form_result.get('Name').encode('utf-8'),
form_result.get('CategoryID'), datetime.now(),
datetime.now(), session['user_id'], session['user_id']))
result = db.execute(
'select * from LUM_Discussion order by DiscussionID desc')
discussion_id = result.fetchone()[0]
#add topic content
db.execute(
'insert into LUM_Comment (Body,DiscussionID,DateCreated,AuthUserID) values(%s,%s,%s,%s)',
(form_result.get('Body').encode('utf-8'), discussion_id,
datetime.now(), session['user_id']))
Session.commit()
log.debug('post submit')
return redirect_to(controller='categories',
action='view',
category_id=form_result.get('CategoryID'))
schema = SignupForm()
try:
form_result = schema.to_python(request.params)
except formencode.Invalid, error:
return 'Invalid: %s' % error
else:
#insert to db
db = Session()
result = db.execute('select * from users where name=? or email=?',(form_result.get('username'),form_result.get('email')))
user_info = result.fetchone()
#log.debug('%s',user_info)
if user_info:
return 'username or email exists'
db.execute('insert into users (name,password,email) values(?,?,?)',(form_result.get('username'),form_result.get('password'),form_result.get('email')))
Session.commit()
result = db.execute('select * from users where name=? and password=? and email=?',(form_result.get('username'),form_result.get('password'),form_result.get('email')))
user_info = result.fetchone()
if not user_info:
return 'db failed'
user_id = user_info[0]
session['user_id']=user_id
session['name']=form_result.get('username')
session.save()
return 'signup success'
