Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | Rename the "do_single_page" database column to "special_name", and update ↵ | David A. Madore | 2014-10-12 | 1 | -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. Madore | 2014-10-12 | 1 | -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. Madore | 2014-10-12 | 1 | -0/+3 |
| | |||||
* | Entry single pages: handle permalinks gracefully, populate with attribute. | David A. Madore | 2011-11-12 | 1 | -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. Madore | 2011-08-28 | 1 | -0/+20 |