PHP SQLBuilder\Universal\Query CreateIndexQuery::spatial Examples

Example #1

File: CreateIndexQueryTest.php Project: Ruyka/SQLBuilder

 public function testCreateSpatialIndex()
 {
     $q = new CreateIndexQuery();
     $q->spatial('salary_idx')->on('employees', ['last_name', 'salary']);
     $this->assertSql('CREATE SPATIAL INDEX `salary_idx` ON `employees` (last_name,salary)', $q);
 }