package com.sunvote.xpadapp.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import com.sunvote.xpadapp.ConstantValues;


/**
 * 数据库帮助类
 * Created by wutaian on 2017/06/01.
 */
public class DBLocalHelper extends SQLiteOpenHelper {
    private static final int VERSION = 1;
    private static final String NAME = "audition.db";
    private SQLiteDatabase db;
    public DBLocalHelper(Context context) {
        super(context, NAME, null, VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        //项目名称表
        db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_ITEM
                + "(ItemNum INTEGER,"+
                 "ItemName TEXT" + ")"); //项目名称

        //综合项目规则表
        db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_ITEM_RULE
                + " (ItemNum INTEGER," +
                    "Rule INTEGER , " + //规则编号从1开始
                    "RuleType INTEGER," +//3自定义评议、4自定义评分
                    "ItemName TEXT" +  ")");//项目名称

        //评分规则表
        db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_SCORE_RULE
                + " (ItemNum INTEGER," +
                "Unit TEXT , " + //评分单位
                "Min TEXT," +//最小值
                "Max TEXT," +//最大值
                "DefaultValue TEXT," +//默认值
                "IntNum INTEGER," +//整数位
                "DecNum INTEGER" +  ")");//小数位

        //评议规则表
        db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_EVALUATION_RULE
                + " (ItemNum INTEGER," +
                "DefaultValue TEXT," + //默认值
                "ItemName TEXT" + ")");//名称

        //评分规则说明表
        db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_SCORERULE_EXPLAIN
                + "(ItemNum INTEGER," +
                  "ScoreExplain TEXT" +  ")");//项目描述

        //历史记录
        db.execSQL("CREATE TABLE IF NOT EXISTS " + ConstantValues.TBL_SCORE_HISTORY
                + " (CandidateNo TEXT NOT NULL, " + //考生编号
                "GroupNo INTEGER," +//分组编号
                "CourseNo TEXT , " + //科目编号
                "ItemNo INTEGER , " + //项编号
                "Score TEXT , " + //评分
                "Remark TEXT , " + //备注项
                "HistoryType TEXT , " + //历史记录表类型 1:单人单项历史记录 2:单人多项历史记录 3:多人单项历史记录 4:多人单项table历史记录 5:多人多项历史记录
                "PRIMARY KEY(GroupNo,CourseNo,ItemNo,HistoryType)"+ ")");

        /**
         * 默认评分规则
         */
        db.execSQL("INSERT INTO " + ConstantValues.TBL_SCORE_RULE + " VALUES ("+
                "'"+ConstantValues.DefalutScoreRuleId +"'," +
                "'r'," +
                "'0'," +
                "'100'," +
                "'0'," +
                "'3'," +
                "'0'" +
                ")");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}