package com.bell.testgreendao;

import android.content.Intent;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;
import android.view.View;

import com.bell.testgreendao.util.db.entity.Mei;
import com.bell.testgreendao.util.db.util.MeiDaoUtil;

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

public class MainActivity extends AppCompatActivity implements View.OnClickListener {
    private String TAG = getClass().getSimpleName();
    private MeiDaoUtil dbUtil;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        dbUtil = new MeiDaoUtil(MainActivity.this);

        findViewById(R.id.insert_btn).setOnClickListener(this);
        findViewById(R.id.insert_multi_btn).setOnClickListener(this);
        findViewById(R.id.update_btn).setOnClickListener(this);
        findViewById(R.id.delete_btn).setOnClickListener(this);
        findViewById(R.id.delete_all_btn).setOnClickListener(this);
        findViewById(R.id.query_btn).setOnClickListener(this);
        findViewById(R.id.query_all_btn).setOnClickListener(this);
        findViewById(R.id.query_native_btn).setOnClickListener(this);
        findViewById(R.id.user_btn).setOnClickListener(this);
    }


    @Override
    public void onClick(View v) {
        switch (v.getId()){
            case R.id.insert_btn:
                Log.e(TAG, "insert result: " + dbUtil.insertMei(new Mei(null, "Google", "http://1111.jpg", "rr", "2017")));
                break;

            case R.id.insert_multi_btn:
                List<Mei> list = new ArrayList<>();
                list.add(new Mei(null, "BaiDu", "http://bbbbbbb", "rr", "2017"));
                list.add(new Mei(null, "163", "http://163163", "rr", "2017"));
                list.add(new Mei(null, "sohu", "http://ssssss", "rr", "2017"));
                list.add(new Mei(null, "sina", "http://aaaaaa", "rr", "2017"));
                list.add(new Mei(null, "ali", "http://iiiiiii", "rr", "2017"));
                Log.e(TAG, "insert multi result: " + dbUtil.insertMultMei(list));
                break;

            case R.id.update_btn:
                Mei mei = new Mei();
                mei.set_id(4l);
                mei.setSource("Google");
                mei.setUrl("http://44444");
                Log.e(TAG, "update result: " + dbUtil.updateMei(mei));
                break;

            case R.id.delete_btn:
                Mei dMei = new Mei();
                dMei.set_id(6l);
                Log.e(TAG, "deleter result: " + dbUtil.deleteMei(dMei));
                break;

            case R.id.delete_all_btn:
                Log.e(TAG, "deleter all result: " + dbUtil.deleteAll());
                break;

            case R.id.query_btn:
                Mei qMei = dbUtil.queryMeiById(5);
                if (null != qMei) {
                    Log.e(TAG, "query result: " + qMei.toString());
                }
                break;

            case R.id.query_all_btn:
                List<Mei> meiList = dbUtil.queryAllMei();
                if (null != meiList) {
                    for (Mei m : meiList) {
                        Log.e(TAG, "query all result: " + m.toString());
                    }
                }
                break;

            case R.id.query_native_btn:
                List<Mei> mList = dbUtil.queryMeiByNativeSQL("where url like ?", new String[]{"%aa%"});
                if (null != mList) {
                    for (Mei m : mList) {
                        Log.e(TAG, "query native result: " + m.toString());
                    }
                }

                break;

            case R.id.user_btn:
                Intent intent = new Intent(MainActivity.this, UserActivity.class);
                startActivity(intent);
                break;
        }
    }

    @Override
    protected void onDestroy() {
        dbUtil.closeDao();
        super.onDestroy();
    }
}