quintans / gosql Goto Github PK

Contributors

Stargazers

Forkers

jmptrader chinaworld snehal1112 fgituser isgasho

store.Query(BOOK).
    All().
    Inner(BOOK_A_PUBLISHER).
    Inner(BOOK_A_BOOK_BIN).
    Fetch().
    Where(BOOK_C_ID.Matches(1)).
    SelectTree(&book)

SELECT t0.`PUBLISHER_ID` AS t0_PublisherId,
    t0.`ID` AS t0_Id, t0.`VERSION` AS t0_Version,
    t0.`NAME` AS t0_Name, t0.`PRICE` AS t0_Price,
    t0.`PUBLISHED` AS t0_Published, t0_j1.`ID` AS t0_j1_Id,
    t0_j1.`VERSION` AS t0_j1_Version, t0_j1.`NAME` AS t0_j1_Name,
    t0_j2.`ID` AS t0_j2_Id, t0_j2.`VERSION` AS t0_j2_Version,
    t0_j2.`HARDCOVER` AS t0_j2_Hardcover
FROM `BOOK` t0 INNER JOIN `PUBLISHER` t0_j1 ON t0.`PUBLISHER_ID` = t0_j1.`ID`
    INNER JOIN `BOOK_BIN` t0_j2 ON t0_j1.`ID` = t0_j2.`ID`
WHERE t0.`ID` = :t0_R1