fixed Bug 1024299
[phpeclipse.git] / archive / net.sourceforge.phpeclipse.quantum.sql / src / com / quantum / wizards / UpdateRowPage.java
index 3753b7c..031ed9f 100644 (file)
 package com.quantum.wizards;
 
+import java.util.Arrays;
+
+import org.eclipse.jface.viewers.CellEditor;
+import org.eclipse.jface.viewers.CheckboxCellEditor;
+import org.eclipse.jface.viewers.ICellModifier;
+import org.eclipse.jface.viewers.ILabelProviderListener;
+import org.eclipse.jface.viewers.IStructuredContentProvider;
+import org.eclipse.jface.viewers.ITableLabelProvider;
+import org.eclipse.jface.viewers.TableViewer;
+import org.eclipse.jface.viewers.TextCellEditor;
+import org.eclipse.jface.viewers.Viewer;
 import org.eclipse.swt.SWT;
 import org.eclipse.swt.events.ModifyEvent;
 import org.eclipse.swt.events.ModifyListener;
 import org.eclipse.swt.events.SelectionEvent;
 import org.eclipse.swt.events.SelectionListener;
+import org.eclipse.swt.graphics.Image;
 import org.eclipse.swt.layout.GridData;
 import org.eclipse.swt.layout.GridLayout;
 import org.eclipse.swt.widgets.Button;
 import org.eclipse.swt.widgets.Composite;
 import org.eclipse.swt.widgets.Label;
+import org.eclipse.swt.widgets.Table;
+import org.eclipse.swt.widgets.TableColumn;
+import org.eclipse.swt.widgets.TableItem;
 import org.eclipse.swt.widgets.Text;
 
+import com.quantum.ImageStore;
 import com.quantum.Messages;
 import com.quantum.adapters.DatabaseAdapter;
 import com.quantum.model.Bookmark;
 import com.quantum.model.Column;
 import com.quantum.model.Entity;
+import com.quantum.wizards.InsertRowPage.CellModifierImpl;
+import com.quantum.wizards.InsertRowPage.ContentProviderImpl;
+import com.quantum.wizards.InsertRowPage.InsertRowTableValues;
+import com.quantum.wizards.InsertRowPage.LabelProviderImpl;
 
 public class UpdateRowPage extends BaseSQLPage implements SQLPage {
+    
+    class UpdateRowTableValues {
+        private String sColNames = null;
+        private String sOldValue = null;
+        private boolean bPrimary = false;
+        private String sNewValue = null;
+        private boolean bSetValue = false;
+        
+        public UpdateRowTableValues() {
+        }
+        /**
+         * @return Returns the bSetValue.
+         */
+        public boolean isBSetValue() {
+            return bSetValue;
+        }
+        /**
+         * @param setValue The bSetValue to set.
+         */
+        public void setBSetValue(boolean setValue) {
+            bSetValue = setValue;
+        }
+        /**
+         * @return Returns the bPrimary.
+         */
+        public boolean isBPrimary() {
+            return bPrimary;
+        }
+        /**
+         * @param where The bPrimary to set.
+         */
+        public void setBPrimary(boolean where) {
+            bPrimary = where;
+        }
+        /**
+         * @return Returns the sColNames.
+         */
+        public String getSColNames() {
+            return sColNames;
+        }
+        /**
+         * @param colNames The sColNames to set.
+         */
+        public void setSColNames(String colNames) {
+            sColNames = colNames;
+        }
+        /**
+         * @return Returns the sNewValue.
+         */
+        public String getSNewValue() {
+            return sNewValue;
+        }
+        /**
+         * @param newValue The sNewValue to set.
+         */
+        public void setSNewValue(String newValue) {
+            sNewValue = newValue;
+        }
+        /**
+         * @return Returns the sOldValue.
+         */
+        public String getSOldValue() {
+            return sOldValue;
+        }
+        /**
+         * @param oldValue The sOldValue to set.
+         */
+        public void setSOldValue(String oldValue) {
+            sOldValue = oldValue;
+        }
+    }
+    
+    class LabelProviderImpl implements ITableLabelProvider {                
+               public Image getColumnImage(Object element, int columnIndex) {
+                   if (columnIndex == 2) {
+                       return ((UpdateRowTableValues)element).isBPrimary() ? imgCheck : imgUncheck;
+                   } else if (columnIndex == 4) {
+                       return ((UpdateRowTableValues)element).isBSetValue() ? imgCheck : imgUncheck;
+                   } else {
+                       return null;
+                   }
+               }
+               public String getColumnText(Object element, int columnIndex) {
+                       String sReturn = "";                    
+                       UpdateRowTableValues updateRow = (UpdateRowTableValues)element;
+                       switch (columnIndex) {
+                               case 0: // column names
+                                   sReturn = updateRow.getSColNames();
+                                   break;
+                               case 1: // old values
+                                   sReturn = updateRow.getSOldValue();
+                                   break;
+                               case 2: // set checkbox
+                                   break;
+                               case 3: // new value
+                                   sReturn = updateRow.getSNewValue();
+                                   break;
+                               case 4: // set value checkbox
+                                   break;                                  
+                               default:
+                                   break;
+                       }
+                       return sReturn;
+               }
+               public void addListener(ILabelProviderListener listener) {}
+               public void dispose() {}
+               public boolean isLabelProperty(Object element, String property) {
+                       return false;
+               }
+               public void removeListener(ILabelProviderListener listener) {}
+       }
+       
+    class ContentProviderImpl implements IStructuredContentProvider {
+               public Object[] getElements(Object inputElement) {
+                       return updateTable;
+               }
+
+               public void dispose() {}
+               public void inputChanged(Viewer viewer, Object oldInput, Object newInput) {}            
+       }
+        
+    class CellModifierImpl implements ICellModifier {
+
+       public boolean canModify(Object element, String property) {
+               return true;
+       }
+       
+       public Object getValue(Object element, String property) {               
+               System.out.println("getValue called");
+       
+               // Find the index of the column
+               int colIndx = getColumnNamesAsList(colNames).indexOf(property);
+               System.out.println("colIndx : " + colIndx);             
+                
+               Object rResult = null;
+               UpdateRowTableValues updateVal = (UpdateRowTableValues)element;
+                               
+               switch (colIndx) {
+                       case 0: // column names
+                           rResult = updateVal.getSColNames();
+                                   break;
+                               case 1: // old values
+                                   rResult = updateVal.getSOldValue();
+                                   break;
+                               case 2: // set checkbox
+                                   rResult = new Boolean(updateVal.isBPrimary());
+                                   break;
+                               case 3: // new value
+                                   rResult = updateVal.getSNewValue();
+                                   break;
+                               case 4: // set value checkbox
+                                   rResult = new Boolean(updateVal.isBSetValue());
+                                   break;                                  
+                               default:
+                                   break;
+               }
+               
+               return rResult;
+       }
+       
+       public void modify(Object element, String property, Object value) {
+               int colIndx = getColumnNamesAsList(colNames).indexOf(property);
+               
+               TableItem item = (TableItem) element;
+               UpdateRowTableValues updateVal = (UpdateRowTableValues)item.getData();
+               
+               switch (colIndx) {
+                       case 0: // column names                     
+                                   break;
+                               case 1: // old values                                               
+                                   break;
+                               case 2: // set checkbox
+                                   updateVal.setBPrimary(((Boolean)value).booleanValue());
+                                   break;
+                               case 3: // new value
+                                   updateVal.setSNewValue(value.toString());                               
+                                   break;
+                               case 4: // set value checkbox
+                                   updateVal.setBSetValue(((Boolean)value).booleanValue());
+                                   break;                                  
+                               default:
+                                   break;
+               }
+               
+               updateView();                               
+                   updateQuery();
+       }
+    }
+    
        String[] columnNames;
+       String[] colNames;
        Text[] oldValues;
        Text[] newValues;
        Button[] primaryKeys;
        Button[] setValues;
        Label query;
+       UpdateRowTableValues[] updateTable = null;
+       TableViewer tableViewer = null;
+       static Image imgCheck = null;
+       static Image imgUncheck = null;
+       
+       static {
+           imgCheck = ImageStore.getImage(ImageStore.CHECKED);
+           imgUncheck = ImageStore.getImage(ImageStore.UNCHECKED);
+       }
+       
        public UpdateRowPage(String pageName) {
                super(pageName);
        }
 
        public void createControl(Composite parent) {
                System.out.println("page create control"); //$NON-NLS-1$
-               Composite container = new Composite(parent, SWT.V_SCROLL);
-               GridLayout layout = new GridLayout();
-               container.setLayout(layout);
+               Composite container = new Composite(parent, SWT.NULL);
+               container.setLayout(new GridLayout());
+               container.setLayoutData(new GridData(GridData.FILL_BOTH | GridData.VERTICAL_ALIGN_BEGINNING));
+               
                Entity entity = this.results.getEntity();
                
-               int layoutColumns = 5;
-               layout.numColumns = layoutColumns;
-
+               // init values to be displayed on the table
                columnNames = this.results.getColumnNames();
-               oldValues = new Text[columnNames.length];
-               newValues = new Text[columnNames.length];
-               primaryKeys = new Button[columnNames.length];
-               setValues = new Button[columnNames.length];
-               Label temp = new Label(container, SWT.NULL);
-               temp.setText(Messages.getString("UpdateRowPage.ColumnName")); //$NON-NLS-1$
-               temp = new Label(container, SWT.NULL);
-               temp.setText(Messages.getString("UpdateRowPage.OldValue")); //$NON-NLS-1$
-               temp = new Label(container, SWT.NULL);
-               temp.setText(""); //$NON-NLS-1$
-               temp = new Label(container, SWT.NULL);
-               temp.setText(Messages.getString("UpdateRowPage.NewValue")); //$NON-NLS-1$
-               temp = new Label(container, SWT.NULL);
-               temp.setText(Messages.getString("UpdateRowPage._13")); //$NON-NLS-1$
-               for (int i = 0; i < columnNames.length; i++) {
-                       Label label = new Label(container, SWT.NULL);
-                       label.setText(columnNames[i]);
-                       oldValues[i] = new Text(container, SWT.BORDER | SWT.SINGLE);
-                       GridData gridData = new GridData();
-                       gridData.widthHint = 100;
-                       oldValues[i].setLayoutData(gridData);
-                       Object data = this.row == null ? null : this.row.get(i+1);
-                       oldValues[i].setText(data == null ? "" : data.toString());
-                       oldValues[i].addModifyListener(new ModifyListener() {
-                               public void modifyText(ModifyEvent e) {
-                                       updateQuery();
-                               }                               
-                       });
-                       primaryKeys[i] = new Button(container, SWT.CHECK);
-                       primaryKeys[i].setText("Where"); //$NON-NLS-1$
-                       Column column = (entity == null) ? null : getColumn(entity, columnNames[i]);
-                       if (column != null && column.isPrimaryKey()) 
-                               primaryKeys[i].setSelection(true);
-                       primaryKeys[i].addSelectionListener(new SelectionListener() {
-                               public void widgetDefaultSelected(SelectionEvent e) {
-                               }
-                               public void widgetSelected(SelectionEvent e) {
-                                       updateQuery();
-                               }
-                       });
-                       newValues[i] = new Text(container, SWT.BORDER | SWT.SINGLE);
-                       newValues[i].setText(data == null ? "" : data.toString());
-                       gridData = new GridData();
-                       gridData.widthHint = 100;
-                       newValues[i].setLayoutData(gridData);
-                       newValues[i].addModifyListener(new ModifyListener() {
-                               public void modifyText(ModifyEvent e) {
-                                       updateQuery();
-                               }                               
-                       });
-                       setValues[i] = new Button(container, SWT.CHECK);
-                       setValues[i].setText(Messages.getString("UpdateRowPage.SetValue")); //$NON-NLS-1$
-                       setValues[i].addSelectionListener(new SelectionListener() {
-                               public void widgetDefaultSelected(SelectionEvent e) {
-                               }
-                               public void widgetSelected(SelectionEvent e) {
-                                       updateQuery();
-                               }
-                       });
+               int nLen = columnNames.length;
+               updateTable = new UpdateRowTableValues[nLen];
+               
+               for(int nCtr=0; nCtr<nLen; nCtr++) {
+                   updateTable[nCtr] = new UpdateRowTableValues();
+                   updateTable[nCtr].setSColNames(columnNames[nCtr]);
+                   Object data = this.row == null ? null : this.row.get(nCtr+1);
+                   updateTable[nCtr].setSOldValue(data == null ? "" : data.toString());
+                   Column column = (entity == null) ? null : getColumn(entity, columnNames[nCtr]);
+                       if (column != null && column.isPrimaryKey()) {
+                           updateTable[nCtr].setBPrimary(true);
+                       }
+                   updateTable[nCtr].setSNewValue(data == null ? "" : data.toString());
                }
-               query = new Label(container, SWT.WRAP | SWT.V_SCROLL);
+               
+               createTable(container);
+               
+               query = new Label(container, SWT.WRAP);
                GridData gridData = new GridData();
-               gridData.horizontalSpan = layoutColumns;
-               gridData.horizontalAlignment = GridData.FILL;
-               gridData.verticalAlignment = GridData.FILL;
-               gridData.grabExcessHorizontalSpace = true;
-               gridData.grabExcessVerticalSpace = true;
+               gridData.horizontalSpan = 1;            
+               gridData.horizontalAlignment = GridData.FILL;
+               gridData.verticalAlignment = GridData.FILL;             
                query.setLayoutData(gridData);
 
                setControl(container);
@@ -123,27 +297,28 @@ public class UpdateRowPage extends BaseSQLPage implements SQLPage {
                DatabaseAdapter adapter = bookmark.getAdapter();
                
                int numValuesSet = 0;
-               int numValuesWhere = 0;
-               for (int i = 0; i < columnNames.length; i++) {
-                       if (primaryKeys[i].getSelection()) {
-                               String value = oldValues[i].getText();
+               int numValuesWhere = 0;         
+               for (int nCtr = 0; nCtr < columnNames.length; nCtr++) {
+                       if (updateTable[nCtr].isBPrimary()) {
+                               String value = updateTable[nCtr].getSOldValue();
                                if (numValuesWhere > 0) whereClause.append(" AND "); //$NON-NLS-1$
                                whereClause.append("("); //$NON-NLS-1$
-                               whereClause.append(columnNames[i]);
+                               whereClause.append(updateTable[nCtr].getSColNames());
                                whereClause.append(" = "); //$NON-NLS-1$
-                appendColumn(whereClause, entity, columnNames[i], adapter, value);
+                appendColumn(whereClause, entity, updateTable[nCtr].getSColNames(), adapter, value);
                                whereClause.append(")"); //$NON-NLS-1$
                                numValuesWhere++;
                        } 
-                       if (setValues[i].getSelection()) {
-                               String value = newValues[i].getText();
+                       if (updateTable[nCtr].isBSetValue()) {
+                               String value = updateTable[nCtr].getSNewValue();
                                if (numValuesSet > 0) setClause.append(", "); //$NON-NLS-1$
-                               setClause.append(columnNames[i]);
+                               setClause.append(updateTable[nCtr].getSColNames());
                                setClause.append(" = "); //$NON-NLS-1$
-                appendColumn(setClause, entity, columnNames[i], adapter, value);
+                appendColumn(setClause, entity, updateTable[nCtr].getSColNames(), adapter, value);
                                numValuesSet++;
                        }
                }
+               
                String query = "UPDATE " + this.results.getEntity().getQuotedTableName(); //$NON-NLS-1$
                query += " SET " + setClause.toString(); //$NON-NLS-1$
                query += " WHERE " + whereClause.toString(); //$NON-NLS-1$
@@ -156,5 +331,52 @@ public class UpdateRowPage extends BaseSQLPage implements SQLPage {
     protected String getQueryText() {
         return query.getText();
     }
+        
+    private void updateView() {
+        this.tableViewer.update(updateTable, null);
+    }
+
+    private void createTable(Composite composite) {
+        System.out.println("Creating table...");
+        int style = SWT.SINGLE | SWT.BORDER | SWT.H_SCROLL | SWT.V_SCROLL | SWT.FULL_SELECTION | SWT.HIDE_SELECTION;
+               Table table = new Table(composite, style);
+       table.setHeaderVisible(true);
+       table.setLinesVisible(true);
+       table.setLayoutData(new GridData(GridData.FILL_BOTH | GridData.VERTICAL_ALIGN_BEGINNING));
+       
+       colNames = new String[] { Messages.getString("UpdateRowPage.ColumnName"), Messages.getString("UpdateRowPage.OldValue"),
+                       "Where", Messages.getString("UpdateRowPage.NewValue"), Messages.getString("UpdateRowPage.SetValue")     };
 
+               createTableColumn(table, colNames[0], SWT.LEFT, 0, 150);
+               createTableColumn(table, colNames[1], SWT.LEFT, 1, 300);
+               createTableColumn(table, colNames[2], SWT.CENTER, 2, 60);
+               createTableColumn(table, colNames[3], SWT.LEFT, 3, 300);
+               createTableColumn(table, colNames[4], SWT.CENTER, 4, 70);
+               this.tableViewer = new TableViewer(table);
+               this.tableViewer.setColumnProperties(colNames);
+
+               CellEditor[] editor = new CellEditor[colNames.length];
+               TextCellEditor txtEditorField = new TextCellEditor(table);
+               txtEditorField.getControl().setEnabled(false);
+               editor[0] = txtEditorField;
+               
+               TextCellEditor txtEditorFieldOld = new TextCellEditor(table);
+               txtEditorFieldOld.getControl().setEnabled(false);
+               editor[1] = txtEditorFieldOld;
+               
+               editor[2] = new CheckboxCellEditor(table, SWT.NULL);
+               
+               TextCellEditor txtEditorValues = new TextCellEditor(table);
+               editor[3] = txtEditorValues;
+               
+               editor[4] = new CheckboxCellEditor(table, SWT.NULL);
+               
+               this.tableViewer.setCellEditors(editor);
+               this.tableViewer.setLabelProvider(new LabelProviderImpl());
+               this.tableViewer.setContentProvider(new ContentProviderImpl());
+               this.tableViewer.setCellModifier(new CellModifierImpl());
+               this.tableViewer.setInput(updateTable);         
+    }
+    
+    
 }
\ No newline at end of file