After Deleting folder programmatically which contain Database , when next time Insert query called , It's returning -1.I think solution is creating database again by calling database constructor.But i don't know how to doing it inside Fragment.
Data Base Class:
public class SQliteHelperClass extends SQLiteOpenHelper {
public static final String Dabase_name= "UserRecord.db";
public static final String Table_name= "RTable";
public static final String col_0= "Id";
public static final String col_1= "KM";
public static final String col_2= "MDATE";
public static final String col_3= "MTIME";
public static final String col_4= "MDIFFER";
public SQliteHelperClass(Context context) {
super(context, Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOWNLOADS)
+ File.separator+"MyCarData"
+ File.separator + Dabase_name, null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE "+ Table_name +"(Id INTEGER PRIMARY KEY AUTOINCREMENT, KM INTEGER, MDATE TEXT, MTIME TEXT , MDIFFER INTEGER) ");
}
public boolean insertData(KmDataModel kmDataModel) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(col_0,kmDataModel.getId());
contentValues.put(col_1,kmDataModel.getKm());
contentValues.put(col_2,kmDataModel.getDate());
contentValues.put(col_3,kmDataModel.getTime());
contentValues.put(col_4,kmDataModel.getDffKm());
long result =db.insert(Table_name,null,contentValues);
if(result == -1){
return false;
}else{
return true;
}
}
}
Delete method which call for deleting Contain of specific folder:
public void DeleteDataFolder(){
File dir = new File(Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOWNLOADS)
+ File.separator+"MyCarData"
+ File.separator);
if (dir.isDirectory())
{
String[] children = dir.list();
for (int i = 0; i < children.length; i++)
{
Log.e("File_List",children[i]);
new File(dir, children[i]).delete();
}
}
}
Note that if I close app and start it again then database working fine, so i was calling method which is force app to close but i don't want to close the app.
