package com.demo.doanandroid.database;

import android.util.Log;

import com.raizlabs.android.dbflow.sql.language.Insert;
import com.raizlabs.android.dbflow.sql.language.SQLite;
import com.raizlabs.android.dbflow.structure.AsyncModel;
import com.raizlabs.android.dbflow.structure.Model;

import java.util.List;

/**
 * Created by ThongLe on 5/6/2016.
 */
public class ExeDatabase {

    public void saveUser(UserModel userModel) {
        Insert<UserModel> insertQuery = SQLite
                .insert(UserModel.class)
                .columnValues(
                        UserModel_Table.name.eq(userModel.getName()),
                        UserModel_Table.password.eq(userModel.getPassword()),
                        UserModel_Table.tokenUser.eq(userModel.getTokenUser()));
        insertQuery.execute();
    }

    public void saveNews(NewsModel newsModel) {
        Insert<NewsModel> insertQuery = SQLite
                .insert(NewsModel.class)
                .columnValues(
                        NewsModel_Table.title.eq(newsModel.getTitle()),
                        NewsModel_Table.content.eq(newsModel.getContent()),
                        NewsModel_Table.date.eq(newsModel.getDate()),
                        NewsModel_Table.tokenUser.eq(newsModel.getTokenUser()));
        insertQuery.execute();
    }

    public void removeNews(NewsModel newsModel) {
        newsModel.delete();
    }

    public void updateNews(NewsModel newsModel) {
        NewsModel dbModel = new NewsModel(newsModel.getTitle(), newsModel.getContent(), newsModel.getDate(),newsModel.getTokenUser());
        dbModel.setId(newsModel.getId());
        dbModel.async().withListener(new AsyncModel.OnModelChangedListener() {
            @Override
            public void onModelChanged(Model model) {
                Log.d("PassedUpdate","Success");
            }
        }).update();
    }

    public List<NewsModel> loadNewsDatabase(String tokenUser) {
        return SQLite
                .select()
                .from(NewsModel.class)
                .where((NewsModel_Table.tokenUser).is(tokenUser))
                .queryList();
    }

    public List<NewsModel> loadNewsDatabaseNoSignin() {
        return SQLite
                .select()
                .from(NewsModel.class)
                .queryList();
    }

    public UserModel checkUserLogin(UserModel userModel) {
        return SQLite
                .select()
                .from(UserModel.class)
                .where((UserModel_Table.name).is(userModel.getName()))
                .and((UserModel_Table.password).is(userModel.getPassword()))
                .querySingle();
    }


}