feat(lucid): add Model.truncate() function (#240)

* feat(lucid): add Model.reset() function * fix(lucid): returns the truncate call * chore(lucid): rename reset to truncate
adonisjs · Nov 17, 2017 · 9be15a9 · 9be15a9
1 parent d3cc53a
commit 9be15a9
Show file tree

Hide file tree

Showing 2 changed files with 27 additions and 0 deletions.
diff --git a/src/Lucid/Model/index.js b/src/Lucid/Model/index.js
@@ -433,6 +433,18 @@ class Model extends BaseModel {
     return Promise.all(payloadArray.map((payload) => this.create(payload, trx)))
   }
 
+  /**
+   * Deletes all rows of this model (truncate table).
+   *
+   * @method truncate
+   *
+   * @return {Promise<void>}
+   */
+  static truncate () {
+    const query = this.query()
+    return query.truncate()
+  }
+
   /**
    * Returns an object of values dirty after persisting to
    * database or after fetching from database.

diff --git a/test/unit/lucid.spec.js b/test/unit/lucid.spec.js
@@ -1096,6 +1096,21 @@ test.group('Model', (group) => {
     assert.isFalse(user.isNew)
   })
 
+  test('reset a table in the database', async (assert) => {
+    class User extends Model {
+    }
+
+    User._bootIfNotBooted()
+    const user = await User.create({ username: 'virk' })
+    assert.isTrue(user.$persisted)
+    assert.isFalse(user.isNew)
+
+    await User.truncate()
+
+    const users = await User.all()
+    assert.equal(users.rows.length, 0)
+  })
+
   test('further changes to instance returned by create should update the model', async (assert) => {
     class User extends Model {
     }