Order dao

OrderDao.kt

@Dao
interface OrderDao {
    //Get an order along with its line items by orderId
    @Transaction
    @Query("SELECT * FROM orders WHERE orderId = :id")
    fun getById(id: String): Flow<OrderWithLineItems>

    //Get an order by its status
    @Transaction
    @Query("SELECT * FROM orders WHERE status = :status  LIMIT 1 ")
    fun getCartWithLineItems(status: String): Flow<OrderWithLineItems>
}