summaryrefslogtreecommitdiffstats
path: root/org/madore/damlengine/weblog-database.sql
Commit message (Collapse)AuthorAgeFilesLines
* Rename the "do_single_page" database column to "special_name", and update ↵David A. Madore2014-10-121-1/+1
| | | | | | | Java variables accordingly. The SQL command is: ALTER TABLE entries RENAME do_single_page TO special_name ;
* Separate the "has_cut" property from "do_single_page".David A. Madore2014-10-121-1/+2
| | | | | | | | | Note: the following SQL should be used to upgrade the database: ALTER TABLE entries ADD COLUMN has_cut boolean NOT NULL DEFAULT FALSE ; UPDATE entries SET has_cut = (array_length(xpath('.//d:cut-here', content, ARRAY[ARRAY['d', 'http://www.madore.org/~david/NS/daml/']]), 1) NOTNULL) ; -- Check that the following returns nothing: SELECT edate , id FROM entries WHERE has_cut != ( do_single_page NOTNULL ) ;
* Commit a reminder about permissions.David A. Madore2014-10-121-0/+3
|
* Entry single pages: handle permalinks gracefully, populate with attribute.David A. Madore2011-11-121-2/+3
| | | | | | | | | | * A single page is generated from the single-page attribute on <entry> element (stored in database as do_single_page). * Permalink refers to the single page. Same from weblog index. Other links are subject to debate (e.g., what about internal links? now we link to single page when link has a supplement part, but this is debatable).
* Preliminary code to populate a PostgreSQL database with weblog entries.David A. Madore2011-08-281-0/+20