db connection and data extraction tested