(Preliminary) handling of weblog entry selection and summary.

1 files changed, 43 insertions, 0 deletions

diff --git a/org/madore/damlengine/WeblogSelect.java b/org/madore/damlengine/WeblogSelect.java
new file mode 100644
index 0000000..ad61cbc
--- /dev/null
+++ b/org/madore/damlengine/WeblogSelect.java
@@ -0,0 +1,43 @@
+package org.madore.damlengine;
+
+import java.util.HashSet;
+import java.util.ArrayList;
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+
+public final class WeblogSelect {
+
+    private WeblogSelect() { // Forbid instantiation
+	throw new AssertionError("WeblogSelect cannot be instantiated");
+    }
+
+    public static void main(String[] args)
+	throws Exception {
+
+	String year = "2011";
+	String month = "08";
+
+	final Connection conn = WeblogDatabaseConnection.getConnection();
+
+	final PreparedStatement selSt
+	    = conn.prepareStatement("SELECT id , content FROM entries WHERE edate LIKE ? ORDER BY id DESC");
+	selSt.setString(1,year+"-"+month+"-__");
+
+	final ResultSet selRes = selSt.executeQuery();
+	final Context.WeblogSelectionContext wsc
+	    = new Context.WeblogMonthSelectionContext(year,month);
+	wsc.sel = new HashSet<Integer>();
+	wsc.xmlData = new ArrayList<String>();
+	while ( selRes.next() ) {
+	    int id = selRes.getInt(1);
+	    String content = selRes.getString(2);
+	    wsc.sel.add(new Integer(id));
+	    wsc.xmlData.add(content);
+	}
+
+	DamlEngine.fullProcess("weblog-month-template.daml", System.out, wsc);
+
+    }
+
+}