X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;f=publish.py;h=288a395eddbc70ae7e3ccbdf04a0b50fc730903d;hb=0d5b65dd317eda7cd09d208c634067c4a9acb6fd;hp=b0847ffaff57ad9a4984de59c8874f6874177b21;hpb=a74a20d64f0c3c757c9a97f9f9a858adca266221;p=dylansserver.git

diff --git a/publish.py b/publish.py
index b0847ff..288a395 100755
--- a/publish.py
+++ b/publish.py
@@ -2,12 +2,18 @@
 
 import os
 import time
-import MySQLdb
+import MySQLdb as db
+import ConfigParser
 
-db = MySQLdb.connect('localhost','dylan','password', 'dylanstestserver')
-cursor = db.cursor()
+config = ConfigParser.RawConfigParser()
+config.read('/etc/dylanstestserver.ini')
+domain = config.get('database', 'domain')
+user = config.get('database', 'user')
+password = config.get('database', 'password')
+database = config.get('database', 'database')
+cursor = db.connect(domain, user, password, database).cursor()
 
-notes = os.listdir('notes')
+notes = os.listdir('/home/dylan/docs/notes')
 
 sql = "SELECT title FROM notes"
 cursor.execute(sql)
@@ -27,7 +33,7 @@ for note in notes:
     date_posted = "%s-%s-%s" % (str(mtime.tm_year)[2:], mtime.tm_mon, mtime.tm_mday)
     sql = "INSERT INTO notes (date_posted, url, title, text)\
              VALUES(\"%s\", \"%s\", \"%s\", \"%s\")"\
-             % (date_posted, url, title, MySQLdb.escape_string(text))
+             % (date_posted, url, title, db.escape_string(text))
 
     #print sql
     cursor.execute(sql)