Configuration

Database connect setting

You can change connect configuration on code/config/database_config.php.

database_config.php

<?php
/**
 * データベース接続先設定
 * Database connect information
 * @see Database.php
 */
// 本番環境
// Production environment
if (false) {

    // Database(Master)設定（１台を想定）
    // Database for Master
    $database_config['master'] = array(
        'dsn' => 'sqlite:'.FEGG_CODE_DIR.'/data/db/db.db',
        'username' => '',
        'password' => ''
    );

    // Database(Slave)設定（複数台を想定）
    // Database for Slave
    $database_config['slave'][] = array(
        'dsn' => 'sqlite:'.FEGG_CODE_DIR.'/data/db/db.db',
        'username' => '',
        'password' => ''
    );

// 開発環境
// Development Environment
} else {

    // Database(Master)設定（１台を想定）
    // Database for Master
    $database_config['master'] = array(
        'dsn' => 'sqlite:'.FEGG_CODE_DIR.'/data/db/db.db',
        'username' => '',
        'password' => ''
    );

    // Database(Slave)設定（複数台を想定）
    // Database for Slave
    $database_config['slave'][] = array(
        'dsn' => 'sqlite:'.FEGG_CODE_DIR.'/data/db/db.db',
        'username' => '',
        'password' => ''
    );

}
/* End of file database_config.php */

Automatic append query configuration

You can arrange automatic append query configuration on code/config/database_regular_use_query.php.

database_regular_use_query.php

<?php
/**
 * 自動的付加クエリー
 * Automatic append query
 * @see Database.php
 *
 * DBクラスのselect, insert, update, deleteメソッド実行時に自動的付加するクエリー
 * （必要に応じて拡張していく予定）
 *
 * Automaticaly append query that "select", "insert", "update", "delete" method in DB Class.
 */
$database_regular_use_query = array(
    // テーブルに関わらず付加されるクエリー
    // Appended query regardless of table
    'regular_use' => array(
        'select' => array(
            'where' => 'CURRENT_TABLE.valid = 1',
            'order' => '',
        ),
        'count' => array(
            'where' => 'CURRENT_TABLE.valid = 1',
            'order' => '',
        ),
        'insert' => array(
            'item' => 'modified = now(), created = now(), valid = 1',
        ),
        'update' => array(
            'item' => "modified = now()",
            'where' => '',
        ),
    ),

    /*
    // テーブルに応じて付加されるクエリー
    // Appended query depending on table
    'table' => array(
        'table_name' => array(
            'select' => array(
                'where' => 'show_flag = 0',
                'order' => '',
            ),
            'insert' => array(
                'item' => 'update_time = now(), create_datetime = now()',
            ),
            'update' => array(
                'item' => 'update_time = now()',
                'where' => '',
            ),
        ),
    ),
    */
);
/* End of file database_regular_use_query.php */