Initial commit

4 files changed, 263 insertions, 0 deletions

diff --git a/src/ryuslash/org/dvdroid/DVD.java b/src/ryuslash/org/dvdroid/DVD.java
new file mode 100644
index 0000000..eba0050
--- /dev/null
+++ b/src/ryuslash/org/dvdroid/DVD.java
@@ -0,0 +1,55 @@
+package ryuslash.org.dvdroid;
+
+public class DVD
+{
+    private long id;
+    private String title;
+    private int watched;
+    private int wishlist;
+
+    public long getId()
+    {
+        return id;
+    }
+
+    public void setId(long id)
+    {
+        this.id = id;
+    }
+
+    public String getTitle()
+    {
+        return title;
+    }
+
+    public void setTitle(String title)
+    {
+        this.title = title;
+    }
+
+    public int getWatched()
+    {
+        return watched;
+    }
+
+    public void setWatched(int watched)
+    {
+        this.watched = watched;
+    }
+
+    public int getWishlist()
+    {
+        return wishlist;
+    }
+
+    public void setWishlist(int wishlist)
+    {
+        this.wishlist = wishlist;
+    }
+
+    @Override
+    public String toString()
+    {
+        return title;
+    }
+}
diff --git a/src/ryuslash/org/dvdroid/DVDDataSource.java b/src/ryuslash/org/dvdroid/DVDDataSource.java
new file mode 100644
index 0000000..428ecc4
--- /dev/null
+++ b/src/ryuslash/org/dvdroid/DVDDataSource.java
@@ -0,0 +1,97 @@
+package ryuslash.org.dvdroid;
+
+import java.util.ArrayList;
+import java.util.List;
+
+import android.content.ContentValues;
+import android.content.Context;
+import android.database.Cursor;
+import android.database.SQLException;
+import android.database.sqlite.SQLiteDatabase;
+
+public class DVDDataSource
+{
+    private SQLiteDatabase database;
+    private SQLiteHelper dbHelper;
+    private String[] allColumns = { SQLiteHelper.COLUMN_ID,
+                                    SQLiteHelper.COLUMN_TITLE,
+                                    SQLiteHelper.COLUMN_WATCHED,
+                                    SQLiteHelper.COLUMN_WISHLIST };
+
+    public DVDDataSource(Context context)
+    {
+        dbHelper = new SQLiteHelper(context);
+    }
+
+    public void open() throws SQLException
+    {
+        database = dbHelper.getWritableDatabase();
+    }
+
+    public void close()
+    {
+        dbHelper.close();
+    }
+
+    public DVD createDVD(String title)
+    {
+        ContentValues values = new ContentValues();
+
+        values.put(SQLiteHelper.COLUMN_TITLE, title);
+        values.put(SQLiteHelper.COLUMN_WATCHED, 0);
+        values.put(SQLiteHelper.COLUMN_WISHLIST, 1);
+
+        long insertId = database.insert(SQLiteHelper.TABLE_DVD, null,
+                                        values);
+        Cursor cursor = database.query(SQLiteHelper.TABLE_DVD,
+                                       allColumns,
+                                       SQLiteHelper.COLUMN_ID + " = "
+                                       + insertId, null, null, null,
+                                       null);
+        cursor.moveToFirst();
+
+        DVD newDVD = cursorToDVD(cursor);
+
+        cursor.close();
+
+        return newDVD;
+    }
+
+    public void deleteDVD(DVD dvd)
+    {
+        long id = dvd.getId();
+        System.out.println("DVD deleted with id: " + id);
+        database.delete(SQLiteHelper.TABLE_DVD,
+                        SQLiteHelper.COLUMN_ID + " = " + id, null);
+    }
+
+    public List<DVD> getWishlist()
+    {
+        List<DVD> dvds = new ArrayList<DVD>();
+        Cursor cursor = database.query(SQLiteHelper.TABLE_DVD,
+                                       allColumns, "wishlist = 1", null,
+                                       null, null, "title");
+
+        cursor.moveToFirst();
+        while(!cursor.isAfterLast()) {
+            DVD dvd = cursorToDVD(cursor);
+            dvds.add(dvd);
+            cursor.moveToNext();
+        }
+
+        cursor.close();
+        return dvds;
+    }
+
+    private DVD cursorToDVD(Cursor cursor)
+    {
+        DVD dvd = new DVD();
+
+        dvd.setId(cursor.getLong(0));
+        dvd.setTitle(cursor.getString(1));
+        dvd.setWatched(cursor.getInt(2));
+        dvd.setWishlist(cursor.getInt(3));
+
+        return dvd;
+    }
+}
diff --git a/src/ryuslash/org/dvdroid/DVDroidActivity.java b/src/ryuslash/org/dvdroid/DVDroidActivity.java
new file mode 100644
index 0000000..20c1ad0
--- /dev/null
+++ b/src/ryuslash/org/dvdroid/DVDroidActivity.java
@@ -0,0 +1,64 @@
+package ryuslash.org.dvdroid;
+
+import java.util.List;
+
+import android.app.ListActivity;
+import android.content.Context;
+import android.os.Bundle;
+import android.view.View;
+import android.widget.ArrayAdapter;
+import android.widget.EditText;
+import android.widget.Toast;
+
+public class DVDroidActivity extends ListActivity
+{
+    private DVDDataSource datasource;
+
+    /** Called when the activity is first created. */
+    @Override
+    public void onCreate(Bundle savedInstanceState)
+    {
+        super.onCreate(savedInstanceState);
+        setContentView(R.layout.main);
+
+        datasource = new DVDDataSource(this);
+        datasource.open();
+
+        List<DVD> values = datasource.getWishlist();
+
+        ArrayAdapter<DVD> adapter =
+            new ArrayAdapter<DVD>(this,
+                                  android.R.layout.simple_list_item_1,
+                                  values);
+        setListAdapter(adapter);
+    }
+
+    public void addDVD(View view)
+    {
+        ArrayAdapter<DVD> adapter = (ArrayAdapter<DVD>)getListAdapter();
+        EditText editText = (EditText)findViewById(R.id.name_entry);
+        DVD dvd = datasource.createDVD(editText.getText().toString());
+        int duration = Toast.LENGTH_SHORT;
+        Toast toast = Toast.makeText(this, "Added " + editText.getText(),
+                                     duration);
+
+        editText.setText("");
+        adapter.add(dvd);
+        adapter.notifyDataSetChanged();
+        toast.show();
+    }
+
+    @Override
+    protected void onResume()
+    {
+        datasource.open();
+        super.onResume();
+    }
+
+    @Override
+    protected void onPause()
+    {
+        datasource.close();
+        super.onPause();
+    }
+}
diff --git a/src/ryuslash/org/dvdroid/SQLiteHelper.java b/src/ryuslash/org/dvdroid/SQLiteHelper.java
new file mode 100644
index 0000000..c2ec71e
--- /dev/null
+++ b/src/ryuslash/org/dvdroid/SQLiteHelper.java
@@ -0,0 +1,47 @@
+package ryuslash.org.dvdroid;
+
+import android.content.Context;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.util.Log;
+
+public class SQLiteHelper extends SQLiteOpenHelper
+{
+    public static final String TABLE_DVD = "dvd";
+    public static final String COLUMN_ID = "id";
+    public static final String COLUMN_TITLE = "title";
+    public static final String COLUMN_WATCHED = "watched";
+    public static final String COLUMN_WISHLIST = "wishlist";
+
+    private static final String DATABASE_NAME = "dvdroid.db";
+    private static final int DATABASE_VERSION = 1;
+
+    private static final String TABLE_DVD_CREATE =
+        "create table " + TABLE_DVD + " ("
+        + COLUMN_ID + " integer primary key autoincrement, "
+        + COLUMN_TITLE + " text not null, "
+        + COLUMN_WATCHED + " integer not null, "
+        + COLUMN_WISHLIST + " integer not null"
+        + ");";
+
+    public SQLiteHelper(Context context)
+    {
+        super(context, DATABASE_NAME, null, DATABASE_VERSION);
+    }
+
+    @Override
+    public void onCreate(SQLiteDatabase database)
+    {
+        database.execSQL(TABLE_DVD_CREATE);
+    }
+
+    @Override
+    public void onUpgrade(SQLiteDatabase db, int oldV, int newV)
+    {
+        Log.w(SQLiteHelper.class.getName(),
+              "Upgrading database from version " + oldV + " to "
+              + newV + ", whech will destroy all old data");
+        db.execSQL("DROP TABLE IF EXISTS " + TABLE_DVD);
+        onCreate(db);
+    }
+}