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