When I dump a query I get some metadata about it <https i2 p cfml #lucee

Join Slack

When I dump a query, I get some metadata about it:...

# lucee

Adam Cameron

02/18/2022, 11:34 AM

When I dump a query, I get some metadata about it:

https://i2.paste.pics/8c44dba63d3e573a17e9e4db1733d2d8.png▾

How do I extract that from the query object? I am specifically after the

cached

value.

getMetadata

only returns column info, not stuff about the query object itself. Note: I am not asking about the

result

option that one can pass to a

queryExecute

call. I only have the query object; I am not in control of the initial call, so I cannot use the

result

. Cheers.

Adam Cameron

02/18/2022, 11:54 AM

Looks like I can call

isCached

on the object and that returns what I need. However I'm slightly hesitant to call something that might be considered "internal implementation" and not intended for use in CFML code..? I see it is documented @ https://javadoc.lucee.org/lucee/runtime/type/Query.html, so perhaps it's OK. (I'm coming from more exposure to CF, where Adobe advise not to use such methods, as they are not a documented / supported API; might be different with Lucee)

neokoenig

02/18/2022, 11:56 AM

Here's a hilariously bad implementation: I don't recommend this, it was purely a "can it be done" experiment

Copy code

function dumpCachedValue(q) {
        var test = dumpStruct(q).comment;
        test = listFirst(test, "SQL");
        test = listLast(test, "Cached: ");
        return test;
    }

Adam Cameron

02/18/2022, 12:03 PM

What is this

dumpStruct

you are using here? (and yes, I checked it on trycf and it is a thing. My question still stands 😉

neokoenig

02/18/2022, 12:06 PM

I looked at the dump cfc in lucee source code and saw that's how the meta data appeared to be created: https://github.com/lucee/Lucee/blob/541388c2d8b392b5d77fe6fbb766fa2fa104950c/core/src/main/java/resource/library/tag/Dump.cfc https://github.com/lucee/Lucee/blob/541388c2d8b392b5d77fe6fbb766fa2fa104950c/core/src/main/java/lucee/runtime/functions/other/DumpStruct.java

neokoenig

02/18/2022, 12:06 PM

That's literally the only mention of dumpStruct in the lucee codebase

neokoenig

02/18/2022, 12:07 PM

As I said, comical implementation

neokoenig

02/18/2022, 12:10 PM

Kinda surprised it's not in the list of lucee functions as it appears to be available everywhere

thisOldDave

02/18/2022, 12:10 PM

so its java underneath try

writeDump(qryResult.getClass());

which should give you a nice list of methods but be warned not all are implemented. e.g.

writeDump(qryResult.getSql().toString());

works,

writeDump(qryResult.getMetaData());

doesnt

thisOldDave

02/18/2022, 12:27 PM

Copy code

writeDump({
    "Sql" =  qryResult.getSql().getSQLString(),
    "ExecutionTime" = qryResult.getExecutionTime(),  
    "CacheType" = qryResult.getCacheType(),
    "isCached" = qryResult.isCached()
    });

Open in Slack

Previous Next