mandarīnpīle Posted January 20, 2014 Report Share Posted January 20, 2014 Nepieciešams Skats ar garu, sarežģītu SELECT statementu. Lai pats un citi varētu to vēlāk pielabot, saprast, pievienoti komentāri un tādas konstrukcijas kā JOIN ir katra savā rindā. Nu, uz šo pusi: -- Descriptive comment SELECT .. FROM .. LEFT JOIN .. ON RIGHT JOIN .. ON -- Another info Bet šo skatu izveidojot, mysql dzēš visus komentārus un sastumj visu vienā garā rindā, turklāt ar JOINiem saliek jocīgas iekavas. Jautājums - kā saglabāt saprotamu struktūru? Quote Link to comment Share on other sites More sharing options...
briedis Posted January 20, 2014 Report Share Posted January 20, 2014 Glabā sql kaut kur kodā, versiju kontrolē? Quote Link to comment Share on other sites More sharing options...
mandarīnpīle Posted January 20, 2014 Author Report Share Posted January 20, 2014 Glabā sql kaut kur kodā, versiju kontrolē? Šobrīd tā tiek darīts, bet it feels so wrong. Quote Link to comment Share on other sites More sharing options...
Kaklz Posted January 20, 2014 Report Share Posted January 20, 2014 Jāskatās vai izmantojamais framework to jau neatbalsta "out of the box"? Piemēram: http://fuelphp.com/docs/general/migrations.html http://laravel.com/docs/migrations Gan jau arī citiem ir kaut kas līdzīgs. Quote Link to comment Share on other sites More sharing options...
Kavacky Posted January 21, 2014 Report Share Posted January 21, 2014 Šobrīd tā tiek darīts, bet it feels so wrong.A rakstīt garu, samudžinātu SQL statementu nefīlo wrong? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.