Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh

    Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh

    Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

    revision 8489 by niro, Fri Feb 5 12:30:35 2016 UTC revision 8499 by niro, Fri Feb 5 14:03:20 2016 UTC
    # Line 90  sql_create_table() Line 90  sql_create_table()
    90    
    91   for ((i=1; i<count; i++))   for ((i=1; i<count; i++))
    92   do   do
    93   line="${TABLE_DEFINITION[${i}]}"   line=( ${TABLE_DEFINITION[${i}]} )
    94   column="${line%% *}"   column="${line[0]}"
    95   opts="${line/${column} /}"   opts="${line[*]:1}"
    96    
    97   case ${opts} in   case ${opts} in
    98   *"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;   *"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
    # Line 123  sql_create_table() Line 123  sql_create_table()
    123   fi   fi
    124  }  }
    125    
    126    # TABLE_DEFINITION=(
    127    # "table_name"
    128    # "column1_name after_column column1_argvs"
    129    # "column2_name after_column column2_argvs"
    130    # "columnN_name after_column columnN_argvs"
    131    # )
    132    sql_add_column()
    133    {
    134     local table
    135     local count
    136     local i
    137     local line
    138     local opts
    139     local column
    140     local autoincrement
    141     local primary
    142    
    143     table="${TABLE_DEFINITION[0]}"
    144     count="${#TABLE_DEFINITION[*]}"
    145    
    146     for ((i=1; i<count; i++))
    147     do
    148     line=( ${TABLE_DEFINITION[${i}]} )
    149     column="${line[0]}"
    150     after="${line[1]}"
    151     opts="${line[*]:2}"
    152    
    153     case ${opts} in
    154     *"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
    155     *"primary key"*) opts="${opts//primary key}"; primary="${column}" ;;
    156     esac
    157    
    158     case ${opts} in
    159     *AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;;
    160     *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
    161     esac
    162    
    163     mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts}) AFTER ${after_column};" || die "add column '${table}'"
    164     done
    165    
    166     if [[ -n ${primary} ]]
    167     then
    168     mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
    169     fi
    170     if [[ -n ${autoincrement} ]]
    171     then
    172     mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'"
    173     fi
    174    }
    175    
    176    # TABLE_DEFINITION=(
    177    # "table_name"
    178    # "column1_name column1_argvs"
    179    # "column2_name column2_argvs"
    180    # "columnN_name columnN_argvs"
    181    # )
    182    sql_modify_column()
    183    {
    184     local table
    185     local count
    186     local i
    187     local line
    188     local opts
    189     local column
    190     local autoincrement
    191     local primary
    192    
    193     table="${TABLE_DEFINITION[0]}"
    194     count="${#TABLE_DEFINITION[*]}"
    195    
    196     for ((i=1; i<count; i++))
    197     do
    198     line=( ${TABLE_DEFINITION[${i}]} )
    199     column="${line[0]}"
    200     opts="${line[*]:1}"
    201    
    202     case ${opts} in
    203     *"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
    204     *"primary key"*) opts="${opts//primary key}"; primary="${column}" ;;
    205     esac
    206    
    207     case ${opts} in
    208     *AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;;
    209     *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
    210     esac
    211    
    212     mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts});" || die "modify table '${table}'"
    213     done
    214    
    215     if [[ -n ${primary} ]]
    216     then
    217     mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
    218     fi
    219     if [[ -n ${autoincrement} ]]
    220     then
    221     mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'"
    222     fi
    223    }
    224    
    225  # VALUE_DEFINITION=(  # VALUE_DEFINITION=(
    226  # "table_name, value_column_name, bool_column_name, id_column_name"  # "table_name, value_column_name, bool_column_name, id_column_name"
    227  # "value1, bool1"  # "value1, bool1"
    # Line 176  sql_set_value() Line 275  sql_set_value()
    275   done   done
    276  }  }
    277    
     update_to_database_schema_version_2()  
     {  
      return 0  
     }  
       
     update_to_database_schema_version_3()  
     {  
      return 0  
     }  
       
    278  create_database()  create_database()
    279  {  {
    280   create_database_schema   create_database_schema
    281    
    282     # update database schema version
    283     mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_schema(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating schema version"
    284  }  }
    285    
    286  update_database()  update_database()
    287  {  {
    288   local current_sql_db_version   local current_sql_db_schema_version
    289   local i   local i
    290    
    291   current_sql_db_version=$(mysqldo "SELECT MAX(version) from meta;")   current_sql_db_schema_version=$(mysqldo "SELECT MAX(version) from meta_schema;")
    292    
    293   if [[ ${current_sql_db_version} = ${MCORE_SQL_DB_VERSION} ]]   if [[ ${current_sql_db_schema_version} = ${MCORE_SQL_DB_SCHEMA_VERSION} ]]
    294   then   then
    295   echo "Database is already up to date"   echo "Database is already up to date"
    296   return 0   return 0
    297   fi   fi
    298    
    299   # run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_VERSION   # run every update_to_database_version_X script which exist up to version MCORE_SQL_DB_SCHEMA_VERSION
    300   for i in $(seq $((${current_sql_db_version}+1)) ${MCORE_SQL_DB_VERSION})   for i in $(seq $((${current_sql_db_schema_version}+1)) ${MCORE_SQL_DB_SCHEMA_VERSION})
    301   do   do
    302   if [[ -n $(typeset -f update_to_database_version_${i}) ]]   if [[ -n $(typeset -f update_to_database_schema_version_${i}) ]]
    303   then   then
    304   echo "Running update_to_database_schema_version_${i}()"   echo "Running update_to_database_schema_version_${i}()"
    305   update_to_database_schema_version_${i}   update_to_database_schema_version_${i} || die
    306   fi   fi
    307   done   done
    308    
    309     # update database schema version
    310     mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_schema(version) VALUES ('${MCORE_SQL_DB_SCHEMA_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_SCHEMA_VERSION}';" || die "updating schema version"
    311  }  }
    312    
    313  fill_database()  fill_database()
    314  {  {
    315     local current_sql_db_values_version
    316     local i
    317    
    318     current_sql_db_values_version=$(mysqldo "SELECT MAX(version) from meta_values;")
    319    
    320     if [[ ${current_sql_db_values_version} = ${MCORE_SQL_DB_VALUES_VERSION} ]]
    321     then
    322     echo "Database values are already up to date"
    323     return 0
    324     fi
    325    
    326   create_database_values   create_database_values
    327     # update database values version
    328     mysqldo "INSERT INTO ${MCORE_SQL_DB}.meta_values(version) VALUES ('${MCORE_SQL_DB_VALUES_VERSION}') ON DUPLICATE KEY UPDATE version='${MCORE_SQL_DB_VALUES_VERSION}';" || die "updating values version"
    329  }  }
    330    
    331  case $1 in  case $1 in
    Legend:
    Removed from v.8489  
    changed lines
      Added in v.8499