public function testGetResourceWithSoqlQuery()
{
$ds = new SodaDataset($this->client, $this->id);
$soql = new SoqlQuery();
$soql->select("date_posted", "state", "sample_type")->where("state = 'AR'");
$results = $ds->getDataset($soql);
$this->assertTrue(count($results) > 1);
}
public function testDeleteRow()
{
$ds = new SodaDataset($this->client, $this->id);
$soql = new SoqlQuery();
$soql->select(":id,date,os,visits");
$result = $ds->getDataset($soql);
$uID = $result[0][':id'];
$ds->deleteRow($uID);
$soql->select(':id')->where(':id = ' . $uID);
$new_result = $ds->getDataset($soql);
$this->assertEmpty($new_result);
}
public function testMultipleSelectsQuery()
{
$soql = new SoqlQuery();
$soql->select("first", "second")->select("third");
$expected = '$select=third';
$this->assertContains($expected, (string) $soql);
}
