Isiguquli se-CSV saya ku-JSON

I-CSV ne-JSON: izindlela ezimbili zokuthwala idatha efanayo

Idatha eyakhelwe kumathebula igcina iphelela kwenye yezindlela ezimbili. I-CSV ulimi lwemvelo lwesipredishithi: ifayela lombhalo olula lapho umugqa ngamunye ungumugqa (row), amakhefu ahlukanisa amakholomu. I-JSON ulimi lwama-API nezinhlelo zokusebenza: ifomethi eyakhiwe eqondile eyakhelwe kuma-objekthi (izinkinombolo namavelu) kanye nama-array (izinhlu ezihleliwe). Zichaza ulwazi olufanayo ngezimo ezehlukene kakhulu, okuyisona sizathu sokuthi kungani ukuguqula phakathi kwazo kuvela kaningi kangaka. Leli khasi lenza lokho kuguqulwa ngazo zombili izindlela, ngokugcwele ngaphakathi kusiphequluli sakho.

I-CSV ikhanyisela noma kuphi lapho igridi izwakala ivamile. Khipha umbiko kusizinda sedatha, ulande uhlu lwama-oda, noma ugcine ishithi kusuka ku-Excel noma i-Google Sheets, futhi cishe uhlale uthola i-CSV. Incane, ifundeka umuntu, futhi wonke amathuluzi okuhlaziya emhlabeni angayivula. I-JSON ikhanyisela noma kuphi lapho isoftware ikhuluma nesoftware. Ama-API e-REST ayithumela futhi ayamukele, amafayela okucushwa ayasebenzisa, futhi i-JavaScript iyayifunda ngaphandle kwanoma yiluphi uhlelo lokuhlaziya. Uma udinga ukondla ukukhishwa kwesipredishithi ku-API noma ukudonsa impendulo ye-API kusipredishithi, ubusuku uguqula phakathi kwalezi zizwe ezimbili.

Indlela imigqa nezihloko ziphenduka ngayo ama-objekthi

Ukumelana kulula kunokubukeka. Umugqa wokuqala wefayela le-CSV ngokuvamile ungumugqa wesihloko, futhi lawo magama esihloko aphenduka ama-key ku-JSON. Umugqa ngamunye olandelayo uphenduka i-objekthi eyodwa, lapho iseli ngayinye ihlanganiswa nesihloko esifanele. Lonke ifayela liphenduka i-array yalawo ma-objekthi. Ngakho i-CSV enamakholomu name,email,age iphenduka uhlu olufana ne-[{"name": "Ada", "email": "ada@example.com", "age": "36"}, ...]. Ohlangothini olulodwa, ukuguqula i-JSON ibe i-CSV kufunda ama-key e-objekthi lokuqala ukwakha umugqa wesihloko, bese kubhalwa umugqa owodwa ngesikhathi ngesikhathi i-objekthi ngayinye. Kuwuhambo oluhlanzekile futhi oluqagelekayo uma nje idatha yakho iyikuvamile yamathebula.

Izinkinga okufanele zaziwe

I-CSV ibukeka ilula kodwa ifihla imiphetho ecijile embalwa. Enkulu wamakhefu angaphakathi kwensimu. Uma ikheli liqukethe "Berlin, Germany", ukuhlukanisa okulula ngamakhefu kungadabula lelo vela elilodwa libe amakholomu amabili. Izinga le-CSV liphatha lokhu ngokugoqa lezo zinsimu ngokwakwa ngamakhwoteshini amabili, futhi amakhwoteshini angaphakathi kwensimu egoqiwe aphindaphindwa (""). Isiguquli esihle silalela leyo mithetho ukuze idatha yakho ingashintshi ngokuthula amakholomu. Qaphela nedelimitha (delimiter) futhi: ukukhishwa okuningi kwaseYurophu kusebenzisa isemikholoni esikhundleni sekhefu, ngoba ikhefu selivele lisebenza njengesiqhema kwezinombolo lapho. Amathebhu namama-pipe navo ayavela.

Umehluko ojulile wubuhlobo. I-CSV ayinamqondo wobuhlobo bezobunjalo nhlobo. Konke kungumbhalo, ngakho inombolo 42, i-boolean true, kanye neseli elingenalutho konke kubukeka njengemibhalo eyisicaba. I-JSON, ngakolunye uhlangothi, ihlukanisa izinombolo, imibhalo, ama-boolean, i-null, kanye nezakhiwo ezifakwe ndawonye. Lapho uguqula i-CSV ibe i-JSON, amavelu afika njengemibhalo ngaphandle kokuba ithuluzi litshelwe ukuhumusha izinombolo nama-boolean. Ukuguqula i-JSON ibe i-CSV kunenkinga ephambene: ama-objekthi nama-array afakwe ndawonye awafaneleki kahle egridini eliyisicaba, ngakho ngokuvamile ayenziwa ayisicaba noma abhalwe njengomunye umbhalo kuseli elilodwa. Ukwazi lokhu kusengaphambili kuyakusindisa ukuxakeka ngokuthi kungani ikholomu "ibukeka ingafanele" kamuva.

Uhambo lwangempela

Nasi isimo esivela njalo. Umsebenzi ozakwenu ukuthumela isipredishithi sabasebenzisi abasha bese ecela ukuthi ubalayishe nge-API yangaphakathi. I-API yamukela i-JSON kuphela. Ukhipha ishithi ube i-CSV, uyinamathisele lapha, futhi uthola i-array elihlanzekile lama-objekthi elungele ukungenzwa esicelweni sakho. Kamuva, i-API ibuyisela uhlu lwe-JSON lwamarekhodi eyawakhile, futhi udinga ukukubuyisela lokho kulowo mngane wakho ukuze abukeze. Ulinamathisela i-JSON, uyiguqule ibe i-CSV, bese kuvuleka ngqo kwisipredishithi sabo. Akukho amaskripti, akukho okufakwayo, izinguqulo ezimbili nje ezisheshayo phakathi nomsebenzi ovamile.

Kwendawo kuphela, ngamabomu

Konke lokhu kwenzeka kusiphequluli sakho. I-CSV ne-JSON yakho kuhlaziywa futhi kuguqulwa yi-JavaScript emshinini wakho siqu, futhi akukho okulayishwayo kuseva. Lokho kubalulekile ngoba ukukhishwa kaningi kuqukethe amagama angempela, ama-imeyili, imininingwane yama-oda, noma izazisi zangaphakathi ongafanele uzinamathisele kusevisi yakude engaziwa. Lapha idatha ayikaze iphume ekhasini. Uma ufuna ukuhlanza umphumela emva kwalokho, i-sishintshi se-JSON sethu sizoyihlela ngokucacile futhi siyiqinisekise, futhi ungaphequlula konke okunye kuma-zishintshi zedatha zethu zamafomethi ahlobene.

Imibuzo evame ukubuzwa