def createList(): authHeader = request.headers.get('Authorization') tokenEncoded = authHeader.split(' ')[1] token = decodeToken(tokenEncoded) user = getUser(token) userId = user['id'] listname = request.json['listname'] taskArr = request.json['taskArr'] cursor = mysql.connection.cursor() cursor.execute(""" INSERT INTO list (listname, userId) VALUES (%s, %s) """, (listname, userId)) cursor.execute(""" SELECT id, listname FROM list WHERE listname = %s """, (listname, )) result = cursor.fetchone() mysql.connection.commit() for task in taskArr: cursor.execute( """ INSERT INTO tasks ( task, listId, userId ) VALUES (%s, %s, %s) """, (task, result['id'], userId)) mysql.connection.commit() cursor.close() return {"message": "List and tasks created"}
def process(self, request, groupKey): if request.get('delete') != groupKey: self.setError("GroupId in body doesn't match URL") group = helper.getGroup(groupKey) if False == group: self.error = True self.message = 'Invalid group. ' if request.get('delMember'): user = helper.getUser(request.get('delMember')) else: user = helper.getUser(users.get_current_user()) if False == user: self.setError('User not found') if users.get_current_user() != user and not helper.groupeStateWritePermission(users.get_current_user(), group): self.setError('No permission to change this group. ') if False == self.error: members = models.GroupMember.gql('WHERE name = :1 and group = :2', user, group) if 0 == members.count(): self.setError("Can't find group membership. ") else: member = members.get(); member.delete(); self.message = 'Successfully deleted group membership. ' # If that was the last member kill the group members = models.GroupMember.gql('WHERE group = :1', group) if 0 == members.count(): group.delete() return { 'error': self.error, 'message': self.message, }
def userBlogs(): authHeader = request.headers.get('Authorization') tokenEncoded = authHeader.split(' ')[1] token = decodeToken(tokenEncoded) user = getUser(token) userId = user[0]['id'] cursor = mysql.connection.cursor() cursor.execute( """ SELECT * FROM blogs2 WHERE userId = %s """, (userId,) ) results = cursor.fetchall() cursor.close() return { "blogs" : getData(results) }
def createComment(): authHeader = request.headers.get('Authorization') tokenEncoded = authHeader.split(' ')[1] token = decodeToken(tokenEncoded) user = getUser(token) username = user[0]['username'] blogId = request.json['blogId'] comment = request.json['comment'] cursor = mysql.connection.cursor() cursor.execute( """INSERT INTO comments2 (blogId, comment, username) VALUES (%s, %s, %s) """, (blogId, comment, username)) mysql.connection.commit() cursor.close() return {"message": "comment created"}
def createTask(): task = request.json['task'] authHeader = request.headers.get('Authorization') tokenEncoded = authHeader.split(' ')[1] token = decodeToken(tokenEncoded) user = getUser(token) userId = user['id'] listId = request.json['listId'] cursor = mysql.connection.cursor() cursor.execute( """ INSERT INTO tasks ( task, listId, userId ) VALUES (%s, %s, %s) """, (task, listId, userId)) mysql.connection.commit() cursor.close() return {'message': "Task added"}
def read(): authHeader = request.headers.get('Authorization') tokenEncoded = authHeader.split(' ')[1] token = decodeToken(tokenEncoded) user = getUser(token) userId = user['id'] cursor = mysql.connection.cursor() cursor.execute( """ SELECT list.id AS listId, listname, COUNT(tasks.id) AS task FROM list JOIN tasks ON list.id = tasks.listId WHERE list.userId = %s GROUP BY list.id """, (userId, )) result = cursor.fetchall() cursor.close() return {'lists': getData(result)}
def createBlog(): authHeader = request.headers.get('Authorization') tokenEncoded = authHeader.split(' ')[1] userId = int(decodeToken(tokenEncoded)) user = getUser(userId) username = user[0]['username'] print(username) title = request.json['title'] blog = request.json['blog'] category = request.json['category'] cursor = mysql.connection.cursor() cursor.execute( """INSERT INTO blogs2 (userId, title, blog, category, username) VALUES (%s, %s, %s, %s, %s) """, (userId, title, blog, category, username) ) mysql.connection.commit() cursor.close() return {"message": "blog created"}
def reactOnMSG(soc, line): _ = lang.getGettext() msg = [] privmsg = line[3].strip(':') if ( privmsg == 'uptime' or privmsg == '!uptime' ): msg = _('Master Yoda long time here is. ') msg += getUptime() msg = [ msg ] elif ( privmsg == '!quote' ): msg = [ getQuote() ] elif ( privmsg == '!tweet' ): try: name = line[4] except Exception: name = None msg = [ tweet.getTimeline(name) ] elif ( privmsg == '!header' ): try: url = line[4] except Exception: url = None msg = header.getHeader(url) elif ( privmsg == '!search' or privmsg == '!google'): try: searchterm = line[4] except Exception: searchterm = None msg = search.getScroogle(searchterm) elif ( privmsg == '!msg' ): try: touser = line[4] message = line msg = [] privateMessage.sendMessage(soc, helper.getUser(line[0]), touser, message) except: touser = None message = None msg = [] elif ( privmsg == '!feed' ): try: feedname = line[4] except: feedname = None msg = feed.sendFeed(feedname) if feedname is not None: try: number = line[5] msg = feed.getEntry(number, feedname) except: msg = feed.sendFeed(feedname) elif ( privmsg == '!version' ): msg = helper.getVersion() elif ( privmsg == '!help' ): msg = helper.getHelp() else: return for entry in msg: try: entry = entry.strip('\x00') entry = '\x02' + entry + '\x03' soc.send(bytearray('NOTICE ' + helper.getUser(line[0]) + ' :' + entry + '\r\n', 'utf-8')) except: pass
def greeting(soc, line): _ = lang.getGettext() msg = _('Hi ') + helper.getUser(line[0]) + _(' my friend. May the force be with you.') soc.send('PRIVMSG ' + helper.getUser(line[0]) + ' :' + msg + '\r\n')
def reactOnMSG(soc, line): _ = lang.getGettext() msg = [] privmsg = line[3].strip(':') if (privmsg == 'uptime' or privmsg == '!uptime'): msg = _('Master Yoda long time here is. ') msg += getUptime() msg = [msg] elif (privmsg == '!quote'): msg = [getQuote()] elif (privmsg == '!tweet'): try: name = line[4] except Exception: name = None msg = [tweet.getTimeline(name)] elif (privmsg == '!header'): try: url = line[4] except Exception: url = None msg = header.getHeader(url) elif (privmsg == '!search' or privmsg == '!google'): try: searchterm = line[4] except Exception: searchterm = None msg = search.getScroogle(searchterm) elif (privmsg == '!msg'): try: touser = line[4] message = line msg = [] privateMessage.sendMessage(soc, helper.getUser(line[0]), touser, message) except: touser = None message = None msg = [] elif (privmsg == '!feed'): try: feedname = line[4] except: feedname = None msg = feed.sendFeed(feedname) if feedname is not None: try: number = line[5] msg = feed.getEntry(number, feedname) except: msg = feed.sendFeed(feedname) elif (privmsg == '!version'): msg = helper.getVersion() elif (privmsg == '!help'): msg = helper.getHelp() else: return for entry in msg: try: entry = entry.strip('\x00') entry = '\x02' + entry + '\x03' soc.send( bytearray( 'NOTICE ' + helper.getUser(line[0]) + ' :' + entry + '\r\n', 'utf-8')) except: pass
def greeting(soc, line): _ = lang.getGettext() msg = _('Hi ') + helper.getUser( line[0]) + _(' my friend. May the force be with you.') soc.send('PRIVMSG ' + helper.getUser(line[0]) + ' :' + msg + '\r\n')