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; }
	
}