Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Format Date: YYYY-MM-DD
- Schedule 1
- - Hit API ke MCCP dengan params:
- {
- "start_date": "",
- "end_date": ""
- }
- - Response API {
- "meta": {
- "limit": 10, --> JUmlah data per halaman
- "offset": 0,
- "page": 1,
- "total": 1,
- "total_page": 1, --> Jumlah banyaknya halaman
- "sort": [
- {
- "column": "created_at",
- "order": "desc"
- }
- ]
- }
- }
- - Insert Data ke log_schedule
- - table log_schedule {
- id uuid [pk] --> UUID
- log_start_date timestamptz --> Tanggal Proses sync
- log_end_date timestamptz --> Tanggal Proses sync
- log_info jsonb {
- "limit": 10,
- "page": 1,
- "total": 1,
- "total_page": 1,
- "current_page": 0
- }
- log_isrun: false
- log_iserror: false
- log_count: 0
- log_maxcount: 3
- log_response text --> jika ada error/success
- created_at timestamptz [not null, default: `CURRENT_TIMESTAMP`]
- updated_at timestamptz [not null, default: `CURRENT_TIMESTAMP`]
- }
- Schedule 2
- - Membaca table log_schedule
- - Check (log_isrun = false && log_iserror == false && total datanya > 0), jika true jalankan Schedule
- - JIka akses API MCCP ada Error (mati), maka sistem akan update log_count += 1
- - Jika log_count == log_maxcount, update log_iserror = true, log_response = "API tidak dapat di Akses"
- - Jika API MCCP Running Well, sistem akan call API dengan params :
- {
- log_start_date: "",
- log_end_date: "",
- page: current_page+1
- limit: limit
- }
- Looping sebanyak total_page {
- - Dapat response dari API MCCP
- - Looping Proses Insert/Update Data dari jumlah data API
- {
- Search data berdasarkan id pada table partner_catalogs
- if Found() {
- Update ke table partner_catalogs
- } else
- {
- Insert ke table partner_catalogs
- }
- }
- - Jika proses looping diatas telah selesai, call
- }
- - Jika proses looping diatas telah selesai, maka update log_isrun = true
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement