{"id":92114,"date":"2020-08-23T19:41:56","date_gmt":"2020-08-23T17:41:56","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql"},"modified":"2020-08-23T19:41:56","modified_gmt":"2020-08-23T17:41:56","slug":"realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","title":{"rendered":"Zbatimi i modelit t\u00eb roleve t\u00eb aksesit duke p\u00ebrdorur Row Level Security n\u00eb PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Zhvillimi i tem\u00ebs Artikull mbi zbatimin e Row Level Security n\u00eb PostgreSQL<\/a><\/noindex> dhe p\u00ebr nj\u00eb p\u00ebrgjigje t\u00eb zgjeruar<\/b> n\u00eb koment.<\/a><\/noindex><\/p>\n

Strategjia e p\u00ebrdorur p\u00ebrfshin konceptin e \"Logjik\u00ebs s\u00eb biznesit n\u00eb DB\", e cila \u00ebsht\u00eb p\u00ebrshkruar m\u00eb n\u00eb detaje k\u00ebtu \u2014 Artikull mbi zbatimin e logjik\u00ebs s\u00eb biznesit n\u00eb nivelin e funksioneve t\u00eb ruajtura PostgreSQL<\/a><\/noindex><\/p>\n

Pjesa teorike \u00ebsht\u00eb p\u00ebrshkruar shk\u00eblqyesh\u00ebm n\u00eb dokumentacion Postgres Pro<\/a><\/noindex> \u2014 Politikat e mbrojtjes s\u00eb rreshtave<\/a><\/noindex>. M\u00eb posht\u00eb \u00ebsht\u00eb analizuar implementimi praktik i nj\u00eb detyre t\u00eb caktuar t\u00eb biznesit \u2014 modeli i rolit t\u00eb qasjes n\u00eb t\u00eb dh\u00ebna.<\/b><\/p>\n

\"Zbatimi<\/p>\n

N\u00eb artikull nuk ka asgj\u00eb t\u00eb re, nuk ka kuptim t\u00eb fshehur dhe njohuri sekrete. Vet\u00ebm nj\u00eb skic\u00eb mbi realizimin praktik t\u00eb nj\u00eb ideje teorike. N\u00ebse dikujt i intereson \u2014 lexoni. At\u00ebher\u00eb shihni, mos e humbni koh\u00ebn tuaj kot.<\/p><\/blockquote>\n

<\/a><\/noindex><\/p>\n

Formulimi i detyr\u00ebs<\/h2>\n

\nDuhet t\u00eb kufizohet qasja p\u00ebr shikim\/inserim\/modifikim\/zhdukje t\u00eb dokumentit n\u00eb p\u00ebrputhje me rolin e p\u00ebrdoruesit t\u00eb aplikacionit. N\u00ebn rol n\u00ebnkuptohet nj\u00eb regjistrim n\u00eb tabel\u00ebn roles<\/b> e lidhur me marr\u00ebdh\u00ebnien shum\u00eb-m\u00eb-shum\u00eb me tabel\u00ebn users<\/b>. Detajet e implementimit t\u00eb tabelave, p\u00ebr shkak t\u00eb triviales, jan\u00eb l\u00ebn\u00eb jasht\u00eb. Gjithashtu jan\u00eb l\u00ebn\u00eb jasht\u00eb detajet specifike t\u00eb implementimit t\u00eb lidhura me fush\u00ebn tematike.<\/p>\n

Implementimi<\/h2>\n

<\/p>\n

Krijojm\u00eb role, skema, tabel\u00ebn<\/h4>\n

<\/p>\n

Krijimi i objekteve t\u00eb DB<\/b><\/p>\n

CREATE ROLE store;\nCREATE SCHEMA store AUTHORIZATION store;\nCREATE TABLE store.docs\n(\n  id integer ,         --id i dokumentit\n  man_id integer , --id i menaxherit t\u00eb dokumentit\n  stat_id integer ,  --id i statusit t\u00eb dokumentit\n  ...\n  is_del BOOLEAN DEFAULT FALSE \n);\nALTER TABLE store.docs ADD CONSTRAINT doc_pk PRIMARY KEY (id);\nALTER TABLE store.docs OWNER TO store ;\n<\/code><\/pre>\n
<\/p>\n
Krijojm\u00eb funksione p\u00ebr implementimin e RLS<\/h4>\n
\nKontrolli i mund\u00ebsis\u00eb p\u00ebr t\u00eb ekzekutuar SELECT p\u00ebr rreshtin<\/p>\n
                        check_select<\/b><\/p>\n
KRIJONI O RINOVONI FUNKSIONIN store.check_select ( current_id store.docs.id%TYPE ) KTHEN ROLLI BOOLEAN SI $$ DECLARONI rezultatin BOOLEAN ; curr_pid INTEGER ; curr_stat_id INTEGER ; doc_man_id INTEGER ; FILLIMI KRIJONI -- DBA ka qasje n\u00eb t\u00eb gjith\u00eb dokumentet IF SESSION_USER = 'curr_dba' THEN KTHEN TRUE ; END IF ; -------------------------------- -- N\u00ebse dokumenti ka etiket\u00ebn 't\u00eb fshir\u00eb' - mos e shfaq n\u00eb seleksionin SELECT is_del INTO rezultatin FROM store.docs WHERE id = current_id ; IF rezultati = TRUE THEN KTHEN FALSE ; END IF ; -------------------------------- -- Merrni id e p\u00ebrdoruesit aktual SELECT service_function.get_curr_pid () INTO curr_pid ; -------------------------------- -- Merrni id e menaxherit t\u00eb dokumentit SELECT man_id INTO doc_man_id FROM store.docs WHERE id = current_id ; -------------------------------- -- N\u00ebse menaxheri i dokumentit nuk \u00ebsht\u00eb p\u00ebrdoruesi aktual ose menaxheri nuk \u00ebsht\u00eb i em\u00ebruar - shtoni dokumentin n\u00eb seleksion IF doc_man_id != curr_pid OR doc_man_id IS NULL THEN KTHEN TRUE ; ELSE -- Merrni statusin aktual t\u00eb dokumentit SELECT stat_id INTO curr_statid FROM store.docs WHERE id = current_id ; -- N\u00ebse statusi lejon q\u00eb dokumenti t\u00eb shikohet - shtoni dokumentin n\u00eb seleksion IF curr_statid = 4 OR curr_statid = 9 THEN KTHEN TRUE ; ELSE -- N\u00eb t\u00eb kund\u00ebrt - p\u00ebrjashtoni dokumentin nga seleksioni KTHEN FALSE ; END IF ; END IF ; -------------------------------- KTHEN FALSE ; END $$ GJUHA plpgsql DEFINUES I SIGURIS\u00cb; Z\u00cbVEND\u00cbSO FUNKSIONIN store.check_select( store.docs.id%TYPE ) PRONAR TE store ; REVOKO EKZEKUTIMIN N\u00cb FUNKSIONIN store.check_select( store.docs.id%TYPE ) NGA publik; GRANT EKZEKUTIMIN N\u00cb FUNKSIONIN store.check_select( store.docs.id%TYPE ) TE sh\u00ebrbimeve funksionale; \n<\/code><\/pre>\n
\nKontrolli i mund\u00ebsis\u00eb p\u00ebr t\u00eb kryer INSERT t\u00eb rreshtit<\/p>\n
                        kontrollo_insert<\/b><\/p>\n
KRIJONI O RINOVONI FUNKSIONIN store.check_insert ( current_id store.docs.id%TYPE ) KTHEN ROLLI BOOLEAN SI $$ DECLARONI curr_role_id INTEGER ; FILLIMI KRIJONI -- DBA mund t\u00eb shtoj\u00eb rreshtin n\u00eb \u00e7do rast IF SESSION_USER = 'curr_dba' THEN KTHEN TRUE ; END IF ; -------------------------------- -- Merrni id e rolit t\u00eb p\u00ebrdoruesit aktual SELECT service_functions.current_rid() INTO curr_role_id ; -------------------------------- -- N\u00ebse roli lejon mund\u00ebsin\u00eb p\u00ebr t\u00eb krijuar nj\u00eb dokument t\u00eb ri -- lejohet IF curr_role_id = 3 OR curr_role_id = 5 THEN KTHEN TRUE ; END IF ; -------------------------------- KTHEN FALSE ; END $$ GJUHA plpgsql DEFINUES I SIGURIS\u00cb; Z\u00cbVEND\u00cbSO FUNKSIONIN store.check_insert( store.docs.id%TYPE ) PRONAR TE store ; REVOKO EKZEKUTIMIN N\u00cb FUNKSIONIN store.check_insert( store.docs.id%TYPE ) NGA publik; GRANT EKZEKUTIMIN N\u00cb FUNKSIONIN store.check_insert( store.docs.id%TYPE ) TE sh\u00ebrbimeve funksionale; \n<\/code><\/pre>\n
\nKontrolli i mund\u00ebsis\u00eb p\u00ebr t\u00eb kryer DELETE t\u00eb rreshtit<\/p>\n
                        kontrollo_fshij<\/b><\/p>\n
KRIJONI O RINOVONI FUNKSIONIN store.check_delete ( current_id store.docs.id%TYPE ) KTHEN ROLLI BOOLEAN SI $$ FILLIMI -- Vet\u00ebm DBA mund t\u00eb fshij\u00eb rreshtin IF SESSION_USER = 'curr_dba' THEN KTHEN TRUE ; END IF ; -------------------------------- KTHEN FALSE ; END $$ GJUHA plpgsql DEFINUES I SIGURIS\u00cb; Z\u00cbVEND\u00cbSO FUNKSIONIN store.check_delete( store.docs.id%TYPE ) PRONAR TE store ; REVOKO EKZEKUTIMIN N\u00cb FUNKSIONIN store.check_delete( store.docs.id%TYPE ) NGA publik;<\/code><\/pre>\n
\nKontrolli i mund\u00ebsis\u00eb p\u00ebr t\u00eb kryer UPDATE t\u00eb rreshtit.<\/p>\n
                        p\u00ebrdorimi_aktualizimi<\/b><\/p>\n
KRIJO OSE Z\u00cbVENDOS FUNKSIONIN store.p\u00ebrdorimi_aktualizimi (current_id store.docs.id%TYPE, is_del boolean)\nKTHEN BOOLEAN AS $$\nFILLIMI\n   --Dokumentet me statusin 't\u00eb fshir\u00eb' nuk redaktohen\n   N\u00cbSE is_del\n   AT\u00cbHER\u00cb\n     KTHIM FALSE;\n ELSE\n    KTHIM TRUE;\n  FUND IF;\n\nFUND\n$$ GJUH\u00cb plpgsql SIGURIA DEFINER;\nNDYSHO FUNKSIONIN store.p\u00ebrdorimi_aktualizimi (store.docs.id%TYPE, boolean) PRONAR TE store;\nHEQ EKZEKUTIMIN N\u00cb FUNKSIONIN store.p\u00ebrdorimi_aktualizimi (store.docs.id%TYPE, boolean) NGA publik;\nJEP EKZEKUTIMIN N\u00cb FUNKSIONIN store.p\u00ebrdorimi_aktualizimi (store.docs.id%TYPE) TE funksionet_e_sh\u00ebrbimeve;<\/code><\/pre>\n
<\/p>\n
                        kontrolli_aktualizimit<\/b><\/p>\n
KRIJO OSE Z\u00cbVENDOS FUNKSIONIN store.aktualizimi_me_kontroll (current_id store.docs.id%TYPE, is_del boolean)\nKTHEN BOOLEAN AS $$\nDECLARE\n  current_rid integer;\n  current_statid integer;\nFILLIMI\n\n  --DBA mund t\u00eb shikoj\u00eb rreshtin\n  N\u00cbSE USER_SESSION = 'curr_dba'\n  AT\u00cbHER\u00cb\n    KTHIM TRUE;\n  FUND IF;\n  --------------------------------\n\n --Merr id-n\u00eb e rolit t\u00eb p\u00ebrdoruesit aktual\n SELECT\n   funksionet_e_sh\u00ebrbimeve.current_rid()\n  N\u00cb\n    curr_role_id;\n --------------------------------                            \n\n --Fshirja e dokumentit - ndryshimi i shenj\u00ebs\n N\u00cbSE is_deleted\n AT\u00cbHER\u00cb\n   --N\u00ebse roli i p\u00ebrdoruesit ***\n   N\u00cbSE current_role_id = 3\n   AT\u00cbHER\u00cb\n      SELECT\n        stat_id\n      N\u00cb\n        curr_statid\n      NGA\n        store.docs\n      KU\n        id = current_id;\n\n      --Dokumenti n\u00eb statusin *** nuk mund t\u00eb fshihet\n      N\u00cbSE current_status_id = 11\n      AT\u00cbHER\u00cb\n         KTHIM FALSE;\n      ELSE\n      --Mund t\u00eb fshihet dokumenti n\u00eb statuset e tjera\n        KTHIM TRUE;\n      FUND IF;\n\n    --P\u00ebrndryshe, n\u00ebse roli i p\u00ebrdoruesit ***\n    ELSIF current_role_id = 5\n    AT\u00cbHER\u00cb\n      --T\u00eb gjitha statuset e dokumentit\n      KTHIM TRUE;\n    ELSE\n      --P\u00ebrdoruesit e tjer\u00eb nuk mund t\u00eb fshijn\u00eb dokumente\n      KTHIM FALSE;\n    FUND IF;\n ELSE\n   --P\u00ebrdit\u00ebsimi i dokumentit \u00ebsht\u00eb i lejuar\n    KTHIM TRUE;\nFUND IF;\n\nKTHIM FALSE;\nFUND\n$$ GJUH\u00cb plpgsql SIGURIA DEFINER;\nNDYSHO FUNKSIONIN store.aktualizimi_me_kontroll (storg.docs.id%TYPE, boolean) PRONAR TE store;\nHEQ EKZEKUTIMIN N\u00cb FUNKSIONIN store.aktualizimi_me_kontroll (storg.docs.id%TYPE, boolean) NGA publik;\nJEP EKZEKUTIMIN N\u00cb FUNKSIONIN store.aktualizimi_me_kontroll (store.docs.id%TYPE) TE funksionet_e_sh\u00ebrbimeve;<\/code><\/pre>\n
\nAktivizimi i politik\u00ebs s\u00eb Siguris\u00eb s\u00eb Nivelit t\u00eb Rreshtit p\u00ebr tabel\u00ebn.<\/p>\n
                        AKTIVIZO SIGURIN\u00cb E NIVELIT T\u00cb RRESHTIT<\/b><\/p>\n
NDYSHO TABEL\u00cbN store.docs AKTIVIZO SIGURIN\u00cb E NIVELIT T\u00cb RRESHTIT;\n\nKRIJO POLITIK\u00cbN doc_select N\u00cb store.docs P\u00cbR ZGJEDHJE TE funksionet_e_sh\u00ebrbimeve P\u00cbR MBULIM (SELECT store.check_select(id));\nKRIJO POLITIK\u00cbN doc_insert N\u00cb store.docs P\u00cbR SHTIM TE funksionet_e_sh\u00ebrbimeve ME KONTROLL (SELECT store.check_insert(id));\nKRIJO POLITIK\u00cbN docs_delete N\u00cb store.docs P\u00cbR FSHIRJE TE funksionet_e_sh\u00ebrbimeve P\u00cbR MBULIM (SELECT store.check_delete(id));\n\nKRIJO POLITIK\u00cbN doc_update_using N\u00cb store.docs P\u00cbR P\u00cbRDIT\u00cbSIM TE funksionet_e_sh\u00ebrbimeve P\u00cbR MBULIM (SELECT store.p\u00ebrdorimi_aktualizimi(id, is_del));\nKRIJO POLITIK\u00cbN doc_update_check N\u00cb store.docs P\u00cbR P\u00cbRDIT\u00cbSIM TE funksionet_e_sh\u00ebrbimeve ME KONTROLL (SELECT store.aktualizimi_me_kontroll(id, is_del));<\/code><\/pre>\n
<\/p>\n
P\u00ebrfundimi<\/h2>\n
\nKjo funksionon.<\/p>\n
Strategjia e propozuar lejoj transferimin e realizimit t\u00eb modelit t\u00eb rolit nga niveli i funksioneve t\u00eb biznesit n\u00eb nivelin e ruajtjes s\u00eb t\u00eb dh\u00ebnave. <\/p>\n
Funksionet mund t\u00eb p\u00ebrdoren si nj\u00eb shabllon p\u00ebr realizimin e modele m\u00eb t\u00eb sofistikuara t\u00eb fshehjes s\u00eb t\u00eb dh\u00ebnave, n\u00ebse k\u00ebrkesat e biznesit e k\u00ebrkojn\u00eb k\u00ebt\u00eb.
\n
Burimi: habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
\u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u0442\u0435\u043c\u044b \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Row Level Secutity \u0432 PostgreSQL \u0438 \u0434\u043b\u044f \u0440\u0430\u0437\u0432\u0435\u0440\u043d\u0443\u0442\u043e\u0433\u043e \u043e\u0442\u0432\u0435\u0442\u0430 \u043d\u0430 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u0442\u0435\u0433\u0438\u044f \u043f\u043e\u0434\u0440\u0430\u0437\u0443\u043c\u0435\u0432\u0430\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043a\u043e\u043d\u0446\u0435\u043f\u0446\u0438\u0438 \u00ab\u0411\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0430 \u0432 \u0411\u0414\u00bb, \u0447\u0442\u043e \u0431\u044b\u043b\u043e \u0447\u0443\u0442\u044c \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u043e \u0437\u0434\u0435\u0441\u044c \u2014 \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0438 \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 PostgreSQL \u0422\u0435\u043e\u0440\u0435\u0442\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u0447\u0430\u0441\u0442\u044c \u043e\u0442\u043b\u0438\u0447\u043d\u043e \u043e\u043f\u0438\u0441\u0430\u043d\u0430 \u0432 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438 Postgres Pro \u2014 \u041f\u043e\u043b\u0438\u0442\u0438\u043a\u0438 \u0437\u0430\u0449\u0438\u0442\u044b \u0441\u0442\u0440\u043e\u043a. \u041d\u0438\u0436\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0430\u044f […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":92115,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-92114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Zbatimi i modelit t\u00eb qasjes me rolin duke p\u00ebrdorur Row Level Security n\u00eb PostgreSQL | ProHoster","description":"Zhvillimi i tem\u00ebs Et\u00fcd mbi zbatimin e Row Level Security n\u00eb PostgreSQL dhe p\u00ebr nj\u00eb p\u00ebrgjigje t\u00eb zgjeruar mbi","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0440\u043e\u043b\u0435\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Row Level Security \u0432 PostgreSQL | ProHoster","og:description":"\u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 \u0442\u0435\u043c\u044b \u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 Row Level Secutity \u0432 PostgreSQL \u0438 \u0434\u043b\u044f \u0440\u0430\u0437\u0432\u0435\u0440\u043d\u0443\u0442\u043e\u0433\u043e \u043e\u0442\u0432\u0435\u0442\u0430 \u043d\u0430","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/realizacziya-rolevoj-modeli-dostupa-s-ispolzovaniem-row-level-security-v-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-08-23T17:41:56+00:00","article:modified_time":"2020-08-23T17:41:56+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"92114","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 12:14:23","updated":"2022-10-06 10:04:45","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/92114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=92114"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/92114\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/92115"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=92114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=92114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=92114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}