package cn.com.basic.face.service.sqlite;

import android.database.Cursor;

import cn.com.basic.face.base.MainActivity;
import cn.com.basic.face.discern.entity.VisitTableSynchronRecord;

/**
 * 同步记录表dao
 * Created by SJW on 2017/7/25 0025.
 */

public class SynchronRecordDao {

    public static  SynchronRecordDao instance=new SynchronRecordDao();
    public static SynchronRecordDao getInstance(){
        return instance;
    }

    /***
     * 加载同步记录表
     * @param tableName   表名
     * @return
     */
    public VisitTableSynchronRecord  getSynRecord(String tableName){
        String sql="select * from visit_table_synchron_record where table_name='" + tableName + "'";
        VisitTableSynchronRecord record=null;
        Cursor c = MainActivity.getInstance().db.rawQuery(sql,new String[]{});
        if(c.moveToFirst()){
            record=new VisitTableSynchronRecord();
            record.setId(c.getString(c.getColumnIndex("id")));
            record.setSynchronTime(c.getString(c.getColumnIndex("synchron_time")));
            record.setTableName(tableName);
            return record;
        }
        return null;
    }

    /**
     * 更新记录
     * @param tableName 表名
     * @param synDate    最近一次同步时间
     */
    public void  updateSynRecord(String tableName, String  synDate){
        String sql="update visit_table_synchron_record set synchron_time="+"'"+synDate+"'"+" where table_name='" + tableName + "'";
        MainActivity.getInstance().db.execSQL(sql);
    }


    /**
     * 添加记录
     * @param tableName
     * @param synTime
     */
    public void insertSynRecord(String tableName,String synTime){
       String sql="insert into visit_table_synchron_record(id,table_name,synchron_time) values(null,'"+tableName+"','"+synTime+"')";
        MainActivity.getInstance().db.execSQL(sql);

    }
}