Examples of Insert


Examples of org.teiid.query.sql.lang.Insert

              if (buffer == null) {
                buffer = getBufferManager().createTupleBuffer(intoElements, getConnectionID(), TupleSourceType.PROCESSOR);
              }
              buffer.addTupleBatch(currentBatch, true);
              if (currentBatch.getTerminationFlag() && (buffer.getRowCount() != 0 || intoGroup.isImplicitTempGroupSymbol())) {
                Insert insert = new Insert(intoGroup, intoElements, null);
                buffer.close();
                insert.setTupleSource(buffer.createIndexedTupleSource(true));
                    // Register insert command against source
                    registerRequest(insert);
              } else {
                requests = 0;
              }
              break;
            case BULK:
              //convert to multivalued parameter
                List<Constant> parameters = new ArrayList<Constant>(intoElements.size());
                for (int i = 0; i < intoElements.size(); i++) {
          Constant value = new Constant(null, ((ElementSymbol)intoElements.get(i)).getType());
          value.setMultiValued(new ArrayList<Object>(currentBatch.getTuples().size()));
                  parameters.add(value);
        }
                for (List row : currentBatch.getTuples()) {
                  for (int i = 0; i < row.size(); i++) {
                    ((List<Object>)parameters.get(i).getValue()).add(row.get(i));
                  }
        }
                // Create a bulk insert command batching all rows in the current batch.
                Insert insert = new Insert(intoGroup, intoElements, parameters);
                // Register insert command against source
                registerRequest(insert);
                break;
            case BATCH:
                // Register batched update command against source
                int endRow = currentBatch.getEndRow();
                List rows = new ArrayList(endRow-batchRow);
                for(int rowNum = batchRow; rowNum <= endRow; rowNum++) {

                    insert = new Insert( intoGroup,
                                                 intoElements,
                                                 convertValuesToConstants(currentBatch.getTuple(rowNum), intoElements));
                    rows.add( insert );
                }
                registerRequest(new BatchedUpdateCommand( rows ));
                break;
            case SINGLE:
                batchSize = 1;
                // Register insert command against source
                // Defect 16036 - submit a new INSERT command to the DataManager.
                registerRequest(new Insert(intoGroup, intoElements, convertValuesToConstants(currentBatch.getTuple(batchRow), intoElements)));
            }
           
            this.batchRow += batchSize;
            if (batchRow > currentBatch.getEndRow()) {
              currentBatch = null;
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

     
      helpTest(gb, "GROUP BY m.g.e1, m.g.e2, m.g.e3");        //$NON-NLS-1$
    }
   
    public void testInsert1() {
       Insert insert = new Insert();
       insert.setGroup(new GroupSymbol("m.g1"));      //$NON-NLS-1$
      
       List vars = new ArrayList();
       vars.add(new ElementSymbol("e1")); //$NON-NLS-1$
       vars.add(new ElementSymbol("e2")); //$NON-NLS-1$
       insert.setVariables(vars);
       List values = new ArrayList();
       values.add(new Constant(new Integer(5)));
       values.add(new Constant("abc")); //$NON-NLS-1$
       insert.setValues(values);
      
       helpTest(insert, "INSERT INTO m.g1 (e1, e2) VALUES (5, 'abc')"); //$NON-NLS-1$
    }
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

                    }
                    return true;
                }
                break;
            case Command.TYPE_INSERT:
              Insert insert = (Insert) command;
              QueryCommand expr = insert.getQueryExpression();
              if (expr != null) {
                return shouldExecute(expr, simplifyCriteria);
              }
              return true;
            case Command.TYPE_UPDATE:
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

            if (dynamicCommand.getAsColumns() != null
          && !dynamicCommand.getAsColumns().isEmpty()) {
            command = QueryRewriter.createInlineViewQuery(new GroupSymbol("X"), command, metadata, dynamicCommand.getAsColumns()); //$NON-NLS-1$
        if (dynamicCommand.getIntoGroup() != null) {
          Insert insert = new Insert(dynamicCommand.getIntoGroup(), dynamicCommand.getAsColumns(), Collections.emptyList());
          insert.setQueryExpression((Query)command);
          command = insert;
        }
      }
           
      command = QueryRewriter.rewrite(command, parentProcCommand, metadata,
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

    @Test public void testDefect23257() throws Exception{
      CreateUpdateProcedureCommand command = helpResolve("EXEC pm5.vsp59()", FakeMetadataFactory.example1Cached()); //$NON-NLS-1$
       
        CommandStatement cs = (CommandStatement)command.getBlock().getStatements().get(1);
       
        Insert insert = (Insert)cs.getCommand();
       
        assertEquals(DataTypeManager.DefaultDataClasses.SHORT, ((Expression)insert.getValues().get(1)).getType());
    }
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

        };
       
        helpProcess(plan, dataManager, expected);
       
        BatchedUpdateCommand buc = (BatchedUpdateCommand)dataManager.getCommandHistory().iterator().next();
        Insert insert = (Insert)buc.getUpdateCommands().get(0);
               
        Constant value0 = (Constant)insert.getValues().get(0);
        Constant value1 = (Constant)insert.getValues().get(1);
       
        assertEquals(DataTypeManager.DefaultDataClasses.BIG_INTEGER, value0.getValue().getClass());
        assertEquals(DataTypeManager.DefaultDataClasses.FLOAT, value1.getValue().getClass());
    }
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

            Arrays.asList(new Object[] { new Integer(1) }),
        };
       
        helpProcess(plan, dataManager, expected);
       
        Insert insert = (Insert)dataManager.getCommandHistory().iterator().next();
       
        Constant value0 = (Constant)insert.getValues().get(0);
        Constant value1 = (Constant)insert.getValues().get(1);
       
        assertEquals(DataTypeManager.DefaultDataClasses.BIG_INTEGER, value0.getValue().getClass());
        assertEquals(DataTypeManager.DefaultDataClasses.FLOAT, value1.getValue().getClass());
    }
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

      gb.addSymbol(exampleElement(true, 1));
      helpTest(gb, getSymbolMap());
  }
 
  public void testVisitInsert1() {
    Insert insert = new Insert();
    insert.setGroup(exampleGroup(true, 0));
    List vars = new ArrayList();
    vars.add(exampleElement(true, 0));
    vars.add(exampleElement(true, 1));
    insert.setVariables(vars);   
    List values = new ArrayList();
    values.add(new Constant("abc")); //$NON-NLS-1$
    values.add(new Constant("abc")); //$NON-NLS-1$
    insert.setValues(values);   
    helpTest(insert, getSymbolMap());
  }
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

    insert.setValues(values);   
    helpTest(insert, getSymbolMap());
  }

  public void testVisitInsert2() {
    Insert insert = new Insert();
    insert.setGroup(exampleGroup(true, 0));
    List values = new ArrayList();
    values.add(new Constant("abc")); //$NON-NLS-1$
    values.add(new Constant("abc")); //$NON-NLS-1$
    insert.setValues(values);   
    helpTest(insert, getSymbolMap());
  }
View Full Code Here

Examples of org.teiid.query.sql.lang.Insert

    helpTestGroups(from, false, groups);
  }
 
  public void testInsert() {
    GroupSymbol gs1 = exampleGroupSymbol(1);
     Insert insert = new Insert();
     insert.setGroup(gs1);
    
     Set groups = new HashSet();
     groups.add(gs1);
     helpTestGroups(insert, true, groups);
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.