app/src/androidTest/java/com/geekorum/ttrss/data/ArticleFullTextSearchTest.kt
author Da Risk <da_risk@geekorum.com>
Mon, 03 Dec 2018 17:40:27 -0800
changeset 24 6386fb76b891
parent 23 9797095c0fc7
child 37 86222b4631ae
permissions -rw-r--r--
Fix license headers
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
23
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     1
/**
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     2
 * Geekttrss is a RSS feed reader application on the Android Platform.
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     3
 *
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     4
 * Copyright (C) 2017-2018 by Frederic-Charles Barthelery.
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     5
 *
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     6
 * This file is part of Geekttrss.
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     7
 *
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     8
 * Geekttrss is free software: you can redistribute it and/or modify
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
     9
 * it under the terms of the GNU General Public License as published by
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    10
 * the Free Software Foundation, either version 3 of the License, or
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    11
 * (at your option) any later version.
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    12
 *
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    13
 * Geekttrss is distributed in the hope that it will be useful,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    14
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    15
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    16
 * GNU General Public License for more details.
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    17
 *
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    18
 * You should have received a copy of the GNU General Public License
24
6386fb76b891 Fix license headers
Da Risk <da_risk@geekorum.com>
parents: 23
diff changeset
    19
 * along with Geekttrss.  If not, see <http://www.gnu.org/licenses/>.
23
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    20
 */
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    21
package com.geekorum.ttrss.data
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    22
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    23
import android.database.sqlite.SQLiteDatabase
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    24
import androidx.arch.core.executor.testing.InstantTaskExecutorRule
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    25
import androidx.core.content.contentValuesOf
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    26
import androidx.lifecycle.Observer
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    27
import androidx.paging.LivePagedListBuilder
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    28
import androidx.paging.PagedList
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    29
import androidx.room.Room
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    30
import androidx.sqlite.db.SupportSQLiteDatabase
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    31
import androidx.test.core.app.ApplicationProvider
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    32
import androidx.test.ext.junit.runners.AndroidJUnit4
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    33
import com.geekorum.ttrss.data.migrations.runInTransaction
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    34
import com.geekorum.ttrss.providers.ArticlesContract
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    35
import com.geekorum.ttrss.providers.DbHelper
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    36
import com.google.common.truth.Truth.assertThat
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    37
import org.junit.Rule
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    38
import org.junit.runner.RunWith
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    39
import kotlin.test.BeforeTest
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    40
import kotlin.test.Test
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    41
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    42
@RunWith(AndroidJUnit4::class)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    43
class ArticleFullTextSearchTest {
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    44
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    45
    @get:Rule
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    46
    val roomRule = InstantTaskExecutorRule()
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    47
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    48
    private lateinit var database: ArticlesDatabase
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    49
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    50
    @BeforeTest
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    51
    fun beforeTest() {
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    52
        database = Room.inMemoryDatabaseBuilder(ApplicationProvider.getApplicationContext(),
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    53
            ArticlesDatabase::class.java)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    54
            .allowMainThreadQueries()
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    55
            .build()
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    56
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    57
        createSomeArticles(database.openHelper.writableDatabase)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    58
    }
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    59
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    60
    @Test
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    61
    fun testAnFTSSearchPagedList() {
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    62
        val expected = Article(
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    63
            id = 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    64
            contentData = ArticleContentIndexed(
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    65
                title = "Comment Linux est devenu un enjeu strategique pour la silicon valley",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    66
                content = """L’emblématique système d’exploitation libre est devenu un outil-clé
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    67
                    |de tous les grands groupes du Web, comme l’illustre le rachat de Red Hat. […]""".trimMargin(),
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    68
                tags = "article tags",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    69
                author = "article author"
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    70
            ),
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    71
            score = 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    72
            isPublished = true,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    73
            lastTimeUpdate = 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    74
            isUnread = true,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    75
            isTransientUnread = true,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    76
            isStarred = true,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    77
            isUpdated = true,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    78
            feedId = 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    79
            link = "article links",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    80
            flavorImageUri = "article flavor image uri",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    81
            contentExcerpt = "a content excerpt"
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    82
        )
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    83
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    84
        val articleDao = database.articleDao()
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    85
        val factory = articleDao.searchArticles("linux")
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    86
        val livedata = LivePagedListBuilder(factory, 10).build()
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    87
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    88
        val observer = Observer<PagedList<Article>> {
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    89
            assertThat(it).containsExactly(expected)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    90
        }
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    91
        livedata.observeForever(observer)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    92
        livedata.removeObserver(observer)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    93
    }
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    94
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    95
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    96
    private fun createSomeArticles(db: SupportSQLiteDatabase) {
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    97
        db.runInTransaction {
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    98
            var values = contentValuesOf(
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
    99
                ArticlesContract.Category._ID to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   100
                ArticlesContract.Category.TITLE to "category",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   101
                ArticlesContract.Category.UNREAD_COUNT to 2
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   102
            )
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   103
            db.insert(DbHelper.TABLE_CATEGORIES, SQLiteDatabase.CONFLICT_NONE, values)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   104
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   105
            values = contentValuesOf(
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   106
                ArticlesContract.Feed.TITLE to "feed title",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   107
                ArticlesContract.Feed.URL to "feed url",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   108
                ArticlesContract.Feed.CAT_ID to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   109
                ArticlesContract.Feed.UNREAD_COUNT to 2,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   110
                ArticlesContract.Feed.LAST_TIME_UPDATE to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   111
                ArticlesContract.Feed.DISPLAY_TITLE to "display title"
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   112
            )
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   113
            db.insert(DbHelper.TABLE_FEEDS, SQLiteDatabase.CONFLICT_NONE, values)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   114
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   115
            values = contentValuesOf(
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   116
                ArticlesContract.Article._ID to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   117
                ArticlesContract.Article.TITLE to "article title",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   118
                ArticlesContract.Article.CONTENT to "a content",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   119
                ArticlesContract.Article.SCORE to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   120
                ArticlesContract.Article.PUBLISHED to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   121
                ArticlesContract.Article.LAST_TIME_UPDATE to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   122
                ArticlesContract.Article.UNREAD to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   123
                ArticlesContract.Article.TRANSIENT_UNREAD to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   124
                ArticlesContract.Article.STARRED to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   125
                ArticlesContract.Article.IS_UPDATED to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   126
                ArticlesContract.Article.FEED_ID to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   127
                ArticlesContract.Article.LINK to "article links",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   128
                ArticlesContract.Article.TAGS to "article tags",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   129
                ArticlesContract.Article.AUTHOR to "article author",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   130
                ArticlesContract.Article.FLAVOR_IMAGE_URI to "article flavor image uri",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   131
                ArticlesContract.Article.CONTENT_EXCERPT to "a content excerpt"
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   132
            )
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   133
            db.insert(DbHelper.TABLE_ARTICLES, SQLiteDatabase.CONFLICT_NONE, values)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   134
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   135
            values = contentValuesOf(
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   136
                ArticlesContract.Article._ID to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   137
                ArticlesContract.Article.TITLE to "Comment Linux est devenu un enjeu strategique pour la silicon valley",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   138
                ArticlesContract.Article.CONTENT to """L’emblématique système d’exploitation libre est devenu un outil-clé
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   139
                    |de tous les grands groupes du Web, comme l’illustre le rachat de Red Hat. […]""".trimMargin(),
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   140
                ArticlesContract.Article.SCORE to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   141
                ArticlesContract.Article.PUBLISHED to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   142
                ArticlesContract.Article.LAST_TIME_UPDATE to 0,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   143
                ArticlesContract.Article.UNREAD to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   144
                ArticlesContract.Article.TRANSIENT_UNREAD to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   145
                ArticlesContract.Article.STARRED to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   146
                ArticlesContract.Article.IS_UPDATED to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   147
                ArticlesContract.Article.FEED_ID to 1,
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   148
                ArticlesContract.Article.LINK to "article links",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   149
                ArticlesContract.Article.TAGS to "article tags",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   150
                ArticlesContract.Article.AUTHOR to "article author",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   151
                ArticlesContract.Article.FLAVOR_IMAGE_URI to "article flavor image uri",
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   152
                ArticlesContract.Article.CONTENT_EXCERPT to "a content excerpt"
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   153
            )
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   154
            db.insert(DbHelper.TABLE_ARTICLES, SQLiteDatabase.CONFLICT_NONE, values)
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   155
        }
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   156
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   157
    }
9797095c0fc7 ArticleDao: allow to search for an article
Da Risk <da_risk@geekorum.com>
parents:
diff changeset
   158
}