Log message #4193221

# At Username Text
# Jul 15th 2019, 18:07 bird87_za Does anyone know of an API I can use to authenticate a user on his xbox profile and pull that data into my app?
# Jul 15th 2019, 17:14 devito thank
# Jul 15th 2019, 17:14 devito @kaliel yeah its mod rewrite
# Jul 15th 2019, 16:50 hippo @rrd564 I think the easiest solution is to specify the columns you would like to export via the `$_extract` view variable.
# Jul 15th 2019, 16:21 rrd564 I have to call toArray on a resultset. Is there any way to define the order of the array keys? I export to CSV using FirendsOfCake csvView plugin, but the order of the columns are mixed
# Jul 15th 2019, 16:02 kaliel @devito nothing on logs ? mod_rewrite enable ?
# Jul 15th 2019, 16:01 devito what would cause me to get a missing home controller error on a fresh stand up of cake3? default / route points to pages home and the route is named to /home
# Jul 15th 2019, 15:57 ndm There's also `assertResponseEquals()` if you want to compare the whole content.
# Jul 15th 2019, 15:55 neon1024 As it’s json, I’d rather do some more intrusive asserts :slightly_smiling_face:
# Jul 15th 2019, 15:55 neon1024 I’d only found `$this->assertResponseContains()`
# Jul 15th 2019, 15:55 neon1024 Ahh, thanks!
# Jul 15th 2019, 15:55 ndm `$this->_response`
# Jul 15th 2019, 15:50 neon1024 Using the IntegrationTestTrait, how do I get the response?
# Jul 15th 2019, 15:24 kaliel your welcome :slightly_smiling_face:
# Jul 15th 2019, 15:24 lubos I'll pick this in the morning with fresh head :slightly_smiling_face: thanks @kaliel for your input! :slightly_smiling_face:
# Jul 15th 2019, 15:23 lubos @kaliel the memory issues are before creating any CSV (when trying to debug `orders` results - just count output)
# Jul 15th 2019, 15:23 kaliel @lubos do you use a plugin or something to output csv ? I had memory issues too with some of them. Or do the allowed memory error is triggered before csv construction ?
# Jul 15th 2019, 15:22 lubos to be even more specific, we have `orders` and `leads` data and client is requiring output of both combined in CSV file so they can process data on their side
# Jul 15th 2019, 15:21 lubos @kaliel as you say, only the new collection is not third table but CSV output
# Jul 15th 2019, 15:20 kaliel @lubos To be clear, you have to query 2 tables, merge the results, do some process, then save this new collection (to a third table) ?
# Jul 15th 2019, 15:19 lubos I'll see, but for now it seems I stick with increasing memory limit, hopefully `512M` is just fine :slightly_smiling_face:
# Jul 15th 2019, 15:18 lubos and sql union could be answer too, but who does like it? :slightly_smiling_face:
# Jul 15th 2019, 15:17 lubos but still, i need to combine two collections (each has different table) that's why I picked post-processing at the first place
# Jul 15th 2019, 15:17 lubos rather than do post-processing with collections
# Jul 15th 2019, 15:16 lubos so using endless group and sql with `limit (number, from)` is the way to go I guess :slightly_smiling_face:
# Jul 15th 2019, 15:15 lubos @kaliel but then 101 - 200 created date could be wrongly sorted with first 100 results, but I need to loop sql queries with short period at this case I think :slightly_smiling_face:
# Jul 15th 2019, 15:14 kaliel @lubos you can sortBy('created') the first 100 results, then query for the 101th to 200th, etc...
# Jul 15th 2019, 15:14 lubos is using `512MB` too much? :slightly_smiling_face:
# Jul 15th 2019, 15:13 lubos but so much easier to increase memory limit
# Jul 15th 2019, 15:13 lubos thanks both, i will do
# Jul 15th 2019, 15:13 lubos but I guess I can make sets limited by short period, e.g. day or so
# Jul 15th 2019, 15:12 lubos and output is one CSV file which would be OK I can append to the CSV, but neeed sort them first
# Jul 15th 2019, 15:12 lubos well I can chunk them, but i need `sortBy('created')` for all items, then chunk does not work well
# Jul 15th 2019, 15:11 ricksaccous like @kaliel is suggesting
# Jul 15th 2019, 15:11 ricksaccous do x amount at a time with some delay in between maybe
# Jul 15th 2019, 15:11 kaliel @lubos you can add a "processed" boolean to each item of your collection, and add multiples tasks with queue plugin
# Jul 15th 2019, 15:11 ricksaccous @lubos you can probably chunk them no?
# Jul 15th 2019, 15:10 ricksaccous in one widget
# Jul 15th 2019, 15:10 ricksaccous and permeating data through different templates
# Jul 15th 2019, 15:10 lubos processing about 9300 results set which does not seems too much though, but there are many fields in the row
# Jul 15th 2019, 15:10 ricksaccous I'm having so much trouble with widgets