1 files changed, 203 insertions, 0 deletions
diff --git a/src/main/java/de/thedevstack/conversationsplus/persistance/db/access/CursorHelper.java b/src/main/java/de/thedevstack/conversationsplus/persistance/db/access/CursorHelper.java
new file mode 100644
index 00000000..122e5160
--- /dev/null
+++ b/src/main/java/de/thedevstack/conversationsplus/persistance/db/access/CursorHelper.java
@@ -0,0 +1,203 @@
+package de.thedevstack.conversationsplus.persistance.db.access;
+
+import android.database.Cursor;
+
+/**
+ * Created by steckbrief on 15.04.2016.
+ */
+public abstract class CursorHelper {
+
+    public static double getDouble(Cursor cursor, String columnName) {
+        if (null == cursor) {
+            return Double.MIN_VALUE;
+        }
+        int columnIndex = getColumnIndex(cursor, columnName);
+        if (columnIndex < 0) {
+            return Double.MIN_VALUE;
+        }
+        return getDouble(cursor, columnIndex);
+    }
+
+    public static String getString(Cursor cursor, String columnName) {
+        if (null == cursor) {
+            return null;
+        }
+        int columnIndex = getColumnIndex(cursor, columnName);
+        if (columnIndex < 0) {
+            return null;
+        }
+        return getString(cursor, columnIndex);
+    }
+
+    public static float getFloat(Cursor cursor, String columnName) {
+        if (null == cursor) {
+            return Float.MIN_VALUE;
+        }
+        int columnIndex = getColumnIndex(cursor, columnName);
+        if (columnIndex < 0) {
+            return Float.MIN_VALUE;
+        }
+        return getFloat(cursor, columnIndex);
+    }
+
+    public static int getInt(Cursor cursor, String columnName) {
+        if (null == cursor) {
+            return Integer.MIN_VALUE;
+        }
+        int columnIndex = getColumnIndex(cursor, columnName);
+        if (columnIndex < 0) {
+            return Integer.MIN_VALUE;
+        }
+        return getInt(cursor, columnIndex);
+    }
+
+    public static long getLong(Cursor cursor, String columnName) {
+        if (null == cursor) {
+            return Long.MIN_VALUE;
+        }
+        int columnIndex = getColumnIndex(cursor, columnName);
+        if (columnIndex < 0) {
+            return Long.MIN_VALUE;
+        }
+        return getLong(cursor, columnIndex);
+    }
+
+    public static int getShort(Cursor cursor, String columnName) {
+        if (null == cursor) {
+            return Short.MIN_VALUE;
+        }
+        int columnIndex = getColumnIndex(cursor, columnName);
+        if (columnIndex < 0) {
+            return Short.MIN_VALUE;
+        }
+        return getShort(cursor, columnIndex);
+    }
+
+    public static byte[] getBlob(Cursor cursor, String columnName) {
+        if (null == cursor) {
+            return null;
+        }
+        int columnIndex = getColumnIndex(cursor, columnName);
+        if (columnIndex < 0) {
+            return null;
+        }
+        return getBlob(cursor, columnIndex);
+    }
+
+    /**
+     * Returns the zero-based index for the given column name, or -1 if the column doesn't exist.
+     * If you expect the column to exist use {@link Cursor#getColumnIndexOrThrow(String)} instead, which
+     * will make the error more clear.
+     *
+     * @param columnName the name of the target column.
+     * @return the zero-based column index for the given column name, or -1 if
+     * the column name does not exist.
+     * @see Cursor#getColumnIndexOrThrow(String)
+     */
+    public static int getColumnIndex(Cursor cursor, String columnName) {
+        return cursor.getColumnIndex(columnName);
+    }
+
+    /**
+     * Returns the value of the requested column as a byte array.
+     *
+     * <p>The result and whether this method throws an exception when the
+     * column value is null or the column type is not a blob type is
+     * implementation-defined.
+     *
+     * @param columnIndex the zero-based index of the target column.
+     * @return the value of that column as a byte array.
+     */
+    public static byte[] getBlob(Cursor cursor, int columnIndex) {
+        return cursor.getBlob(columnIndex);
+    }
+
+    /**
+     * Returns the value of the requested column as a String.
+     *
+     * <p>The result and whether this method throws an exception when the
+     * column value is null or the column type is not a string type is
+     * implementation-defined.
+     *
+     * @param columnIndex the zero-based index of the target column.
+     * @return the value of that column as a String.
+     */
+    public static String getString(Cursor cursor, int columnIndex) {
+        return cursor.getString(columnIndex);
+    }
+
+    /**
+     * Returns the value of the requested column as a short.
+     *
+     * <p>The result and whether this method throws an exception when the
+     * column value is null, the column type is not an integral type, or the
+     * integer value is outside the range [<code>Short.MIN_VALUE</code>,
+     * <code>Short.MAX_VALUE</code>] is implementation-defined.
+     *
+     * @param columnIndex the zero-based index of the target column.
+     * @return the value of that column as a short.
+     */
+    public static short getShort(Cursor cursor, int columnIndex) {
+        return cursor.getShort(columnIndex);
+    }
+
+    /**
+     * Returns the value of the requested column as an int.
+     *
+     * <p>The result and whether this method throws an exception when the
+     * column value is null, the column type is not an integral type, or the
+     * integer value is outside the range [<code>Integer.MIN_VALUE</code>,
+     * <code>Integer.MAX_VALUE</code>] is implementation-defined.
+     *
+     * @param columnIndex the zero-based index of the target column.
+     * @return the value of that column as an int.
+     */
+    public static int getInt(Cursor cursor, int columnIndex) {
+        return cursor.getInt(columnIndex);
+    }
+
+    /**
+     * Returns the value of the requested column as a long.
+     *
+     * <p>The result and whether this method throws an exception when the
+     * column value is null, the column type is not an integral type, or the
+     * integer value is outside the range [<code>Long.MIN_VALUE</code>,
+     * <code>Long.MAX_VALUE</code>] is implementation-defined.
+     *
+     * @param columnIndex the zero-based index of the target column.
+     * @return the value of that column as a long.
+     */
+    public static long getLong(Cursor cursor, int columnIndex) {
+        return cursor.getLong(columnIndex);
+    }
+
+    /**
+     * Returns the value of the requested column as a float.
+     *
+     * <p>The result and whether this method throws an exception when the
+     * column value is null, the column type is not a floating-point type, or the
+     * floating-point value is not representable as a <code>float</code> value is
+     * implementation-defined.
+     *
+     * @param columnIndex the zero-based index of the target column.
+     * @return the value of that column as a float.
+     */
+    public static float getFloat(Cursor cursor, int columnIndex) {
+        return cursor.getFloat(columnIndex);
+    }
+
+    /**
+     * Returns the value of the requested column as a double.
+     *
+     * <p>The result and whether this method throws an exception when the
+     * column value is null, the column type is not a floating-point type, or the
+     * floating-point value is not representable as a <code>double</code> value is
+     * implementation-defined.
+     *
+     * @param columnIndex the zero-based index of the target column.
+     * @return the value of that column as a double.
+     */
+    public static double getDouble(Cursor cursor, int columnIndex) {
+        return cursor.getDouble(columnIndex);
+    }
+}