Beispiel #1
0
def addPhotoFavoriteToDB(userid, photoid):
    cursor=conn.cursor()
    from datetime import datetime
    try:
        if cursor is not None:
            sql = ("select * from favorite where Userid=%(uid)s and Photoid=%(pic)s")
            data={'uid':userid, 'pic':photoid}
            cursor.execute(sql,data)
            result=cursor.fetchall()
            if (len(result)>0):
                return true
            else:
                sql=("Insert into favorite "
                     "Values(%(uid)s, %(pic)s, %(time)s)")
                data={'uid':userid, 'pic':photoid,'time':datetime.now().strftime('%Y-%m-%d %H:%M:%S')}
                cursor.execute(sql,data)
                result=cursor.rowcount
                conn.commit()
                cursor.close()
                if (result>0):
                    return true
                else:
                    return false;
    except:
        print (exc_info())
        conn.rollback()
        cursor.close()
        return false
Beispiel #2
0
def addNewTag(tagText):
    newCursor=conn.cursor();
    try:
        args = [tagText, 0]
        result_args = newCursor.callproc('uspAddTag', args)
        conn.commit()
        if result_args[1]>0:
            return result_args[1]
    except Error as e:
        conn.rollback()
        print (e)
        newCursor.close()
    return 0;
Beispiel #3
0
def addphoto(UID, PName, PDesc, PPath, FiName):
    newCursor = conn.cursor();
    try:
        args = [UID, PName, PDesc, PPath, FiName, 0]
        result_args = newCursor.callproc('uspAddPhoto', args)
        conn.commit()
        newCursor.close()
        return (result_args[5])
    except Error as e:
        conn.rollback()
        print(e)
        newCursor.close()
    return 0;
Beispiel #4
0
def UnlikePic(UID,PID):
    if UID==0 or PID==0:
        return False
    try:
        cursor = conn.cursor()
        args = [UID, PID, 0]
        result_args = cursor.callproc('uspCancelLike', args)
        conn.commit()
        cursor.close()
        return True
        # print(result_args[3])
    except Error as e:
        conn.rollback()
        print(e)
        cursor.close()
        return False
Beispiel #5
0
def AddLike(UID, PID):
    if UID==0 or PID==0:
        return
    try:
        cursor = conn.cursor()
        args = [UID, PID, 0]
        result_args = cursor.callproc('uspAddLike', args)
        conn.commit()
        return True
        # print(result_args[3])
    except Error as e:
        conn.rollback()
        print(e)
        return False
    finally:
        cursor.close()
Beispiel #6
0
def AddNewUser(Username, Pword, salt, email):
    from datetime import datetime
    try:
        cursor=conn.cursor()
        timeFormat='%Y-%m-%d %H:%M:%S'
        args = [Username,Pword, 0, salt, email, datetime.utcnow().strftime(timeFormat),0]
        result_args = cursor.callproc('uspAddUser', args)
        conn.commit()
        cursor.close()
        #print(result_args[6])
        return result_args[6]
    except Error as e:
        conn.rollback()
        cursor.close()
        print(e)
    return 0
Beispiel #7
0
def AddUserRelation(u1id, u2id, Rtype):
    if u1id ==0 or u2id==0:
        return
    success=False
    try:
        cursor = conn.cursor()
        args = [u1id, u2id, Rtype, 0]
        result_args = cursor.callproc('uspAddUserRelation', args)
        conn.commit()
        # print(result_args[3])
        success=True
    except Error as e:
        conn.rollback()
        print(e)
    finally:
        cursor.close()
        return success
Beispiel #8
0
def addcomment(CText, UID, PID):
    if UID==0 or PID==0 or CText is None:
        return
    if len(CText) <1:
        return
    cursor = conn.cursor()
    try:

        args = [CText, UID, PID, 0]
        result_args = cursor.callproc('uspAddComment', args)
        conn.commit()
        #print(result_args[4])
        return result_args[3]
    except Error as e:
        conn.rollback()
        print(e)
    finally:
        cursor.close()
Beispiel #9
0
def addphotoTags(Pid,Tags):
    newCursor=conn.cursor();
    try:
        for tag in Tags:
            tagid=tag['tagid']
            if (tagid == 0):
                tagid=addNewTag(tag['text'])
            sql=("Insert into PhotoTags (PhotoID,TagID,LeftX,TopY)"
                     "Values(%(pic)s, %(tag)s, %(x)s,%(y)s)")
            data={'pic':Pid, 'tag':tagid,'x':tag['left'],'y':tag['top']}
            newCursor.execute(sql,data)
            result=newCursor.rowcount
        conn.commit()
        newCursor.close()
        return true
    except Error as e:
        conn.rollback()
        print (e)
        newCursor.close()
    return false;
Beispiel #10
0
def addUserProfile(uid,Uname,Location,brithday,Gender,Occupation,Height,Weight):
    if uid==0:
        return None
    cursor=conn.cursor()
    try:
        sql=("insert into userdb.userDetails (UserId,username,location,brithday,Gender,Occupation,Height,Weight)"
            " Values(%(uid)s, %(uname)s, %(loca)s, %(brith)s, %(Gender)s, %(Occup)s, %(Height)s, %(Weight)s)")
        data={"uid":uid, "uname":Uname,"loca":Location,"brith":datetime.strptime(brithday,'%Y-%m-%d'),"Gender":Gender,"Occup":Occupation,"Height":Height,"Weight":Weight}
        cursor.execute(sql,data)
        row=cursor.rowcount
        conn.commit();
        cursor.close()
        if row >0:
            return true;
        else:
            return false;
    except:
        print (exc_info())
        conn.rollback()
        cursor.close()
        return false;
Beispiel #11
0
def saveUserKeys(userid,priv_pem,pub_pem):
    if userid<1:
        return False
    cursor=conn.cursor()
    try:
        sql=("Update userdb.userinfo "
             " SET Private_key=%(prv)s, Public_key=%(pub)s "
             " WHERE ID=%(uid)s")
        data={'uid':userid, 'prv':priv_pem,'pub':pub_pem}
        cursor.execute(sql,data)
        result=cursor.rowcount
        conn.commit()
        cursor.close()
        if (result>0):
            return true
        else:
            return false
    except:
        print (exc_info())
        conn.rollback()
        cursor.close()
        return False;
Beispiel #12
0
def updateUserProfile(uid,Uname,Location,brithday,Gender,Occupation,Height,Weight):
    if uid==0:
        return None
    cursor=conn.cursor()
    try:
        sql=("Update userdetails "
            "set Username=%(uname)s,Location=%(loca)s,Brithday=%(brith)s,Gender=%(Gender)s,Occupation=%(Occup)s,"
	        "Height=%(Height)s,Weight=%(Weight)s "
            "Where UserID=%(uid)s")
        data={"uid":uid, "uname":Uname,"loca":Location,"brith":datetime.strptime(brithday,'%Y-%m-%d'),"Gender":Gender,"Occup":Occupation,"Height":Height,"Weight":Weight}
        cursor.execute(sql,data)
        row=cursor.rowcount
        conn.commit();
        cursor.close()
        if row >0:
            return true;
        else:
            return false;
    except:
        print (exc_info())
        conn.rollback()
        cursor.close()
        return false;
Beispiel #13
0
def updateUserToken(userid, token):
    if userid<0:
        return False
    else:
        cursor=conn.cursor()
        try:
            sql=("Update userdb.userinfo "
                 " SET accessToken=%(token)s "
                 " WHERE ID=%(uid)s")
            data={'uid':userid, 'token':token}
            cursor.execute(sql,data)
            result=cursor.rowcount
            conn.commit()
            cursor.close()
            if (result>0):
                return True
            else:
                return False
        except:
            print (exc_info())
            conn.rollback()
            cursor.close()
            return False;