package com.myproject.fla;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.util.Log;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.Toast;

public class MainActivity extends Activity {

    private SQLiteDatabase db;
    private Cursor cursor;
    CustomCursorAdapter listAdapter;

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

        SQLiteOpenHelper databaseHelper = new DatabaseHelper(this);
        ListView listView = (ListView) findViewById(R.id.listView_records);

        try {

            db = databaseHelper.getReadableDatabase();


            cursor = db.query("record", new String[]{"KEY_ID", "KEY_DATE", "KEY_TIME", "KEY_STAFF", "KEY_ANIMAL", "KEY_ACTIVITY", "KEY_DETAIL"}, null, null, null, null, null);

            //cursor = db.query("RECORD", new String[]{"_id", "NAME", "TYPE", "DESCRIPTION"}, null, null, null, null, "_id DESC");
            //cursor = db.query("RECORD", new String[]{"_id", "NAME", "TYPE", "DESCRIPTION"}, null, null, null, null, "NAME ASC");

            //cursor = db.query("RECORD", new String[]{"_id", "NAME", "TYPE", "DESCRIPTION"}, "TYPE = ?", new String[] {"Droid"}, null, null, null);
            //cursor = db.query("RECORD", new String[]{"_id", "NAME", "TYPE", "DESCRIPTION"}, "TYPE = ? OR TYPE = ?", new String[] {"Droid", "Location"}, null, null, null);
            //cursor = db.query("RECORD", new String[]{"_id", "NAME", "TYPE", "DESCRIPTION"}, "_id = ?", new String[] {Integer.toString(3)}, null, null, null);

            listAdapter = new CustomCursorAdapter(this, cursor, 0);

            listView.setAdapter(listAdapter);

        } catch(SQLiteException e) {
            Toast.makeText(this, "Database unavailable", Toast.LENGTH_SHORT).show();
        }

        //Log.i(">>> Activity_main", "Cursor size=" + Integer.toString(cursor.getCount()));
        Log.i(">>> Activity_main", "Database records:" + DatabaseHelper.getDatabaseContentsAsString(db));
    }

    @Override
    protected void onDestroy() {
        super.onDestroy();

        if(cursor != null) cursor.close();
        if(db != null) db.close();
    }

}