Android Open Source - android-core Database

• Back to Map/object  ↑

From Project

Back to project page android-core.

License

The source code is released under:

Apache License

Java Source Code

/** 
 * [SIMINOV FRAMEWORK]/*from   w  w  w . java2 s. c om*/
 * Copyright [2015] [Siminov Software Solution LLP|support@siminov.com]
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 **/

package siminov.core.database;

import java.util.Iterator;
import java.util.Map;

import siminov.core.database.design.IAverage;
import siminov.core.database.design.ICount;
import siminov.core.database.design.IDatabase;
import siminov.core.database.design.IDelete;
import siminov.core.database.design.IGroupConcat;
import siminov.core.database.design.IMax;
import siminov.core.database.design.IMin;
import siminov.core.database.design.ISelect;
import siminov.core.database.design.ISum;
import siminov.core.database.design.ITotal;
import siminov.core.exception.DatabaseException;
import siminov.core.model.DatabaseDescriptor;
import siminov.core.model.DatabaseMappingDescriptor;
import siminov.core.resource.ResourceManager;

/**
 * Exposes methods to interact with database. 
 * It has methods to create, delete, and perform other common database management tasks.
 */
public class Database implements IDatabase {

  private Object object = null;
  
  /**
   * Database Constructor
   */
  public Database() {
    
  }
  
  public Database(Object object) {
    this.object = object;
  }
  
  /**
   * It drop's the whole database based on database name.
      <p>
      <pre> Drop the Liquor table.
  
  {@code
  
    DatabaseDescriptor databaseDescriptor = new Liquor().getDatabaseDescriptor();
    
    try {
      Database.dropDatabase(databaseDescriptor.getDatabaseName());
    } catch(DatabaseException databaseException) {
      //Log It.
    }
  
  }
      </pre>
    </p>
   * @param databaseName Database-mapping object which defines the structure of table.
   * @throws DatabaseException If not able to drop database.
   */
  public static void dropDatabase(String databaseName) throws DatabaseException {
    ResourceManager resourceManager = ResourceManager.getInstance();
    DatabaseHelper.dropDatabase(resourceManager.getDatabaseDescriptorBasedOnName(databaseName));
  }
  
  /**
     Is used to create a new table in an database.
      <p>
      Using SIMINOV there are three ways to create table in database.
       
       <pre> 
        <ul>
          <li> Describing table structure in form of DATABASE-MAPPING-DESCRIPTOR XML file. And creation of table will be handled by SIMINOV.
            <p>
SIMINOV will parse each DATABASE-MAPPING-DESCRIPTOR XML defined by developer and create table's in database.
            
Example:
  {@code

    <database-mapping-descriptor>
    
      <entity table_name="LIQUOR" class_name="siminov.core.sample.model.Liquor">
        
        <attribute variable_name="liquorType" column_name="LIQUOR_TYPE">
          <property name="type">java.lang.String</property>
          <property name="primary_key">true</property>
          <property name="not_null">true</property>
          <property name="unique">true</property>
        </attribute>    
    
        <attribute variable_name="description" column_name="DESCRIPTION">
          <property name="type">java.lang.String</property>
        </attribute>
    
        <attribute variable_name="history" column_name="HISTORY">
          <property name="type">java.lang.String</property>
        </attribute>
    
        <attribute variable_name="link" column_name="LINK">
          <property name="type">java.lang.String</property>
          <property name="default">www.wikipedia.org</property>
        </attribute>
    
        <attribute variable_name="alcholContent" column_name="ALCHOL_CONTENT">
          <property name="type">java.lang.String</property>
        </attribute>
    
        <index name="LIQUOR_INDEX_BASED_ON_LINK" unique="true">
          <attribute>HISTORY</attribute>
        </index>
    
        <relationships>
    
            <one-to-many refer="liquorBrands" refer_to="siminov.core.sample.model.LiquorBrand" on_update="cascade" on_delete="cascade">
            <property name="load">true</property>
          </one-to-many>    
            
        </relationships>
                          
      </entity>
    
    </database-mapping-descriptor>    
  }
          </p>
          </li>
        </ul> 
      </pre>
    </p>
    
   * @throws DatabaseException If not able to create table in SQLite.
   */
  public void createTable() throws DatabaseException {
    DatabaseHelper.createTable(getDatabaseMappingDescriptor());
  }

  /**
   * It drop's the table from database based on database-mapping.
      <p>
      <pre> Drop the Liquor table.
  
  {@code
  
  Liquor liquor = new Liquor();
  
  try {
    liquor.dropTable();
  } catch(DatabaseException databaseException) {
    //Log It.
  }
  
  }
  
      </pre>
    </p>

   * @throws DatabaseException If not able to drop table.
   */
  public void dropTable() throws DatabaseException {
    DatabaseHelper.dropTable(getDatabaseMappingDescriptor());
  }

  /**
     Is used to drop a index on a table in database.
      <p>
      <pre> Create Index On Liquor table.
  
  {@code
  
  String indexName = "LIQUOR_INDEX_BASED_ON_LINK";
  Liquor liquor = new Liquor();
  
  try {
    liquor.dropIndex(indexName);
  } catch(DatabaseException databaseException) {
    //Log It.
  }
  
  }
      </pre>
    </p>

   * @param indexName Name of a index needs to be drop.
   * @throws DatabaseException If not able to drop index on table.
   */
  public void dropIndex(String indexName) throws DatabaseException {
    DatabaseHelper.dropIndex(getDatabaseMappingDescriptor(), indexName);
  }
  

  /**
   Returns all tuples based on query from mapped table for invoked class object.
 
   <pre>
   
Example:

{@code

Liquor[] liquors = null;
try {
  liquors = new Liquor().select().execute();
} catch(DatabaseException de) {
  //Log it.
}
     
}       
   </pre>

     @return ISelect object.
     @throws DatabaseException If any error occur while getting tuples from a single table.
   */
  public ISelect select() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), ISelect.class.getName());
  }

  /**
   Returns all tuples based on manual query from mapped table for invoked class object.
 
   <pre>
   
Example:

{@code

String query = "SELECT * FROM LIQUOR";

Liquor[] liquors = null;
try {
  liquors = new Liquor().select(query);
} catch(DatabaseException de) {
  //Log it.
}
     
}       
   </pre>

    @param query Query to get tuples from database.
     @return ISelect object.
     @throws DatabaseException If any error occur while getting tuples from a single table.
   */
  public Object[] select(String query) throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.select(object, query);
    } else {
      return DatabaseHelper.select(this, query);
    }
  }

  /**
  It adds a record to any single table in a relational database.

     <pre>
     
Example: Make Liquor Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

try {
  beer.save();
} catch(DatabaseException de) {
  //Log it.
}

}

    </pre>
 
     @throws DatabaseException If any error occurs while saving tuples in database.
   */
  public void save() throws DatabaseException {

    if(object != null) {
      DatabaseHelper.save(object);
    } else {
      DatabaseHelper.save(this);
    }
  }

  /**
  It updates a record to any single table in a relational database.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

try {
  beer.update();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while saving tuples in database.
   */
  public void update() throws DatabaseException {
    
    if(object != null) {
      DatabaseHelper.update(object);
    } else {
      DatabaseHelper.update(this);
    }
  }

  
  /**
    It finds out whether tuple exists in table or not.
    IF NOT EXISTS:
      adds a record to any single table in a relational database.
    ELSE:
      updates a record to any single table in a relational database.
  
       <pre>
       
Example: Make Beer Object

  {@code

  Liquor beer = new Liquor();
  beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
  beer.setDescription(applicationContext.getString(R.string.beer_description));
  beer.setHistory(applicationContext.getString(R.string.beer_history));
  beer.setLink(applicationContext.getString(R.string.beer_link));
  beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));
  
  try {
    beer.saveOrUpdate();
  } catch(DatabaseException de) {
    //Log it.
  }
      
  }      
        
      </pre>
   
       @throws DatabaseException If any error occurs while saving tuples in database.
   */
  public void saveOrUpdate() throws DatabaseException {
    
    if(object != null) {
      DatabaseHelper.saveOrUpdate(object);
    } else {
      DatabaseHelper.saveOrUpdate(this);
    }
  }

  /**
  It deletes a record from single table in a relational database.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

try {
  beer.delete();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while saving tuples in database.
   */
  public IDelete delete() throws DatabaseException {
    
    if(object != null) {
      return new Where(getDatabaseMappingDescriptor(), IDelete.class.getName(), object);
    } else {
      return new Where(getDatabaseMappingDescriptor(), IDelete.class.getName(), this);
    }
  }

  /**
  Returns the count of rows based on where clause provided.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

int noOfBeers = 0;

try {
  noOfBeers = beer.count().execute();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while getting count of tuples from database.
   */
  public ICount count() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), ICount.class.getName());
  }

  /**
  Returns the average based on where clause provided.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

int noOfBeers = 0;

try {
  noOfBeers = beer.avg().execute();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while getting average from database.
   */
  public IAverage avg() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), IAverage.class.getName());
  }

  /**
  Returns the sum based on where clause provided.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

int noOfBeers = 0;

try {
  noOfBeers = beer.sum().execute();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while getting sum from database.
   */
  public ISum sum() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), ISum.class.getName());
  }

  /**
  Returns the total based on where clause provided.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

int totalBeers = 0;

try {
  totalBeers = beer.avg().execute();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while getting total tuples from database.
   */
  public ITotal total() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), ITotal.class.getName());
  }

  /**
  Returns the min based on where clause provided.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

int minBeers = 0;

try {
  minBeers = beer.min().execute();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while getting min from database.
   */
  public IMin min() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), IMin.class.getName());
  }

  /**
  Returns the max based on where clause provided.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

int maxBeers = 0;

try {
  maxBeers = beer.max().execute();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while getting max from database.
   */
  public IMax max() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), IMax.class.getName());
  }

  /**
  Returns the group concat based on where clause provided.

     <pre>

Example: Make Beer Object

{@code

Liquor beer = new Liquor();
beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
beer.setDescription(applicationContext.getString(R.string.beer_description));
beer.setHistory(applicationContext.getString(R.string.beer_history));
beer.setLink(applicationContext.getString(R.string.beer_link));
beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

int groupConcatBeers = 0;

try {
  groupConcatBeers = beer.groupConcat().execute();
} catch(DatabaseException de) {
  //Log it.
}

}
    </pre>
 
     @throws DatabaseException If any error occurs while getting group concat from database.
   */
  public IGroupConcat groupConcat() throws DatabaseException {
    return new Where(getDatabaseMappingDescriptor(), IGroupConcat.class.getName());
  }

  /**
   * Returns database descriptor object based on the POJO class called.

   <pre>
Example:

  {@code
  try {
    DatabaseDescriptor databaseDescriptor = new Liquor().getDatabaseDescriptor();
  } catch(DatabaseException databaseException) {
    //Log It.
  }
  
  }
  </pre>
  
   * @return Database Descriptor Object.
   * @throws DatabaseException If any error occur while getting database descriptor object.
   */
  public DatabaseDescriptor getDatabaseDescriptor() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getDatabaseDescriptor(object.getClass().getName());
    } else {
      return DatabaseHelper.getDatabaseDescriptor(this.getClass().getName());
    }
  }

  /**
   Returns the actual database mapping object mapped for invoked class object.
 
   <pre>
   
Example:
{@code
       
DatabaseMapping databaseMapping = null;
try {
  databaseMapping = new Liquor().getDatabaseMapping();
} catch(DatabaseException de) {
  //Log it.
}

}       
    
   </pre>
   
   @return DatabaseMapping Object
   @throws DatabaseException If database mapping object not mapped for invoked class object.
   */
  public DatabaseMappingDescriptor getDatabaseMappingDescriptor() throws DatabaseException {

    if(object != null) {
      return DatabaseHelper.getDatabaseMappingDescriptor(object.getClass().getName());
    } else {
      return DatabaseHelper.getDatabaseMappingDescriptor(this.getClass().getName());
    }
  }

  
  /**
   Returns the mapped table name for invoked class object.
 
   <pre>

Example:

{@code

String tableName = null;
try {
  tableName = new Liquor().getTableName();
} catch(DatabaseException de) {
  //Log it.
}

}
       
   </pre>
 
   @return Mapped Table name.
   @throws DatabaseException If no mapped table found for invoked class object.
   */
  public String getTableName() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getTableName(object);
    } else {
      return DatabaseHelper.getTableName(this);
    }
  }

  /**
   Returns all column names of mapped table.
   
   <pre>

Example:

{@code

Iterator<String> columnNames = null;
try {
  columnNames = new Liquor().getColumnNames();
} catch(DatabaseException de) {
  //Log it.
}
     
}       
   </pre>
   
   @return All column names of mapped table.
   @throws DatabaseException If no mapped table found for invoked class object.
   */
  public Iterator<String> getColumnNames() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getColumnNames(object);
    } else {
      return DatabaseHelper.getColumnNames(this);
    }
  }

  /**
   Returns all column values in the same order of column names for invoked class object.
   
   <pre>

Example:
{@code

Map<String, Object> values = null;
try {
  values = new Liquor().getColumnValues();
} catch(DatabaseException de) {
  //Log it.
}

}  
   </pre>
   
   @return All column values for invoked object.
   @throws DatabaseException If no mapped table found for invoked class object.
   */
  public Map<String, Object> getColumnValues() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getColumnValues(object);
    } else {
      return DatabaseHelper.getColumnValues(this);
    }
  }

  /**
   Returns all columns with there data types for invoked class object.

   <pre>

Example:

{@code

Map<String, String> columnTypes = null;
try {
  columnTypes = new Liquor().getColumnTypes();
} catch(DatabaseException de) {
  //Log it.
}  

}     
   </pre>
   
   @return All columns with there data types.
   @throws DatabaseException If no mapped table found for invoked class object.
   */
  public Map<String, String> getColumnTypes() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getColumnTypes(object);
    } else {
      return DatabaseHelper.getColumnTypes(this);
    }
  }

  /**
   Returns all primary keys of mapped table for invoked class object.
   
   <pre>

Example:
     
{@code

Iterator<String> primaryKeys = null;
try {
  primaryKeys = new Liquor().getPrimeryKeys();
} catch(DatabaseException de) {
  //Log it.
}

}   
   </pre>
 
   @return All primary keys.
   @throws DatabaseException If not mapped table found for invoked class object.
   */
  public Iterator<String> getPrimaryKeys() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getPrimaryKeys(object);
    } else {
      return DatabaseHelper.getPrimaryKeys(this);
    }
  }

  /**
   Returns all mandatory fields which are associated with mapped table for invoked class object.
 
   <pre>

Example:
       
{@code

Iterator<String> mandatoryFields = null;
try {
  mandatoryFields = new Liquor().getMandatoryFields();
} catch(DatabaseException de) {
  //Log it.
}

}       
   </pre>
 
   @return All mandatory fields for mapped table.
   @throws DatabaseException If no mapped table found for invoked class object.
   */
  public Iterator<String> getMandatoryFields() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getMandatoryFields(object);
    } else {
      return DatabaseHelper.getMandatoryFields(this);
    }
  }

  /**
   Returns all unique fields which are associated with mapped table for invoked class object.
 
   <pre>

Example:
       
{@code
       
Iterator<String> uniqueFields = null;
try {
  uniqueFields = new Liquor().getUniqueFields();
} catch(DatabaseException de) {
  //Log it.
}
     
}       
   </pre>
 
   @return All unique fields for mapped table.
   @throws DatabaseException If no mapped table found for invoked class object.
   */
  public Iterator<String> getUniqueFields() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getUniqueFields(object);
    } else {
      return DatabaseHelper.getUniqueFields(this);
    }
  }

  /**
   Returns all foreign keys of mapped table for invoked class object.
 
   <pre>
     
Example:
       
{@code
       
Iterator<String> foreignKeys = null;
try {
  foreignKeys = new Liquor().getForeignKeys();
} catch(DatabaseException de) {
  //Log it.
}

}       
     
   </pre>
 
   @return All foreign keys of mapped table.
   @throws DatabaseException If no mapped table found for invoked class object.
 */
  public Iterator<String> getForeignKeys() throws DatabaseException {
    
    if(object != null) {
      return DatabaseHelper.getForeignKeys(object);
    } else {
      return DatabaseHelper.getForeignKeys(this);
    }
  }

  /**
     Begins a transaction in EXCLUSIVE mode.
     <p>
     Transactions can be nested. When the outer transaction is ended all of the work done in that transaction and all of the nested transactions will be committed or rolled back.
     The changes will be rolled back if any transaction is ended without being marked as clean(by calling commitTransaction). Otherwise they will be committed.
    
     <pre>

Example: Make Beer Object

  {@code

  Liquor beer = new Liquor();
  beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
  beer.setDescription(applicationContext.getString(R.string.beer_description));
  beer.setHistory(applicationContext.getString(R.string.beer_history));
  beer.setLink(applicationContext.getString(R.string.beer_link));
  beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

  DatabaseDescriptor databaseDescriptor = beer.getDatabaseDescriptor();

  try {
    Database.beginTransaction(databaseDescriptor);
  
    beer.save();

    Database.commitTransaction(databaseDescriptor);
  } catch(DatabaseException de) {
    //Log it.
  } finally {
    Database.endTransaction(databaseDescriptor);
  }
        
  }        
     </pre>
    
   * @throws DatabaseException If beginTransaction does not starts.
   */
  public static void beginTransaction(final DatabaseDescriptor databaseDescriptor) throws DatabaseException {
    DatabaseHelper.beginTransaction(databaseDescriptor);
  }
  
  
  /**
     Marks the current transaction as successful. 
     <p> Finally it will End a transaction.
     <pre>

Example: Make Beer Object
  {@code

  Liquor beer = new Liquor();
  beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
  beer.setDescription(applicationContext.getString(R.string.beer_description));
  beer.setHistory(applicationContext.getString(R.string.beer_history));
  beer.setLink(applicationContext.getString(R.string.beer_link));
  beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

  DatabaseDescriptor databaseDescriptor = beer.getDatabaseDescriptor();
  
  try {
    Database.beginTransaction(databaseDescriptor);
      
    beer.save();
  
    Database.commitTransaction(databaseDescriptor);
  } catch(DatabaseException de) {
    //Log it.
  } finally {
    Database.endTransaction(databaseDescriptor);
  }
  
  }

      </pre>
   * @throws DatabaseException If not able to commit the transaction.
   */
  public static void commitTransaction(final DatabaseDescriptor databaseDescriptor) throws DatabaseException {
    DatabaseHelper.commitTransaction(databaseDescriptor);
  }
  
  /**
   * End the current transaction.
  
  <pre>

Example:
  {@code

  Liquor beer = new Liquor();
  beer.setLiquorType(Liquor.LIQUOR_TYPE_BEER);
  beer.setDescription(applicationContext.getString(R.string.beer_description));
  beer.setHistory(applicationContext.getString(R.string.beer_history));
  beer.setLink(applicationContext.getString(R.string.beer_link));
  beer.setAlcholContent(applicationContext.getString(R.string.beer_alchol_content));

  DatabaseDescriptor databaseDescriptor = beer.getDatabaseDescriptor();
  
  try {
    Database.beginTransaction(databaseDescriptor);
      
    beer.save();
  
    Database.commitTransaction(databaseDescriptor);
  } catch(DatabaseException de) {
    //Log it.
  } finally {
    Database.endTransaction(databaseDescriptor);
  }
  
  }
  </pre>

   * @param databaseDescriptor Database Descriptor Object.
   */
  public static void endTransaction(final DatabaseDescriptor databaseDescriptor) {
    DatabaseHelper.endTransaction(databaseDescriptor);
  }
}

Java Source Code List

• Back to Map/object  ↑