X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;f=publish_projects.py;h=14a577279e2926928064b53382b0d25ee5ae873b;hb=f599d79cf6bf53ad8e4e3164bc01c9b55ecc199f;hp=7e5535ce40b1b3d0bd4fcd26da236ed0c1a2c144;hpb=05250f978cc7e3e1f7df92f20fd18f4667a06f2f;p=dylansserver.git

diff --git a/publish_projects.py b/publish_projects.py
index 7e5535c..14a5772 100755
--- a/publish_projects.py
+++ b/publish_projects.py
@@ -1,5 +1,7 @@
 #!/usr/bin/python
 
+PROJECTS_DIRECTORY = '/home/dylan/docs/projects'
+
 import os
 import time
 import MySQLdb as db
@@ -11,10 +13,9 @@ domain = config.get('database', 'domain')
 user = config.get('database', 'user')
 password = config.get('database', 'password').replace('"', '')
 database = config.get('database', 'database')
-print domain, user, password, database
 cursor = db.connect(domain, user, password, database).cursor()
 
-notes = os.listdir('projects')
+notes = os.listdir(PROJECTS_DIRECTORY)
 
 sql = "SELECT title FROM projects"
 cursor.execute(sql)
@@ -24,9 +25,10 @@ for row in results:
     existing_titles.append(row[0])
 
 for note in notes:
+    if (note[:1] == '.'): continue
     title = note[:note.index('.')]
-    f = open(os.path.join('projects', note))
+    f = open(os.path.join(PROJECTS_DIRECTORY, note))
     if title in existing_titles: continue
     text = f.read()
     cursor.execute("INSERT INTO projects (title, text)\
-                      VALUES (%s, %s)", (title, text))
+                        VALUES (%s, %s)", (title, text))