Python databaseinterface.DatabaseInterface类代码示例

	def add(cls, follower, following, weight=1):
		""" Returns 0 if it """
		cursor = dbi.execute(
			"INSERT IGNORE INTO analytics_follow (follower,following,weight) VALUES(%s,%s,%s)"
			,(follower,following,weight)
		)
		return (cursor.lastrowid!=0)

	def remove_comment(cls, usr, content):
		dbi.execute(
			"UPDATE analytics_content SET comments=comments-1 WHERE content=%s"
			,(content,)
		)

	def add_invite(cls, follower, following):
		cls.assert_exists(follower, following)
		dbi.execute(
			"UPDATE analytics_follow SET invites = invites+1 WHERE follower=%s and following=%s"
			,(follower, following)
		)

	def remove_comment(cls, follower, following):
		dbi.execute(
			"UPDATE analytics_follow SET comments = comments-1 WHERE follower=%s and following=%s"
			,(follower, following)
		)

	def remove(cls, follower, following):
		cursor = dbi.execute(
			"DELETE FROM analytics_follow WHERE follower=%s and following=%s"
			,(follower,following)
		)
		return (cursor.rowcount!=0)

 def remove_comment(cls, usr, content, tabloid):
     dbi.execute(
         "UPDATE analytics_tabloidentry SET comments=comments-1 WHERE tabloid=%s and content=%s"(tabloid, content)
     )

 def remove_view(cls, usr, content, tabloid):
     dbi.execute("UPDATE analytics_tabloidentry SET views=views-1 WHERE tabloid=%s and content=%s"(tabloid, content))

	def add(cls, usr, content):
		dbi.execute(
			"INSERT INTO analytics_usr_seen (usr,content) VALUES(%s,%s) "
			,(usr, content)
		)

	def remove_invite(cls, usr, tabloid):
		dbi.execute(
			"UPDATE analytics_tabloid SET invites=invites-1 WHERE tabloid=%s"
			,(tabloid,)
		)

	def add_invite(cls, usr, tabloid):
		cls.assert_exists(tabloid)
		dbi.execute(
			"UPDATE analytics_tabloid SET invites=invites+1 WHERE tabloid=%s"
			,(tabloid,)
		)

	def get_owner(cls, tabloid):
		row = dbi.execute("SELECT usr FROM analytics_tabloid WHERE tabloid=%s",(tabloid,)).fetchone()
		if row is not None:
			return row["usr"]
		else:
			return None

	def remove_view(cls, usr, tabloid):
		dbi.execute(
			"UPDATE analytics_tabloid SET views=views+1 WHERE tabloid=%s"
			,(tabloid,)
		)

	def add_view(cls, usr, tabloid):
		cls.assert_exists(tabloid)
		dbi.execute(
			"UPDATE analytics_tabloid SET views=views+1 WHERE tabloid=%s"
			,(tabloid,)
		)

	def add(cls, usr, tabloid):
		dbi.execute(				
			"INSERT INTO analytics_tabloid (tabloid,usr) VALUES(%s,%s)"
			,(tabloid,usr)
		)

	def add_time_spent(cls, usr, content):
		cls.assert_exists(content)
		dbi.execute(
			"UPDATE analytics_content SET time_spent=time_spent+%s WHERE content=%s"
			,(content,time_spent)
		)