congrats Icon
New! Tabnine Pro 14-day free trial
Start a free trial
Tabnine Logo
SqlJetDb.createIndex
Code IndexAdd Tabnine to your IDE (free)

How to use
createIndex
method
in
org.tmatesoft.sqljet.core.table.SqlJetDb

Best Java code snippets using org.tmatesoft.sqljet.core.table.SqlJetDb.createIndex (Showing top 10 results out of 315)

origin: org.tmatesoft.svnkit/svnkit

  public Object run(SqlJetDb db) throws SqlJetException {
    db.createTable("create table revprop (revision integer UNIQUE not null, " +
        "properties BLOB not null);");
    db.createIndex("create index i_revision on revprop (revision);");
    db.getOptions().setUserVersion(1);
    return null;
  }
});
origin: org.syncloud/syncloud-dao-sqljet

private void createStructure(SqlJetDb db) throws SqlJetException {
  db.beginTransaction(SqlJetTransactionMode.WRITE);
  try {
    db.createTable("CREATE TABLE states (full_name TEXT NOT NULL PRIMARY KEY, version TEXT NULL)");
    db.createIndex("CREATE INDEX full_name_index ON states(full_name)");
  } finally {
    db.commit();
  }
}
origin: ha-jdbc/ha-jdbc

  @Override
  public void execute(SqlJetDb database) throws SqlJetException
  {
    ISqlJetSchema schema = database.getSchema();
    if (schema.getTable(INVOCATION_TABLE) == null)
    {
      database.createTable(CREATE_INVOCATION_SQL);
    }
    if (schema.getTable(INVOKER_TABLE) == null)
    {
      database.createTable(CREATE_INVOKER_SQL);
      database.createIndex(CREATE_INVOKER_INDEX);
    }
  }
};
origin: org.tmatesoft.sqljet/sqljet

  handleDropTable();
} else if ("create_index".equalsIgnoreCase(stmtName)) {
  db.createIndex(sql);
} else if ("drop_index".equalsIgnoreCase(stmtName)) {
  handleDropIndex();
origin: org.tmatesoft.svnkit/svnkit

private void ensureNodesMovedToIndex(SVNSqlJetDb sDb) throws SVNException {
  try {
    sDb.beginTransaction(SqlJetTransactionMode.WRITE);
    if (sDb.getDb().getSchema().getIndex("I_NODES_MOVED") == null) {
      sDb.getDb().createIndex("CREATE UNIQUE INDEX I_NODES_MOVED ON NODES (wc_id, moved_to, op_depth);");
    }
    sDb.commit();
  } catch (SqlJetException e) {
    sDb.rollback();
    SVNSqlJetDb.createSqlJetError(e);
  }
  
}
origin: org.tmatesoft.svnkit/svnkit

public void bumpTo(SVNWCDb db, SVNSqlJetDb sDb, File wcRootAbsPath) throws SVNException {
  try {
    if (sDb.getDb().getSchema().getTable("NODES").getColumn("inherited_props") == null) {
      sDb.getDb().createIndex("CREATE UNIQUE INDEX IF NOT EXISTS I_NODES_MOVED ON NODES (wc_id, moved_to, op_depth);");
      sDb.getDb().createIndex("CREATE INDEX IF NOT EXISTS I_PRISTINE_MD5 ON PRISTINE (md5_checksum);");
origin: org.tmatesoft.svnkit/svnkit

      "  PRIMARY KEY (wc_id, local_relpath) " +
      "); "); 
  sDb.getDb().createIndex("CREATE INDEX I_EXTERNALS_PARENT ON EXTERNALS (wc_id, parent_relpath);");
  sDb.getDb().createIndex("CREATE UNIQUE INDEX I_EXTERNALS_DEFINED ON EXTERNALS (wc_id, def_local_relpath, local_relpath);");
} catch (SqlJetException e) {
  SVNSqlJetDb.createSqlJetError(e);
origin: org.tmatesoft.svnkit/svnkit

  db.createIndex(stmt.getSql()); 
db.createIndex(stmt.getSql()); 
origin: org.tmatesoft.svnkit/svnkit

sDb.getDb().createIndex("CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath, local_relpath, op_depth);");
sDb.getDb().dropIndex("I_ACTUAL_PARENT");
sDb.getDb().createIndex("CREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (wc_id, parent_relpath, local_relpath);");
origin: org.tmatesoft.svnkit/svnkit

  + "  changed_revision  INTEGER, changed_date INTEGER, changed_author TEXT, translated_size  INTEGER, last_mod_time  INTEGER, "
  + "  dav_cache  BLOB, file_external  TEXT, PRIMARY KEY (wc_id, local_relpath, op_depth) ); ");
sDb.getDb().createIndex("CREATE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath, op_depth); ");
org.tmatesoft.sqljet.core.tableSqlJetDbcreateIndex

Javadoc

Create index from SQL clause.

Popular methods of SqlJetDb

  • getTable
    Open table.
  • open
  • close
  • getOptions
  • createTable
    Create table from SQL clause.
  • runWithLock
    Do some actions with locking database's internal threads synchronization mutex. It is related only w
  • runWriteTransaction
    Run modifications in write transaction.
  • beginTransaction
  • commit
  • getSchema
    Get database schema.
  • runReadTransaction
    Run read-only transaction.
  • dropIndex
    Drop index.
  • runReadTransaction,
  • dropIndex,
  • dropTable,
  • getTemporaryDatabase,
  • isInTransaction,
  • isOpen,
  • rollback,
  • <init>,
  • alterTable

Popular in Java

  • Parsing JSON documents to java classes using gson
  • setRequestProperty (URLConnection)
  • addToBackStack (FragmentTransaction)
  • scheduleAtFixedRate (ScheduledExecutorService)
  • Color (java.awt)
    The Color class is used to encapsulate colors in the default sRGB color space or colors in arbitrary
  • Thread (java.lang)
    A thread is a thread of execution in a program. The Java Virtual Machine allows an application to ha
  • ConnectException (java.net)
    A ConnectException is thrown if a connection cannot be established to a remote host on a specific po
  • UUID (java.util)
    UUID is an immutable representation of a 128-bit universally unique identifier (UUID). There are mul
  • Options (org.apache.commons.cli)
    Main entry-point into the library. Options represents a collection of Option objects, which describ
  • StringUtils (org.apache.commons.lang)
    Operations on java.lang.String that arenull safe. * IsEmpty/IsBlank - checks if a String contains
  • Sublime Text for Python
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimAtomGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyStudentsTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now