import android.widget.FilterQueryProvider;
import android.widget.SimpleCursorAdapter;
+import net.ktnx.mobileledger.async.DescriptionSelectedCallback;
import net.ktnx.mobileledger.model.Data;
import org.jetbrains.annotations.NonNls;
public static synchronized SQLiteDatabase getDatabase(DatabaseMode mode) {
checkState();
+ SQLiteDatabase db;
+
if (mode == READ) {
if (helperForReading == null) helperForReading = new MobileLedgerDatabase(context);
- return helperForReading.getReadableDatabase();
+ db = helperForReading.getReadableDatabase();
}
else {
if (helperForWriting == null) helperForWriting = new MobileLedgerDatabase(context);
- return helperForWriting.getWritableDatabase();
+ db = helperForWriting.getWritableDatabase();
}
+
+ db.execSQL("pragma case_sensitive_like=ON;");
+ return db;
}
public static SQLiteDatabase getReadableDatabase() {
return getDatabase(READ);
final AutoCompleteTextView view,
final String table, final String field,
final boolean profileSpecific) {
- hookAutocompletionAdapter(context, view, table, field, profileSpecific, null);
+ hookAutocompletionAdapter(context, view, table, field, profileSpecific, null, null);
}
@TargetApi(Build.VERSION_CODES.N)
public static void hookAutocompletionAdapter(final Context context,
final AutoCompleteTextView view,
final String table, final String field,
final boolean profileSpecific,
- final View nextView) {
+ final View nextView,
+ final DescriptionSelectedCallback callback) {
String[] from = {field};
int[] to = {android.R.id.text1};
SimpleCursorAdapter adapter =
if (nextView != null) {
view.setOnItemClickListener((parent, itemView, position, id) -> {
nextView.requestFocus(View.FOCUS_FORWARD);
+ if (callback != null) {
+ callback.descriptionSelected(String.valueOf(view.getText()));
+ }
});
}
}
class MobileLedgerDatabase extends SQLiteOpenHelper implements AutoCloseable {
public static final String DB_NAME = "MoLe.db";
- public static final int LATEST_REVISION = 17;
+ public static final int LATEST_REVISION = 19;
private final Application mContext;