archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/php/wizards/PHPUpdateRowPage.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.events.SelectionEvent;
  12 import org.eclipse.swt.events.SelectionListener;
  13 import org.eclipse.swt.layout.GridData;
  14 import org.eclipse.swt.layout.GridLayout;
  15 import org.eclipse.swt.widgets.Button;
  16 import org.eclipse.swt.widgets.Composite;
  17 import org.eclipse.swt.widgets.Label;
  18 import org.eclipse.swt.widgets.Text;
  19
  20 import com.quantum.QuantumPlugin;
  21 import com.quantum.adapters.DatabaseAdapter;
  22 import com.quantum.model.Bookmark;
  23 import com.quantum.model.Column;
  24 import com.quantum.model.Entity;
  25 import com.quantum.php.PHPMessages;
  26 import com.quantum.wizards.BaseSQLPage;
  27 import com.quantum.wizards.SQLPage;
  28
  29 public class PHPUpdateRowPage extends BaseSQLPage implements SQLPage {
  30         String[] columnNames;
  31         Text[] oldValues;
  32         Text[] newValues;
  33         Button[] primaryKeys;
  34         Button[] setValues;
  35         Label query;
  36         IPreferenceStore fStore;
  37         public PHPUpdateRowPage(String pageName) {
  38                 super(pageName);
  39         }
  40
  41         public void createControl(Composite parent) {
  42                 System.out.println("page create control"); //$NON-NLS-1$
  43                 Composite container = new Composite(parent, SWT.V_SCROLL);
  44                 fStore = QuantumPlugin.getDefault().getPreferenceStore();
  45                 GridLayout layout = new GridLayout();
  46                 container.setLayout(layout);
  47                 Entity entity = this.results.getEntity();
  48
  49                 int layoutColumns = 5;
  50                 layout.numColumns = layoutColumns;
  51
  52                 columnNames = this.results.getColumnNames();
  53                 oldValues = new Text[columnNames.length];
  54                 newValues = new Text[columnNames.length];
  55                 primaryKeys = new Button[columnNames.length];
  56                 setValues = new Button[columnNames.length];
  57                 Label temp = new Label(container, SWT.NULL);
  58                 temp.setText(PHPMessages.getString("PHPUpdateRowPage.ColumnName")); //$NON-NLS-1$
  59                 temp = new Label(container, SWT.NULL);
  60                 temp.setText(PHPMessages.getString("PHPUpdateRowPage.OldValue")); //$NON-NLS-1$
  61                 temp = new Label(container, SWT.NULL);
  62                 temp.setText(""); //$NON-NLS-1$
  63                 temp = new Label(container, SWT.NULL);
  64                 temp.setText(PHPMessages.getString("PHPUpdateRowPage.NewValue")); //$NON-NLS-1$
  65                 temp = new Label(container, SWT.NULL);
  66                 temp.setText(PHPMessages.getString("PHPUpdateRowPage._13")); //$NON-NLS-1$
  67                 for (int i = 0; i < columnNames.length; i++) {
  68                         Label label = new Label(container, SWT.NULL);
  69                         label.setText(columnNames[i]);
  70                         oldValues[i] = new Text(container, SWT.BORDER | SWT.SINGLE);
  71                         GridData gridData = new GridData();
  72                         gridData.widthHint = 100;
  73                         oldValues[i].setLayoutData(gridData);
  74                         Object data = this.row == null ? null : this.row.get(i+1);
  75                         oldValues[i].setText(data == null ? "" : '$'+columnNames[i]);
  76                         oldValues[i].addModifyListener(new ModifyListener() {
  77                                 public void modifyText(ModifyEvent e) {
  78                                         updateQuery();
  79                                 }
  80                         });
  81                         primaryKeys[i] = new Button(container, SWT.CHECK);
  82                         primaryKeys[i].setText("Where"); //$NON-NLS-1$
  83                         Column column = (entity == null) ? null : getColumn(entity, columnNames[i]);
  84                         if (column != null && column.isPrimaryKey())
  85                                 primaryKeys[i].setSelection(true);
  86                         primaryKeys[i].addSelectionListener(new SelectionListener() {
  87                                 public void widgetDefaultSelected(SelectionEvent e) {
  88                                 }
  89                                 public void widgetSelected(SelectionEvent e) {
  90                                         updateQuery();
  91                                 }
  92                         });
  93                         newValues[i] = new Text(container, SWT.BORDER | SWT.SINGLE);
  94                         newValues[i].setText(data == null ? "" : '$'+columnNames[i]);
  95                         gridData = new GridData();
  96                         gridData.widthHint = 100;
  97                         newValues[i].setLayoutData(gridData);
  98                         newValues[i].addModifyListener(new ModifyListener() {
  99                                 public void modifyText(ModifyEvent e) {
 100                                         updateQuery();
 101                                 }
 102                         });
 103                         setValues[i] = new Button(container, SWT.CHECK);
 104                         setValues[i].setText(PHPMessages.getString("PHPUpdateRowPage.SetValue")); //$NON-NLS-1$
 105                         setValues[i].addSelectionListener(new SelectionListener() {
 106                                 public void widgetDefaultSelected(SelectionEvent e) {
 107                                 }
 108                                 public void widgetSelected(SelectionEvent e) {
 109                                         updateQuery();
 110                                 }
 111                         });
 112                 }
 113                 query = new Label(container, SWT.WRAP | SWT.V_SCROLL);
 114                 GridData gridData = new GridData();
 115                 gridData.horizontalSpan = layoutColumns;
 116                 gridData.horizontalAlignment = GridData.FILL;
 117                 gridData.verticalAlignment = GridData.FILL;
 118                 gridData.grabExcessHorizontalSpace = true;
 119                 gridData.grabExcessVerticalSpace = true;
 120                 query.setLayoutData(gridData);
 121
 122                 setControl(container);
 123         updateQuery();
 124
 125                 setPageComplete(true);
 126         }
 127         public void updateQuery() {
 128                 System.out.println("Updating query"); //$NON-NLS-1$
 129                 StringBuffer setClause = new StringBuffer();
 130                 StringBuffer whereClause = new StringBuffer();
 131                 Bookmark bookmark = this.results.getBookmark();
 132                 Entity entity = this.results.getEntity();
 133                 DatabaseAdapter adapter = bookmark.getAdapter();
 134
 135                 int numValuesSet = 0;
 136                 int numValuesWhere = 0;
 137                 for (int i = 0; i < columnNames.length; i++) {
 138                         if (primaryKeys[i].getSelection()) {
 139                                 String value = oldValues[i].getText();
 140                                 if (numValuesWhere > 0) whereClause.append(" AND "); //$NON-NLS-1$
 141                                 whereClause.append("("); //$NON-NLS-1$
 142                                 whereClause.append(columnNames[i]);
 143                                 whereClause.append(" = "); //$NON-NLS-1$
 144                 appendColumn(whereClause, entity, columnNames[i], adapter, value);
 145                                 whereClause.append(")"); //$NON-NLS-1$
 146                                 numValuesWhere++;
 147                         }
 148                         if (setValues[i].getSelection()) {
 149                                 String value = newValues[i].getText();
 150                                 if (numValuesSet > 0) setClause.append(", "); //$NON-NLS-1$
 151                                 setClause.append(columnNames[i]);
 152                                 setClause.append(" = "); //$NON-NLS-1$
 153                 appendColumn(setClause, entity, columnNames[i], adapter, value);
 154                                 numValuesSet++;
 155                         }
 156                 }
 157 //              String query = "UPDATE " + this.results.getEntity().getQuotedTableName(); //$NON-NLS-1$
 158 //              query += " SET " + setClause.toString(); //$NON-NLS-1$
 159 //              query += " WHERE " + whereClause.toString(); //$NON-NLS-1$
 160 //
 161                 String[] arguments = { this.results.getEntity().getQuotedTableName(), setClause.toString(), whereClause.toString()};
 162             MessageFormat form = new MessageFormat(fStore.getString("phpeclipse.sql.update.template"));
 163
 164             String query = form.format(arguments);
 165             this.query.setText(query);
 166
 167         }
 168
 169     /* (non-Javadoc)
 170      * @see com.quantum.wizards.BaseSQLPage#getQueryText()
 171      */
 172     protected String getQueryText() {
 173         return query.getText();
 174     }
 175
 176   /* (non-Javadoc)
 177    * @see com.quantum.wizards.SQLPage#performFinish()
 178    */
 179   public boolean performFinish() {
 180         QuantumPlugin.getDefault().getSysClip().setContents(
 181                         new Object[] { query.getText() },
 182                         new Transfer[] { TextTransfer.getInstance()});
 183     return true;
 184   }
 185 }