Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
mil.nga.geopackage.db.master.SQLiteMaster Maven / Gradle / Ivy
package mil.nga.geopackage.db.master;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import mil.nga.geopackage.db.GeoPackageCoreConnection;
import mil.nga.geopackage.db.table.ConstraintParser;
import mil.nga.geopackage.db.table.TableConstraints;
/**
* SQLite Master table queries (sqlite_master)
*
* @author osbornb
* @since 3.3.0
*/
public class SQLiteMaster {
/**
* Table Name
*/
public static final String TABLE_NAME = "sqlite_master";
/**
* SQLiteMaster query results
*/
private final List> results;
/**
* Mapping between result columns and indices
*/
private final Map columns = new HashMap<>();
/**
* Query result count
*/
private final int count;
/**
* Constructor
*
* @param results
* query results
* @param columns
* query columns
*/
private SQLiteMaster(List> results,
SQLiteMasterColumn[] columns) {
if (columns != null) {
this.results = results;
this.count = results.size();
for (int i = 0; i < columns.length; i++) {
this.columns.put(columns[i], i);
}
} else {
// Count only result
this.results = new ArrayList<>();
this.count = ((Number) results.get(0).get(0)).intValue();
}
}
/**
* Result count
*
* @return count
*/
public int count() {
return count;
}
/**
* Get the columns in the result
*
* @return columns
*/
public Set columns() {
return columns.keySet();
}
/**
* Get the type
*
* @param row
* row index
* @return type
*/
public SQLiteMasterType getType(int row) {
return SQLiteMasterType.valueOf(getTypeString(row).toUpperCase());
}
/**
* Get the type string
*
* @param row
* row index
* @return type string
*/
public String getTypeString(int row) {
return (String) getValue(row, SQLiteMasterColumn.TYPE);
}
/**
* Get the name
*
* @param row
* row index
* @return name
*/
public String getName(int row) {
return (String) getValue(row, SQLiteMasterColumn.NAME);
}
/**
* Get the table name
*
* @param row
* row index
* @return name
*/
public String getTableName(int row) {
return (String) getValue(row, SQLiteMasterColumn.TBL_NAME);
}
/**
* Get the rootpage
*
* @param row
* row index
* @return name
*/
public Long getRootpage(int row) {
return (Long) getValue(row, SQLiteMasterColumn.ROOTPAGE);
}
/**
* Get the sql
*
* @param row
* row index
* @return name
*/
public String getSql(int row) {
return (String) getValue(row, SQLiteMasterColumn.SQL);
}
/**
* Get the value of the column at the row index
*
* @param row
* row index
* @param column
* column type
* @return value
*/
public Object getValue(int row, SQLiteMasterColumn column) {
return getValue(getRow(row), column);
}
/**
* Get the row at the row index
*
* @param row
* row index
* @return row column values
*/
public List getRow(int row) {
if (row < 0 || row >= results.size()) {
String message;
if (results.isEmpty()) {
message = "Results are empty";
} else {
message = "Row index: " + row + ", not within range 0 to "
+ (results.size() - 1);
}
throw new IndexOutOfBoundsException(message);
}
return results.get(row);
}
/**
* Get the value in the row at the column index
*
* @param row
* row
* @param column
* column type
* @return value
*/
public Object getValue(List row, SQLiteMasterColumn column) {
return row.get(getColumnIndex(column));
}
/**
* Get the column index of the column type
*
* @param column
* column type
* @return column index
*/
public int getColumnIndex(SQLiteMasterColumn column) {
Integer index = columns.get(column);
if (index == null) {
throw new IndexOutOfBoundsException(
"Column does not exist in row values: " + column);
}
return index;
}
/**
* Get the constraints from table SQL
*
* @param row
* row index
* @return constraints
*/
public TableConstraints getConstraints(int row) {
TableConstraints constraints = new TableConstraints();
if (getType(row) == SQLiteMasterType.TABLE) {
String sql = getSql(row);
if (sql != null) {
constraints = ConstraintParser.getConstraints(sql);
}
}
return constraints;
}
/**
* Shortcut to build columns into an array
*
* @param columns
* columns
* @return columns
*/
public static SQLiteMasterColumn[] columns(SQLiteMasterColumn... columns) {
return columns;
}
/**
* Shortcut to build types into an array
*
* @param types
* types
* @return types
*/
public static SQLiteMasterType[] types(SQLiteMasterType... types) {
return types;
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @return count
*/
public static int count(GeoPackageCoreConnection db) {
return count(db, types(), SQLiteMasterQuery.create());
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db) {
return query(db, SQLiteMasterQuery.create());
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param tableName
* table name
* @return count
*/
public static int count(GeoPackageCoreConnection db, String tableName) {
return count(db, types(), tableName);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
String tableName) {
return query(db, SQLiteMasterColumn.values(), types(), tableName);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @return SQLiteMaster result
*/
public static SQLiteMaster queryForColumns(GeoPackageCoreConnection db,
Collection columns) {
return queryForColumns(db, columns, null);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster queryForColumns(GeoPackageCoreConnection db,
Collection columns, String tableName) {
return query(db, columns.toArray(new SQLiteMasterColumn[0]), types(),
tableName);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @return count
*/
public static int countByType(GeoPackageCoreConnection db,
SQLiteMasterType type) {
return countByType(db, type, null);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @return SQLiteMaster result
*/
public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
SQLiteMasterType type) {
return queryByType(db, type, null);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @return count
*/
public static int countByType(GeoPackageCoreConnection db,
Collection types) {
return countByType(db, types, null);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @return SQLiteMaster result
*/
public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
Collection types) {
return queryByType(db, types, null);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @param tableName
* table name
* @return count
*/
public static int countByType(GeoPackageCoreConnection db,
SQLiteMasterType type, String tableName) {
return count(db, type, tableName);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
SQLiteMasterType type, String tableName) {
return query(db, SQLiteMasterColumn.values(), type, tableName);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @param tableName
* table name
* @return count
*/
public static int countByType(GeoPackageCoreConnection db,
Collection types, String tableName) {
return count(db, types.toArray(new SQLiteMasterType[0]), tableName);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster queryByType(GeoPackageCoreConnection db,
Collection types, String tableName) {
return query(db, SQLiteMasterColumn.values(),
types.toArray(new SQLiteMasterType[0]), tableName);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @return count
*/
public static int count(GeoPackageCoreConnection db,
Collection types) {
return count(db, types, null);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param type
* result type
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
Collection columns, SQLiteMasterType type) {
return query(db, columns, type, null);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param types
* result types
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
Collection columns,
Collection types) {
return query(db, columns, types, null);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param type
* result type
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
Collection columns, SQLiteMasterType type,
String tableName) {
return query(db, columns.toArray(new SQLiteMasterColumn[0]), type,
tableName);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @param tableName
* table name
* @return count
*/
public static int count(GeoPackageCoreConnection db,
Collection types, String tableName) {
return count(db, types.toArray(new SQLiteMasterType[0]), tableName);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param types
* result types
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
Collection columns,
Collection types, String tableName) {
return query(db, columns.toArray(new SQLiteMasterColumn[0]),
types.toArray(new SQLiteMasterType[0]), tableName);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @return count
*/
public static int count(GeoPackageCoreConnection db,
SQLiteMasterType type) {
return count(db, types(type));
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param type
* result type
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, SQLiteMasterType type) {
return query(db, columns, types(type));
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @param tableName
* table name
* @return count
*/
public static int count(GeoPackageCoreConnection db, SQLiteMasterType type,
String tableName) {
return count(db, types(type), tableName);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param type
* result type
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, SQLiteMasterType type,
String tableName) {
return query(db, columns, types(type), tableName);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @return count
*/
public static int count(GeoPackageCoreConnection db,
SQLiteMasterType[] types) {
return count(db, types, SQLiteMasterQuery.create());
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param types
* result types
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, SQLiteMasterType[] types) {
return query(db, columns, types, SQLiteMasterQuery.create());
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @param tableName
* table name
* @return count
*/
public static int count(GeoPackageCoreConnection db,
SQLiteMasterType[] types, String tableName) {
SQLiteMasterQuery query = null;
if (tableName != null) {
query = SQLiteMasterQuery.create(SQLiteMasterColumn.TBL_NAME,
tableName);
}
return count(db, types, query);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param types
* result types
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, SQLiteMasterType[] types,
String tableName) {
SQLiteMasterQuery query = null;
if (tableName != null) {
query = SQLiteMasterQuery.create(SQLiteMasterColumn.TBL_NAME,
tableName);
}
return query(db, columns, types, query);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param query
* query
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterQuery query) {
return query(db, SQLiteMasterColumn.values(), query);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param query
* query
* @return count
*/
public static int count(GeoPackageCoreConnection db,
SQLiteMasterQuery query) {
return count(db, types(), query);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param query
* query
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, SQLiteMasterQuery query) {
return query(db, columns, types(), query);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @param query
* query
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterType type, SQLiteMasterQuery query) {
return query(db, SQLiteMasterColumn.values(), type, query);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param type
* result type
* @param query
* query
* @return count
*/
public static int count(GeoPackageCoreConnection db, SQLiteMasterType type,
SQLiteMasterQuery query) {
return count(db, types(type), query);
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param type
* result type
* @param query
* query
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, SQLiteMasterType type,
SQLiteMasterQuery query) {
return query(db, columns, types(type), query);
}
/**
* Count the sqlite_master table
*
* @param db
* connection
* @param types
* result types
* @param query
* query
* @return count
*/
public static int count(GeoPackageCoreConnection db,
SQLiteMasterType[] types, SQLiteMasterQuery query) {
return query(db, null, types, query).count();
}
/**
* Query the sqlite_master table
*
* @param db
* connection
* @param columns
* result columns
* @param types
* result types
* @param query
* query
* @return SQLiteMaster result
*/
public static SQLiteMaster query(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, SQLiteMasterType[] types,
SQLiteMasterQuery query) {
StringBuilder sql = new StringBuilder("SELECT ");
List args = new ArrayList<>();
if (columns != null && columns.length > 0) {
for (int i = 0; i < columns.length; i++) {
if (i > 0) {
sql.append(", ");
}
sql.append(columns[i].name().toLowerCase());
}
} else {
sql.append("count(*)");
}
sql.append(" FROM ");
sql.append(TABLE_NAME);
boolean hasQuery = query != null && query.has();
boolean hasTypes = types != null && types.length > 0;
if (hasQuery || hasTypes) {
sql.append(" WHERE ");
if (hasQuery) {
sql.append(query.buildSQL());
args.addAll(query.getArguments());
}
if (hasTypes) {
if (hasQuery) {
sql.append(" AND");
}
sql.append(" type IN (");
for (int i = 0; i < types.length; i++) {
if (i > 0) {
sql.append(", ");
}
sql.append("?");
args.add(types[i].name().toLowerCase());
}
sql.append(")");
}
}
List> results = db.queryResults(sql.toString(),
args.toArray(new String[0]));
SQLiteMaster sqliteMaster = new SQLiteMaster(results, columns);
return sqliteMaster;
}
/**
* Query the sqlite_master views on the table
*
* @param db
* connection
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster queryViewsOnTable(GeoPackageCoreConnection db,
String tableName) {
return queryViewsOnTable(db, SQLiteMasterColumn.values(), tableName);
}
/**
* Query the sqlite_master views on the table
*
* @param db
* connection
* @param columns
* result columns
* @param tableName
* table name
* @return SQLiteMaster result
*/
public static SQLiteMaster queryViewsOnTable(GeoPackageCoreConnection db,
SQLiteMasterColumn[] columns, String tableName) {
return query(db, columns, SQLiteMasterType.VIEW,
SQLiteMasterQuery.createTableViewQuery(tableName));
}
/**
* Count the sqlite_master views on the table
*
* @param db
* connection
* @param tableName
* table name
* @return count
*/
public static int countViewsOnTable(GeoPackageCoreConnection db,
String tableName) {
return count(db, SQLiteMasterType.VIEW,
SQLiteMasterQuery.createTableViewQuery(tableName));
}
/**
* Query for the table constraints
*
* @param db
* connection
* @param tableName
* table name
* @return SQL constraints
*/
public static TableConstraints queryForConstraints(
GeoPackageCoreConnection db, String tableName) {
TableConstraints constraints = new TableConstraints();
SQLiteMaster tableMaster = SQLiteMaster.queryByType(db,
SQLiteMasterType.TABLE, tableName);
for (int i = 0; i < tableMaster.count(); i++) {
constraints.addConstraints(tableMaster.getConstraints(i));
}
return constraints;
}
}
