dds_schema_test.php

<?php
/**
 * Test DDS Schema creation
 *
 * @author    Aaron Harris <aharris@intacct.com>
 * @copyright 2000-2014 Intacct Corporation
 *
 * This document contains trade secret data that belongs to Intacct
 * Corporation and is protected by the copyright laws.  Information
 * herein may not be used, copied or disclosed in whole or in part
 * without prior written consent from Intacct Corporation.
 */

// simple test to see if we can create a database
require_once 'intacctws-php/api_session.php';
require_once 'intacctws-php/api_post.php';

require_once 'DdsLoader/DdsDbManager.php';
require_once 'DdsLoader/DdsController.php';
require_once 'DdsLoader/DBs/DdsDbRedshift.php';

try {

    $memcache = new Memcache();
    $memcache->connect("localhost", 11211);
    $key = 'dds_loader_test_session';
    $session = $memcache->get($key);
    if ($session === false) {
        $session = new api_session();
        $session->connectCredentials(
            $_SERVER['IntacctCompanyId'],
            $_SERVER['IntacctUserId'],
            $_SERVER['IntacctPwd'],
            $_SERVER['SenderId'],
            $_SERVER['SenderPwd']
        );
        $memcache->set($key, $session, null, 300);
    }

    $intacctPg = new DdsDbRedshift(
        $_SERVER['RedShiftURL'],
        $_SERVER['RedShiftDB'],
        $_SERVER['RedShiftUser'],
        $_SERVER['RedShiftPwd']
    );

    //DdsDbManager::rebuildSchema($intacctPg, $session);
    DdsController::runDdsJob('ardetail', api_post::DDS_JOBTYPE_ALL, $session);


    echo "done!";
}
catch (Exception $ex) {
    print_r($ex->getMessage());
    print_r(api_post::getLastRequest());
    print_r(api_post::getLastResponse());
}