class Ideone {
public static void onUpgrade( int oldVersion, int newVersion) {
System .
out .
println ( String .
format ( "***from %d to %d***" , oldVersion, newVersion
) ) ; switch ( oldVersion) {
case 10 : // from 10 to 11 and go to next case
System .
out .
println ( " TABLE_MAIN_UPGRADE_10_11" ) ; case 11 : // from 11 to 12 and go to next case
System .
out .
println ( " TABLE_MAIN_UPGRADE_11_12" ) ; case 12 : // from 12 to 13 and go to next case
System .
out .
println ( " TABLE_MAIN_UPGRADE_12_13" ) ; case 13 : // from 13 to newVersion
System .
out .
println ( " TABLE_MAIN_UPGRADE_13_14" ) ; break ;
default :
System .
out .
println ( " DROP AND CREATE" ) ; break ;
}
}
int newVersion = 14 ;
for ( int i = 5 ; i < newVersion; i++ )
onUpgrade( i, newVersion) ;
}
}
Y2xhc3MgSWRlb25lIHsKICAgIHB1YmxpYyBzdGF0aWMgdm9pZCBvblVwZ3JhZGUoaW50IG9sZFZlcnNpb24sIGludCBuZXdWZXJzaW9uKSB7CiAgICAgICAgU3lzdGVtLm91dC5wcmludGxuKFN0cmluZy5mb3JtYXQoIioqKmZyb20gJWQgdG8gJWQqKioiLCBvbGRWZXJzaW9uLCBuZXdWZXJzaW9uKSk7CiAgICAgICAgc3dpdGNoIChvbGRWZXJzaW9uKSB7CiAgICAgICAgICAgIGNhc2UgMTA6IC8vIGZyb20gMTAgdG8gMTEgYW5kIGdvIHRvIG5leHQgY2FzZQogICAgICAgICAgICAgICAgU3lzdGVtLm91dC5wcmludGxuKCIJVEFCTEVfTUFJTl9VUEdSQURFXzEwXzExIik7CiAgICAgICAgICAgIGNhc2UgMTE6IC8vIGZyb20gMTEgdG8gMTIgYW5kIGdvIHRvIG5leHQgY2FzZQogICAgICAgICAgICAgICAgU3lzdGVtLm91dC5wcmludGxuKCIJVEFCTEVfTUFJTl9VUEdSQURFXzExXzEyIik7CiAgICAgICAgICAgIGNhc2UgMTI6IC8vIGZyb20gMTIgdG8gMTMgYW5kIGdvIHRvIG5leHQgY2FzZQogICAgICAgICAgICAgICAgU3lzdGVtLm91dC5wcmludGxuKCIJVEFCTEVfTUFJTl9VUEdSQURFXzEyXzEzIik7CiAgICAgICAgICAgIGNhc2UgMTM6IC8vIGZyb20gMTMgdG8gbmV3VmVyc2lvbgogICAgICAgICAgICAgICAgU3lzdGVtLm91dC5wcmludGxuKCIJVEFCTEVfTUFJTl9VUEdSQURFXzEzXzE0Iik7CiAgICAgICAgICAgICAgICBicmVhazsKICAgICAgICAgICAgZGVmYXVsdDoKICAgICAgICAgICAgICAgIFN5c3RlbS5vdXQucHJpbnRsbigiCURST1AgQU5EIENSRUFURSIpOwogICAgICAgICAgICAgICAgYnJlYWs7CiAgICAgICAgfQogICAgfQoKICAgIHB1YmxpYyBzdGF0aWMgdm9pZCBtYWluKFN0cmluZ1tdIGFyZ3MpIHRocm93cyBqYXZhLmxhbmcuRXhjZXB0aW9uIHsKICAgICAgICBpbnQgbmV3VmVyc2lvbiA9IDE0OwogICAgICAgIGZvciAoaW50IGkgPSA1OyBpIDwgbmV3VmVyc2lvbjsgaSsrKQogICAgICAgICAgICBvblVwZ3JhZGUoaSwgbmV3VmVyc2lvbik7CiAgICB9Cn0=