Query查询

1 普通查询

$manager = new MongoDB\Driver\Manager();
$filter = [
    'genenane' => 'ABCG1'
];
$options = [];
$query = new MongoDB\Driver\Query($filter, $options);
$cursor = $manager->executeQuery('dbname.colname', $query);
$docs = $cursor->toArray();
var_dump($docs);

and查询

$filter = [
    'genenane' => 'ABCG1',
  'chrom' => '1',
  'pos' => [
    '$gte' => 1000,
    '$lte' => 2000
  ],
];

or查询

$filter = [
  '$or' => [
    ['het_sample' => 'S1'],
    ['hom_sample' => ['$in' => 'S1'] ]
  ]
];

Regex查询

正则查询无法使用索引？

$regex = new MongoDB\Bson\Regex('^abcg1$', 'i');  # i 忽略大小写
$filter = ['genename' => $regex];