X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;f=publish_projects.py;h=6e538d965777242d03cc0fd3d24758633257b48b;hb=a344a94edd8dbab7ff00ebd5e26d9acfabda679d;hp=da77e399d521924f52d2267cb779fcef03dbe24d;hpb=22ca6f0ce2843b106996d6df20012d8aee139e70;p=dylansserver.git diff --git a/publish_projects.py b/publish_projects.py index da77e39..6e538d9 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) @@ -24,7 +26,7 @@ for row in results: for note in notes: 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)\