Day 21 - Active Android

git clone https://github.com/pardom/ActiveAndroid.git

sudo apt-get install ant
ant

dependencies {
    compile fileTree(dir: 'libs', include: ['*.jar'])
}

dependencies {
    compile files('libs/ActiveAndroid.jar')
}

package com.devahoy.learn30androidlibraries.day21;

import android.app.Application;
import com.activeandroid.ActiveAndroid;

public class AAApplication extends Application {

    @Override
    public void onCreate() {
        super.onCreate();
        ActiveAndroid.initialize(this);
    }

    @Override
    public void onTerminate() {
        super.onTerminate();
        ActiveAndroid.dispose();
    }
}

<manifest ...>
    <application
        ...
        android:name=".AAApplication">

        ...

        <meta-data android:name="AA_DB_NAME" android:value="Devahoy-AA.db" />
        <meta-data android:name="AA_DB_VERSION" android:value="1" />

    </application>
</manifest>

package com.devahoy.learn30androidlibraries.day21;

import com.activeandroid.Model;
import com.activeandroid.annotation.Column;
import com.activeandroid.annotation.Table;

@Table(name = "Book")
public class Book extends Model{

    @Column(name = "title")
    public String title;

    @Column(name = "author")
    public String author;

    @Column(name = "publisher")
    public String publisher;

    @Column(name = "release_date")
    public String releaseDate;

}

package com.devahoy.learn30androidlibraries.day21;

import com.activeandroid.Model;
import com.activeandroid.annotation.Column;
import com.activeandroid.annotation.Table;

@Table(name = "Book")
public class Book extends Model{

    public Book() {
        super();
    }
    public Book(String title, String author, String publisher, String date) {
        super();
        this.title = title;
        this.author = author;
        this.publisher = publisher;
        this.releaseDate = date;
    }
}

Book book = new Book("A Song of Ice and Fire",
                "George R. R. Martin",
                "Bantam Books",
                "August 1996");
book.save();

 Select().from(Book.class).execute();

Select()
    .from(Book.class)
    .where("id = ?", String.valueOf(id))
    .executeSingle();
}

Book book = Book.load(Book.class, 1); // select * from Book where id = 1

Book book = Book.load(Book.class, 1);
book.title = "Another name";
book.save();

Book book = Book.load(Book.class, 1);
book.delete()

Book.delete(Book.class, 1);

new Delete().from(Book.class).where("Id = ?", 1).execute();

package com.devahoy.learn30androidlibraries.day21;

import android.app.ListActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

import com.activeandroid.ActiveAndroid;
import com.activeandroid.query.Delete;

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

public class ActiveAndroidActivity extends ListActivity {

    private List<Book> mBooks;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        initSampleData();
        mBooks = AAHelper.findBooks();

        StringBuilder builder = new StringBuilder();
        ArrayList<String> dataset = new ArrayList<String>();
        for (Book book : mBooks) {
            builder.setLength(0);
            builder.append("Name : " + book.title + "\n");
            builder.append("By   : " + book.author + "\n");
            builder.append("Publisher : " + book.publisher + "\n");
            builder.append("Release Date : " + book.releaseDate + "\n");
            dataset.add(builder.toString());
        }

        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,
                android.R.layout.simple_list_item_1, dataset);
        setListAdapter(adapter);
    }

    @Override
    protected void onListItemClick(ListView l, View v, int position, long id) {
        super.onListItemClick(l, v, position, id);
        Book book = AAHelper.findBookById(mBooks.get(position).getId());
        Toast.makeText(this, "You choose " + book.title, Toast.LENGTH_SHORT).show();
    }

    private void initSampleData() {
        new Delete().from(Book.class).execute();

        ActiveAndroid.beginTransaction();

        try {
            Book book1 = new Book("Android Cookbook",
                    "Ian F. Darwin",
                    "O'Reilly Media" ,
                    "April 2012");
            book1.save();

            Book book2 = new Book("Android Recipes, 3rd Edition",
                    "Dave Smith , Jeff Friesen",
                    "Apress",
                    "February 2014");
            book2.save();

            Book book3 = new Book("Expert Android",
                    "Satya Komatineni, Dave MacLean",
                    "Apress",
                    "July 2013");
            book3.save();

            Book book4 = new Book("50 Android Hacks",
                    "Carlos Sessa",
                    "Manning Publications",
                    "May 2013");
            book4.save();

            Book book5 = new Book("Learn Java for Android Development, 3rd Edition",
                    "Jeff Friesen",
                    "Apress",
                    "March 2014");
            book5.save();

            Book book6 = new Book("Learning Android, 2nd Edition",
                    "Marko Gargenta, Masumi Nakamura",
                    "O'Reilly Media, Inc.",
                    "January 2014");
            book6.save();
        } finally {
            ActiveAndroid.setTransactionSuccessful();
        }

        ActiveAndroid.endTransaction();
    }
}

package com.devahoy.learn30androidlibraries.day21;

import com.activeandroid.query.Select;
import java.util.List;

public class AAHelper {

    public static List<Book> findBooks() {
        return new Select()
                .from(Book.class)
                .execute();
    }

    public static Book findBookById(long id) {
        return new Select()
                .from(Book.class)
                .where("id = ?", String.valueOf(id))
                .executeSingle();
    }
}