Best Practices Adding/Removing From DB

Anvil Q&A
15

So I’m getting an error when trying to do this:

tables.TableError: Cannot automatically add column 'owner' to this view

Here is my code

@anvil.server.callable
def get_snakes_table():
  me = ensure_user()
  return app_tables.snakes.client_writable(owner = me)

self.my_snake_items = anvil.server.call('get_snakes_table')

def add_snake_click(self, **event_args):
    """This method is called when the button is clicked"""
    me = anvil.users.get_user()
    self.my_snake_items.add_row(sex=self.gender_dropdown.selected_value,
                              genes={"genes": [self.genes_dropdown.selected_value]},
                              hatchdate=self.hatch_date_picker.date,
                              name=self.name_text_box.text,
                              type=self.type_dropdown.selected_value,
                              owner=me,
                              alive=self.alive_dropdown.selected_value,
                              producer=self.producer_dropdown.text)

So what am I doing wrong :slight_smile: