def save(self, player):
if player.uid is None:
execute_nonquery(self.connection, 'insert into players (name, rating) values (?, ?)',
(player.name, player.rating))
# set player.uid
else:
execute_nonquery(self.connection, 'update players set name = ?, rating = ? where rowid = ?',
(player.name, player.rating, player.uid))
def create_schema(self):
"""Create the database schema"""
execute_nonquery(self._connection, 'create table players (name text not null, rating real not null)')
