Examples of Insert


Examples of com.headius.invokebinder.transform.Insert

     * @param index the index at which to insert the argument value
     * @param value the value to insert
     * @return a new Binder
     */
    public Binder insert(int index, boolean value) {
        return new Binder(this, new Insert(index, value));
    }
View Full Code Here

Examples of com.taobao.tdhs.client.easy.Insert

        processResponse(response, true);
    }

    private void doInsert(com.taobao.tdhs.client.statement.Statement s, ParseSQL parseSQL, String tableName,
                          String dbName) throws SQLException {
        Insert insert = s.insert().use(dbName).from(tableName);
        List<Entry<String, String>> insertEntries = parseSQL.getInsertEntries();
        if (insertEntries == null || insertEntries.isEmpty()) {
            throw new TDHSSQLException("no value to insert!", parseSQL.getSql());
        }
        for (Entry<String, String> e : insertEntries) {
            if (StringUtils.isBlank(e.getKey()) || StringUtils.isBlank(e.getValue())) {
                throw new TDHSSQLException("insert column and values can't be empty!", parseSQL.getSql());
            }
            String field = StringUtil.escapeField(StringUtils.trim(e.getKey()));
            if (field == null) {
                throw new TDHSSQLException("insert column is error!", parseSQL.getSql());
            }
            String value = StringUtils.trim(e.getValue());
            if (StringUtils.equalsIgnoreCase("null", value)) {
                insert.valueSetNull(field);
            } else if (StringUtils.equalsIgnoreCase("now()", value)) {
                insert.valueSetNow(field);
            } else {
                value = StringUtil.escapeValue(value);
                if (value == null) {
                    throw new TDHSSQLException("insert value is error!", parseSQL.getSql());
                }
                if (StringUtils.startsWith(value, BYTE_PARAMETER_PREFIX)) {
                    int pidx = ConvertUtil.safeConvertInt(StringUtils.substring(value, BYTE_PARAMETER_PREFIX.length()),
                            -1);
                    if (byteParameters.containsKey(pidx)) {
                        insert.value(field, byteParameters.get(pidx));
                    } else {
                        insert.value(field, value);
                    }
                } else {
                    insert.value(field, value);
                }
            }
        }
        TDHSResponse response = null;
        try {
            response = insert.insert();
        } catch (TDHSException e) {
            throw new SQLException(e);
        }
        processResponse(response, null, true, true);
    }
View Full Code Here

Examples of com.uwyn.rife.database.queries.Insert

      .whereParameter("botname", "=")
      .whereParameterAnd("channel", "=")
      .whereParameterAnd("servername", "=")
      .whereParameterAnd("lower(nickname)", "nickname", "=");

    mAddSeen = new Insert(getDatasource())
      .into("seen")
      .fieldParameter("botname")
      .fieldParameter("channel")
      .fieldParameter("servername")
      .fieldsParameters(SeenData.class);
View Full Code Here

Examples of com.uwyn.rife.database.queries.Insert

      .column("message", String.class, CreateTable.NOTNULL)
      .column("raw", String.class, CreateTable.NOTNULL);

    mCreateGetLogMessagesIndex = "CREATE INDEX log_getlog_idx ON "+mCreateTableLog.getTable()+" (botname, channel, servername, moment)";

    mAddLog = new Insert(getDatasource())
      .into(mCreateTableLog.getTable())
      .fieldCustom("moment", "CURRENT_TIMESTAMP")
      .fieldParameter("botname")
      .fieldParameter("channel")
      .fieldParameter("servername")
View Full Code Here

Examples of com.uwyn.rife.database.queries.Insert

    super(datasource);

    mCreateTableFaq = mCreateTableFaq
      .customAttribute("id", "AUTO_INCREMENT");

    mAddFaq = new Insert(getDatasource())
      .into("faq")
      .fieldsParametersExcluded(FaqData.class, new String[] {"id"})
      .fieldParameter("botname");
  }
View Full Code Here

Examples of com.uwyn.rife.database.queries.Insert

    super(datasource);

    mCreateTableFaq = mCreateTableFaq
      .customAttribute("id", "GENERATED ALWAYS AS IDENTITY");

    mAddFaq = new Insert(getDatasource())
      .into("faq")
      .fieldsParametersExcluded(FaqData.class, new String[] {"id"})
      .fieldParameter("botname");
  }
View Full Code Here

Examples of dk.brics.string.stringoperations.Insert

                Integer pos = trackInteger(expr.getArg(0));
                Variable rvar = valueOf(expr.getArgBox(1), arguments.get(1), 10, target.getParameterType(0), factory);
                if (pos != null && pos.intValue() == 0) {
                  factory.addStatement(new StringBufferPrepend(callee, rvar));
                } else {
                  factory.addStatement(new StringBufferBinaryOp(callee, new Insert(), rvar));
                }
                return callee;
            }
            // StringBuffer.delete(int,int)
            else if (methodName.equals("delete") && numArgs == 2) {
View Full Code Here

Examples of jp.ameba.mongo.protocol.Insert

   
    client.delete(new Delete("test", "insert", new BasicBSONObject("_id", 1)));
   
    // insert new document
    client.insert(
        new Insert("test", "insert",
          new BasicBSONObject("_id", 1)
            .append("name", "test-name")
            .append("integer", 100)
            .append("long", 1000L)
            .append("binary", "test binary".getBytes())
    ));

    // find
    Query query = new Query("test", "insert", 0, 1, new BasicBSONObject("_id", 1), null);
    Response response = client.query(query);
    Assert.assertNotNull(response);
    Assert.assertEquals(1, response.getNumberReturned());
    Assert.assertEquals(0, response.getStartingFrom());
    Assert.assertEquals(query.getWaitingRequestId(), response.getHeader().getResponseTo());
   
    BSONObject resultObject = response.getDocuments().get(0);
    Assert.assertEquals(1, resultObject.get("_id"));
    Assert.assertEquals("test-name", resultObject.get("name"));
    Assert.assertEquals(100, resultObject.get("integer"));
    Assert.assertEquals(1000L, resultObject.get("long"));
    Assert.assertArrayEquals("test binary".getBytes(), (byte[]) resultObject.get("binary"));
   
    // Duplicate error
    MongoException me = null;
    try {
      client.insert(
          new Insert("test", "insert",
              new BasicBSONObject("_id", 1)
                .append("name", "test-name2")
          )
      );
    } catch (MongoException e) {
View Full Code Here

Examples of lupos.engine.operators.singleinput.sparul.Insert

      if(with!=null){
        Tuple<Construct, Item> entry = graphConstraints.get(i);
        if(entry.getSecond()==null)
          entry.setSecond(with);
      }
      MultipleURIOperator bo = new Insert(null, this.indexScanCreator.getDataset());
      connection.connect(bo);
      muos.add(bo);
    }   
    insertMultipleURIOperator(muos, graphConstraints, connection);
  }
View Full Code Here

Examples of net.sf.jsqlparser.statement.insert.Insert

                {if (true) return replace;}
    throw new Error("Missing return statement in function");
  }

  final public Insert Insert() throws ParseException {
        Insert insert = new Insert();
        Table table = null;
        Column tableColumn = null;
        List columns = new ArrayList();
        List primaryExpList = new ArrayList();
        ItemsList itemsList = null;
        Expression exp = null;
    jj_consume_token(K_INSERT);
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_INTO:
      jj_consume_token(K_INTO);
      break;
    default:
      jj_la1[10] = jj_gen;
      ;
    }
    table = Table();
    if (jj_2_2(2)) {
      jj_consume_token(79);
      tableColumn = Column();
                                              columns.add(tableColumn);
      label_5:
      while (true) {
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case 78:
          ;
          break;
        default:
          jj_la1[11] = jj_gen;
          break label_5;
        }
        jj_consume_token(78);
        tableColumn = Column();
                                                                                                      columns.add(tableColumn);
      }
      jj_consume_token(80);
    } else {
      ;
    }
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_VALUES:
      jj_consume_token(K_VALUES);
      jj_consume_token(79);
      exp = SimpleExpression();
                                                         primaryExpList.add(exp);
      label_6:
      while (true) {
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case 78:
          ;
          break;
        default:
          jj_la1[12] = jj_gen;
          break label_6;
        }
        jj_consume_token(78);
        exp = SimpleExpression();
                                                               primaryExpList.add(exp);
      }
      jj_consume_token(80);
                                                                                                   itemsList = new ExpressionList(primaryExpList);
      break;
    case K_SELECT:
    case 79:
      if (jj_2_3(2)) {
        jj_consume_token(79);
      } else {
        ;
      }
                          insert.setUseValues(false);
      itemsList = SubSelect();
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case 80:
        jj_consume_token(80);
        break;
      default:
        jj_la1[13] = jj_gen;
        ;
      }
      break;
    default:
      jj_la1[14] = jj_gen;
      jj_consume_token(-1);
      throw new ParseException();
    }
                insert.setItemsList(itemsList);
            insert.setTable(table);
            if (columns.size() > 0)
                insert.setColumns(columns);
        {if (true) return insert;}
    throw new Error("Missing return statement in function");
  }
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.