X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;f=publish_notes.py;h=4b711d963a9347ca75a8840847b78bb65da4f8ba;hb=eb9db23304d0f3ad3462bf192c6c0837cb79e6a7;hp=8663f9c44c1333686c428854ff378af059dc5276;hpb=a6fc8a7a21a0063db905737365e9daa149554665;p=dylansserver.git

diff --git a/publish_notes.py b/publish_notes.py
index 8663f9c..4b711d9 100755
--- a/publish_notes.py
+++ b/publish_notes.py
@@ -1,4 +1,4 @@
-#!/usr/bin/python
+#!/usr/bin/env python2
 
 NOTES_DIRECTORY = '/home/dylan/docs/notes'
 
@@ -8,7 +8,7 @@ import MySQLdb as db
 import ConfigParser
 
 config = ConfigParser.RawConfigParser()
-config.read('/etc/dylanstestserver.ini')
+config.read('/etc/dylansserver.ini')
 domain = config.get('database', 'domain')
 user = config.get('database', 'user')
 password = config.get('database', 'password').replace('"', '')
@@ -25,17 +25,17 @@ for row in results:
     existing_titles.append(row[0])
 
 for note in notes:
+    if note[:1] == '.': continue
     if note == 'index.php' or note == 'notes.php': continue
     url = note[:note.index('.')]
     f = open(os.path.join(NOTES_DIRECTORY, note))
     title = str(f.readline()[:-1])
+    date_posted = time.strptime(str(f.readline()[:-1]), "%Y/%m/%d %I:%M%p")
     text = ''.join(f.readlines()) #converts list to single string
     if title in existing_titles: continue
-    mtime = time.localtime(os.path.getmtime(os.path.join(NOTES_DIRECTORY, note)))
-    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, db.escape_string(text))
+             % (time.strftime("%Y/%m/%d %I:%M:00", date_posted), url, title, db.escape_string(text))
 
-    #print sql
-    cursor.execute(sql)
+    print sql
+    #cursor.execute(sql)