Indlela yokulayisha kunye nokugcina idatha yeeMidlalo kwi-SDK ye-SDK

Indlela yokusebenzisa i-SQLite ukugcina idatha yeMidlalo kunye neZixhobo

Into enye phantse yonke iprogram kunye nomdlalo ufana ngokufanayo kuyimfuneko yokugcina nokufumana idatha. Ngona umdlalo ongcono kakhulu unokusebenzisa iSQLite ukugcina inombolo yenguqulo yohlelo lokusebenza, engasetyenziselwa ukuqinisekisa ukuhambelana nokuphucula ukuqhuba, okanye izicwangciso ezilula ezifana nokuguqula okanye ukucima umsindo wegeyimu.

Ukuba awuzange wenze umsebenzi omkhulu kunye neenkcukacha zolwazi okanye usebenzisa i-database ye- SDE ye - Corona , ungakhathazeki. Ngokwenene inkqubo ecacileyo ngokubonga ngamandla e-LUA kunye nenjini ye-SQLite ye-database esebenzisa kwi-SDK ye-Corona. Olu qeqesho luya kuhamba kwinkqubo yokudala itheyibhile yesetyenziso kunye nokugcina nokufumana ulwazi kuyo. Indlela yokuphuhlisa iifowuni ze-iPad.

Kwakhona gcinani engqondweni ukuba le nqubo ingahamba ngaphezu kokugcina izicwangciso ezisetyenziswa ngumsebenzisi. Ngokomzekelo, kuthekani ukuba unomdlalo onokudlala ngokusebenzisa iindlela ezahlukeneyo zemidlalo ezifana ne "story" mode kunye ne "arcade". Le tafile yesetyenzisi ingasetyenziselwa ukugcina imo yangoku. Okanye nayiphi nayinye into efuna ukuhlala iqhubekayo nangona umsebenzisi ephuma ngaphandle komdlalo aze aphinde abuyele kwakhona.

Inyathelo lokuqala: Ukuqalisa isiseko sedatha kunye nokudala i-table setting

Into yokuqala esifanele siyenze ukunyusa ilayibrari ye-SQLite kwaye sitshele i-app yethu apho ukufumana ifayile yedatha. Indawo efanelekileyo yokubeka le khowudi ilungile phezulu kwifayili enkulu kunye kunye nezinye zifuna iingxelo. Ifayile yesiseko iya kudalwa ukuba akukho nto ifunyenweyo, kwaye siya kuyigcina kwifolda yeMibhalo ukuze sikwazi ukuyifunda kuyo kwaye sibhale kuyo.

kufuna "sqlite3"
yedatha_path = system.pathForFile ("data.db", inkqubo yeDocumentsDirectory);
db = sqlite3.open (idatha_path);

Phawula indlela uguquko lwe "db" lungekho ndawo. Senze oku ukuqinisekisa ukuba singakwazi ukufikelela kwi-database kwiprojekthi yethu. Ungenza kwakhona ifayile ethile .lua kuyo yonke imisebenzi yeenkcukacha zeenkcukacha kwaye ugcine isiseko seenkcukacha kwindawo leyo kwifayile.

Emva koko, kufuneka senze itafile yedata egcina izicwangciso zethu:

kwendawo sql = "YOKHALA ITHEBHA UKUBA UKUSETYENZISWA kwezicwangciso (igama, xabiso);"
db: exec (sql);

Le nkcazo idala itheyibhile yethu yesetya. Kukulungele ukuyiqhuba rhoqo emva kokuba i-app imithwalo ngenxa yokuba ithe itafile sele ikhona, le ntetho ayiyi kwenza nantoni na. Ungayifaka le nkcazo ngqo phantsi apho siye sazisa khona isiseko sedatha okanye kumsebenzi obeka insiza yakho ukuba isebenze. Imfuno ephambili (1) ukuqhuba ezo nkcazo rhoqo ngexesha lwakhiwo lusetyenziso kwaye (2) luyenze ngaphambi kokuba nayiphi na ifowuni ilayishe okanye igcine izicwangciso.

Inyathelo lesibini: Ukugcina izicwangciso kwiziko ledatha

Umsebenzi usetha (igama, ixabiso)
sql = "SUSELA kwiisetYHO apho igama =" "igama ..." '";
db: exec (sql)

sql = "LUNGISA izicwangciso (igama, xabiso) IIMALI ('" ..namename "", ".. .. value" ");";
db: exec (sql)
isiphelo

umsebenzi setSettingString (igama, ixabiso)
setSetting (igama, "'" .. xabisa .. "'");
isiphelo

Umsebenzi weSetSetting ususa zonke izicwangciso zangaphambili ezigcinwe kwitheyibhile kwaye zifaka ixabiso elitsha. Iya kusebenza kunye neendidi zombini kunye nezintambo, kodwa ukulondoloza umtya kufuna iicatshulwa ezilinganayo malunga nexabiso, ngoko sisebenzise umsebenzi weSetSettingString ukuba senze loo msebenzi wongeziweyo.

Inyathelo lesithathu: Ukulayisha izicwangciso kwi-database

Umsebenzi ufumana (igama)

kwendawo sql = "UKUKHETHA * KUSETSHENZISWA KWEZIHLOKO EZIPHI igama =" "igama ..." '";
xabiso lendawo = -1;

umgca kwi-db: i-nrows (sql) yenza
xabiso = row.value;
isiphelo

xabiso lokubuyela;
isiphelo

umsebenzi GetSettingString (igama)
kwendawo sql = "UKUKHETHA * KUSETSHENZISWA KWEZIHLOKO EZIPHI igama =" "igama ..." '";
xabiso lendawo = '';

umgca kwi-db: i-nrows (sql) yenza
xabiso = row.value;
isiphelo

xabiso lokubuyela;
isiphelo

Njengokuba ngasentla, siphule imisebenzi kwiinguqulelo ezimbini: enye yeenombolo kunye neyodwa yezixhobo. Isizathu esinqununu esiye senza oku sikwazi ukuba siqalise ngokubaluleka kwexabiso elithile ukuba akukho mqathango okhoyo kwi database. Umsebenzi we-GetSetting uza kubuya -1, oya kuthi usazise ukuba isilungiselelo asigcinwanga. I-getSettingString iya kubuyisa umtya ongenanto.

Umsebenzi we-GetSettingString ukhetha ngokuzikhethela. Ukwahlukana kuphela phakathi kwalo kunye nomsebenzi oqhelekileyo we-GetSetting yinto ebuyiselwayo ukuba akukho nto ifunyenweyo kwisiseko sedatha.

Inyathelo lesine: Ukusebenzisa i-table setting

Ngoku ukuba sinomsebenzi onzima, sinokulayisha lula kwaye silondoloze izicwangciso kwi-database ekhoyo. Ngokomzekelo, sinokuzilalisa isandi ngolu hlobo lulandelayo:

setSetting ('sound', inkohliso);

Kwaye sinokusebenzisa isicwangciso somsebenzi womhlaba wonke wokudlala izandi:

Umdlalo odlalayoSound (soundID)
ukuba (getSetting ('sound') ke
audio.play (soundID)
isiphelo
isiphelo

Ukuyibuyisela kwakhona isandi, simisa nje ukubeka kwezandi kwi nyaniso:

setSetting ('sound', yinyaniso);

Inxalenye enhle malunga nale mi sebenzi unako ukugcina imigqomo okanye i-integers kwisetyu yesilungiselelo kwaye uyifumane kalula. Oku kukuvumela ukuba wenze nantoni na ukusindisa igama lomdlali ukugcina amanqaku aphezulu.

I-SDK ye-SDK: Indlela yokwenza iIgraphic Graphics, Hambisa iIgraphics kwaye Yenza imizobo phambi