Package com.uwyn.rife.database.queries

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


      .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

    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

    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

TOP

Related Classes of com.uwyn.rife.database.queries.Insert

Copyright © 2018 www.massapicom. 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.