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 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 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_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 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 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()