*
* The latest code can be found at <http://exakat.io/>.
*
*/
$rows = glob('projects/*', GLOB_ONLYDIR);
$finals = [];
foreach ($rows as $row) {
// print $row."\n";
$final = [basename($row)];
$sqliteFilename = $row . '/datastore.sqlite';
if (!file_exists($sqliteFilename)) {
print "No {$sqliteFilename}\n";
continue;
}
$sqlite = new \Sqlite3($sqliteFilename);
$res = $sqlite->querySingle('SELECT name FROM sqlite_master WHERE type="table" AND name="hash";');
if ($res === null) {
print "No hash table in {$row}\n";
continue;
}
$res = $sqlite->query('SELECT * FROM hash WHERE key = "loc";');
$sqlRow = $res->fetchArray();
$final[] = $sqlRow['value'];
$res = $sqlite->query('SELECT * FROM hash WHERE key = "tokens";');
$sqlRow = $res->fetchArray();
$final[] = $sqlRow['value'];
$finals[] = $final;
}
$fp = fopen('size.csv', 'w+');
foreach ($finals as $final) {
fputcsv($fp, $final);
