| [19:50:47] | <symbioquine[m]> | farmOS_wfs is mostly up to the same level for 2.x as it was for 1.x - https://github.com/symbioquine/farmOS_wfs/tree/2.x |
| [19:51:22] | <symbioquine[m]> | I'm now working on making all assets accessible instead of just those with intrinsic geometry. |
| [19:52:24] | <symbioquine[m]> | I'll probably try to do a bit more polishing/testing after that so I can make a 2.x-v0.0.1 release :) |
| [19:55:55] | <paul121[m]> | hey symbioquine I was going to tell ya, the views_geojson module supports bbox filtering: https://www.drupal.org/project/views_geojson |
| [19:56:39] | <paul121[m]> | but unfortunately it uses a SQL query to do that, so it'll be the same issue with computed fields |
| [19:57:03] | <paul121[m]> | it also only checks the `node__{field_name}` table which is annoying |
| [19:57:04] | <paul121[m]> | https://git.drupalcode.org/project/views_geojson/-/blob/8.x-1.x/src/Plug... |
| [19:57:24] | <paul121[m]> | but anyways, might be worth referring to! |
| [19:57:59] | <symbioquine[m]> | Yeah, that's pretty similar to what I've got right now... https://github.com/symbioquine/farmOS_wfs/blob/0e72fffaf8a48805f3b9bb6cc... |
| [19:58:04] | <mstenta[m]> | Awesome symbioquine ! |
| [19:58:21] | <mstenta[m]> | And yea we should take a look at the query ideas soon |
| [19:58:25] | <symbioquine[m]> | Trying to workout a version which works with both the intrinsic and log-based geometries now :) |
| [19:58:55] | <symbioquine[m]> | I can see already I'll need to add tests against multiple DB backends just to prove that query works on the popular ones :( |
| [20:00:17] | <paul121[m]> | oh yea? does `condition` not always do the same thing? |
| [20:02:04] | <symbioquine[m]> | <paul121[m] "oh yea? does `condition` not alw"> The asset query stuff should be very well tested accross different DBMS, but it doesn't support complex joins, subqueries, or window functions so I think I need to use the lower level DB API - and that opens up a whole range of ways it might be DBMS-specific... |
| [20:02:54] | <paul121[m]> | ah |
| [20:02:58] | <symbioquine[m]> | https://matrix.to/#/!rxZezKXfxOKJxTgNGs:matrix.org/$1609691426435068xSQUh:matrix.org?via=matrix.org&via=jcalonso.com |
| [20:03:53] | <symbioquine[m]> | I'd like to do it in a way that allows pagination at the DB layer, which makes the simpler approach of using multiple queries less attractive. |
| [20:04:00] | <mstenta[m]> | Perhaps more reason to add a db caching layer that can be queried directly |
| [20:04:25] | <symbioquine[m]> | That would also be an option! |
| [00:27:44] | <symbioquine[m]> | Is there an easy way to "recursively delete" assets - i.e. delete the referencing logs then delete the asset - either through the JSON:API or Drush? |
| [00:28:33] | <symbioquine[m]> | I can obviously query all the logs and do it in my code, but that seems like a pain. |
| [00:29:29] | <symbioquine[m]> | In case it's relevant this is for some test cleanup code so it doesn't have to be beautiful/production-ready just succinct and relatively fast. |
| [01:00:13] | <symbioquine[m]> | In case anyone's curious, [this](https://github.com/symbioquine/farmOS_wfs/commit/77c405f7f1ae93f8b4e89ff...) is what I ended up doing... (Not pretty, but it works. 😑) |
| [06:16:25] | <mstenta[m]> | > Is there an easy way to "recursively delete" assets - i.e. delete the referencing logs then delete the asset - either through the JSON:API or Drush? |
| [06:16:25] | <mstenta[m]> | we don't have a helper for that, no |
| [06:20:30] | * calbasi_matrix has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:32] | * dazinism has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:33] | * JulianF has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:33] | * pllagn[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:35] | * zedrickr11[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:35] | * lauriexwayne[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:36] | * wombat83[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:36] | * jcalonso[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:38] | * generalredneck[m has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:41] | * symbioquine[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:41] | * braught[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:41] | * leogaggl[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:20:44] | * sydney_zimbotech has quit (Quit: Bridge terminating on SIGTERM) |
| [06:21:07] | * kunigunde[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:21:07] | * paul121[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:21:07] | * mstenta[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:21:08] | * jgaehring[m] has quit (Quit: Bridge terminating on SIGTERM) |
| [06:31:07] | * dazinism has joined #farmos |
| [06:31:32] | * calbasi_matrix has joined #farmos |
| [07:11:04] | * JulianF has joined #farmos |
| [07:11:04] | * kunigunde[m] has joined #farmos |
| [07:11:05] | * spitz234[m] has joined #farmos |
| [07:11:10] | * generalredneck[m has joined #farmos |
| [07:11:10] | * mstenta[m] has joined #farmos |
| [07:11:10] | * jgaehring[m] has joined #farmos |
| [07:11:10] | * braught[m] has joined #farmos |
| [07:11:10] | * leogaggl[m] has joined #farmos |
| [07:11:11] | * paul121[m] has joined #farmos |
| [07:11:11] | * symbioquine[m] has joined #farmos |
| [07:11:11] | * pllagn[m] has joined #farmos |
| [07:11:11] | * jcalonso[m] has joined #farmos |
| [07:11:11] | * wombat83[m] has joined #farmos |
| [07:11:11] | * sydney_zimbotech has joined #farmos |
| [07:11:12] | * lauriexwayne[m] has joined #farmos |
| [07:11:12] | * zedrickr11[m] has joined #farmos |
| [09:53:11] | <mstenta[m]> | Curious to get thoughts from the community on this: https://www.drupal.org/project/farm/issues/3191115 |