DOC Add doc and how to on join
Add doc and how to on .join
specifically with were. Example:
# id_2internal = (
# (
# SQLEnumerable(conn, "exodam_cerberus2data")
# .select(lambda x: {"data_id": x.id_cerberus_data})
# .where(lambda x: x.id_cerberus == ref_cerberus_id)
# .where(lambda x: x.name == "internal")
# .execute()
# )
# .to_list()[0]
# .data_id
# )
# get_internal = (
# SQLEnumerable(conn, "exodam_cerberus_data")
# .select(lambda x: x.data)
# .where(lambda x: x.id == id_2internal)
# .execute()
# )
# bot == top
get_internal = (
SQLEnumerable(conn, "exodam_cerberus_data")
.join(
inner=SQLEnumerable(conn, "exodam_cerberus2data"),
outer_key=lambda cerberus_data: cerberus_data.id,
inner_key=lambda cerberus2data: cerberus2data.id_cerberus_data,
result_function=lambda cerberus2data, cerberus_data: {
"cerberus2data_id": cerberus2data.id,
"cerberus_data_id": cerberus_data.id,
"cerberus_data_data": cerberus_data.data,
},
)
.where(lambda x: x.exodam_cerberus2data.id_cerberus == ref_cerberus_id)
.where(lambda x: x.exodam_cerberus2data.name == "internal")
.execute()
)