# core mysql->postgres ## to do ```bash= ``` ### complex query ```bash= curl --request GET \ --url 'https://api-beta.evaly.com.bd/core/v2/merchant/orders/delivered/analytics/shop?page=1&order_status=delivered&shop=the-new-vision' \ --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6IjAxMjAwMDAwMDA2IiwiZ3JvdXBzIjpbXSwiZmlyc3RfbmFtZSI6IkZvcmVzdCIsImxhc3RfbmFtZSI6IlByb2hhc2thIiwiaXNfc3RhZmYiOmZhbHNlLCJpc19hY3RpdmUiOnRydWUsImlzX3N1cGVydXNlciI6ZmFsc2UsInZlcmlmaWVkIjpmYWxzZSwidXNlcl90eXBlIjoiY3VzdG9tZXIiLCJ1c2VyX3N0YXR1cyI6ImFjdGl2ZSIsImVtYWlsIjoiIiwiY29udGFjdCI6IjAxMjAwMDAwMDA2IiwiZGF0ZV9qb2luZWQiOiIyMDIxLTA4LTA4VDA3OjA4OjIyLjc5M1oiLCJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiaXNfZWF1dGgiOnRydWUsImV4cCI6MTYyOTYyMTMyNH0.fFHMy-rvP-iAzujCPXOXWjnAINKQbULf7bsTP3y-ZYI' ``` ## done ```bash= curl --request GET \ --url 'http://localhost:8000/v2/merchant/orders/sales-growth?shop=the-new-vision&year=2020' \ --header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6IjAxMjAwMDAwMDA2IiwiZ3JvdXBzIjpbXSwiZmlyc3RfbmFtZSI6IkZvcmVzdCIsImxhc3RfbmFtZSI6IlByb2hhc2thIiwiaXNfc3RhZmYiOmZhbHNlLCJpc19hY3RpdmUiOnRydWUsImlzX3N1cGVydXNlciI6ZmFsc2UsInZlcmlmaWVkIjpmYWxzZSwidXNlcl90eXBlIjoiY3VzdG9tZXIiLCJ1c2VyX3N0YXR1cyI6ImFjdGl2ZSIsImVtYWlsIjoiIiwiY29udGFjdCI6IjAxMjAwMDAwMDA2IiwiZGF0ZV9qb2luZWQiOiIyMDIxLTA4LTA4VDA3OjA4OjIyLjc5M1oiLCJ0b2tlbl90eXBlIjoiYWNjZXNzIiwiaXNfZWF1dGgiOnRydWUsImV4cCI6MTYyOTYzNTkyN30.0mZEghIKLQCv_zzAoNo63wo9hOCIK97Fju2Ey8FtCcs' ```