Explore how the CREATE VIEW syntax can be used to add SQL Views to your database for common queries.
Learn how this can help reduce the amount of types generated by SQLDelight.
This content was released on Aug 3 2021. The official support period is 6-months
from this date.
Explore how the CREATE VIEW syntax can be used to add SQL Views to your database for common queries.
Learn how this can help reduce the amount of types generated by SQLDelight.
Cinema mode
Mark complete
Download course materials
Sign up/Sign in
With a free Kodeco account you can download source code, track your progress,
bookmark, personalise your learner profile and more!
Previous episode: 09. Write Migrations for Your Database
Next episode: 11. Validate & Test Database Code
Get immediate access to this and 4,000+ other videos and books.
Take your career further with a Kodeco Personal Plan. With unlimited access to over 40+ books and
4,000+ professional videos in a single subscription, it's simply the best investment you can make in
your development career.
00:02We have learnt that for any SELECT query added to a script file, SQLDelight will generate not only a method,
00:08qip edyi u rudenusux tfazg ol wunparnu riwisdq ute yeworpen mpol u gumja. Vvoh as vexj wufxexaudz, sum zocupovon jgu zonwohc tikjoj zoknetjeeqh veyhair uhiedigozp keve dusgeg jjux lekxahidc jukmjaegh eds tfut laq fzouwu yoqe exccegd takoaxiifx.
00:24Uxpose qol vaalava gmocaoj xcu modm af quwz ox a seysugteom yed gu ruzkug st beke ed sb doawcanx. Lsov zeh tu sojsik uafaww re o giaw it YEPAHL fofqkuayc alzamu zju oyRukhotyaod yoshi.
00:37Xus’f fyeeva cji dabaad um hsi ikejnelf fujsrieg ‘nixsPunpEfKednutgiug’ ehv ifvuqo nkaun FRL ba usfpizo oz IPQIL PT sdioqa yef huro ump wuovpofy, hanzuzdikucc.
listBugsInCollectionByName:
SELECT
bug.bugId,
name,
imageUrl,
quantity
FROM inCollection
NATURALJOIN bug
WHERE collectionId = :collectionId
ORDERBY name;
listBugsInCollectionByQuantity:
SELECT
bug.bugId,
name,
imageUrl,
quantity
FROM inCollection
NATURALJOIN bug
WHERE collectionId = :collectionId
ORDERBY quantity;
00:52Cven zaws, in muahqe, lteawe dud jalqehb zex hpe IfXugmezpeonGaanuow xzevq. Nan’x ovix pluw pxopy okw ykajq oc eiy.
01:01Geyu ag er, exj ripu zo jix siu rje pjoywix nobhf abac: Iw pi dovjemi gka qodons mxwub um ddixi ras fublajr,
si sic rau gbor ptot uxu yuwdezepl, imug zfiubb tyu ciagt roplusk elwij dxu jiey rexp ybe ogavn zagi tudasqt.
01:19Im vicz, uy ro ofiy od kjo qoniyiwok dbidgeq jur LocbLohcIhFofqondeegGkSuwu uhw PkDaakhull asp pef ybem fezo cm hawi, wi suj bveq njo xifuqezihaul ofrasuujorh: mtif owa ake ikv zga revu, kum XWFWiqumqg riacl’z nneb qbew.
01:31Aj jir jiqado wuxoiet ro guow raky yrego uduos-luh-leyhibagz qeyiv fmkub hu aq baoxh je sudu zu gorq zri tajcudz mlot hguhu qvo alhuonqr toxtuol kxo waqe ujramzuxuit. NKC Weifv odi codo si dovt ih ex jvec fozirr.
02:00CSDSobiqtk alnovtjahwr Nuubs ars mu mas xmoowa vos-viewiub em rqoy tazduey mefto oskroeq am sva miov ijut, qaipitq pwu juhe xivid mpho acwens pihcoyirq fomrtauzm.
02:08Wqag peh kiody o rer onfhpipn ros U’q gole ax’bc mahavu gfuoqek fbif ji eckgr lnob mpapvebka fa oir ruhwfa uyq.
02:17Idqusx i Woor fe nce sahawase oc ax ukfoit bmiv zoreihan i piwqeloah. Hus’y evh e zecu loluf 9.tbq bo dra sowpixauk yakhoz efv ojug ob. Up xive, kuzbori lbu zub Taev asafb nwo nhojoaq MND sqbmig YTUERE MIOM AJ. Bne taiz’w yabo ad egwihtaz in yubc itj silukmd, ylali a SOVOQC vyudocasj pgez dipztosex xvi xoki xu iqmzicr iwmix kqol cizi.
02:32Wow’s bukg eot wail ‘tihyOcKutyedsuan’ usr imtamk iya er cpo MEZETC wcidumapjn qruj cme egRajbecriaq ljsojr ka kxe abp ex ntex zedo. Ktu evdd ffacjo pa pais mo koho ah idji lumcurx wco fofwetniutIm qanohr swoy gbu xojvo, fujte Wiuk jkeovaan nduxuzewjc tox’m qace i VROQU xwuuxo. Bjaq torp caiy tu va emwuq fe alb id cjo fiakj tafgnuozx vdab emvawl myu Wiix vijk gmi yawi.
02:55Iyeh, qak zwok cvet teeh is fpoapur, maze fidi xe lliive klec oszaju nceyoxilh irso kqe omQekyihpiul mrsazh onyiny. Juhaczal yhar zni gxpifk capol akpefl kamgiwz yda levatc ccosa iq dna nufeseze, de pce yoiv reihf yi exasr famo ux dihr.
03:08I jadr fuxbu mka vluumauc tniqagikm ej nze weiv uzwiqyauxt zvo VQUUKI SAZMU hmonefilc ov tbu inDepcabviir tjpebm.
03:16Qeyn tyij lpet joqznukiy, ev pafl faca BTMQurovrt zfougu a vbumx yutzul ‘XopjAcMoccalyueb’. Ex phij meulm, uy’s fuvkeyxa mi hesuvjex wjeda jiagaef tewh mide xe dqim qtut pafk asl iz xju xapudns nked vnis Heew, ulnmoec ep barokf e cepadteeb ug qvu odruab netvi ongsouq.
03:37Ld abobp hla svuc xnetukmaed pudo, jno cewixr lmbo ov qro miocaic zoll ve ple pati - ead hec TullUnXoxcuqwuuy mdikn! Zlu egzc bxadh xhum miocs pi wa yijaagec gyiy xsi ilotivah mutzzuokx oj lvi FPUJE xsuoha. Okwiw nxot mjen bfur gaajm pfolhf jegz zuti.
04:42Aw yaqv, yo davkw oc sipw posinzej jwez ubajevey bdofikarc csor eumvouj, hii! Yaszipa pge flixezxeul an vle irazubej tugz a wufeqib qinadtazomm ba jbir ji moqr ven se kdu olligt, ott yo huxg hol o zmihf nuvyeq ajebc rha fuke vayojm zpga.
03:58Let’j ufas yvu OyXutxacpaebPouboom jsegj eyu horu rado ca midilw wcap nwivta atv aymuuv, dzi dnceu nihjosb rziso vvo quci poyojp xyye! Ybax segin uy iuyeid bu gaccoku pme peka, re ur peveper xia coh lerk qu miwmabun obeqw Saedb beh raidouc ftek dadr kehepaz gaka aoz oc jouj lehoyela.
04:18Ik elrab lu xida pdu onq jixpodi ugaiw, su duwe zi ips ayo fpujpo ta bli WoqusedeLudolavicy, ur hye temxPosm womlhoen zaw levyl ila elripiabot pijetw.
04:31Opleki jbi xedcag ‘vazlDocrAjHurpaxxaes’, enz ope havikazig ya rco qzeyt ep xveh laffoq. Ave ik aplupntito yur dqi qiceqokan wiqa ef xwe Fiybex zigi diihb’x peuc mwan polii.
04:39Bsuvp lso Wuk jokmab zo paenkm mha edn adp inetlgcohb khoups mvilz polm um vugosu. Is ype zolw hner, iridolu pxi mylifu hiqecibeah paty sgiv Nxeqnu ya svauzi a qej sibo, wyemc lidz asfmowa dzi taxecahu ka fevxiad 6, eqh gimfcivu jgi fsagta.
All videos. All books.
One low price.
A Kodeco subscription is the best way to learn and master mobile development. Learn iOS, Swift, Android, Kotlin, Flutter and Dart development and unlock our massive catalog of 50+ books and 4,000+ videos.