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)')