⌈⌋ ⎇ branch:  freshcode


Check-in [3e849fb034]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
SHA1:3e849fb034cf42fdf3693aa3077e1669da801b99
Date: 2015-04-14 12:05:57
User: mario
Comment:Add `summary` table field (oneliner, to be used in rss/search/twitter, and somewhen later frontpage listings).
Tags And Properties
  • branch=trunk inherited from [82405bb421]
  • sym-trunk inherited from [82405bb421]
Context
2015-04-14
12:07
[d7ae58c7dd] For resiliency support `set_password` update in session handler. Prepare login page for complaints about visible text field. (Alternatively just placeholder=notice for login feedback). (user: mario, tags: trunk)
12:05
[3e849fb034] Add `summary` table field (oneliner, to be used in rss/search/twitter, and somewhen later frontpage listings). (user: mario, tags: trunk)
2015-04-12
15:26
[884a3cd028] API locked against `test.db` (needs an inspection UI still) for now. Mostly untested implementation of CREATE/new_project() method with SSL cert requirement. (user: mario, tags: trunk)
Changes

Changes to db.sql.

1
2
3
4
5
6
7

8
9
10
11
12
13
14
--# title: freshcode database schema
--# version: 0.7

CREATE TABLE [release] ( 
    name              VARCHAR( 100 )     NOT NULL,
    title             TEXT               NOT NULL,
    homepage          TEXT,

    description       TEXT               NOT NULL,
    license           VARCHAR( 100 ),
    tags              VARCHAR( 200 ),
    version           VARCHAR( 100 )     NOT NULL,
    state             VARCHAR( 20 ),
    scope             VARCHAR( 20 ),
    changes           TEXT,







>







1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
--# title: freshcode database schema
--# version: 0.7

CREATE TABLE [release] ( 
    name              VARCHAR( 100 )     NOT NULL,
    title             TEXT               NOT NULL,
    homepage          TEXT,
    summary           VARCHAR( 200 ),
    description       TEXT               NOT NULL,
    license           VARCHAR( 100 ),
    tags              VARCHAR( 200 ),
    version           VARCHAR( 100 )     NOT NULL,
    state             VARCHAR( 20 ),
    scope             VARCHAR( 20 ),
    changes           TEXT,

Changes to release.php.

83
84
85
86
87
88
89

90
91
92
93
94
95
96
                 "name"     => $newdata->proj_name         ->length…3…33["name"],
                 "homepage" => $newdata->ascii->trim->http  ->length…250["homepage"],
                 "download" => $newdata->ascii->trim->url   ->length…250["download"],
                 "image"    => $newdata->ascii->trim->http  ->length…250["image"],
           "autoupdate_url" => $newdata->ascii->trim->http  ->length…250["autoupdate_url"],
                 "title"    => $newdata->text               ->length…100["title"],
              "description" => $newdata->nl                ->length…2000["description"],

                 "license"  => $newdata->words               ->length…30["license"],
                 "tags"     => $newdata->words->f_tags      ->length…150["tags"],
                 "version"  => $newdata->f_version           ->length…30["version"],
                 "state"    => $newdata->words->strtolower   ->length…30["state"],
                 "scope"    => $newdata->words->strtolower   ->length…30["scope"],
                 "changes"  => $newdata->text->nl          ->length…2000["changes"],
                "submitter" => $newdata->text               ->length…100["submitter"],







>







83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
                 "name"     => $newdata->proj_name         ->length…3…33["name"],
                 "homepage" => $newdata->ascii->trim->http  ->length…250["homepage"],
                 "download" => $newdata->ascii->trim->url   ->length…250["download"],
                 "image"    => $newdata->ascii->trim->http  ->length…250["image"],
           "autoupdate_url" => $newdata->ascii->trim->http  ->length…250["autoupdate_url"],
                 "title"    => $newdata->text               ->length…100["title"],
              "description" => $newdata->nl                ->length…2000["description"],
                 "summary"  => $newdata->text->nl           ->length…160["summary"],
                 "license"  => $newdata->words               ->length…30["license"],
                 "tags"     => $newdata->words->f_tags      ->length…150["tags"],
                 "version"  => $newdata->f_version           ->length…30["version"],
                 "state"    => $newdata->words->strtolower   ->length…30["state"],
                 "scope"    => $newdata->words->strtolower   ->length…30["scope"],
                 "changes"  => $newdata->text->nl          ->length…2000["changes"],
                "submitter" => $newdata->text               ->length…100["submitter"],