public function dataProvider()
{
return [["SELECT foo.* FROM foo", 'foo'], ["SELECT foo.* FROM foo", 'foo', '*'], ["SELECT f.* FROM foo AS f", 'foo f'], ["SELECT f.* FROM foo AS f", 'foo AS f'], ["SELECT f.* FROM foo AS f", 'foo as f'], ["SELECT f.* FROM foo AS f", ' foo as f '], ["SELECT foo.bar, foo.qux AS q FROM foo", 'foo', ['bar', 'q' => 'qux']], ["SELECT bar, qux AS q FROM foo", 'foo', 'bar, qux AS q'], ["SELECT f.bar, f.qux AS q FROM foo AS f", 'foo f', ['bar', 'q' => 'qux']], ["SELECT COUNT(*) AS c FROM foo AS f", 'foo f', ['c' => 'COUNT(*)']], ["SELECT CURRENT_TIMESTAMP, f.bar AS b FROM foo AS f", 'foo f', ['#CURRENT_TIMESTAMP', 'b' => 'bar']], ["SELECT CURRENT_TIMESTAMP, f.bar AS b FROM foo AS f", 'foo f', [ConnectionManager::raw('CURRENT_TIMESTAMP'), 'b' => 'bar']]];
}
public function dataProviderTestBind()
{
return [["foo = 1", 'foo', 1], ["foo = 1", 'foo = ?', 1], ["foo != 1", 'foo != ?', 1], ["foo = 'foo'", 'foo', 'foo'], ["foo IS NULL", 'foo', null], ["foo IS NOT NULL", 'foo != ?', null], ["foo IN (1, 2, 3)", 'foo IN (?)', [1, 2, 3]], ["foo NOT IN (1, 2, 3)", 'foo NOT IN (?)', [1, 2, 3]], ["foo IN (SELECT 1, 2, 3)", 'foo IN(?)', ConnectionManager::raw('SELECT 1, 2, 3')], ["foo LIKE '%foo%'", "foo LIKE %?%", 'foo'], ["foo LIKE '%foo'", "foo LIKE %?", 'foo'], ["foo LIKE 'foo%'", "foo LIKE ?%", 'foo'], ["foo = 1 bar = 'bar'", 'foo = ? bar = ?', [1, 'bar']], ["foo = 1 bar = 'bar'", 'foo = :foo bar = :bar', ['foo' => 1, 'bar' => 'bar']]];
}
