package com.mycoolweather.app.db;

import java.util.ArrayList;
import java.util.List;

import com.mycoolweather.app.model.City;
import com.mycoolweather.app.model.County;
import com.mycoolweather.app.model.Province;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class MyCoolWeatherDB {
	/**
	* Êý¾Ý¿âÃû
	*/
	public final String DB_NAME="My_cool_weather";
	/**
	* Êý¾Ý°æ±¾
	*/
	public static final int VERSION=1;
	private static MyCoolWeatherDB myCoolWeatherDB;
	private SQLiteDatabase db;
	/**
	* ½«¹¹Ôì·½·¨Ë½ÓÐ»¯
	*/
	private MyCoolWeatherDB(Context context){
		MyCoolWeatherOpenHelper dbHelper=new MyCoolWeatherOpenHelper//
				(context, DB_NAME, null, VERSION);
		db=dbHelper.getWritableDatabase();
	}
	/**
	* »ñÈ¡MyCoolWeatherDBµÄÊµÀý¡£
	*/
	public synchronized static MyCoolWeatherDB getInstance(Context context){
		if(myCoolWeatherDB==null){
			myCoolWeatherDB=new MyCoolWeatherDB(context);
		}
		return myCoolWeatherDB;
		
	}
	/**
	* ½«ProvinceÊµÀý´æ´¢µ½Êý¾Ý¿â¡£
	*/
	public void saveProvince(Province province){
		if(province!=null){
			ContentValues values=new ContentValues();
			values.put("province_name", province.getProvinceName());
			values.put("province_code", province.getProvinceCode());
			db.insert("Province", null, values);
		}
	}
	/**
	* ´ÓÊý¾Ý¿â¶ÁÈ¡È«¹úËùÓÐµÄÊ¡·ÝÐÅÏ¢¡£
	*/
	public List<Province> loadProvince(){
		List<Province> list=new ArrayList<Province>();
		
		Cursor cursor=db.query("Province", null, null, null, null, null, null);
		if(cursor.moveToFirst()){
			do{
				Province province=new Province();
				province.setId(cursor.getInt(cursor.getColumnIndex("id")));
				province.setProvinceName(cursor.getString(cursor.getColumnIndex("province_name")));
				province.setProvinceCode(cursor.getString(cursor.getColumnIndex("province_code")));
				list.add(province);
			}while(cursor.moveToNext());
		}
		return list;
	}
	/**
	* ½«CityÊµÀý´æ´¢µ½Êý¾Ý¿â¡£
	*/
	public void saveCity(City city){
		if(city!=null){
			ContentValues values=new ContentValues();
			values.put("City_name", city.getCityName());
			values.put("City_code", city.getCityCode());
			values.put("province_id", city.getProvinceId());
			db.insert("City", null, values);
		}
	}
	/**
	* ´ÓÊý¾Ý¿â¶ÁÈ¡Ä³Ê¡ÏÂËùÓÐµÄ³ÇÊÐÐÅÏ¢¡£
	*/
	public List<City> loadCities(int provinceId){
		List<City> list=new ArrayList<City>();
		Cursor cursor=db.query("City", null, "province_id=?", //
				new String[]{String.valueOf(provinceId)}, null, null, null);
		if(cursor.moveToFirst()){
			do{City city=new City();
			city.setId(cursor.getInt(cursor.getColumnIndex("id")));
			city.setCityName(cursor.getString(cursor.getColumnIndex("city_name")));
			city.setCityCode(cursor.getString(cursor.getColumnIndex("city_code")));
			city.setProvinceId(provinceId);
			list.add(city);
				
			}while(cursor.moveToNext());
		}
		return list;
		
	}
	/**
	* ½«CountyÊµÀý´æ´¢µ½Êý¾Ý¿â¡£
	*/
	public void saveCounty(County county){
		if(county!=null){
			ContentValues values=new ContentValues();
			values.put("county_name", county.getCountyName());
			values.put("county_code", county.getCountyCode());
			values.put("city_id", county.getCityId());
			db.insert("County", null, values);
		}
	}
	/**
	* ´ÓÊý¾Ý¿â¶ÁÈ¡Ä³³ÇÊÐÏÂËùÓÐµÄÏØÐÅÏ¢¡£
	*/
	public List<County> loadCounties(int cityId){
		List<County> list=new ArrayList<County>();
		Cursor cursor=db.query("County", null, "city_id=?",//
				new String[]{String.valueOf(cityId)}, null, null, null);
		if(cursor.moveToFirst()){
			do{
				County county=new County();
				county.setId(cursor.getInt(cursor.getColumnIndex("id")));
				county.setCountyName(cursor.getString(cursor.getColumnIndex("county_name")));
				county.setCountyCode(cursor.getString(cursor.getColumnIndex("county_code")));
				county.setCityId(cityId);
				list.add(county);
			
		}while(cursor.moveToNext());
		}
		return list;	
}
	
}
