From 6c4cab0a9f5dbc019d81eeaeae46c8f17c7bdca7 Mon Sep 17 00:00:00 2001 From: "David A. Madore" Date: Sun, 12 Oct 2014 21:03:33 +0200 Subject: Rename the "do_single_page" database column to "special_name", and update Java variables accordingly. The SQL command is: ALTER TABLE entries RENAME do_single_page TO special_name ; --- org/madore/damlengine/WeblogRSS.java | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'org/madore/damlengine/WeblogRSS.java') diff --git a/org/madore/damlengine/WeblogRSS.java b/org/madore/damlengine/WeblogRSS.java index 85d9fc0..30ff5ca 100644 --- a/org/madore/damlengine/WeblogRSS.java +++ b/org/madore/damlengine/WeblogRSS.java @@ -27,7 +27,7 @@ public final class WeblogRSS { final Connection conn = WeblogDatabaseConnection.getConnection(); final PreparedStatement selSt - = conn.prepareStatement("SELECT id , edate , to_char(cdate,'YYYY-MM-DD\"T\"HH24:MI:SS\"Z\"') , lang , do_single_page , title , content FROM entries ORDER BY id DESC LIMIT 25"); + = conn.prepareStatement("SELECT id , edate , to_char(cdate,'YYYY-MM-DD\"T\"HH24:MI:SS\"Z\"') , lang , special_name , title , content FROM entries ORDER BY id DESC LIMIT 25"); final ResultSet selRes = selSt.executeQuery(); @@ -97,7 +97,7 @@ public final class WeblogRSS { final String date = selRes.getString(2); final String cdate = selRes.getString(3); final String lang = selRes.getString(4); - final String doSinglePage = selRes.getString(5); + final String specialName = selRes.getString(5); final String title = selRes.getString(6); final String contentXml = selRes.getString(7); final Matcher matcher = Pattern.compile("^(\\d{4})-(\\d{2})-(\\d{2})$").matcher(date); @@ -109,7 +109,7 @@ public final class WeblogRSS { final String numberStr = String.format("%04d",id); final WeblogLink lk = new WeblogLink(yearStr, monthStr, dayStr, numberStr, "", - doSinglePage); + specialName); lk.setTypeStandard(); final String aboutUri = weblogBaseURI + "#" + lk.getFragment(); final String linkUri = lk.getTarget(weblogBaseURI); -- cgit v1.2.3