implemented shoes API and integrated with mysql