4. Return Values

Contents

• Return Values
  • Create
  • Update
  • Read
  • Delete

For all queries (C, U, R, D), their executed returns are:

• C: last row's id or Model instance
• U: rows affected
• R: SelectResult object
• D: rows affected

4.1. Create

Model.create returns a Model instance:

>>> User.create(name='jack')
<models.User object at 0xb6f8dc4c>

model.save returns inserted row’s id:

>>> user = User(name='jack')
>>> user.save()
7

4.2. Update

Update queries return number of the rows affected:

>>> query = User.where(name='jack').update(email='jack@gmail.com')
>>> query.execute()
2

even queries from model.save:

>>> user = User.at(1),getone()
>>> user.name = 'aNewName'
>>> user.save()
1

4.3. Read

Return SelectResult object:

>>> result = User.where(name='jack').select().execute()
>>> result
<skylark.SelectResult object at 0xb6f8df6c>

And from SelectResult object, we can fetch user:

>>> result.one()
<models.User object at 0xb6f8dccc>

4.4. Delete

Return number of the rows deleted:

>>> user.destroy()
1
>>> User.where(name='jack').delete().execute()
4