net.zer0bandwidth.android.lib.database

Class SQLiteColumnInfo

java.lang.Object

net.zer0bandwidth.android.lib.database.SQLiteColumnInfo

public class SQLiteColumnInfo
extends java.lang.Object

Contains information returned by the table_info pragma in SQLite.

Since:

zer0bandwidth-net/android 0.1.4 (#26)

Field Summary

Fields

Modifier and Type	Field and Description
boolean	bNotNull Indicates whether the column is defined NOT NULL.
boolean	bPrimaryKey Indicates whether the column is the table's primary key.
int	nColumnID The numeric ID of the column in any given row.
java.lang.String	sColumnName The name of the column in the table definition.
java.lang.String	sColumnType The magic SQLite token indicating this column's data type.
java.lang.String	sDefault The default value of the column, as a string.
java.lang.String	sTableName The name of the table containing this column.

Constructor Summary

Constructors

Constructor and Description
SQLiteColumnInfo()

Method Summary

Modifier and Type	Method and Description
static java.util.List<SQLiteColumnInfo>	gatherColumnList(android.database.sqlite.SQLiteDatabase db, java.lang.String sTableName) Gathers information about the columns in the specified table, and returns the column descriptions in a list.
static java.util.Map<java.lang.String,SQLiteColumnInfo>	gatherColumnMap(android.database.sqlite.SQLiteDatabase db, java.lang.String sTableName) Gathers information about the columns in the specified table, and returns the column descriptions in a map.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

sTableName

public java.lang.String sTableName

The name of the table containing this column.

nColumnID

public int nColumnID

The numeric ID of the column in any given row.

sColumnName

public java.lang.String sColumnName

The name of the column in the table definition.

sColumnType

public java.lang.String sColumnType

The magic SQLite token indicating this column's data type.

bNotNull

public boolean bNotNull

Indicates whether the column is defined NOT NULL.

sDefault

public java.lang.String sDefault

The default value of the column, as a string.

bPrimaryKey

public boolean bPrimaryKey

Indicates whether the column is the table's primary key.

Constructor Detail

SQLiteColumnInfo

public SQLiteColumnInfo()

Method Detail

gatherColumnList

public static java.util.List<SQLiteColumnInfo> gatherColumnList(android.database.sqlite.SQLiteDatabase db,
                                                                java.lang.String sTableName)

Gathers information about the columns in the specified table, and returns the column descriptions in a list.

Parameters:

db - the database to be analyzed

sTableName - the name of the table to be analyzed

Returns:

a list of objects describing the columns of the table

See Also:

SQLitePortal.getColumnListForTable(java.lang.String)

gatherColumnMap

public static java.util.Map<java.lang.String,SQLiteColumnInfo> gatherColumnMap(android.database.sqlite.SQLiteDatabase db,
                                                                               java.lang.String sTableName)

Gathers information about the columns in the specified table, and returns the column descriptions in a map.

Parameters:

db - the database to be analyzed

sTableName - the name of the table to be analyzed

Returns:

a map of column names to objects describing those columns

See Also:

SQLitePortal.getColumnMapForTable(java.lang.String)