package cn.com.basic.face.util;

import android.database.sqlite.SQLiteConstraintException;

import java.util.List;

import cn.com.basic.face.base.MainActivity;
import cn.com.basic.face.discern.common.SqliteSqlBean;

public class SqliteSqlUtil {

    public static void insert(List<SqliteSqlBean> sqliteSqlBeenList) {
        if (sqliteSqlBeenList == null) {
            return;
        }
        SqliteSqlBean sqliteSqlBean = null;
        for (int i = 0; i < sqliteSqlBeenList.size(); i++) {
            try {
                sqliteSqlBean = sqliteSqlBeenList.get(i);
                System.out.println(sqliteSqlBean.getInsertSql());
                MainActivity.getInstance().db.execSQL(sqliteSqlBean.getInsertSql());

            } catch (Exception e) {
                if (e instanceof SQLiteConstraintException) {
                    System.out.println(e.getMessage());
                    return;
                }
                if (sqliteSqlBean != null) {
                    String sql = sqliteSqlBean.getInsertSql();
                }
                e.printStackTrace();
            }
        }
    }

}