org.tmatesoft.sqljet.core.table.ISqlJetCursor.isNull java code examples

Common ways to obtain ISqlJetCursor

private void myMethod () {
 ISqlJetCursor i =ISqlJetTable iSqlJetTable;ISqlJetTable iSqlJetTable2;iSqlJetTable.lookup(iSqlJetTable2.getPrimaryKeyIndexName(), new Object[]{hash})
Smart code suggestions by Codota
}

public boolean isNull(int field) throws SqlJetException {
  return cursor.isNull(field);
}

public boolean isNull(String fieldName) throws SqlJetException {
  return cursor.isNull(fieldName);
}

public boolean isNull(int columnIndex) throws SqlJetException {
  return cursor.isNull(columnIndex);
}

if (!cursor.isNull(HASH_FIELD)) {
  myHash = cursor.getString(HASH_FIELD);
if (!cursor.isNull(REVISION_FIELD)) {
  myRevision = cursor.getInteger(REVISION_FIELD);
if (!cursor.isNull(OFFSET_FIELD)) {
  myOffset = cursor.getInteger(OFFSET_FIELD);
if (!cursor.isNull(SIZE_FIELD)) {
  mySize = cursor.getInteger(SIZE_FIELD);
if (!cursor.isNull(EXPANDED_SIZE_FIELD)) {
  myExpandedSize = cursor.getInteger(EXPANDED_SIZE_FIELD);

if (!cursor.isNull(HASH_FIELD)) {
  myHash = cursor.getString(HASH_FIELD);
if (!cursor.isNull(REVISION_FIELD)) {
  myRevision = cursor.getInteger(REVISION_FIELD);
if (!cursor.isNull(OFFSET_FIELD)) {
  myOffset = cursor.getInteger(OFFSET_FIELD);
if (!cursor.isNull(SIZE_FIELD)) {
  mySize = cursor.getInteger(SIZE_FIELD);
if (!cursor.isNull(EXPANDED_SIZE_FIELD)) {
  myExpandedSize = cursor.getInteger(EXPANDED_SIZE_FIELD);

if (!cursor.isNull(HASH_FIELD)) {
  myHash = cursor.getString(HASH_FIELD);
if (!cursor.isNull(REVISION_FIELD)) {
  myRevision = cursor.getInteger(REVISION_FIELD);
if (!cursor.isNull(OFFSET_FIELD)) {
  myOffset = cursor.getInteger(OFFSET_FIELD);
if (!cursor.isNull(SIZE_FIELD)) {
  mySize = cursor.getInteger(SIZE_FIELD);
if (!cursor.isNull(EXPANDED_SIZE_FIELD)) {
  myExpandedSize = cursor.getInteger(EXPANDED_SIZE_FIELD);

private State read(ISqlJetCursor cursor) {
  try {
    String fullname = cursor.getString(StateTable.COL_FULL_NAME);
    String version = null;
    if (!cursor.isNull(StateTable.COL_VERSION))
      version = cursor.getString(StateTable.COL_VERSION);
    return new State(fullname, version);
  } catch (SqlJetException e) {
    logger.error("unable to read", e);
    return null;
  }
}

protected boolean isColumnNull(String f) throws SVNException {
  try {
    if (getCursor() == null || getCursor().eof())
      return true;
    return getCursor().isNull(f);
  } catch (SqlJetException e) {
    SVNSqlJetDb.createSqlJetError(e);
    return false;
  }
}

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 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);
}

if (!cursor.isNull(ACTUAL_NODE__Fields.changelist.toString()) && 
  (!cursor.getValue(ACTUAL_NODE__Fields.changelist.toString()).equals(newValues.get(ACTUAL_NODE__Fields.changelist.toString()) )
  || (newValues.get(ACTUAL_NODE__Fields.changelist.toString()) == null)))
    (cursor.isNull(ACTUAL_NODE__Fields.changelist.toString())
        ||    !cursor.getValue(ACTUAL_NODE__Fields.changelist.toString()).equals(newValues.get(ACTUAL_NODE__Fields.changelist.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 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);
}

InvokerEvent invokerEvent = SQLiteStateManager.this.eventFactory.createInvokerEvent(event.getTransactionId(), event.getPhase(), databaseId);
if (!cursor.isNull(RESULT_COLUMN))

Javadoc

Tests field value for null.

Popular methods of ISqlJetCursor

close
Closes the cursor.
eof
Tests whether this cursor is positioned behind the last record.
getString
Returns specified field's value as String.
getInteger
Returns specified field's value as integer.
delete
Deletes the current record.
getFieldsCount
Returns number of fields in the current record.
next
Goes to the next record.
getBlobAsArray
Returns specified field's value as BLOB.
updateByFieldNames
Updates the current record.
getBoolean
Returns specified field's value as boolean.
getFieldType
Returns field type.
getRowCount
Returns number of rows accessible with this cursor.

Popular in Java

Making http post requests using okhttp
getOriginalFilename (MultipartFile)
Return the original filename in the client's filesystem.This may contain path information depending
compareTo (BigDecimal)
startActivity (Activity)
Kernel (java.awt.image)
FileOutputStream (java.io)
A file output stream is an output stream for writing data to aFile or to a FileDescriptor. Whether
Path (java.nio.file)
DecimalFormat (java.text)
DecimalFormat is a concrete subclass ofNumberFormat that formats decimal numbers. It has a variety o
Base64 (org.apache.commons.codec.binary)
Provides Base64 encoding and decoding as defined by RFC 2045.This class implements section 6.8. Base
Runner (org.openjdk.jmh.runner)

How to use isNullmethodin org.tmatesoft.sqljet.core.table.ISqlJetCursor

Best Java code snippets using org.tmatesoft.sqljet.core.table.ISqlJetCursor.isNull (Showing top 14 results out of 315)

How to use
isNull
method
in
org.tmatesoft.sqljet.core.table.ISqlJetCursor