/**
  * test creating a Vendor and then deleting it
  **/
 public function testDeleteValidVendor()
 {
     // count the number of rows and save it for later
     $numRows = $this->getConnection()->getRowCount("vendor");
     // create a new Profile and insert to into mySQL
     $vendor = new Vendor(null, $this->VALID_contactName, $this->VALID_vendorEmail, $this->VALID_vendorName, $this->VALID_vendorPhoneNumber);
     $vendor->insert($this->getPDO());
     // delete the Vendor from mySQL
     $this->assertSame($numRows + 1, $this->getConnection()->getRowCount("vendor"));
     $vendor->delete($this->getPDO());
     // grab the data from mySQL and enforce the Vendor does not exist
     $pdoVendor = Vendor::getVendorByVendorId($this->getPDO(), $vendor->getvendorId());
     $this->assertNull($pdoVendor);
     $this->assertSame($numRows, $this->getConnection()->getRowCount("vendor"));
 }