X-Git-Url: http://git.linex4red.de/pub/Android/ownCloud.git/blobdiff_plain/dc8c32fb3f7033d6fdfa7e1b64eaa77884da678a..231533c56e8873c6c77f6ff9f649c7b587ab5cce:/src/eu/alefzero/owncloud/db/DbHandler.java diff --git a/src/eu/alefzero/owncloud/db/DbHandler.java b/src/eu/alefzero/owncloud/db/DbHandler.java index d2e0b118..23b8bb6e 100644 --- a/src/eu/alefzero/owncloud/db/DbHandler.java +++ b/src/eu/alefzero/owncloud/db/DbHandler.java @@ -26,78 +26,61 @@ import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; -import android.util.Log; /** * Custom database helper for ownCloud + * * @author Bartek Przybylski - * + * */ public class DbHandler { - private SQLiteDatabase mDB; - private OpenerHepler mHelper; - private final String mDatabaseName = "ownCloud"; - private final String TABLE_SESSIONS = "sessions"; - private final int mDatabaseVersion = 1; - - public DbHandler(Context context) { - mHelper = new OpenerHepler(context); - mDB = mHelper.getWritableDatabase(); - } - - public Vector getSessionList() { - Cursor c = mDB.query(TABLE_SESSIONS, null, null, null, null, null, null); - Vector v = new Vector(); - if (!c.moveToFirst()) { - return v; - } - while (!c.isAfterLast()) { - v.add(new OwnCloudSession(c.getString(c.getColumnIndex("sessionName")), - c.getString(c.getColumnIndex("sessionUrl")), - c.getInt(c.getColumnIndex("_id")))); - c.moveToNext(); + private SQLiteDatabase mDB; + private OpenerHepler mHelper; + private final String mDatabaseName = "ownCloud"; + private final String TABLE_SESSIONS = "sessions"; + private final int mDatabaseVersion = 1; + + private final String TABLE_INSTANT_UPLOAD = "instant_upload"; + + public DbHandler(Context context) { + mHelper = new OpenerHepler(context); + mDB = mHelper.getWritableDatabase(); } - c.close(); - return v; - } - - public void addSession(String sessionName, String uri) { - ContentValues cv = new ContentValues(); - cv.put("sessionName", sessionName); - cv.put("sessionUrl", uri); - mDB.insert(TABLE_SESSIONS, null, cv); - } - - public void removeSessionWithId(int sessionId) { - mDB.delete(TABLE_SESSIONS, "_id = ?", new String[] {String.valueOf(sessionId)}); - } - public void changeSessionFields(int id, String hostname, String uri) { - ContentValues cv = new ContentValues(); - cv.put("sessionName", hostname); - cv.put("sessionUrl", uri); - mDB.update(TABLE_SESSIONS, cv, "_id = ?", new String[] {String.valueOf(id)}); - } - - public void close() { - mDB.close(); - } - - private class OpenerHepler extends SQLiteOpenHelper { - public OpenerHepler(Context context) { - super(context, mDatabaseName, null, mDatabaseVersion); + public void close() { + mDB.close(); } - @Override - public void onCreate(SQLiteDatabase db) { - db.execSQL("CREATE TABLE " + TABLE_SESSIONS + " (" + - " _id INTEGER PRIMARY KEY, " + - " sessionName TEXT, " + - " sessionUrl TEXT);"); + public boolean putFileForLater(String filepath, String account) { + ContentValues cv = new ContentValues(); + cv.put("path", filepath); + cv.put("account", account); + return mDB.insert(TABLE_INSTANT_UPLOAD, null, cv) != -1; } + + public Cursor getAwaitingFiles() { + return mDB.query(TABLE_INSTANT_UPLOAD, null, null, null, null, null, null); + } + + public void clearFiles() { + mDB.delete(TABLE_INSTANT_UPLOAD, null, null); + } + + private class OpenerHepler extends SQLiteOpenHelper { + public OpenerHepler(Context context) { + super(context, mDatabaseName, null, mDatabaseVersion); + } + + @Override + public void onCreate(SQLiteDatabase db) { + db.execSQL("CREATE TABLE " + TABLE_INSTANT_UPLOAD + " (" + + " _id INTEGET PRIMARY KEY, " + + " path TEXT," + + " account TEXT);"); + } - @Override - public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { + @Override + public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { + } } - } }