X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;f=publish_notes.py;h=331030caeba5b3984ebbf70a2814cefa4817ac63;hb=d2156630c0f3e7aca93cb72c762f713e9c8bdad3;hp=8663f9c44c1333686c428854ff378af059dc5276;hpb=a6fc8a7a21a0063db905737365e9daa149554665;p=dylansserver.git diff --git a/publish_notes.py b/publish_notes.py index 8663f9c..331030c 100755 --- a/publish_notes.py +++ b/publish_notes.py @@ -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)