Is there a way to accept both Local and LocalReadOnly as paramter to do read only operations?

[corrm]

    // Called from reducer
    #[inline(always)]
    pub fn get_tile(db: &Local, map_id: u32, x: u32, y: u32) -> Option<MapTile> {
        db.map_tile().map_tile_idx().filter((map_id, x, y)).next()
    }

    // Called from view
    #[inline(always)]
    pub fn get_tile_view(db: &LocalReadOnly, map_id: u32, x: u32, y: u32) -> Option<MapTile> {
        db.map_tile().map_tile_idx().filter((map_id, x, y)).next()
    }

    // Even this will only accept `Local`
    // Hope to make it work from both view and reducer
    pub fn get_title2(db: &impl map_tile, map_id: u32, x: u32, y: u32) -> Option<MapTile> {
        db.map_tile().map_tile_idx().filter((map_id, x, y)).next()
    }

[corrm]

@egormanga you know how to do it?

[egormanga]

You've got a ReducerContext and a ViewContext at hand, both implement DbContext so accepting it will probably do it.

[corrm]

Did you change the parameter type to something like &impl DbContext as well?

Yes, it say DbContext doesnt have function named map_tile.

[egormanga]

That's because you should access .db on it first. It's a context, not a DbView itself!

[corrm]

That's because you should access .db on it first. It's a context, not a DbView itself!

doesnt work:

ctx: &impl DbContext:

error[E0599]: no method named `map_tile` found for reference `&<impl DbContext as spacetimedb::DbContext>::DbView` in the current scope
  --> crates/server/src/map/service.rs:31:18
   |
31 |         ctx.db().map_tile().map_tile_idx().filter((map_id, x, y)).next()
   |                  ^^^^^^^^ method not found in `&<impl DbContext as spacetimedb::DbContext>::DbView`
   |
   = help: items from traits can only be used if the trait is implemented and in scope
   = note: the following traits define an item `map_tile`, perhaps you need to implement one of them:
           candidate #1: `schema::map::map_tile`
           candidate #2: `schema::map::map_tile__query`
           candidate #3: `schema::map::map_tile__view`

ctx: &(impl DbContext + map_tile):

error[E0599]: no method named `map_tile` found for reference `&<impl DbContext + map_tile as spacetimedb::DbContext>::DbView` in the current scope
  --> crates/server/src/map/service.rs:31:18
   |
31 |         ctx.db().map_tile().map_tile_idx().filter((map_id, x, y)).next()
   |         ---      ^^^^^^^^ method not found in `&<impl DbContext + map_tile as spacetimedb::DbContext>::DbView`
   |         |
   |         method `map_tile` is available on `&impl DbContext + map_tile`
   |
   = help: items from traits can only be used if the trait is implemented and in scope
   = note: the following traits define an item `map_tile`, perhaps you need to implement one of them:
           candidate #1: `schema::map::map_tile`
           candidate #2: `schema::map::map_tile__query`
           candidate #3: `schema::map::map_tile__view`

[egormanga]

I think you swapped them