title: I can't insert data to SQLite and can't see my table
body: <p>I can't insert data to SQLite and can't see my table.<br>
  I try to see the table in DB Browser for SQLite, but I can't see anything inserted and also can't see the rows I created.</p>
  
  <p>here insert method from DataBaseHelper:</p>
  
  <pre><code>//Adding new trainee
  public void addTrainee(Trainee trainee) {
      SQLiteDatabase db = this.getWritableDatabase();
  
      ContentValues values = new ContentValues();
  
      int count = getShopsCount();
  
      values.put(COL_ID, 1);
      values.put(COL_USERNAME, trainee.getUsername());
      values.put(COL_NAME, trainee.getName());
      values.put(COL_PASS, trainee.getPassword());
      values.put(COL_EMAIL, trainee.getEmail());
  
      // Inserting Row
      db.insert(TABLE_NAME, null, values);
      db.close();// Closing database connection
  }
  
  // Getting shops Count
  public int getShopsCount() {
      String countQuery = "SELECT  * FROM " + TABLE_NAME;
      SQLiteDatabase db = this.getReadableDatabase();
      Cursor cursor = db.rawQuery(countQuery, null);
      cursor.close();
      // return count
      return cursor.getCount();
  }
  </code></pre>
  
  <p>here insert registration from main activity:</p>
  
  <pre><code>public void confirminput(View v) {
      //If one of the validate retuen false the validation faild.
      if (  !validateEmail() || !validateUsername() || !validateName() || !validatePassword()) {
          Toast.makeText(getApplicationContext(), " Validation NOT OK", Toast.LENGTH_LONG).show();
          return;
      }
  
      //Inserting Trainee.
      Trainee trainee = new Trainee();
      trainee.setUsername(textInputUsername.getEditText().getText().toString().trim();
      trainee.setName(textInputName.getEditText().getText().toString().trim());
      trainee.setEmail(textInputEmail.getEditText().getText().toString().trim());
      trainee.setPassword(textInputPassword.getEditText().getText().toString().trim();
  
      //Insert Method data .
      myDb.addTrainee(trainee);
  
  
  }
  </code></pre>
  
  <p>onCreate():</p>
  
  <pre><code>//onCreat
  @Override
  public void onCreate(SQLiteDatabase db) {
  
      String CREATE_CONTACTS_TABLE = "CREATE TABLE "+ TABLE_NAME + "("
              + COL_ID + " INTEGER PRIMARY KEY," + COL_USERNAME + " TEXT,"
              + COL_NAME  + " TEXT," + COL_PASS + " TEXT," +COL_EMAIL + " TEXT" + ")";
      db.execSQL(CREATE_CONTACTS_TABLE);
      this.db = db;
  }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/1Xgm5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1Xgm5.png" alt="enter image description here"></a></p>