await Band.select(
Band.name
).where(
Band.popularity > 100
).run()
await Band.select(
Band.name,
Band.manager.name
).run()
await Band.delete().where(
(Band.band_members == 0) | (Band.manager.status == 'disabled')
).run()
await Band.update({Band.members: 5}).where(
Band.name == 'Pythonistas'
).run()
Or, alternatively:
band = await Band.objects().where(Band.name == 'Pythonistas').first().run()
band.members = 5
await band.save().run()
Read the docs, and learn the basics in 5 minutes.