botlistprojects/botbert/lib/python/business/media_bom.py

   1 """
   2  Berlin Brown
   3  6/20/2007
   4
   5  media_bom.py
   6
   7  media business object model
   8 """
   9 __author__ = "Berlin Brown"
  10 __version__ = "0.1"
  11
  12 import MySQLdb
  13 from botlist_business_object import BotlistBusinessObject
  14
  15 SQL_PREFIX = "'"
  16 SQL_SUFFIX = "', "
  17 SQL_EMPTY = "'', "
  18
  19 MAX_FEEDS_CREATE = 10
  20
  21 #--------------------------------------
  22 class MediaHandler(BotlistBusinessObject):
  23
  24     def createActiveMedia(self):
  25         """ Delete existing media feeds and activate a new set"""
  26         try:
  27             cursor = self.conn.cursor()
  28             toggle_media_type = False
  29
  30             # Delete existing records from active feed set
  31             res = cursor.execute("delete from active_media_feeds")
  32
  33             # Iterate and create new records
  34             for i in range(0, MAX_FEEDS_CREATE):
  35                 sql_set = []
  36                 toggle_media_type = not toggle_media_type
  37                 # 'H' (home) OR 'B' botverse
  38                 media_type = toggle_media_type and 'H' or 'B'
  39                 sql_set.append("insert into active_media_feeds ")
  40                 sql_set.append("    values((select id from media_feeds order by RAND() limit 1),'%s', NOW());")
  41                 sql_str = ''.join(sql_set)
  42                 res = cursor.execute(sql_str % media_type)
  43
  44             cursor.close()
  45         except MySQLdb.OperationalError, message:
  46             errorMessage = "ERR %d:\n%s" % (message[0], message[1])
  47             return
  48
  49     def createCursor(self, media_obj):
  50         try:
  51             cursor = self.conn.cursor()
  52             sql_set = []
  53             sql_set.append("insert into ")
  54             sql_set.append("media_feeds ")
  55             sql_set.append("(image_filename, media_url, ")
  56             sql_set.append("image_thumbnail, media_title, ")
  57             sql_set.append("media_descr, media_type, ")
  58             sql_set.append("author, rating, rating_count, ")
  59             sql_set.append("views, keywords, orginal_imgurl, ")
  60             sql_set.append("process_count, created_on) ")
  61
  62             # Set the values
  63             sql_set.append("VALUES(")
  64             sql_set.append(SQL_EMPTY)  # filename
  65             sql_set.append(SQL_PREFIX + media_obj.url + SQL_SUFFIX)       # media url
  66             sql_set.append(SQL_PREFIX + media_obj.thumbnail + SQL_SUFFIX) # thumbnail
  67             sql_set.append(SQL_PREFIX + media_obj.title + SQL_SUFFIX)     # title
  68             sql_set.append(SQL_PREFIX + media_obj.descr + SQL_SUFFIX)     # descr
  69             sql_set.append("'V', ")             # media type
  70             sql_set.append(SQL_PREFIX + media_obj.author + SQL_SUFFIX)    # author
  71
  72             sql_set.append(media_obj.rating + ", ")       # rating
  73             sql_set.append(media_obj.rating_ct + ", ")    # rating count
  74             sql_set.append(media_obj.views + ", ")        # views
  75
  76             sql_set.append(SQL_PREFIX + media_obj.keywords + SQL_SUFFIX)  # keywords
  77             sql_set.append(SQL_EMPTY)           # orginal img url
  78             sql_set.append("0, ")               # process count
  79             sql_set.append("NOW())")
  80
  81             sql_str = ''.join(sql_set)
  82             cursor.execute(sql_str)
  83             cursor.close()
  84         except MySQLdb.OperationalError, message:
  85             errorMessage = "ERR %d:\n%s" % (message[0], message[1])
  86             return
  87
  88 # End of file