Insert row into data table at set place

[user8]

What I’m trying to do:
I have repeating panel that is displaying rows from a data table. I added a button to be able to insert a row. I would like this row to be inserted right under the selected row and not at the end.

I saw this code in the forum:

@bryndonlee

with psycopg2.connect(conn_string) as conn:
    with conn.cursor(cursor_factory=psycopg2.extras.DictCursor) as cur:
      cur.execute(
        """
          INSERT INTO table_987654 (col_1, col_2) VALUES 
          ('a', 'b') 
          RETURNING *;
        """
      )
      print(list(cur.fetchone()))

But I don’t understand what its doing or how to modify it to fit my need.

Are there any other examples on how to add rows at a set location?

[stefano.menci]

You can’t rely on the order of the rows in a data table.

You can get the rows in a specific order by sorting them with search(orderby(column)).

The post you are mentioning talks about sql, not data tables using the Anvil APIs.

[jshaffstall]

You shouldn’t rely on the insert order in the data tables for displaying them in that order. Instead you add a field to the table that represents the order (e.g. a date if you want it to be displayed chronologically, a title field for alphabetically, a number field if you want an arbitrary order, etc) and then use tables.order_by on that field when you get search results from that table.

Using tables.order_by you can display data from the same table in different orders, regardless of their insert order. Anvil Docs | Using Data Tables from Python

[user8]

I am new to Python and databases in general.

I was not aware that row order is not dependable. Thank you both for the clarification. I will add a counter column, or use another method for ordering them.