alcatel/mediapartdb/MediapartReader.py
changeset 37 3848e1813a30
parent 27 8ca7f2cea729
--- a/alcatel/mediapartdb/MediapartReader.py	Mon Jul 22 14:56:35 2013 +0200
+++ b/alcatel/mediapartdb/MediapartReader.py	Wed Aug 14 16:36:41 2013 +0200
@@ -12,8 +12,8 @@
 class MediapartReader() :
     def __init__(self):
         self.conn = MySQLdb.connect (host = 'localhost',
-            user = 'mediapart',
-            passwd = 'mediapart',
+            user = 'root',
+            passwd = '',
             db = 'www_mediapart_fr')
         
         warnings.filterwarnings('ignore', category=MySQLdb.Warning)
@@ -22,20 +22,24 @@
         self.conn.close ()
        
     def get_date(self, document_id):     
-
         self.conn.query('SELECT changed FROM node where nid=\''+document_id+'\'')
+        
         r = self.conn.use_result()
         row = r.fetch_row()
         if row:
             date = (row)[0][0]
         else:
             date = '0'
-
+        '''logger.info('get_date')
+        logger.info('document_id = '+document_id)
+        logger.info('date = '+str(date))'''
         #changed_date = datetime.datetime.fromtimestamp(int(change_date_unix[0])).strftime('%Y-%m-%d %H:%M:%S')
         return date
     
     def get_title(self, document_id): 
         self.conn.query('SELECT title FROM node where nid=\''+document_id+'\'')
+        '''logger.info('get_title')
+        logger.info('document_id = '+document_id)'''
         r = self.conn.use_result()
         row = r.fetch_row()
         if row:
@@ -77,6 +81,7 @@
                 return category 
             else:
                 category = '' 
+        
         return category
     
     def get_tags(self, document_id):
@@ -93,21 +98,25 @@
         return tags
     
     def get_url(self, document_id):
+        logger.info('get_url')
+        logger.info('document_id = '+document_id)
         self.conn.query('SELECT dst FROM url_alias where src="node/'+document_id+'"')
+        '''logger.info('get_url')
+        logger.info('document_id = '+document_id)'''
         r = self.conn.use_result()
         row = r.fetch_row()
         
         if row:
-            print 'row!!!!!!!!!!!!!!!!!!!!!!!!'
-            print row
-            print (row)[0][0]
             url = 'http://www.mediapart.fr/'+(row)[0][0]
         else:
             url = ''
+        logger.info('url = '+url)
         return url
     
     def get_author(self, document_id):
         self.conn.query('SELECT u.uid, u.name FROM users u, node n where u.uid=n.uid AND n.nid=\''+document_id+'\'')
+        '''logger.info('get_author')
+        logger.info('document_id = '+document_id)'''
         r = self.conn.use_result()
         row = r.fetch_row()
         if row: