PHP SchemaDef::CreateSchemaStatements 예제들

예제 #1

파일: upgrade_schema_0_2-0_4.php 프로젝트: psagi/cloudbank

#!/usr/bin/php
<?php 
require_once dirname(__FILE__) . '/../server/CloudBankServer.php';
require_once dirname(__FILE__) . '/../server/SchemaDef.php';
//   require_once('SCA/SCA.php');
CloudBankServer::Singleton()->tryQuery('
      ALTER TABLE event ADD statement_item_id VARCHAR(16)
   ');
CloudBankServer::Singleton()->tryQuery('
      ALTER TABLE event ADD is_cleared BOOLEAN DEFAULT 0
   ');
CloudBankServer::Singleton()->tryQuery('DROP VIEW account_events');
$g_createSchemaStatements = SchemaDef::CreateSchemaStatements();
foreach (array('account_events', 'statement_item', 'statement_item_unmatched', 'event_statement_item_match', 'event_matched') as $v_dBObject) {
    CloudBankServer::Singleton()->tryQuery($g_createSchemaStatements[$v_dBObject]);
}

예제 #2

파일: create_schema.php 프로젝트: psagi/cloudbank

#!/usr/bin/php
<?php 
require_once dirname(__FILE__) . '/../server/CloudBankServer.php';
require_once dirname(__FILE__) . '/../server/SchemaDef.php';
require_once 'SCA/SCA.php';
foreach (SchemaDef::CreateSchemaStatements() as $v_dBObject => $v_sQLStatement) {
    CloudBankServer::Singleton()->tryQuery($v_sQLStatement);
}
$v_ledgerAccountService = SCA::getService(dirname(__FILE__) . '/../server/LedgerAccountService.php');
$v_ledgerAccountService->createBeginningAccount();