Changeset 1013

Show
Ignore:
Timestamp:
06/25/06 03:02:27
Author:
woremacx
Message:

Change Schema(s/read/readmark/g; s/key/keyid/g;). Fixes #247

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/feature-server/plagger/assets/plugins/Store-DBIC/plagger.sqlite.sql

    r743 r1013  
    2424       rate TEXT, 
    2525       icon TEXT, 
    26        read INTEGER NOT NULL DEFAULT 0 
     26       readmark INTEGER NOT NULL DEFAULT 0 
    2727); 
    2828 
    …… 
    3030       id INTEGER NOT NULL PRIMARY KEY, 
    3131       feed INTEGER NOT NULL, 
    32        key TEXT NOT NULL, 
     32       keyid TEXT NOT NULL, 
    3333       value TEXT 
    3434); 
    …… 
    3737       id INTEGER NOT NULL PRIMARY KEY, 
    3838       entry INTEGER NOT NULL, 
    39        key TEXT NOT NULL, 
     39       keyid TEXT NOT NULL, 
    4040       value TEXT 
    4141); 

  • branches/feature-server/plagger/lib/Plagger/Plugin/Store/DBIC.pm

    r722 r1013  
    8282    $feed->metas->delete_all; # need more hack 
    8383    for my $k ( keys %{ $args->{feed}->meta } ) { 
    84         $feed->add_to_metas( { key => $k, value=> $args->{feed}->meta->{$k} } ); 
     84        $feed->add_to_metas( { keyid => $k, value=> $args->{feed}->meta->{$k} } ); 
    8585    } 
    8686 
    …… 
    114114        for my $k ( keys %{ $feed_entry->meta } ) { 
    115115            $entry->add_to_metas( 
    116                 { key => $k, value => $feed_entry->meta->{$k}, } ); 
     116                { keyid => $k, value => $feed_entry->meta->{$k}, } ); 
    117117        } 
    118118 

  • branches/feature-server/plagger/lib/Plagger/Schema/SQLite/Entry.pm

    r707 r1013  
    99 
    1010__PACKAGE__->add_columns( 
    11     qw/id feed title author date link summary body rate icon read/ 
     11    qw/id feed title author date link summary body rate icon readmark/ 
    1212); 
    1313__PACKAGE__->set_primary_key('id'); 

  • branches/feature-server/plagger/lib/Plagger/Schema/SQLite/EntryMeta.pm

    r707 r1013  
    99 
    1010__PACKAGE__->add_columns( 
    11     qw/id entry key value/ 
     11    qw/id entry keyid value/ 
    1212); 
    1313__PACKAGE__->set_primary_key('id'); 

  • branches/feature-server/plagger/lib/Plagger/Schema/SQLite/FeedMeta.pm

    r707 r1013  
    88 
    99__PACKAGE__->add_columns( 
    10     qw/id feed key value/ 
     10    qw/id feed keyid value/ 
    1111); 
    1212__PACKAGE__->set_primary_key('id'); 
    13 __PACKAGE__->utf8_columns(qw/key value/); 
     13__PACKAGE__->utf8_columns(qw/keyid value/); 
    1414 
    1515__PACKAGE__->belongs_to( feed => 'Plagger::Schema::SQLite::Feed' ); 

  • branches/feature-server/plagger/lib/PlaggerLDR.pm

    r708 r1013  
    1010    'View::JSON' => { 
    1111        expose_stash => 'json', 
     12        json_driver  => 'JSON::Syck', 
    1213    }, 
    1314); 

  • branches/feature-server/plagger/lib/PlaggerLDR/Controller/API.pm

    r743 r1013  
    2323      $c->req->params->{unread} 
    2424      ? $schema->resultset('Feed')->search( 
    25             { 'entries.read' => 0 }, 
     25            { 'entries.readmark' => 0 }, 
    2626            { 
    2727                join            => [qw/entries/], 
    …… 
    7474                    rows => 20, 
    7575                    page => $c->req->param('offset') / 20 + 1 }) 
    76         : ({ read => 0 }); 
     76        : ({ readmark => 0 }); 
    7777 
    7878    my @items; 
    …… 
    106106 
    107107    my $feed = $schema->resultset('Feed')->find( $c->req->param('subscribe_id') ); 
    108     for my $entry ($feed->entries({ read => 0 })) { 
    109         $entry->read(1); 
     108    for my $entry ($feed->entries({ readmark => 0 })) { 
     109        $entry->readmark(1); 
    110110        $entry->update; 
    111111    }