def get_collection(collectionID): query = '''SELECT * FROM collection, author, dynasty\n WHERE collection.AuthorID = author.AuthorID\n AND author.DynastyID = dynasty.dynastyID AND collectionID = %d''' % collectionID cursor.execute(query) return cursor.fetchone()
def get_author(authorID): query = '''SELECT *\n FROM author, dynasty\n WHERE author.DynastyID = dynasty.DynastyID\n AND author.AuthorID = %d''' % authorID cursor.execute(query) return cursor.fetchone()
def get_review(review_id): query = '''SELECT review.ReviewID, review.Title, review.Content, review.Time, user.UserID, user.Name, user.Avatar, work.WorkID, work.Title AS WorkTitle, work.Content AS WorkContent, author.Author\n FROM review, user, work, author\n WHERE review.ReviewID = %d\n AND review.UserID = user.UserID\n AND review.WorkID = work.WorkID\n AND work.AuthorID = author.AuthorID''' % review_id cursor.execute(query) return cursor.fetchone()
def get_work(workID): query = '''SELECT work.WorkID, work.Title, work.Content, work.Foreword, work.Introduction AS WorkIntroduction, work.Type, work.AuthorID, work.DynastyID, work.CollectionID, author.Author, author.Introduction AS AuthorIntroduction, dynasty.Dynasty, collection.Collection, collection.Introduction\n FROM work, author, dynasty, collection\n WHERE work.workID = %d\n AND work.AuthorID = author.AuthorID\n AND work.DynastyID = dynasty.DynastyID\n AND work.collectionID = collection.CollectionID\n''' % workID cursor.execute(query) return cursor.fetchone()
def get_name(user_id): query = "SELECT Name FROM user WHERE UserID = %d" % user_id cursor.execute(query) return cursor.fetchone()['Name']
def get_people(user_id): query = "SELECT * FROM user WHERE UserID = %d" % user_id cursor.execute(query) return cursor.fetchone()
def get_widget(widget_id): query = "SELECT * FROM widget WHERE WidgetID = %d" % widget_id cursor.execute(query) return cursor.fetchone()
def get_product(product_id): query = "SELECT * FROM product WHERE ProductID = %d" % product_id cursor.execute(query) return cursor.fetchone()
def get_dynastyID_by_author(authorID): query = "SELECT DynastyID FROM author WHERE AuthorID = %d" % authorID cursor.execute(query) return cursor.fetchone()['DynastyID']
def get_dynasty(dynastyID): query = "SELECT * FROM dynasty WHERE DynastyID = %d" % dynastyID cursor.execute(query) return cursor.fetchone()