package com.example.testsql;


import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class Database{
	
	private final SQLiteOpenHelper _help;
	/**/
	public Database(Context context){
		//_help = new HamburgerHelper(context);
		_help = new SQLiteOpenHelper(context, "hamburger", null, 1){
			public void onCreate(SQLiteDatabase db) {
		        db.execSQL("CREATE TABLE hamburger(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(32) NOT NULL);");
			}
			public void onUpgrade(SQLiteDatabase db, 
								  int oldVersion,
								  int newVersion) {
		        db.execSQL("DROP TABLE IF EXISTS hamburger;");
		        onCreate(db);
			}
		};
	}
	
	public Cursor read(){
		return _help.getReadableDatabase().rawQuery("SELECT * FROM hamburger", null);
	}
	
	public void add(String name){
		_help.getWritableDatabase().execSQL("INSERT INTO hamburger (name) VALUES ('"+name+"');");
	}

}