$this->database->select(
$sql['tables'],
$sql['fields'],
- isset( $sql['conds'] ) ? $sql['conds'] : [],
+ $sql['conds'] ?? [],
__METHOD__,
- isset( $sql['options'] ) ? $sql['options'] : [],
- isset( $sql['join_conds'] ) ? $sql['join_conds'] : []
+ $sql['options'] ?? [],
+ $sql['join_conds'] ?? []
);
$this->assertLastSql( $sqlText );
}
$this->database->selectRowCount(
$sql['tables'],
$sql['field'],
- isset( $sql['conds'] ) ? $sql['conds'] : [],
+ $sql['conds'] ?? [],
__METHOD__,
- isset( $sql['options'] ) ? $sql['options'] : [],
- isset( $sql['join_conds'] ) ? $sql['join_conds'] : []
+ $sql['options'] ?? [],
+ $sql['join_conds'] ?? []
);
$this->assertLastSql( $sqlText );
}
$sql['values'],
$sql['conds'],
__METHOD__,
- isset( $sql['options'] ) ? $sql['options'] : []
+ $sql['options'] ?? []
);
$this->assertLastSql( $sqlText );
}
$sql['table'],
$sql['rows'],
__METHOD__,
- isset( $sql['options'] ) ? $sql['options'] : []
+ $sql['options'] ?? []
);
$this->assertLastSql( $sqlText );
}
$sql['varMap'],
$sql['conds'],
__METHOD__,
- isset( $sql['insertOptions'] ) ? $sql['insertOptions'] : [],
- isset( $sql['selectOptions'] ) ? $sql['selectOptions'] : [],
- isset( $sql['selectJoinConds'] ) ? $sql['selectJoinConds'] : []
+ $sql['insertOptions'] ?? [],
+ $sql['selectOptions'] ?? [],
+ $sql['selectJoinConds'] ?? []
);
$this->assertLastSql( $sqlTextNative );
$sql['varMap'],
$sql['conds'],
__METHOD__,
- isset( $sql['insertOptions'] ) ? $sql['insertOptions'] : [],
- isset( $sql['selectOptions'] ) ? $sql['selectOptions'] : [],
- isset( $sql['selectJoinConds'] ) ? $sql['selectJoinConds'] : []
+ $sql['insertOptions'] ?? [],
+ $sql['selectOptions'] ?? [],
+ $sql['selectJoinConds'] ?? []
);
$this->assertLastSqlDb( implode( '; ', [ $sqlSelect, 'BEGIN', $sqlInsert, 'COMMIT' ] ), $dbWeb );
}
$params['table'],
$params['vars'],
$params['permute_conds'],
- isset( $params['extra_conds'] ) ? $params['extra_conds'] : '',
+ $params['extra_conds'] ?? '',
'FNAME',
- isset( $params['options'] ) ? $params['options'] : [],
- isset( $params['join_conds'] ) ? $params['join_conds'] : []
+ $params['options'] ?? [],
+ $params['join_conds'] ?? []
) );
$this->assertEquals( $expect, $sql );
}