Examples of InsertStatement

com.ibatis.sqlmap.engine.mapping.statement.InsertStatement
liquibase.statement.core.InsertStatement
org.apache.ws.jaxme.sqls.InsertStatement

Interface of an INSERT statement.
@author Jochen Wiedmann
org.g4studio.core.orm.xibatis.sqlmap.engine.mapping.statement.InsertStatement
org.hibernate.hql.ast.tree.InsertStatement
Defines a top-level AST node representing an HQL "insert select" statement. @author Steve Ebersole
org.hibernate.hql.internal.ast.tree.InsertStatement
Defines a top-level AST node representing an HQL "insert select" statement. @author Steve Ebersole
org.yaac.server.egql.InsertStatement
@author Max Zhu (thebbsky@gmail.com)

Examples of org.apache.ws.jaxme.sqls.InsertStatement

    
    /** <p>Basic test for creating an <code>INSERT</code> statement.</p>
     */
    public void testBasicInsert() {
        Table table = getBasicTable();
        InsertStatement insertStatement = table.getInsertStatement();
        SQLGenerator generator = getSQLGenerator();
        generator.setLineTerminator("\n");
        String s = generator.getQuery(insertStatement);
        assertEquals("INSERT INTO MySchema.MyTable (MyIndex, MyName, MyDate) VALUES (?, ?, ?)", s);
    }

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.InsertStatement

   public int hashCode() {
      return getSchema().hashCode() + getName().hashCode();
   }


   public InsertStatement getInsertStatement() {
      InsertStatement result = getSchema().getSQLFactory().newInsertStatement();
      result.setTable(this);
      for (Iterator iter = getColumns();  iter.hasNext();  ) {
         result.addSet((Column) iter.next());
      }
      return result;
   }

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.InsertStatement

    
    /** <p>Basic test for creating an <code>INSERT</code> statement.</p>
     */
    public void testBasicInsert() {
        Table table = getBasicTable();
        InsertStatement insertStatement = table.getInsertStatement();
        SQLGenerator generator = getSQLGenerator();
        generator.setLineTerminator("\n");
        String s = generator.getQuery(insertStatement);
        assertEquals("INSERT INTO MySchema.MyTable (MyIndex, MyName, MyDate) VALUES (?, ?, ?)", s);
    }

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.InsertStatement

        return "INSERT INTO MySchema.MyTable (MyTable.MyIndex, MyTable.MyName, MyTable.MyDate) (SELECT MyTable0.MyIndex, MyTable0.MyName, MyTable0.MyDate FROM MySchema.MyTable AS MyTable0)";
    }


    public void testBulkInsert() {
        Table table = getBasicTable();
        InsertStatement insertStatement = getSQLFactory().newInsertStatement();
        insertStatement.setTable(table);
        SelectStatement st = table.getSelectStatement();
        SQLGenerator generator = getSQLGenerator();
        generator.setLineTerminator("\n");
        insertStatement.setSubSelect(st);
        String got = generator.getQuery(insertStatement);
        String expect = getBulkInsertResult();
        assertEquals(expect, got);
    }

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.InsertStatement

    DirectAccessible connection = jm.addParam(Connection.class, "pConn");
    DirectAccessible values = jm.addParam(Object[].class, "pValue");
    
    logFinestEntering(jm, null);
    
    InsertStatement insertStatement = table.getInsertStatement();
    String s = table.getSchema().getSQLFactory().newSQLGenerator().getQuery(insertStatement);
    Object query = JavaSource.getQuoted(s);
    if (isGeneratingLogging()) {
      LocalJavaField q = jm.newJavaField(String.class);
      q.addLine(query);

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.InsertStatement

   public int hashCode() {
      return getSchema().hashCode() + getName().hashCode();
   }


   public InsertStatement getInsertStatement() {
      InsertStatement result = getSchema().getSQLFactory().newInsertStatement();
      result.setTable(this);
      for (Iterator iter = getColumns();  iter.hasNext();  ) {
         result.addSet((Column) iter.next());
      }
      return result;
   }

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.InsertStatement

    DirectAccessible connection = jm.addParam(Connection.class, "pConn");
    DirectAccessible values = jm.addParam(Object[].class, "pValue");
    
    logFinestEntering(jm, null);
    
    InsertStatement insertStatement = table.getInsertStatement();
    String s = table.getSchema().getSQLFactory().newSQLGenerator().getQuery(insertStatement);
    Object query = JavaSource.getQuoted(s);
    if (isGeneratingLogging()) {
      LocalJavaField q = jm.newJavaField(String.class);
      q.addLine(query);

View Full Code Here

Examples of org.g4studio.core.orm.xibatis.sqlmap.engine.mapping.statement.InsertStatement

        statementParser.parseGeneralStatement(node, new MappedStatement());
      }
    });
    parser.addNodelet("/sqlMap/insert", new Nodelet() {
      public void process(Node node) throws Exception {
        statementParser.parseGeneralStatement(node, new InsertStatement());
      }
    });
    parser.addNodelet("/sqlMap/update", new Nodelet() {
      public void process(Node node) throws Exception {
        statementParser.parseGeneralStatement(node, new UpdateStatement());

View Full Code Here

Examples of org.g4studio.core.orm.xibatis.sqlmap.engine.mapping.statement.InsertStatement


  private Object executeSelectKey(SessionScope sessionScope, Transaction trans, MappedStatement ms, Object param)
      throws SQLException {
    Object generatedKey = null;
    StatementScope statementScope;
    InsertStatement insert = (InsertStatement) ms;
    SelectKeyStatement selectKeyStatement = insert.getSelectKeyStatement();
    if (selectKeyStatement != null) {
      statementScope = beginStatementScope(sessionScope, selectKeyStatement);
      try {
        generatedKey = selectKeyStatement.executeQueryForObject(statementScope, trans, param, null);
        String keyProp = selectKeyStatement.getKeyProperty();

View Full Code Here

Examples of org.g4studio.core.orm.xibatis.sqlmap.engine.mapping.statement.InsertStatement

  }


  public void setSelectKeyStatement(SqlSource processor, String resultClassName, String keyPropName,
      boolean runAfterSQL, String type) {
    if (rootStatement instanceof InsertStatement) {
      InsertStatement insertStatement = ((InsertStatement) rootStatement);
      Class parameterClass = insertStatement.getParameterClass();
      errorContext.setActivity("parsing a select key");
      SelectKeyStatement selectKeyStatement = new SelectKeyStatement();
      resultClassName = typeHandlerFactory.resolveAlias(resultClassName);
      Class resultClass = null;


      // get parameter and result maps
      selectKeyStatement.setSqlMapClient(client);
      selectKeyStatement.setId(insertStatement.getId() + "-SelectKey");
      selectKeyStatement.setResource(errorContext.getResource());
      selectKeyStatement.setKeyProperty(keyPropName);
      selectKeyStatement.setRunAfterSQL(runAfterSQL);
      // process the type (pre or post) attribute
      if (type != null) {
        selectKeyStatement.setRunAfterSQL("post".equals(type));
      }
      try {
        if (resultClassName != null) {
          errorContext.setMoreInfo("Check the select key result class.");
          resultClass = Resources.classForName(resultClassName);
        } else {
          if (keyPropName != null && parameterClass != null) {
            resultClass = PROBE.getPropertyTypeForSetter(parameterClass,
                selectKeyStatement.getKeyProperty());
          }
        }
      } catch (ClassNotFoundException e) {
        throw new SqlMapException("Error.  Could not set result class.  Cause: " + e, e);
      }
      if (resultClass == null) {
        resultClass = Object.class;
      }


      // process SQL statement, including inline parameter maps
      errorContext.setMoreInfo("Check the select key SQL statement.");
      Sql sql = processor.getSql();
      setSqlForStatement(selectKeyStatement, sql);
      ResultMap resultMap;
      resultMap = new AutoResultMap(client.getDelegate(), false);
      resultMap.setId(selectKeyStatement.getId() + "-AutoResultMap");
      resultMap.setResultClass(resultClass);
      resultMap.setResource(selectKeyStatement.getResource());
      selectKeyStatement.setResultMap(resultMap);
      errorContext.setMoreInfo(null);
      insertStatement.setSelectKeyStatement(selectKeyStatement);
    } else {
      throw new SqlMapException("You cant set a select key statement on statement named " + rootStatement.getId()
          + " because it is not an InsertStatement.");
    }
  }

View Full Code Here

0 1 2 3 4 5

TOP

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.