package com.bell.testgreendao;

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.User;
import com.bell.testgreendao.util.db.util.UserDaoUtil;

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

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

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

        dbUtil = new UserDaoUtil(UserActivity.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).setVisibility(View.GONE);
    }


    @Override
    public void onClick(View v) {
        switch (v.getId()){
            case R.id.insert_btn:
                Log.e(TAG, "insert result: " + dbUtil.insertUser(new User(null, "name1", 18, "rr")));
                break;

            case R.id.insert_multi_btn:
                List<User> list = new ArrayList<>();
                list.add(new User(null, "name1", 18, "rr"));
                list.add(new User(null, "name2", 19, "rr"));
                list.add(new User(null, "name3", 20, "rr"));
                list.add(new User(null, "name4", 21, "rr"));
                list.add(new User(null, "name5", 22, "rr"));
                Log.e(TAG, "insert multi result: " + dbUtil.insertMultUser(list));
                break;

            case R.id.update_btn:
                User mei = new User();
                mei.set_id(4l);
                mei.setName("Google");
                mei.setMobile("1380000000");
                Log.e(TAG, "update result: " + dbUtil.updateUser(mei));
                break;

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

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

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

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

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

                break;
        }
    }

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