archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/php/wizards/PHPInsertRowPage.java

   1 package com.quantum.php.wizards;
   2
   3 import java.text.MessageFormat;
   4
   5 import org.eclipse.jface.preference.IPreferenceStore;
   6 import org.eclipse.swt.SWT;
   7 import org.eclipse.swt.dnd.TextTransfer;
   8 import org.eclipse.swt.dnd.Transfer;
   9 import org.eclipse.swt.events.ModifyEvent;
  10 import org.eclipse.swt.events.ModifyListener;
  11 import org.eclipse.swt.layout.GridData;
  12 import org.eclipse.swt.layout.GridLayout;
  13 import org.eclipse.swt.widgets.Composite;
  14 import org.eclipse.swt.widgets.Label;
  15 import org.eclipse.swt.widgets.Text;
  16
  17 import com.quantum.QuantumPlugin;
  18 import com.quantum.adapters.DatabaseAdapter;
  19 import com.quantum.model.Bookmark;
  20 import com.quantum.model.Entity;
  21 import com.quantum.php.PHPMessages;
  22 import com.quantum.wizards.BaseSQLPage;
  23 import com.quantum.wizards.SQLPage;
  24
  25 public class PHPInsertRowPage extends BaseSQLPage implements SQLPage {
  26         String[] columnNames;
  27         Text[] values;
  28         Label query;
  29         int numColumns = 0;
  30         private IPreferenceStore fStore;
  31
  32         public PHPInsertRowPage(String pageName) {
  33                 super(pageName);
  34         }
  35
  36         public void createControl(Composite parent) {
  37                 System.out.println("page create control"); //$NON-NLS-1$
  38                 fStore = QuantumPlugin.getDefault().getPreferenceStore();
  39                 Composite container = new Composite(parent, SWT.V_SCROLL);
  40                 GridLayout layout = new GridLayout();
  41                 container.setLayout(layout);
  42                 layout.numColumns = 2;
  43
  44                 columnNames = this.results.getColumnNames();
  45                 values = new Text[columnNames.length];
  46                 new Label(container, SWT.NULL).setText(PHPMessages.getString("PHPInsertRowPage.ColumnName")); //$NON-NLS-1$
  47                 new Label(container, SWT.NULL).setText(PHPMessages.getString("PHPInsertRowPage.Value")); //$NON-NLS-1$
  48                 for (int i = 0; i < columnNames.length; i++) {
  49                         Label label = new Label(container, SWT.NULL);
  50                         label.setText(columnNames[i]);
  51                         values[i] = new Text(container, SWT.BORDER | SWT.SINGLE);
  52                         GridData gridData = new GridData(GridData.FILL_HORIZONTAL);
  53                         gridData.widthHint = 150;
  54                         values[i].setLayoutData(gridData);
  55
  56                         //values[i].setText(data[i]);
  57                         values[i].addModifyListener(new ModifyListener() {
  58                                 public void modifyText(ModifyEvent e) {
  59                                         updateQuery();
  60                                 }
  61                         });
  62                 }
  63                 query = new Label(container, SWT.WRAP);
  64                 GridData gridData = new GridData();
  65                 gridData.horizontalSpan = layout.numColumns;
  66                 gridData.horizontalAlignment = GridData.FILL;
  67                 gridData.verticalAlignment = GridData.FILL;
  68                 gridData.grabExcessHorizontalSpace = true;
  69                 gridData.grabExcessVerticalSpace = true;
  70                 query.setLayoutData(gridData);
  71
  72                 setControl(container);
  73         updateQuery();
  74
  75                 setPageComplete(true);
  76         }
  77         public void updateQuery() {
  78                 System.out.println("Updating query"); //$NON-NLS-1$
  79                 StringBuffer valuesClause = new StringBuffer();
  80                 StringBuffer namesClause = new StringBuffer();
  81                 Bookmark bookmark = this.results.getBookmark();
  82                 Entity entity = this.results.getEntity();
  83                 DatabaseAdapter adapter = bookmark.getAdapter();
  84
  85                 numColumns = 0;
  86                 for (int i = 0; i < columnNames.length; i++) {
  87                         String name = columnNames[i];
  88                         String value = values[i].getText();
  89                         if (value.length() > 0) {
  90                                 if (numColumns > 0) {
  91                                         valuesClause.append(", "); //$NON-NLS-1$
  92                                         namesClause.append(", ");
  93                                 }
  94                 appendColumn(valuesClause, entity, name, adapter, value);
  95                                 namesClause.append(name);
  96                                 numColumns++;
  97                         }
  98                 }
  99
 100 //              String query = "INSERT INTO " + this.results.getEntity().getQuotedTableName(); //$NON-NLS-1$
 101 //              if (numColumns > 0) {
 102 //                      query += " (" + namesClause + ")";
 103 //                      query += " VALUES " + "(" + valuesClause; //$NON-NLS-1$
 104 //                      query += " )"; //$NON-NLS-1$
 105 //              }
 106             String[] arguments = { this.results.getEntity().getQuotedTableName(), namesClause.toString(), valuesClause.toString()};
 107             MessageFormat form = new MessageFormat(fStore.getString("phpeclipse.sql.insert.template"));
 108
 109             String query = form.format(arguments);
 110
 111             //    String query = "$results = mysql_query(\"INSERT INTO " + row.getTable() + " (";
 112             //    query += fieldClause.toString() + ") ";
 113             //    query += " VALUES (" + valuesClause.toString();
 114             //    query += ")\");";
 115                 this.query.setText(query);
 116         }
 117     /* (non-Javadoc)
 118      * @see com.quantum.wizards.BaseSQLPage#getQueryText()
 119      */
 120     protected String getQueryText() {
 121         return this.query.getText();
 122     }
 123     /* (non-Javadoc)
 124      * @see com.quantum.wizards.SQLPage#performFinish()
 125      */
 126     public boolean performFinish() {
 127         QuantumPlugin.getDefault().getSysClip().setContents(
 128                         new Object[] { query.getText() },
 129                         new Transfer[] { TextTransfer.getInstance()});
 130       return true;
 131     }
 132 }
 133
 134 //package com.quantum.php.wizards;
 135 //
 136 //import java.text.MessageFormat;
 137 //
 138 //import org.eclipse.jface.preference.IPreferenceStore;
 139 //import org.eclipse.jface.wizard.WizardPage;
 140 //import org.eclipse.swt.SWT;
 141 //import org.eclipse.swt.dnd.TextTransfer;
 142 //import org.eclipse.swt.dnd.Transfer;
 143 //import org.eclipse.swt.events.ModifyEvent;
 144 //import org.eclipse.swt.events.ModifyListener;
 145 //import org.eclipse.swt.layout.GridData;
 146 //import org.eclipse.swt.layout.GridLayout;
 147 //import org.eclipse.swt.widgets.Composite;
 148 //import org.eclipse.swt.widgets.Label;
 149 //import org.eclipse.swt.widgets.Text;
 150 //
 151 //import com.quantum.QuantumPlugin;
 152 //import com.quantum.sql.TableRow;
 153 //import com.quantum.wizards.BaseSQLPage;
 154 //import com.quantum.wizards.SQLPage;
 155 ////import com.quantum.view.PHPSourceConsole;
 156 ////import com.quantum.view.tableview.TableAdapter;
 157 //
 158 //public class PHPInsertRowPage extends BaseSQLPage implements SQLPage {
 159 //  TableRow row;
 160 //  String[] columnNames;
 161 //  Text[] values;
 162 //  Label query;
 163 //  private final static boolean DEBUG = false;
 164 //  private IPreferenceStore fStore;
 165 //
 166 //  public PHPInsertRowPage(String pageName) {
 167 //    super(pageName);
 168 //  }
 169 //
 170 ////  public void init(TableRow row, TableAdapter adapter) {
 171 ////    this.row = row;
 172 ////  }
 173 //
 174 //  public void createControl(Composite parent) {
 175 //    if (DEBUG) {
 176 //      System.out.println("page create control");
 177 //    }
 178 //    fStore = QuantumPlugin.getDefault().getPreferenceStore();
 179 //    Composite container = new Composite(parent, SWT.NULL);
 180 //    GridLayout layout = new GridLayout();
 181 //    container.setLayout(layout);
 182 //    int layoutColumns = 2;
 183 //    layout.numColumns = layoutColumns;
 184 //
 185 //    if (DEBUG) {
 186 //      if (row == null) {
 187 //        System.out.println("Row is null");
 188 //      }
 189 //      if (row.getColumnNames() == null) {
 190 //        System.out.println("Columns are null");
 191 //      }
 192 //      if (row.getTableData() == null) {
 193 //        System.out.println("Data is null");
 194 //      }
 195 //    }
 196 //
 197 //    columnNames = row.getColumnNames();
 198 //    String[] data = row.getTableData();
 199 //    if (DEBUG) {
 200 //      for (int i = 0; i < row.getColumnCount(); i++) {
 201 //        System.out.println("data = " + i + "=" + data[i]);
 202 //        System.out.println("column = " + i + "=" + columnNames[i]);
 203 //      }
 204 //    }
 205 //    values = new Text[row.getColumnCount()];
 206 //    Label temp = new Label(container, SWT.NULL);
 207 //    temp.setText("Column Name");
 208 //    temp = new Label(container, SWT.NULL);
 209 //    temp.setText("Value");
 210 //    for (int i = 0; i < row.getColumnCount(); i++) {
 211 //      Label label = new Label(container, SWT.NULL);
 212 //      label.setText(columnNames[i]);
 213 //      values[i] = new Text(container, SWT.BORDER | SWT.SINGLE);
 214 //      GridData fullHorizontal = new GridData();
 215 //      fullHorizontal.horizontalAlignment = GridData.FILL;
 216 //      values[i].setLayoutData(fullHorizontal);
 217 //
 218 //      //values[i].setText(data[i]);
 219 //      values[i].addModifyListener(new ModifyListener() {
 220 //        public void modifyText(ModifyEvent e) {
 221 //          updateQuery();
 222 //        }
 223 //      });
 224 //    }
 225 //    query = new Label(container, SWT.WRAP);
 226 //    GridData gridData = new GridData();
 227 //    gridData.horizontalSpan = layoutColumns;
 228 //    gridData.horizontalAlignment = GridData.FILL;
 229 //    gridData.verticalAlignment = GridData.FILL;
 230 //    gridData.grabExcessHorizontalSpace = true;
 231 //    gridData.grabExcessVerticalSpace = true;
 232 //    query.setLayoutData(gridData);
 233 //
 234 //    setControl(container);
 235 //    updateQuery();
 236 //
 237 //    setPageComplete(true);
 238 //  }
 239 //  public void updateQuery() {
 240 //    if (DEBUG) {
 241 //      System.out.println("Updating insert query");
 242 //    }
 243 //    StringBuffer fieldClause = new StringBuffer();
 244 //
 245 //    StringBuffer valuesClause = new StringBuffer();
 246 //    String text;
 247 //    boolean first = false;
 248 //    for (int i = 0; i < columnNames.length; i++) {
 249 //      text = values[i].getText();
 250 //      if (!text.equals("")) {
 251 //        if (first) {
 252 //          valuesClause.append(", ");
 253 //          fieldClause.append(", ");
 254 //        }
 255 //        valuesClause.append("'" + values[i].getText() + "'");
 256 //        fieldClause.append(columnNames[i]);
 257 //        first = true;
 258 //      }
 259 //    }
 260 //    //    if (valuesClause.length() > 1) {
 261 //    //      valuesClause.deleteCharAt(valuesClause.length() - 1);
 262 //    //      valuesClause.deleteCharAt(valuesClause.length() - 1);
 263 //    //    }
 264 //    String[] arguments = { row.getTable(), fieldClause.toString(), valuesClause.toString()};
 265 //    MessageFormat form = new MessageFormat(fStore.getString("phpeclipse.sql.insert.template"));
 266 //
 267 //    String query = form.format(arguments);
 268 //
 269 //    //    String query = "$results = mysql_query(\"INSERT INTO " + row.getTable() + " (";
 270 //    //    query += fieldClause.toString() + ") ";
 271 //    //    query += " VALUES (" + valuesClause.toString();
 272 //    //    query += ")\");";
 273 //    this.query.setText(query);
 274 //  }
 275 //  public boolean performFinish() {
 276 ////    PHPSourceConsole console = PHPSourceConsole.getInstance();
 277 ////    console.clear();
 278 ////    console.print(query.getText());
 279 //      QuantumPlugin.getDefault().getSysClip().setContents(
 280 //                      new Object[] { query.getText() },
 281 //                      new Transfer[] { TextTransfer.getInstance()});
 282 //    return true;
 283 //  }
 284 //  /* (non-Javadoc)
 285 //   * @see com.quantum.wizards.BaseSQLPage#getQueryText()
 286 //   */
 287 //  protected String getQueryText() {
 288 //      return this.query.getText();
 289 //  }
 290 //}