Article.java

package com.mysite.models;

import com.mysite.news.R;

public class Article
{
    public static final String TABLE = "articles";
    public static final String COLUMN_ID = "_id";
    public static final String COLUMN_TITLE = "title";
    public static final String COLUMN_SUBTITLE = "subtitle";
    public static final String COLUMN_LINK = "link";
    public static final String COLUMN_BYLINE = "byline";
    public static final String COLUMN_DESCRIPTION = "description";
    public static final String COLUMN_STORYTEXT = "storytext";
    public static final String COLUMN_TRIBID = "tribid";
    public static final String COLUMN_PUBDATE = "pubdate";
    public static final String COLUMN_KEYWORDS = "keywords";
    public static final String COLUMN_CATEGORY = "category";
    public static final String COLUMN_SUBCATEGORY = "subcategory";
    public static final String COLUMN_WEIGHT = "weight";
    public static final String COLUMN_MODIFIED = "modified";
    public static final String COLUMN_S_TOP = "s_top";
    public static final String COLUMN_S_UTAH = "s_utah";
    public static final String COLUMN_S_SPORTS = "s_sports";
    public static final String COLUMN_S_MONEY = "s_money";
    public static final String COLUMN_S_OPINION = "s_opinion";
    public static final String COLUMN_S_MIX = "s_mix";
    public static final String COLUMN_S_POPULAR = "s_popular";
    public static final String COLUMN_S_BAGLEY = "s_bagley";
    public static final String COLUMN_S_OBITS = "s_obits";
    public static final String COLUMN_THUMBPATH = "filepath"; //not a table column - just a place to hold thumb path
    public static final int IMAGE_PLACEHOLDER = R.drawable.ic_launcher;

    public long id;
    public String title;
    public String subtitle;
    public String link;
    public String byline;
    public String description;
    public String storytext;
    public String tribid;
    public String pubdate;
    public String keywords;
    public String category;
    public String subcategory;
    public int weight;
    public String modified;
    public int s_top; //each section  is 1 or 0/null if it's in that section (can be in more than 1)
    public int s_utah;
    public int s_sports;
    public int s_money;
    public int s_opinion;
    public int s_mix;
    public int s_popular;
    public int s_bagley;
    public int s_obits;

    public String filepath; //temporarily holds the "filepath" from the SQL join when querying for the lists


    //Database creation sql statement
    public static final String TABLE_CREATE = "CREATE TABLE "
        + Article.TABLE + "( "
            + Article.COLUMN_ID + " INTEGER primary key autoincrement, "
            + Article.COLUMN_TITLE + " TEXT, "
            + Article.COLUMN_SUBTITLE + " TEXT, "
            + Article.COLUMN_LINK + " TEXT, "
            + Article.COLUMN_BYLINE + " TEXT, "
            + Article.COLUMN_DESCRIPTION + " TEXT, "
            + Article.COLUMN_STORYTEXT + " TEXT, "
            + Article.COLUMN_TRIBID + " TEXT, "
            + Article.COLUMN_PUBDATE + " TEXT, "
            + Article.COLUMN_KEYWORDS + " TEXT, "
            + Article.COLUMN_CATEGORY + " TEXT, "
            + Article.COLUMN_SUBCATEGORY + " TEXT, "
            + Article.COLUMN_WEIGHT + " INTEGER, "
            + Article.COLUMN_MODIFIED + " TEXT, "
            + Article.COLUMN_S_TOP + " INT, "
            + Article.COLUMN_S_UTAH + " INT, "
            + Article.COLUMN_S_SPORTS + " INT, "
            + Article.COLUMN_S_MONEY + " INT, "
            + Article.COLUMN_S_OPINION + " INT, "
            + Article.COLUMN_S_MIX + " INT, "
            + Article.COLUMN_S_POPULAR + " INT, "
            + Article.COLUMN_S_BAGLEY + " INT, "
            + Article.COLUMN_S_OBITS + " INT"
        + ");";

    //Will be used by the ArrayAdapter in the ListView
    @Override
    public String toString() { return this.title; }

}