--- a/import.php +++ b/import.php @@ -1,7 +1,6 @@ setDatabase("disclosr-agencies", true); +$db = $server->get_db('disclosr-agencies'); //createAgencyDesignDoc(); $conn = new PDO("pgsql:dbname=contractDashboard;user=postgres;password=snmc;host=localhost"); $namesQ = 'select agency.abn, string_agg("agencyName",\',\') as names from agency inner join agency_nametoabn on agency.abn::text = agency_nametoabn.abn group by agency.abn;'; @@ -16,7 +15,8 @@ if (sizeof($abntonames[$agency['abn']]) == 1) $agency['name'] = $abntonames[$agency['abn']][0]; $agency["lastScraped"] = "1/1/1970"; $agency["scrapeDepth"] = 1; - $sag->post($agency); + $doc = $db->save($agency); +print_r($doc); } ?>