Is it possible to get an entity from a ResultRow that contains aliased table?

[ezhaka]

Hi!

Consider a simple example:

val subQueryAlias = Table2.select { /* tricky subquery goes here */ }

val query = Join(Table1).join(subQueryAlias) { Table1.id eq subQueryAlias[Table2.id] }

query.map { resultRow -> 
    // bang! it's impossible to do because Table2 is under the alias in the resultRow
    Table2Entity.wrapRow(resultRow) 
}

Is there a way to get my entity from ResultRow?

[albertPu]

@Tapac
Can I get the entities from the query results and serialize them directly into json?Each time, the foreach loop assembles the data, and some cases can be serialized directly

[albertPu]

@Tapac
.Net LinqToDB framework for querying data is very convenient, if you can achieve that effect kotlin's query is too convenient

[Tapac]

@albertPu , I do not quite understand what do you mean and how this relates to a current issue.
You can't serialize entity to json without custom serializer, because of all entitie's fields are delegates, not a real fields.

[yanghengyh]

@Tapac How can I define the serialization program myself?

[rabolfazl]

Please add this feature :)

[gabrielgatu]

For those still searching: this has been implemented so now it's possible to deserialize ResultRow into a model. In my case, this is what I've had to write:

RevenueTable.innerJoin(ProductTable)
        .slice(RevenueTable.columns)
        .select {
            ...
        }.let { RevenueModel.wrapRows(it) }.toList()

Hope this can help other people in my same situation.

[gunslingor]

I'm not following the solution.... what needs to happen? I don't see the wrapRows function anywhere, nor Table2Entityh. Somehow there has to be an efficient way to get entities back instead of resultRows without manually doing this for every table right?

object Outlets : Table() {
    val outlet = varchar("outlet", 255)
    val url = varchar("url", 2083)

    fun getAll(){
        dbConnect()
        val result = mutableMapOf<String, Outlet>()
        transaction { selectAll() }.forEach {
            result.put(it[outlet],
                Outlet(
                    it[outlet],
                    it[url]
                )
            )
        }
        return result
    }
}

class Outlet(
    val outlet: String,
    val url: String? = null
)

[joaoeudes7]

Any solution to get value from alias in ResultRow?

[Tapac]

@joaoeudes7 , please check that test, it contains an example.