From 75e132f05e9b46a388c2ca3a23e30e57e9d9bc3f Mon Sep 17 00:00:00 2001
From: Dylan Lloyd <dylan@psu.edu>
Date: Tue, 22 Mar 2011 22:08:04 -0400
Subject: [PATCH] Moved projects/ out of repo.

I don't really know why I was versioning these, it doesn't seem appropriate, I wan't to be able to easily change them.
---
 projects/drawcss.html        | 17 -----------------
 projects/i_like_pandora.html | 17 -----------------
 projects/peepshow.html       | 16 ----------------
 projects/readoo.html         | 13 -------------
 projects/repthis.html        | 17 -----------------
 projects/youtube_backup.html | 16 ----------------
 publish_projects.py          |  7 ++++---
 7 files changed, 4 insertions(+), 99 deletions(-)
 delete mode 100644 projects/drawcss.html
 delete mode 100644 projects/i_like_pandora.html
 delete mode 100644 projects/peepshow.html
 delete mode 100644 projects/readoo.html
 delete mode 100644 projects/repthis.html
 delete mode 100644 projects/youtube_backup.html

diff --git a/projects/drawcss.html b/projects/drawcss.html
deleted file mode 100644
index e5f8bdd..0000000
--- a/projects/drawcss.html
+++ /dev/null
@@ -1,17 +0,0 @@
-        <div class="exhibit" id="drawcss_">
-          <h1 id="drawcss_title"><a href=
-          "drawcss">drawcss</a></h1><span id=
-          "drawcss_entry">writing markup for website wireframes
-          always seemed silly.<br>
-
-          <br>
-          this is a tool to draw them (it's not done).<br>
-          <br>
-          <a href="#show" id="showdivs" name="showdivs">check
-          out</a> the invisible elements this page is built on.<br>
-          <br>
-          then get <a href=
-          "http://github.com/nospampleasemam/drawcss">the
-          code</a>.</span>
-
-        </div>
diff --git a/projects/i_like_pandora.html b/projects/i_like_pandora.html
deleted file mode 100644
index 0a615cc..0000000
--- a/projects/i_like_pandora.html
+++ /dev/null
@@ -1,17 +0,0 @@
-        <div class="exhibit" id="i_like_pandora_">
-          <h1 id="i_like_pandora_title"><a href=
-          "https://github.com/nospampleasemam/i_like_pandora">i_like_pandora</a></h1><span id="i_like_pandora_entry">searches
-          <a href="http://youtube.com">youtube</a> for what you
-          like on <a href="http://pandora.com">pandora</a>.<br>
-
-          <br>
-          then it downloads the first video.<br>
-          <br>
-          it's working, but i'm still making it better.<br>
-          <br>
-          <br>
-          the code is free (as in freedom), <a href=
-          "http://github.com/nospampleasemam/i_like_pandora">here</a>.<br>
-
-          </span>
-        </div>
diff --git a/projects/peepshow.html b/projects/peepshow.html
deleted file mode 100644
index 08156c5..0000000
--- a/projects/peepshow.html
+++ /dev/null
@@ -1,16 +0,0 @@
-        <div class="exhibit" id="peepshow_">
-          <h3 id="peepshow_title_1"><a href=
-          "foxy-addons/peepshow/peepshow.xpi">foxy-addons/</a></h3>
-
-          <h1 id="peepshow_title_2"><a href=
-          "foxy-addons/peepshow/peepshow.xpi">peepshow</a></h1><span id="peepshow_entry">a
-          <a href=
-          "http://www.mozilla.com/en-US/products/download.html">firefox</a>
-          addon, to load linked images inline (like on <a href=
-          "http://reddit.com/r/pics">reddit</a>).<br>
-
-          <br>
-          here's the <a href=
-          "http://github.com/nospampleasemam/peepshow/">repo</a>
-          for the source code.</span>
-        </div>
diff --git a/projects/readoo.html b/projects/readoo.html
deleted file mode 100644
index 1c1919c..0000000
--- a/projects/readoo.html
+++ /dev/null
@@ -1,13 +0,0 @@
-        <div class="exhibit" id="readoo_">
-          <h1 id="readoo_title"><a href=
-          "http://github.com/nospampleasemam/readoo">readoo</a></h1><span id="readoo_entry">helps
-          you find search keywords to target.<br>
-          <br>
-          it reads your IIS logs, and finds successful keywords
-          worth focusing on.<br>
-          <br>
-          it's not done yet! here's the <a href=
-          "http://github.com/nospampleasemam/readoo">source
-          code</a>.</span>
-
-        </div>
diff --git a/projects/repthis.html b/projects/repthis.html
deleted file mode 100644
index c395d49..0000000
--- a/projects/repthis.html
+++ /dev/null
@@ -1,17 +0,0 @@
-		<div class="exhibit" id="repthis_">
-          <span id="reprap_entry">3D printing is a form of additive
-          manufacturing technology where a three dimensional object
-          is created by successive layers of material. [1]:<a href=
-          "http://repthis.info/">http://en.wikipedia.org/wiki/3D_printing</a><br>
-
-          <br>
-          <a href="http://reprap.org">reprap</a> is a <a href=
-          "http://en.wikipedia.org/wiki/Free_software">free</a>
-
-          desktop 3D printer capable of printing plastic
-          objects.<br>
-          <br>
-          <a href="http://repthis.info">repthis.info</a> is the
-          account of a friend and I learning to build our own.<br>
-          <br></span>
-        </div>
diff --git a/projects/youtube_backup.html b/projects/youtube_backup.html
deleted file mode 100644
index 8f7767e..0000000
--- a/projects/youtube_backup.html
+++ /dev/null
@@ -1,16 +0,0 @@
-        <div class="exhibit" id="youtube_backup_">
-
-          <h1 id="youtube_backup_title"><a href=
-          "https://github.com/nospampleasemam/youtube_backup">youtube_backup</a></h1><span id="youtube_backup_entry">backs
-          up all the <a href="http://youtube.com">youtube</a>
-          videos in a users favorites list.<br>
-          <br>
-          this is my fork of the <a href=
-          "https://github.com/hagnas/youtube_backup">original
-          youtube_backup</a> which adds asynchronous alerts after
-          successful downloads.<br>
-          <br>
-
-          it's written in <a href=
-          "http://www.python.org/">python</a>.</span>
-        </div>
diff --git a/publish_projects.py b/publish_projects.py
index 7e5535c..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
@@ -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)
@@ -25,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)\
-- 
2.30.2