expo sqlite can't get new data after inserting sql query

Question

So basically i am trying to insert a new data inside orders but for some reason i can't get new data when i try to select from orders all what i get is old data

i only get new data if i refresh the app otherwise it is showing just old one

import * as SQLite from "expo-sqlite";

function openDatabase() {
  const db = SQLite.openDatabase("db.db");
  return db;
}

const db = openDatabase();



// Create table part

export const createTable = async () => {
  db.transaction((tx) => {
    tx.executeSql(
      "create table if not exists orders (id integer primary key not null, manager int, buyer int, sum int, date text, products text);"
    );
  });

  return {message: "created tables"}
};


// orders part

export const getOrders = new Promise(function(resolve, reject) {
  db.transaction((tx) => {
    tx.executeSql("select * from orders", [], (_, { rows }) => {
      resolve(rows)
    })
  })
});


export const setOrder = (workerId, consumerId, sum, date, products) => {
  db.transaction((tx) => {
    tx.executeSql("insert into orders (manager, buyer, sum, date, products) values (?, ?, ?, ?, ?)", [workerId, consumerId, sum, date, products])
  });
}

honestly i tried everything in my mind but didn't help so i am here for help