Basic non-array field updating
[disclosr.git] / import.php
blob:a/import.php -> blob:b/import.php
--- a/import.php
+++ b/import.php
@@ -9,10 +9,10 @@
 $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;';
+$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;';
 $abntonames = Array();
 foreach ($conn->query($namesQ) as $row) {
-    $abntonames[$row['abn']] = explode(",", $row['names']);
+    $abntonames[$row['abn']] = explode("|", $row['names']);
 }
 $result = $conn->query("select * from agency");
 while ($agency = $result->fetch(PDO::FETCH_ASSOC)) {