Python MySQL API

Common

• SQLUpdateQueries():
• FatalSQLerror():
• SQLgetDatabaseStatus():
• SQLgetEditingStatus():
• SQLgetSchemaVersion():
• todaysDate():
• SQLgetNotes(index):
• SQLgetUserName(userId):
• SQLisUserModerator(userId):
• SQLgetSubmitterID(submitter):
• SQLgetSubmitterName(submitter):
• SQLmarkIntegrated(db, recno, reviewerid):
• SQLloadXML(recno):
• SQLloadState(recno):
• SQLwikiLinkExists(namespace, title):

Authors

• SQLgetAuthorData(author):
• SQLloadAuthorData(author_id):
• SQLauthorIsPseudo(au_id):
• SQLauthorHasPseudo(au_id):
• SQLgetActualFromPseudo(au_id):
• SQLgetPseudoFromActual(au_id):
• SQLupdateViews(author_id):
• SQLloadEmails(author_id):
• SQLloadWebpages(author_id):
• SQLbornToday():
• SQLdiedToday():
• SQLgetAuthorVariants(author_id):
• SQLGetInterviews(author_id):
• SQLFindAuthors(target):

Titles

• SQLupdateTitleViews(title_id):
• SQLloadTitlesXBA(aurec, alpha, views, chron):
• SQLserialTitlesXBA(aurec, alpha, views):
• SQLloadLongTitlesXBA(aurec, alpha, views):
• SQLloadAnyTitles(aurec):
• SQLloadShortTitlesXBA(aurec, alpha, views):
• SQLloadTitlesXBT(recno):
• SQLloadIntervieweeXBA(author):
• SQLloadTitle(titlerec):
• SQLFindTitles(target):
• SQLCollaborators(author_id):
• SQLTitleCollaborators(title_id, author_id):
• SQLTitleAuthors(title_id):
• SQLInterviewAuthors(title_id):
• SQLReviewAuthors(title_id):
• SQLFindYear(target):
• SQLgetTitle(titleId):
• SQLgetTitleVariants(title_id):
• SQLgetSerialsByTitle(title):
• SQLFindReviewParent(title, author):
• SQLloadTitleReviews(title_id):
• SQLfindReviewedTitle(review_id):

Series

• SQLgetShortSeriesData(authorec):
• SQLgetEssaySeriesData(authorec):
• SQLget1Series(seriesrec):
• SQLgetNCSeriesData(authorec):
• SQLgetASeriesData(authorec):
• SQLgetESeriesData(authorec):
• SQLgetNFSeriesData(authorec):
• SQLFindSeries(target):
• SQLFindSeriesChildren(id):
• SQLgetSeriesName(id):
• SQLFindSeriesId(target):
• SQLFindSeriesName(target):
• SQLFindSeries2(target):
• SQLloadTitlesXBS(series):

Awards

• SQLloadTitleFromAward(award_id):
• SQLloadAwardsXBA(author):
• SQLloadAwardsXBY(year):
• SQLTitleAwards(title_id):
• SQLloadAwards(award_id):

Publications

• SQLGetForthcoming(month, year, day, all):
• SQLGetTodaysPubs(month, year, day, limit):
• SQLGetPubByTag(tag):
• SQLGetPubById(tag):
• SQLGetPubsByTitle(titlerec):
• SQLGetPubsByPublisherYear(publisher_id, year):
• SQLGetPubsByAuthor(aurec):
• SQLGetPubsByPublisherYear(publisher_id, year):
• SQLGetPubContentByAuthor(aurec):
• SQLFindPubsByIsbn(target):
• SQLPubAuthors(pub_id):
• SQLMarqueAuthors(pub_id):
• SQLgetTitleReferral(pub_id):
• SQLgetPubTitle(pubId):
• SQLGetPubContentList(pub_id):
• SQLRefList():
• SQLVerificationList(pub_id):

Publishers

• SQLGetPublisher(pubrec):
• SQLFindPublisher(target):
• SQLGetPublisherYears(publisher_id):
• SQLgetPublisherName(id):
• SQLloadPublisherWebpages(publisher_id):

User Tags

• SQLgetAuthorTags(author_id):
• SQLgetTitleTags(title_id):
• SQLgetUserTags(title_id, user_id):
• SQLGetTagById(tag_id):
• SQLgetPopularTags():
• SQLsearchTags(tag):