* * 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);