// ==================================================== // 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 sql_createList = new ArrayList(){{ //Create a new TABLE with these queries add(new SQLITECreateInfo("TABLE1_NAME", new ArrayList(){{ add("QUERY1"); add("QUERY2"); }})); //Create a new TABLE with these queries add(new SQLITECreateInfo("TABLE2_NAME", new ArrayList(){{ add("QUERY1"); add("QUERY2"); }})); }}; final List sql_upgradeList = new ArrayList(){{ //Run this queries when upgrade version 0 to 1 add(new SQLITEUpgradeInfo(0, 1, new ArrayList(){{ add("QUERY1"); add("QUERY2"); }})); //Run this queries when upgrade version 1 to 2 add(new SQLITEUpgradeInfo(1, 2, new ArrayList(){{ add("QUERY1"); add("QUERY2"); }})); }}; //SQLITESetting class. Parameters : (DB_NAME, VERSION, List, List) final SQLITESetting sql_setting = new SQLITESetting("DB_NAME", 1, sql_createList, sql_upgradeList); //Main initializer SQLITE sql = new SQLITE(CONTEXT, sql_setting); } }