<?php
require 'vendor/autoload.php';
require 'rb.php';
R::setup('mysql:host=localhost;dbname=chai-crm', 'chai-crm', '6TWe9K7NPzT6jNDP');
R::freeze(TRUE);
$client = new Everyman\Neo4j\Client();
$client->getTransport()->setAuth('neo4j', 'neo4j');
// Get all nodes : AKA Tables
$nodeNames = array();
foreach ($client->GetLabels() as $label) {
$node = $label->getName();
if ($node[0] != "_") {
$nodeNames[] = $node;
}
}
// Get each nodes properties
foreach ($nodeNames as $nodeName) {
$queryString = "MATCH (n:`" . $nodeName . "`) return count(n) as count";
$query = new Everyman\Neo4j\Cypher\Query($client, $queryString);
$result = $query->getResultSet();
$count = 0;
foreach ($result as $row) {
$count = $row["count"];
}
echo "Total Count for {$nodeName}: {$count} \n";
$mysql_count = 0;
try {
$mysql_count = R::count($nodeName);
} catch (Exception $e) {
echo "Records do not exist for {$nodeName} in MySQL\n";