Dear Kawan saya ada program compare data JSON value denagn yang di postgresql database. Hasil compare adalah menampilkan value d json yang tidak ada di database.
input an Json =
{
"nama_master": "SYNC_PAS",
"data": [{
"company": "123",
"total_data": "300",
"faktur_pas": ["T-666-1776", "T-324-0002", "T-675-0003"]
}, {
"company": "456",
"total_data": "200",
"faktur_pas": ["T-123-2001", "T-145-2002", "T-321-2003"]
}, {
"company": "dst",
"total_data": "100",
"faktur_pas": ["T-321-3001", "T-211-3002", "T-657-3003"]
}]
}
Output hasil compare saat ini
[T-666-1776, T-324-0002, T-675-0003, T-123-2001, T-145-2002, T-321-2003, T-321-3001, T-211-3002, T-657-3003]
Sedangkan yang diharapkan adalah:
{
"nama_master": "xxxxxxxx",
"data": [{
"company": "SAT",
"faktur_pas": [
"T-xxx-xxxx",
"T-J12-xxx",
"dst"
]
},
{
"company": "MUI",
"faktur_pas": [
"T-xxx-xxx",
"T-xxx-xxxx",
"dst"
]
},
{
"company": "dst",
"faktur_pas": [
"T-xxx-0001",
"T-xx-xxx",
"dst"
]
}
]
}
YAng terpilih akan di share gitnya
note: lanjutan https://projects.co.id/user/my_projects/view/e26e16/compare-data-json-dengan-query-sql-postgresql