Changeset 11672

Timestamp:

May 18, 2009, 4:37:47 PM (13 years ago)

Author:

fukamachi

Message:

DBコンバータ - インストール時に入力されたデータ(管理者アカウントなど)を削除させる

Location:

OpenPNE/branches/work/fukamachi/db_converter

Files:

• db_converter.php (modified) (3 diffs)
• db_relation.yml (modified) (7 diffs)

OpenPNE/branches/work/fukamachi/db_converter/db_converter.php

@@ -34 +34 @@
 // 対応表からSQLを生成
 $insert_ary = array();
+$delete_ary = array();
 foreach ($sql_list as $sql) {
+    if (array_key_exists('clear', $sql) && $sql['clear'] === 1) {
+        array_push($delete_ary, clear_record_installed($sql['table']));
+    }
+
     $insert;
     if (array_key_exists('special', $sql) && $sql['special'] === 1) {
@@ -46 +51 @@
 
 // とりあえず出力
+print_r($delete_ary);
 print_r($insert_ary);
 
@@ -162 +168 @@
 }
 
+/******************************
+ * インストールレコードの削除 *
+ ******************************/
+
+function clear_record_installed($table)
+{
+    return 'DELETE FROM `'.$table.'`';
+}
 
 /**********************

OpenPNE/branches/work/fukamachi/db_converter/db_relation.yml

@@ -1 +1 @@
 - table: admin_user
   column: [id, username, password]
+  clear: 1
   sql: >
     SELECT
@@ -44 +45 @@
 - table: community_category
   special: 1
+  clear: 1
   column: [id, lft_key, rht_key, tree_key, name, sort_order, is_allow_member_community]
   sql1: >
@@ -278 +280 @@
 - table: member
   special: 1
+  clear: 1
   column: [id, name, is_active, invite_member_id, created_at, updated_at]
   sql1: >
@@ -299 +302 @@
 - table: member_config
   special: 1
+  clear: 1
   column: [id, member_id, name, value]
   sql: >
@@ -353 +357 @@
 - table: member_profile
   special: 1
+  clear: 1
   # public_flag は3.0.3以降で実装
   column: [id, lft_key, rht_key, tree_key, member_id, profile_id, profile_option_id, value, public_flag]
@@ -497 +502 @@
 
 - table: profile
+  clear: 1
   column: [id, name, is_required, is_unique, form_type, value_type, value_regexp, value_min, value_max, is_disp_regist, is_disp_config, is_disp_search, sort_order]
   sql: >
@@ -516 +522 @@
 
 - table: profile_option
+  clear: 1
   column: [id, profile_id, sort_order]
   sql: >