// ====================================================
// EasySQLITE Copyright(C) 2017 EasySQLITE
// This program comes with ABSOLUTELY NO WARRANTY; This is free software, 
// and you are welcome to redistribute it under certain conditions; See 
// file LICENSE, which is part of this source code package, for details.
// ====================================================

package com.dentrax.easysqlite.examples;

import com.dentrax.easysqlite.source.SQLITE;
import com.dentrax.easysqlite.source.SQLITECreateInfo;
import com.dentrax.easysqlite.source.SQLITESetting;
import com.dentrax.easysqlite.source.SQLITEUpgradeInfo;

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

import static com.dentrax.easysqlite.MainActivity.CONTEXT;

/**
 * Created by Furkan on 11/09/2013.
 */

public final class Example1 {

    public Example1(){

        final List<SQLITECreateInfo> sql_createList = new ArrayList<SQLITECreateInfo>(){{
            //Create a new TABLE with these queries
            add(new SQLITECreateInfo("TABLE1_NAME", new ArrayList<String>(){{
                add("QUERY1");
                add("QUERY2");
            }}));

            //Create a new TABLE with these queries
            add(new SQLITECreateInfo("TABLE2_NAME", new ArrayList<String>(){{
                add("QUERY1");
                add("QUERY2");
            }}));
        }};

        final List<SQLITEUpgradeInfo> sql_upgradeList = new ArrayList<SQLITEUpgradeInfo>(){{
            //Run this queries when upgrade version 0 to 1
            add(new SQLITEUpgradeInfo(0, 1, new ArrayList<String>(){{
                add("QUERY1");
                add("QUERY2");
            }}));

            //Run this queries when upgrade version 1 to 2
            add(new SQLITEUpgradeInfo(1, 2, new ArrayList<String>(){{
                add("QUERY1");
                add("QUERY2");
            }}));
        }};

        //SQLITESetting class. Parameters : (DB_NAME, VERSION, List<SQLITECreateInfo>, List<SQLITEUpgradeInfo>)
        final SQLITESetting sql_setting = new SQLITESetting("DB_NAME", 1, sql_createList, sql_upgradeList);

        //Main initializer
        SQLITE sql = new SQLITE(CONTEXT, sql_setting);
    }
}