diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2017-04-23 12:46:48 +0200 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2017-04-23 18:43:26 +0200 |
| commit | 016b40f99d679f0787f7c8a5f61f4a411b6c3632 (patch) | |
| tree | 587e6326208d2b241a4f719e6db55b765b92df4b /upgrading | |
| parent | 4abde895a5b579fb798e062806c8fef2289f0d8f (diff) | |
| download | aur-016b40f99d679f0787f7c8a5f61f4a411b6c3632.tar.gz aur-016b40f99d679f0787f7c8a5f61f4a411b6c3632.tar.xz | |
Render comments when storing them in the database
Instead of converting package comments from plain text to HTML code when
they are displayed, do the conversion when the comment is posted and
store the rendered result in the database. The conversion itself is done
by a Python script which uses Bleach for sanitizing the text.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading')
| -rw-r--r-- | upgrading/4.6.0.txt | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/upgrading/4.6.0.txt b/upgrading/4.6.0.txt index 45740f40..b051baca 100644 --- a/upgrading/4.6.0.txt +++ b/upgrading/4.6.0.txt @@ -9,3 +9,9 @@ UPDATE PackageDepends SET DepName = SUBSTRING(DepName FROM 1 FOR POSITION(': ' IN DepName) - 1) WHERE POSITION(': ' IN DepName) > 0; --- + +2. Add RenderedComment column to PackageComments: + +--- +ALTER TABLE PackageComments ADD COLUMN RenderedComment TEXT NOT NULL; +--- |