Android Open Source - android-davsync Dav Sync Open Helper

• Back to Development/tool  ↑

From Project

Back to project page android-davsync.

License

The source code is released under:

Copyright ? 2013, Michael Stapelberg and contributors All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following ...

Java Source Code

package net.zekjur.davsync;
//from ww  w.  java 2 s  .  co  m
import java.util.ArrayList;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.net.Uri;

public class DavSyncOpenHelper extends SQLiteOpenHelper {
  private static final String DATABASE_NAME = "davsync";
  private static final int DATABASE_VERSION = 1;

  public DavSyncOpenHelper(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE IF NOT EXISTS sync_queue (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, uri STRING NOT NULL, not_before DATETIME, uploading BOOLEAN DEFAULT 0);");
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  }

  /*
   * Returns an ArrayList of Uris which are queued and not already being
   * uploaded. Also marks all of them as being uploaded so that duplicate
   * network change events dont upload the same Uris a lot of times.
   */
  public ArrayList<String> getQueuedUris() {
    ArrayList<String> result = new ArrayList<String>();
    SQLiteDatabase database = getWritableDatabase();
    database.beginTransaction();
    try {
      Cursor cursor = database.rawQuery("SELECT uri FROM sync_queue WHERE NOT uploading", null);
      if (cursor.moveToFirst()) {
        do {
          result.add(cursor.getString(0));
        } while (cursor.moveToNext());
      }

      if (cursor != null && !cursor.isClosed())
        cursor.close();

      database.execSQL("UPDATE sync_queue SET uploading = 1");

      database.setTransactionSuccessful();
    } finally {
      database.endTransaction();
    }
    return result;
  }

  public void queueUri(Uri uri) {
    SQLiteDatabase database = getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put("uri", uri.toString());
    database.insertOrThrow("sync_queue", null, values);
  }

  public void removeUriFromQueue(String uri) {
    SQLiteDatabase database = getWritableDatabase();
    database.delete("sync_queue", "uri = ?", new String[] { uri });
  }
}

Java Source Code List

• Back to Development/tool  ↑