org.tmatesoft.sqljet.core.table.SqlJetDb.getTemporaryDatabase java code examples

/**
 * @see #getTemporaryDatabase(boolean)
 * 
 * @return SqlJetDb object for temporary database
 * @throws SqlJetException
 */
public SqlJetDb getTemporaryDatabase() throws SqlJetException {
  return getTemporaryDatabase(false);
}

public void statementCompleted(SqlJetDb db, SqlJetException error) throws SqlJetException {
  if (error == null) {
    this.db.getDb().getTemporaryDatabase().commit();
  } else {
    this.db.getDb().getTemporaryDatabase().rollback();
  }
}

public void statementCompleted(SqlJetDb db, SqlJetException error) throws SqlJetException {
  if (error == null) {
    this.db.getDb().getTemporaryDatabase().commit();
  } else {
    this.db.getDb().getTemporaryDatabase().rollback();
  }
}

public void statementCompleted(SqlJetDb db, SqlJetException error) throws SqlJetException {
  if (error == null) {
    this.db.getDb().getTemporaryDatabase().commit();
  } else {
    this.db.getDb().getTemporaryDatabase().rollback();
  }
}

public void statementCompleted(SqlJetDb db, SqlJetException error) throws SqlJetException {
  if (error == null) {
    this.db.getDb().getTemporaryDatabase().commit();
  } else {
    this.db.getDb().getTemporaryDatabase().rollback();
  }
}

public void statementStarted(SqlJetDb db) throws SqlJetException {
  this.db.getDb().getTemporaryDatabase().beginTransaction(SqlJetTransactionMode.WRITE);
}

public void statementStarted(SqlJetDb db) throws SqlJetException {
  this.db.getDb().getTemporaryDatabase().beginTransaction(SqlJetTransactionMode.WRITE);
}

public void statementStarted(SqlJetDb db) throws SqlJetException {
  this.db.getDb().getTemporaryDatabase().beginTransaction(SqlJetTransactionMode.WRITE);
}

public void statementStarted(SqlJetDb db) throws SqlJetException {
  this.db.getDb().getTemporaryDatabase().beginTransaction(SqlJetTransactionMode.WRITE);
}

/**
*    DROP TRIGGER IF EXISTS   trigger_changelist_list_actual_cl_insert;
*    CREATE TEMPORARY TRIGGER trigger_changelist_list_actual_cl_insert
*    BEFORE INSERT ON actual_node
*    BEGIN
*        INSERT INTO changelist_list(wc_id, local_relpath, notify, changelist)
*        VALUES (NEW.wc_id, NEW.local_relpath, 26, NEW.changelist);
*    END;     
*/
public void beforeInsert(SqlJetConflictAction conflictAction, ISqlJetTable table, Map<String, Object> newValues) throws SqlJetException {
  ISqlJetTable clltable = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.CHANGELIST_LIST.toString());
  
  Map<String, Object> rowValues = new HashMap<String, Object>();
  rowValues.put(CHANGELIST_LIST__Fields.wc_id.toString(), newValues.get(ACTUAL_NODE__Fields.wc_id.toString()));
  rowValues.put(CHANGELIST_LIST__Fields.local_relpath.toString(), newValues.get(ACTUAL_NODE__Fields.local_relpath.toString()));
  rowValues.put(CHANGELIST_LIST__Fields.notify.toString(), 26);
  rowValues.put(CHANGELIST_LIST__Fields.changelist.toString(), newValues.get(ACTUAL_NODE__Fields.changelist.toString()));
    
  clltable.insertByFieldNames(rowValues);
  
}

public SVNSqlJetDb getTemporaryDb() throws SVNException {
  if (temporaryDb == null) {
    try {
      temporaryDb = new SVNSqlJetDb(getDb().getTemporaryDatabase(temporaryDbInMemory), temporaryDbInMemory);
    } catch (SqlJetException e) {
      SVNErrorMessage err = SVNErrorMessage.create(SVNErrorCode.SQLITE_ERROR, e);
      SVNErrorManager.error(err, SVNLogType.WC);
      return null;
    }
  }
  return temporaryDb;
}

public void beforeDelete(ISqlJetCursor cursor) throws SqlJetException {
  ISqlJetTable table = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.REVERT_LIST.toString());
  
  Map<String, Object> rowValues = new HashMap<String, Object>();
  rowValues.put(REVERT_LIST__Fields.local_relpath.toString(), cursor.getValue(NODES__Fields.local_relpath.toString()));
  rowValues.put(REVERT_LIST__Fields.actual.toString(), 0);
  rowValues.put(REVERT_LIST__Fields.op_depth.toString(), cursor.getValue(NODES__Fields.op_depth.toString()));
  rowValues.put(REVERT_LIST__Fields.repos_id.toString(), cursor.getValue(NODES__Fields.repos_id.toString()));
  rowValues.put(REVERT_LIST__Fields.kind.toString(), cursor.getValue(NODES__Fields.kind.toString()));
  table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, rowValues);
}

public void beforeUpdate(ISqlJetCursor cursor, Map<String, Object> newValues) throws SqlJetException {
  ISqlJetTable table = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.REVERT_LIST.toString());
  Map<String, Object> rowValues = new HashMap<String, Object>();
  rowValues.put(REVERT_LIST__Fields.local_relpath.toString(), cursor.getValue(ACTUAL_NODE__Fields.local_relpath.toString()));
  rowValues.put(REVERT_LIST__Fields.actual.toString(), 1);
  rowValues.put(REVERT_LIST__Fields.conflict_data.toString(), cursor.getBlobAsArray(ACTUAL_NODE__Fields.conflict_data.toString()));
  if (!cursor.isNull(ACTUAL_NODE__Fields.properties.toString())
      || !cursor.isNull(ACTUAL_NODE__Fields.tree_conflict_data.toString())) {
    rowValues.put(REVERT_LIST__Fields.notify.toString(), 1);
  } else if (!exists(db.getDb().getTemporaryDatabase(), cursor.getInteger(ACTUAL_NODE__Fields.wc_id.toString()), cursor.getString(ACTUAL_NODE__Fields.local_relpath.toString()))) {
    rowValues.put(REVERT_LIST__Fields.notify.toString(), 1);
  } else {
    rowValues.put(REVERT_LIST__Fields.notify.toString(), null);
  }
  table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, rowValues);
}

public void beforeUpdate(ISqlJetCursor cursor, Map<String, Object> newValues) throws SqlJetException {
  ISqlJetTable table = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.REVERT_LIST.toString());
  Map<String, Object> rowValues = new HashMap<String, Object>();
  rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.local_relpath.toString(), cursor.getValue(SVNWCDbSchema.ACTUAL_NODE__Fields.local_relpath.toString()));
  rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.actual.toString(), 1);
  rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.conflict_data.toString(), getConflictData(cursor));
  if (!cursor.isNull(SVNWCDbSchema.ACTUAL_NODE__Fields.properties.toString())
      || !cursor.isNull(SVNWCDbSchema.ACTUAL_NODE__Fields.tree_conflict_data.toString())) {
    rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.notify.toString(), 1);
  } else if (!exists(db.getDb().getTemporaryDatabase(), cursor.getInteger(SVNWCDbSchema.ACTUAL_NODE__Fields.wc_id.toString()), cursor.getString(SVNWCDbSchema.ACTUAL_NODE__Fields.local_relpath.toString()))) {
    rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.notify.toString(), 1);
  } else {
    rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.notify.toString(), null);
  }
  table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, rowValues);
}

public void beforeUpdate(ISqlJetCursor cursor, Map<String, Object> newValues) throws SqlJetException {
  ISqlJetTable table = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.CHANGELIST_LIST.toString());

public void beforeDelete(ISqlJetCursor cursor) throws SqlJetException {
  ISqlJetTable table = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.REVERT_LIST.toString());
  
  Map<String, Object> rowValues = new HashMap<String, Object>();
  rowValues.put(REVERT_LIST__Fields.local_relpath.toString(), cursor.getValue(ACTUAL_NODE__Fields.local_relpath.toString()));
  rowValues.put(REVERT_LIST__Fields.actual.toString(), 1);
  rowValues.put(REVERT_LIST__Fields.conflict_data.toString(), cursor.getBlobAsArray(ACTUAL_NODE__Fields.conflict_data.toString()));
  if (!cursor.isNull(ACTUAL_NODE__Fields.properties.toString()) 
      || !cursor.isNull(ACTUAL_NODE__Fields.tree_conflict_data.toString())) {
    rowValues.put(REVERT_LIST__Fields.notify.toString(), 1);
  } else if (!exists(db.getDb(), cursor.getInteger(ACTUAL_NODE__Fields.wc_id.toString()), cursor.getString(ACTUAL_NODE__Fields.local_relpath.toString()))) {
    rowValues.put(REVERT_LIST__Fields.notify.toString(), 1);
  } else {
    rowValues.put(REVERT_LIST__Fields.notify.toString(), null);
  }
  table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, rowValues);
}

public void beforeDelete(ISqlJetCursor cursor) throws SqlJetException {
  ISqlJetTable table = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.REVERT_LIST.toString());
  Map<String, Object> rowValues = new HashMap<String, Object>();
  rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.local_relpath.toString(), cursor.getValue(SVNWCDbSchema.ACTUAL_NODE__Fields.local_relpath.toString()));
  rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.actual.toString(), 1);
  rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.conflict_data.toString(), getConflictData(cursor));
  if (!cursor.isNull(SVNWCDbSchema.ACTUAL_NODE__Fields.properties.toString())
      || !cursor.isNull(SVNWCDbSchema.ACTUAL_NODE__Fields.tree_conflict_data.toString())) {
    rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.notify.toString(), 1);
  } else if (!exists(db.getDb(), cursor.getInteger(SVNWCDbSchema.ACTUAL_NODE__Fields.wc_id.toString()), cursor.getString(SVNWCDbSchema.ACTUAL_NODE__Fields.local_relpath.toString()))) {
    rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.notify.toString(), 1);
  } else {
    rowValues.put(SVNWCDbSchema.REVERT_LIST__Fields.notify.toString(), null);
  }
  table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, rowValues);
}

Popular methods of SqlJetDb

getTable
Open table.
open
close
getOptions
createIndex
Create index from SQL clause.
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.

Popular in Java

Reading from database using SQL prepared statement
getSystemService (Context)
getOriginalFilename (MultipartFile)
Return the original filename in the client's filesystem.This may contain path information depending
getResourceAsStream (ClassLoader)
Date (java.sql)
A class which can consume and produce dates in SQL Date format. Dates are represented in SQL as yyyy
Deque (java.util)
A linear collection that supports element insertion and removal at both ends. The name deque is shor
TreeSet (java.util)
TreeSet is an implementation of SortedSet. All optional operations (adding and removing) are support
Executor (java.util.concurrent)
An object that executes submitted Runnable tasks. This interface provides a way of decoupling task s
Notification (javax.management)
IOUtils (org.apache.commons.io)
General IO stream manipulation utilities. This class provides static utility methods for input/outpu
Top plugins for Android Studio

How to use getTemporaryDatabasemethodin org.tmatesoft.sqljet.core.table.SqlJetDb

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

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