Ejemplos de DataImporter::get_meter_id en PHP

Ejemplo n.º 1

Archivo: build_db.php Proyecto: jacobm001/independence_water

#!/usr/bin/php
<?php 
include "../api/Init.php";
include "../api/DataImporter.php";
$objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator("./historical_data"));
$Regex = new RegexIterator($objects, '/^.+\\.txt$/i', RecursiveRegexIterator::GET_MATCH);
foreach ($Regex as $name => $object) {
    echo "Importing file: " . $name . "\n";
    $DI = new DataImporter($db, file_get_contents($name));
    // most of the supplied files have the address as part of the filename
    $str = explode("/", $name);
    if (count($str) == 4) {
        $query = "insert into meter_info(`meter_id`, `address`) values(:meter_id, :address);";
        $stmt = $db->prepare($query);
        $id = $DI->get_meter_id();
        $stmt->bindParam(':meter_id', $id);
        $stmt->bindParam(':address', $str[2]);
        $stmt->execute();
    } else {
        $query = "insert into meter_info(`meter_id`, `address`) values(:meter_id, 'unknown');";
        $stmt = $db->prepare($query);
        $id = $DI->get_meter_id();
        $stmt->bindParam(':meter_id', $id);
        $stmt->execute();
    }
}