def add_author(author, quote, introduction, birthYear, deathYear,
dynastyID):
query = '''INSERT INTO author (Author, Quote, Introduction, BirthYear, DeathYear, DynastyID) VALUES\n
('%s', '%s', '%s', %d, %d, %d)''' % (author, quote, introduction, birthYear,
deathYear, dynastyID)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def edit_author(author, quote, introduction, birthYear, deathYear,
dynastyID, authorID):
query = '''UPDATE author\n
SET Author='%s', Quote='%s', Introduction='%s', BirthYear=%d, DeathYear=%d, DynastyID=%d\n
WHERE AuthorID = %d''' % (author, quote, introduction, birthYear, deathYear,
dynastyID, authorID)
cursor.execute(query)
return conn.commit()
def add_comment(user_id,
review_id,
comment,
is_root=0,
parent_comment_id=0):
query = '''INSERT INTO comment (UserID, ReviewID, Comment, IsRoot, ParentCommentID)\n
VALUES (%d, %d, '%s', %d, %d)''' % (user_id, review_id, comment, is_root,
parent_comment_id)
cursor.execute(query)
return conn.commit()
def add_comment(user_id, review_id, comment, is_root=0, parent_comment_id=0):
query = """INSERT INTO comment (UserID, ReviewID, Comment, IsRoot, ParentCommentID)\n
VALUES (%d, %d, '%s', %d, %d)""" % (
user_id,
review_id,
comment,
is_root,
parent_comment_id,
)
cursor.execute(query)
return conn.commit()
def delete_work(workID): query = "DELETE FROM work WHERE WorkID = %d" % workID cursor.execute(query) return conn.commit()
def edit_collection(collection, authorID, introduction, collectionID): query = '''UPDATE collection SET Collection = '%s', AuthorID = %d, Introduction = '%s'\n WHERE CollectionID = %d''' % (collection, authorID, introduction, collectionID) cursor.execute(query) return conn.commit()
def edit_work(title, content, foreword, introduction, authorID, dynastyID, collectionID, type, workID): query = '''UPDATE work SET Title = '%s', Content = '%s', Foreword = '%s', Introduction = '%s', AuthorID = %d, DynastyID = %d, CollectionID = %d, Type = '%s' WHERE WorkID=%d''' % (title, content, foreword, introduction, authorID, dynastyID, collectionID, type, workID) cursor.execute(query) return conn.commit()
def edit_dynasty(dynasty, introduction, startYear, endYear, dynastyID): query = '''UPDATE dynasty SET Dynasty='%s', Introduction='%s', StartYear=%d, EndYear=%d\n WHERE DynastyID = %d''' % (dynasty, introduction, startYear, endYear, dynastyID) cursor.execute(query) return conn.commit()
def add_email(user_id, email): query = "UPDATE user SET Email = '%s' WHERE UserID = %d" % (email, user_id) cursor.execute(query) return conn.commit()
def add_user(userID, name, avatar, signature, desc, locationID, location):
query = '''INSERT INTO user (UserID, Name, Avatar, Signature, Description, LocationID, Location)\n
VALUES (%d, '%s', '%s', '%s', '%s', %d, '%s')''' % (
userID, name, avatar, signature, desc, locationID, location)
cursor.execute(query)
return conn.commit()
def add_author(author, quote, introduction, birthYear, deathYear, dynastyID):
query = '''INSERT INTO author (Author, Quote, Introduction, BirthYear, DeathYear, DynastyID) VALUES\n
('%s', '%s', '%s', %d, %d, %d)''' % (author, quote, introduction, birthYear, deathYear, dynastyID)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def edit_product(product_id, product, url, image_url, introduction): query = '''UPDATE product SET Product = '%s', Url = '%s', ImageUrl = '%s', Introduction = '%s' WHERE ProductID = %d''' % (product, url, image_url, introduction, product_id) cursor.execute(query) return conn.commit()
def add_review(work_id, user_id, title, content):
query = '''INSERT INTO review (WorkID, UserID, Title, Content)\n
VALUES (%d, %d, '%s', '%s')''' % (work_id, user_id, title, content)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def edit_collection(collection, authorID, introduction, collectionID):
query = '''UPDATE collection SET Collection = '%s', AuthorID = %d, Introduction = '%s'\n
WHERE CollectionID = %d''' % (collection, authorID, introduction,
collectionID)
cursor.execute(query)
return conn.commit()
def add_product(product, url, image_url, introduction):
query = '''INSERT INTO product (Product, Url, ImageUrl, Introduction)\n
VALUES ('%s', '%s', '%s', '%s')''' % (product, url, image_url, introduction)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def add_collection(collection, authorID, introduction):
query = '''INSERT INTO collection (Collection, AuthorID, Introduction) VALUES\n
('%s', %d, '%s')''' % (collection, authorID, introduction)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def remove_love(user_id, work_id):
query = "DELETE FROM love WHERE UserID = %d AND WorkID = %d" % (
user_id, work_id)
cursor.execute(query)
return conn.commit()
def add_love(user_id, work_id):
query = "INSERT INTO love (UserID, WorkID) VALUES (%d, %d)" % (user_id,
work_id)
cursor.execute(query)
return conn.commit()
def active_user(userID):
query = "UPDATE user SET IsActive = 1 WHERE UserID = %d" % userID
cursor.execute(query)
return conn.commit()
def add_review(work_id, user_id, title, content): query = '''INSERT INTO review (WorkID, UserID, Title, Content)\n VALUES (%d, %d, '%s', '%s')''' % (work_id, user_id, title, content) cursor.execute(query) conn.commit() return cursor.lastrowid
def add_email(user_id, email):
query = "UPDATE user SET Email = '%s' WHERE UserID = %d" % (email,
user_id)
cursor.execute(query)
return conn.commit()
def add_widget(target_type, target_id, title, content, position_index):
query = '''INSERT INTO widget (Type, TargetID, Title, Content, PositionIndex)\n
VALUES ('%s', %d, '%s', '%s', %d)''' % (target_type, target_id, title, content, position_index)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def edit_author(author,quote, introduction, birthYear, deathYear, dynastyID, authorID): query = '''UPDATE author\n SET Author='%s', Quote='%s', Introduction='%s', BirthYear=%d, DeathYear=%d, DynastyID=%d\n WHERE AuthorID = %d''' % (author, quote, introduction, birthYear, deathYear, dynastyID, authorID) cursor.execute(query) return conn.commit()
def delete_widget(widget_id): query = "DELETE FROM widget WHERE WidgetID = %d" % widget_id cursor.execute() return conn.commit()
def edit_review(review_id, title, content):
query = '''UPDATE review SET Title = '%s', Content = '%s' WHERE ReviewID = %d''' % (
title, content, review_id)
cursor.execute(query)
return conn.commit()
def add_dynasty(dynasty, introduction, startYear, endYear):
query = '''INSERT INTO dynasty (Dynasty, Introduction, StartYear, EndYear) VALUES
('%s', '%s', %d, %d)''' % (dynasty, introduction, startYear, endYear)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def edit_review(review_id, title, content): query = '''UPDATE review SET Title = '%s', Content = '%s' WHERE ReviewID = %d''' % (title, content, review_id) cursor.execute(query) return conn.commit()
def add_love(user_id, work_id): query = "INSERT INTO love (UserID, WorkID) VALUES (%d, %d)" % (user_id, work_id) cursor.execute(query) return conn.commit()
def edit_widget(widget_id, title, content, position_index): query = '''UPDATE widget SET Title = '%s', Content = '%s', PositionIndex = %d\n WHERE WidgetID = %d''' % (title, content, position_index, widget_id) cursor.execute(query) return conn.commit()
def remove_love(user_id, work_id): query = "DELETE FROM love WHERE UserID = %d AND WorkID = %d" % (user_id, work_id) cursor.execute(query) return conn.commit()
def active_user(userID): query = "UPDATE user SET IsActive = 1 WHERE UserID = %d" % userID cursor.execute(query) return conn.commit()
def add_work(title, content, foreword, introduction, authorID, dynastyID, collectionID, type):
query = '''INSERT INTO work (Title, Content, Foreword, Introduction, AuthorID, DynastyID, CollectionID, Type)\n
VALUES ('%s', '%s', '%s','%s', %d, %d, %d, '%s')''' % (title, content, foreword, introduction, authorID, dynastyID, collectionID, type)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
def add_user(userID, name, avatar, signature, desc, locationID, location): query = '''INSERT INTO user (UserID, Name, Avatar, Signature, Description, LocationID, Location)\n VALUES (%d, '%s', '%s', '%s', '%s', %d, '%s')''' % (userID, name, avatar, signature, desc, locationID, location) cursor.execute(query) return conn.commit()
def add_collection(collection, authorID, introduction):
query = '''INSERT INTO collection (Collection, AuthorID, Introduction) VALUES\n
('%s', %d, '%s')''' % (collection, authorID, introduction)
cursor.execute(query)
conn.commit()
return cursor.lastrowid
