archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/util/NthLevelConverter.java

   1 /*
   2  * Created on 11/08/2003
   3  *
   4  */
   5 package com.quantum.util;
   6
   7 import java.util.Iterator;
   8 import java.util.Vector;
   9
  10 import com.quantum.QuantumPlugin;
  11
  12 import org.eclipse.jface.preference.IPreferenceStore;
  13
  14 /**
  15  * Class to clasify two levels of strings. It's called Nth Level but in fact it has only two levels :o)
  16  * @author panic
  17  *
  18  */
  19 public class NthLevelConverter {
  20         private final int DEFAULT_COLUMNS = 10;
  21         private final int DEFAULT_INCREMENT = 10;
  22
  23         private Vector upper = new Vector(DEFAULT_COLUMNS,DEFAULT_INCREMENT);
  24
  25         public void add(String id, String parentId, int level) {
  26                 OneLevelConverter upperLine = new OneLevelConverter(id);
  27                 if (level == 1) { // If it's an upper leaf
  28                         if (!upper.contains(upperLine))
  29                                 this.upper.add(upperLine);
  30                 }
  31                 else if (level == 0) { // It's a lower leaf
  32                         if  (parentId == null) return; // No parent, what shall we do.
  33                         OneLevelConverter upperFinder = new OneLevelConverter(parentId);
  34                         // Search if its parent is already present in the upper level
  35                         int ind = upper.indexOf(upperFinder);
  36                         // If not, addIt and find its index
  37                         if (ind < 0) {
  38                                 this.upper.add(upperFinder);
  39                                 ind = upper.indexOf(upperFinder);
  40                         }
  41                         OneLevelConverter upperItem = (OneLevelConverter) upper.get(ind);
  42                         // If it has no children, we create a new Vector for the children
  43                         if (upperItem.getLower() == null)
  44                                 upperItem.setLower(new Vector(DEFAULT_COLUMNS,DEFAULT_INCREMENT));
  45                         Vector children = upperItem.getLower();
  46                         // Is the item already present in the children of its parent?
  47                         int indChildren = children.indexOf(id);
  48                         // If it's not, we add it
  49                         if (indChildren < 0) {
  50                                 OneLevelConverter leaf = new OneLevelConverter(id);
  51                                 children.add(leaf);
  52                         }
  53                 }
  54
  55         }
  56
  57
  58         /**
  59          * @return
  60          */
  61         public Vector getUpper() {
  62                 return upper;
  63         }
  64
  65         public Vector getLevel(String id, int level){
  66                 if (level == 1)
  67                         return upper;
  68                 else if (level == 0){
  69                         if (id == null) return null;
  70                         OneLevelConverter upperFinder = new OneLevelConverter(id);
  71                         int ind = upper.indexOf(upperFinder);
  72                         if (ind < 0)
  73                                 return null;
  74                         else {
  75                                 OneLevelConverter upperItem = (OneLevelConverter) upper.get(ind);
  76                                 return upperItem.getLower();
  77                         }
  78                 }
  79                 return null;
  80         }
  81
  82         public void convert(String ind){
  83                 IPreferenceStore store = QuantumPlugin.getDefault().getPreferenceStore();
  84
  85                 String tableItem = QuantumUtil.trasposeEscape(store.getString("customCopyTableItem" + ind));
  86                 String tableSeparator = QuantumUtil.trasposeEscape(store.getString("customCopyTableSeparator" + ind));
  87                 String columnItem = QuantumUtil.trasposeEscape(store.getString("customCopyColumnItem" + ind));
  88                 String columnSeparator = QuantumUtil.trasposeEscape(store.getString("customCopyColumnSeparator" + ind));
  89
  90                 for (Iterator iter = upper.iterator(); iter.hasNext();) {
  91                         OneLevelConverter oneLevel = (OneLevelConverter) iter.next();
  92                         String upperId = oneLevel.getId();
  93                         Vector lower = oneLevel.getLower();
  94                         if (lower != null) {
  95                                 for (Iterator iterator = lower.iterator(); iterator.hasNext();) {
  96                                         OneLevelConverter element = (OneLevelConverter) iterator.next();
  97                                         String convLeaf =       columnItem + (iterator.hasNext() ? columnSeparator : "");
  98
  99                                         convLeaf = StringUtil.substituteString(convLeaf, "${schema}", QuantumUtil.getSchemaName(upperId));
 100                                         convLeaf = StringUtil.substituteString(convLeaf, "${qualified}", upperId);
 101                                         convLeaf = StringUtil.substituteString(convLeaf, "${table}", QuantumUtil.getTableName(upperId));
 102                                         convLeaf = StringUtil.substituteString(convLeaf, "${column}", element.getId());
 103
 104                                         element.setResult(convLeaf);
 105                                 }
 106                         }
 107                         // We have all the leafs converted, we calculate the parent conversion
 108                         String convUpper = tableItem + (iter.hasNext() ? tableSeparator : "");
 109                         convUpper = StringUtil.substituteString(convUpper, "${schema}", QuantumUtil.getSchemaName(upperId));
 110                         convUpper = StringUtil.substituteString(convUpper, "${qualified}", upperId);
 111                         convUpper = StringUtil.substituteString(convUpper, "${table}", QuantumUtil.getTableName(upperId));
 112                         convUpper = StringUtil.substituteString(convUpper, "${column_list}", getColumnList(oneLevel));
 113
 114                         oneLevel.setResult(convUpper);
 115                 }
 116         }
 117
 118
 119         /**
 120          * Calculates the list of columns for an upper level converter. Has to be already converted.
 121          * @param oneLevel
 122          * @return
 123          */
 124         private String getColumnList(OneLevelConverter oneLevel) {
 125
 126                 String result = "";
 127                 Vector lower = oneLevel.getLower();
 128                 if (lower != null) {
 129                         for (Iterator iterator = lower.iterator(); iterator.hasNext();) {
 130                                 OneLevelConverter element = (OneLevelConverter) iterator.next();
 131                                 result += element.getResult();
 132                         }
 133                 }
 134                 return result;
 135         }
 136
 137         public String getTableList() {
 138                 String result = "";
 139                 for (Iterator iter = upper.iterator(); iter.hasNext();) {
 140                         OneLevelConverter oneLevel = (OneLevelConverter) iter.next();
 141                         result += oneLevel.getResult();
 142                 }
 143                 return result;
 144         }
 145 }