commit static method

dynamic commit()

Implementation

static commit() async {
  try {
    Batch batch = CrazyDB.db.batch();
    for (String sql in CrazyDB._transactionSqlList) {
      String headAction = sql.substring(0,sql.indexOf(" "));
      if(headAction == "update"){
        batch.rawUpdate(sql);
      }else if(headAction == "insert"){
        batch.rawInsert(sql);
      }else if(headAction == "delete"){
        batch.rawDelete(sql);
      }
    }
    await batch.commit(noResult: true);
    CrazyDB.rollback();
  } catch (e) {
    debugPrint("${CrazyDB._tag} Exception=> $e");
    throw Exception(e);
  }
}