X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;f=publish_projects.py;h=14a577279e2926928064b53382b0d25ee5ae873b;hb=2cf7880d4afdde09707d4fc62e82597d6bfea7a0;hp=da77e399d521924f52d2267cb779fcef03dbe24d;hpb=22ca6f0ce2843b106996d6df20012d8aee139e70;p=dylansserver.git

diff --git a/publish_projects.py b/publish_projects.py
index da77e39..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
@@ -13,7 +15,7 @@ password = config.get('database', 'password').replace('"', '')
 database = config.get('database', '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)
@@ -23,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))