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

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

Updating database using SQL prepared statement
orElseThrow (Optional)
Return the contained value, if present, otherwise throw an exception to be created by the provided s
getContentResolver (Context)
runOnUiThread (Activity)
ByteBuffer (java.nio)
A buffer for bytes. A byte buffer can be created in either one of the following ways: * #allocate
SecureRandom (java.security)
This class generates cryptographically secure pseudo-random numbers. It is best to invoke SecureRand
ImageIO (javax.imageio)
Reference (javax.naming)
Servlet (javax.servlet)
Defines methods that all servlets must implement. A servlet is a small Java program that runs within
SAXParseException (org.xml.sax)
Encapsulate an XML parse error or warning.> This module, both source code and documentation, is in t
Github Copilot alternatives

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