/**
* @param $sub
* @return \CatLab\OpenIDClient\Models\User|null
*/
public function getFromSubject($sub)
{
$query = new Query("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\t{$this->table_users}\n\t\t\tWHERE\n\t\t\t\tu_sub = ?\n\t\t");
$query->bindValue(1, $sub);
return $this->getSingle($query->execute());
}
/**
* @param $username
* @return \CatLab\Accounts\Models\User|null
*/
public function getFromUsername($username)
{
$query = new Query("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\t{$this->table_users}\n\t\t\tWHERE\n\t\t\t\tu_username = ?\n\t\t");
$query->bindValue(1, $username);
return $this->getSingle($query->execute());
}
/**
* @test
*/
public function testStupidZeroBasedQuestionmarks()
{
// Insert
$query = new Query("INSERT INTO `table` SET m_id = ?, m_test = ?, m_next = ?");
$query->bindValue(0, 1);
$query->bindValue(1, 'test string with a random :m_next parameter in it.');
$query->bindValue(2, 'another parameter');
$expected = "INSERT INTO `table` SET m_id = 1, m_test = 'test string with a random :m_next parameter in it.', m_next = 'another parameter'";
$this->assertEquals($expected, $query->getParsedQuery());
}