Changeset 22842


Ignore:
Timestamp:
2013/05/31 11:55:54 (11 years ago)
Author:
nanasess
Message:

#150 (ユニットテスト環境の整備)

  • 汎用性向上
  • travis-ci でも正常セットアップできるように修正
Location:
branches/version-2_13-dev
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_13-dev/.travis.yml

    r22793 r22842  
    66 
    77env: 
    8   - DB=mysql USER=root 
    9   - DB=pgsql USER=postgres 
     8  - DB=mysql USER=root DBNAME=myapp_test DBPASS=' ' DBUSER=root 
     9  - DB=pgsql USER=postgres DBNAME=myapp_test DBPASS=password DBUSER=postgres 
    1010 
    1111before_script: 
    1212  - sh -c "if [ '$DB' = 'mysql' ]; then mysql -e 'CREATE DATABASE myapp_test;'; fi" 
    13   - sh -c "if [ '$DB' = 'mysql' ]; then mysql myapp_test < html/install/sql/create_table_mysql.sql; fi" 
    14   - sh -c "if [ '$DB' = 'mysql' ]; then mysql myapp_test < html/install/sql/insert_data.sql; fi" 
    15   - echo "<?php define('ECCUBE_INSTALL', 'ON');define('HTTP_URL', 'http://localhost/');define('HTTPS_URL', 'http://localhost/');define('ROOT_URLPATH', '/');define('DOMAIN_NAME', '');define('DB_TYPE', '$DB');define('DB_USER', '$USER');define('DB_PASSWORD', '');define('DB_SERVER', '127.0.0.1');define('DB_NAME', 'myapp_test');define('DB_PORT', '');define('ADMIN_DIR', 'admin/');define('ADMIN_FORCE_SSL', FALSE);define('ADMIN_ALLOW_HOSTS', 'a:0:{}');define('AUTH_MAGIC', 'chouteavaemicrouchaivojigiatriowioviamit');define('PASSWORD_HASH_ALGOS', 'sha256');define('MAIL_BACKEND', 'mail');define('SMTP_HOST', '');define('SMTP_PORT', '');define('SMTP_USER', '');define('SMTP_PASSWORD', '');" > data/config/config.php 
     13  - sh -c "if [ '$DB' = 'mysql' ]; then sh ./eccube_install.sh mysql; fi" 
    1614  - sh -c "if [ '$DB' = 'pgsql' ]; then psql -c 'create database myapp_test;' -U postgres; fi" 
    17   - sh -c "if [ '$DB' = 'pgsql' ]; then psql myapp_test < html/install/sql/create_table_pgsql.sql -U postgres; fi" 
    18   - sh -c "if [ '$DB' = 'pgsql' ]; then psql myapp_test < html/install/sql/insert_data.sql -U postgres; fi" 
     15  - sh -c "if [ '$DB' = 'pgsql' ]; then sh ./eccube_install.sh pgsql; fi" 
    1916  - cp tests/require.php.jenkins tests/require.php 
     17  - cat ./data/config/config.php 
    2018script: 
    2119  - phpunit --bootstrap ./data/config/config.php --configuration tests/phpunit.xml.jenkins tests 

  • branches/version-2_13-dev/eccube_install.sh

    r22143 r22842  
    2626 
    2727####################################################################### 
    28 # Configuration  
     28# Configuration 
    2929#-- Shop Configuration 
    3030CONFIG_PHP="data/config/config.php" 
    … …  
    3434HTTPS_URL=${HTTPS_URL:-"http://test.local/"} 
    3535DOMAIN_NAME=${DOMAIN_NAME:-""} 
     36 
     37DBSERVER=${DBSERVER-"127.0.0.1"} 
     38DBNAME=${DBNAME:-"cube213_dev"} 
     39DBUSER=${DBUSER:-"cube213_dev_user"} 
     40DBPASS=${DBPASS:-"password"} 
     41 
    3642ADMINPASS="f6b126507a5d00dbdbb0f326fe855ddf84facd57c5603ffdf7e08fbb46bd633c" 
    3743AUTH_MAGIC="droucliuijeanamiundpnoufrouphudrastiokec" 
    … …  
    4046 
    4147case "${DBTYPE}" in 
    42 "pgsql" )  
     48"pgsql" ) 
    4349    #-- DB Seting Postgres 
    4450    PSQL=psql 
    … …  
    4652    DROPDB=dropdb 
    4753    CREATEDB=createdb 
    48     DBSERVER="127.0.0.1" 
    49     DBNAME=cube212_dev 
    50     DBUSER=cube212_dev_user 
    51     DBPASS=password 
    5254    DBPORT=5432 
    5355;; 
    54 "mysql" )  
     56"mysql" ) 
    5557    #-- DB Seting MySQL 
    5658    MYSQL=mysql 
    5759    ROOTUSER=root 
    58     ROOTPASS=password 
     60    ROOTPASS=$DBPASS 
    5961    DBSERVER="127.0.0.1" 
    60     DBNAME=cube212_dev 
    61     DBUSER=cube212_dev_user 
    62     DBPASS=password 
    6362    DBPORT=3306 
    6463;; 
    … …  
    7069 
    7170####################################################################### 
    72 # Install  
     71# Install 
    7372 
    7473#-- Update Permissions 
    7574echo "update permissions..." 
    76 chmod -R 777 "./html" 
    77 chmod 755 "./data" 
    78 chmod -R 777 "./data/Smarty" 
    79 chmod -R 777 "./data/cache" 
    80 chmod -R 777 "./data/class" 
    81 chmod -R 755 "./data/class_extends" 
    82 chmod 777 "./data/config" 
    83 chmod -R 777 "./data/download" 
    84 chmod -R 777 "./data/downloads" 
    85 chmod 755 "./data/fonts" 
    86 chmod 755 "./data/include" 
    87 chmod 777 "./data/logs" 
    88 chmod -R 777 "./data/module" 
    89 chmod 755 "./data/smarty_extends" 
    90 chmod 777 "./data/upload" 
    91 chmod 777 "./data/upload/csv" 
     75chmod -R go+w "./html" 
     76chmod go+w "./data" 
     77chmod -R go+w "./data/Smarty" 
     78chmod -R go+w "./data/cache" 
     79chmod -R go+w "./data/class" 
     80chmod -R go+w "./data/class_extends" 
     81chmod go+w "./data/config" 
     82chmod -R go+w "./data/download" 
     83chmod -R go+w "./data/downloads" 
     84chmod go+w "./data/fonts" 
     85chmod go+w "./data/include" 
     86chmod go+w "./data/logs" 
     87chmod -R go+w "./data/module" 
     88chmod go+w "./data/smarty_extends" 
     89chmod go+w "./data/upload" 
     90chmod go+w "./data/upload/csv" 
    9291 
    9392#-- Setup Database 
    … …  
    10099fi 
    101100 
     101SEQUENCES=" 
     102dtb_best_products_best_id_seq 
     103dtb_bloc_bloc_id_seq 
     104dtb_category_category_id_seq 
     105dtb_class_class_id_seq 
     106dtb_classcategory_classcategory_id_seq 
     107dtb_csv_no_seq 
     108dtb_csv_sql_sql_id_seq 
     109dtb_customer_customer_id_seq 
     110dtb_deliv_deliv_id_seq 
     111dtb_holiday_holiday_id_seq 
     112dtb_kiyaku_kiyaku_id_seq 
     113dtb_mail_history_send_id_seq 
     114dtb_maker_maker_id_seq 
     115dtb_member_member_id_seq 
     116dtb_module_update_logs_log_id_seq 
     117dtb_news_news_id_seq 
     118dtb_order_order_id_seq 
     119dtb_order_detail_order_detail_id_seq 
     120dtb_other_deliv_other_deliv_id_seq 
     121dtb_pagelayout_page_id_seq 
     122dtb_payment_payment_id_seq 
     123dtb_products_class_product_class_id_seq 
     124dtb_products_product_id_seq 
     125dtb_review_review_id_seq 
     126dtb_send_history_send_id_seq 
     127dtb_mailmaga_template_template_id_seq 
     128dtb_plugin_plugin_id_seq 
     129dtb_plugin_hookpoint_plugin_hookpoint_id_seq 
     130dtb_api_config_api_config_id_seq 
     131dtb_api_account_api_account_id_seq 
     132" 
     133 
    102134echo "create optional SQL..." 
    103135echo "INSERT INTO dtb_member (member_id, login_id, password, salt, work, del_flg, authority, creator_id, rank, update_date) VALUES (2, 'admin', '${ADMINPASS}', '${AUTH_MAGIC}', '1', '0', '0', '0', '1', current_timestamp);" >> ${OPTIONAL_SQL_FILE} 
    104136echo "INSERT INTO dtb_baseinfo (id, shop_name, email01, email02, email03, email04, email05, top_tpl, product_tpl, detail_tpl, mypage_tpl, update_date) VALUES (1, '${SHOP_NAME}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', '${ADMIN_MAIL}', 'default1', 'default1', 'default1', 'default1', current_timestamp);" >> ${OPTIONAL_SQL_FILE} 
    105137 
    106  
    107138case "${DBTYPE}" in 
    108 "pgsql" )  
     139"pgsql" ) 
    109140    # PostgreSQL 
    110141    echo "dropdb..." 
    … …  
    116147    echo "insert data..." 
    117148    sudo -u ${PGUSER} ${PSQL} -U ${DBUSER} -f ${SQL_DIR}/insert_data.sql ${DBNAME} 
     149    for S in $SEQUENCES 
     150    do 
     151    echo "CREATE SEQUENCE $S START 10000;" >> ${OPTIONAL_SQL_FILE} 
     152    done 
    118153    echo "execute optional SQL..." 
    119154    sudo -u ${PGUSER} ${PSQL} -U ${DBUSER} -f ${OPTIONAL_SQL_FILE} ${DBNAME} 
    120155;; 
    121 "mysql" )  
     156"mysql" ) 
     157    DBPASS=`echo $DBPASS | tr -d " "` 
     158    if [ -n ${DBPASS} ]; then 
     159    PASSOPT="--password=$DBPASS" 
     160    CONFIGPASS=$DBPASS 
     161    fi 
    122162    # MySQL 
    123163    echo "dropdb..." 
    124     ${MYSQL} -u ${ROOTUSER} -p${ROOTPASS} -e "drop database ${DBNAME}" 
     164    ${MYSQL} -u ${ROOTUSER} ${PASSOPT} -e "drop database ${DBNAME}" 
    125165    echo "createdb..." 
    126     ${MYSQL} -u ${ROOTUSER} -p${ROOTPASS} -e "create database ${DBNAME}" 
     166    ${MYSQL} -u ${ROOTUSER} ${PASSOPT} -e "create database ${DBNAME}" 
    127167    #echo "grant user..." 
    128     #${MYSQL} -u ${ROOTUSER} -p${ROOTPASS} -e "GRANT ALL ON ${DBNAME}.* TO '${DBUSER}'@'%' IDENTIFIED BY '${DBPASS}'" 
     168    #${MYSQL} -u ${ROOTUSER} ${PASSOPT} -e "GRANT ALL ON ${DBNAME}.* TO '${DBUSER}'@'%' IDENTIFIED BY '${DBPASS}'" 
    129169    echo "create table..." 
    130     ${MYSQL} -u ${DBUSER} -p${DBPASS} ${DBNAME} < ${SQL_DIR}/create_table_mysql.sql 
     170    ${MYSQL} -u ${DBUSER} ${PASSOPT} ${DBNAME} < ${SQL_DIR}/create_table_mysql.sql 
    131171    echo "insert data..." 
    132     ${MYSQL} -u ${DBUSER} -p${DBPASS} ${DBNAME} < ${SQL_DIR}/insert_data.sql 
     172    ${MYSQL} -u ${DBUSER} ${PASSOPT} ${DBNAME} < ${SQL_DIR}/insert_data.sql 
     173    for S in $SEQUENCES 
     174    do 
     175    echo "CREATE TABLE $S ( sequence int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence)) ENGINE=MyISAM DEFAULT CHARSET=utf8; LOCK TABLES $S WRITE; INSERT INTO $S VALUES (10000); UNLOCK TABLES;" >> ${OPTIONAL_SQL_FILE} 
     176    done 
    133177    echo "execute optional SQL..." 
    134     ${MYSQL} -u ${DBUSER} -p${DBPASS} ${DBNAME} < ${OPTIONAL_SQL_FILE} 
     178    ${MYSQL} -u ${DBUSER} ${PASSOPT} ${DBNAME} < ${OPTIONAL_SQL_FILE} 
    135179;; 
    136180esac 
    … …  
    151195define('DB_TYPE', '${DBTYPE}'); 
    152196define('DB_USER', '${DBUSER}'); 
    153 define('DB_PASSWORD', '${DBPASS}'); 
     197define('DB_PASSWORD', '${CONFIGPASS}'); 
    154198define('DB_SERVER', '${DBSERVER}'); 
    155199define('DB_NAME', '${DBNAME}'); 
Note: See TracChangeset for help on using the changeset viewer.