--- 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: