// ############################################
echo '<h3>fetchManyCursor</h3>';
$counter = 0;
foreach ($dbh->fetchRowManyCursor($query, $conds) as $result) {
echo '<h4>#' . ++$counter . ' cursor</h4>';
var_dump($result);
}
// ############################################
echo '<h3>execute sql: truncate</h3>';
$response = $dbh->executeSql('TRUNCATE import_dump');
var_dump($response);
// ############################################
echo '<h3>insert</h3>';
echo '<h4>with ID response</h4>';
$data = ['id' => null, 'dump' => '{"message":"#One"}'];
$results = $dbh->insert('import_dump', $data);
var_dump($results);
echo '<h4>with NO-ID response</h4>';
$data = ['dump' => '{"message":"#One"}'];
$results = $dbh->insert('import_dump_no_id', $data);
var_dump($results);
// ############################################
echo '<h3>insertMany</h3>';
echo '<h4>with ID response</h4>';
$data = [['id' => null, 'dump' => '{"message":"Hello"}'], ['id' => null, 'dump' => '{"message":"Foo"}'], ['id' => null, 'dump' => '{"message":"Bar"}']];
$results = $dbh->insertMany('import_dump', $data);
var_dump($results);
echo '<h4>with NO-ID response</h4>';
$data = [['dump' => '{"message":"Hello"}'], ['dump' => '{"message":"Foo"}'], ['dump' => '{"message":"Bar"}']];
$results = $dbh->insertMany('import_dump_no_id', $data);
var_dump($results);
<?php
require __DIR__ . '/vendor/autoload.php';
require __DIR__ . '/config/config.php';
exit;
$vk = new \BW\Vkontakte($config['vk']);
$dbConn = new \Simplon\Mysql\Mysql($config['db']['host'], $config['db']['user'], $config['db']['password'], $config['db']['database']);
require __DIR__ . '/prepare-db.php.php';
// get group info
$group = $vk->api('groups.getById', ['group_id' => $config['group_id'], 'fields' => 'members_count'])[0];
$dbConn->insert('groups', ['vk_id' => $group['id']]);
$request_count = 1000;
$members_count = $group['members_count'];
$iterations_count = $members_count / $request_count;
for ($i = 0; $i < $iterations_count; $i++) {
echo 'Fetching users ' . $request_count * $i . ' - ' . ($request_count * $i + $request_count) . PHP_EOL;
$members = $vk->api('groups.getMembers', ['group_id' => $config['group_id'], 'fields' => 'sex,bdate', 'offset' => $request_count * $i, 'count' => $request_count]);
echo 'Inserting them to database' . PHP_EOL;
foreach ($members['items'] as $member) {
$birth_date = null;
if (isset($member['bdate'])) {
$bdateParts = explode('.', $member['bdate']);
$birth_date = count($bdateParts) == 3 ? implode('-', array_reverse($bdateParts)) : null;
}
$putMemeber = ['vk_id' => $member['id'], 'sex' => $member['sex'], 'birth_date' => $birth_date];
try {
$dbConn->insert('members', $putMemeber);
} catch (Exception $e) {
}
}
}
