Package org.loboevolution.store

Class SQLiteCommon

java.lang.Object

org.loboevolution.store.SQLiteCommon

public class SQLiteCommon
extends Object

SQLiteCommon class.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	CHECK_CACHE	Constant CHECK_CACHE="SELECT count(*) FROM cache WHERE baseUr"{trunked}
static final String	COOKIES	Constant COOKIES=" SELECT DISTINCT cookieName, cookieValu"{trunked}
static final String	DELETE_ALL_CACHE	Constant DELETE_ALL_CACHE="DELETE FROM cache
static final String	DELETE_ALL_WEBSTORAGE	Constant DELETE_WEBSTORAGE="DELETE FROM WEB_STORAGE WHER"{trunked}
static final String	DELETE_INPUT	Constant DELETE_INPUT="DELETE FROM INPUT"
static final String	DELETE_INPUT2	Constant DELETE_INPUT="DELETE FROM INPUT"
static final String	DELETE_LINK	Constant DELETE_LINK="DELETE FROM LINK_VISITED"
static final String	DELETE_SOURCE_CACHE	Constant DELETE_SOURCE_CACHE="DELETE FROM cache WHERE baseUrl = ?
static final String	DELETE_WEBSTORAGE	Constant DELETE_WEBSTORAGE="DELETE FROM WEB_STORAGE WHER"{trunked}
static final String	INPUT	Constant INPUT="SELECT DISTINCT value from INPUT where "{trunked}
static final String	INPUT_LIMIT	Constant INPUT="SELECT DISTINCT value from INPUT where "{trunked}
static final String	INSERT_CACHE	Constant INSERT_CACHE="INSERT INTO CACHE (baseUrl, source, con"{trunked}
static final String	INSERT_COOKIES	Constant INSERT_COOKIES="INSERT INTO COOKIE (cookieName, cookieV"{trunked}
static final String	INSERT_INPUT	Constant INSERT_INPUT="INSERT INTO INPUT (name, value) VALUES("{trunked}
static final String	INSERT_LINK	Constant INSERT_LINK="INSERT INTO LINK_VISITED VALUES(?)"
static final String	LINK	Constant LINK="SELECT COUNT(*) FROM LINK_VISITED WHERE"{trunked}
static final String	SOURCE_CACHE	Constant SOURCE_CACHE="SELECT source FROM cache WHERE baseUrl "{trunked}
static final String	WEBSTORAGE	Constant WEBSTORAGE="INSERT INTO WEB_STORAGE (key, value, session) "{trunked}
static final String	WEBSTORAGE_DELETE_KEY	Constant WEBSTORAGE_DELETE_KEY="DELETE FROM WEB_STORAGE WHER"{trunked}
static final String	WEBSTORAGE_MAP	Constant LINK="SELECT NAME, VALUE FROM WEB_STORAGE"{trunked}
static final String	WEBSTORAGE_SIZE	Constant WEBSTORAGE_SIZE="SELECT COUNT(*) FROM LINK_VISITED WHERE"{trunked}
static final String	WEBSTORAGE_VALUE	Constant LINK="SELECT NAME FROM WEB_STORAGE WHERE"{trunked}

Constructor Summary

Constructors

Constructor	Description
SQLiteCommon()

Method Summary

Methods inherited from class java.lang.Object

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

Field Details

COOKIES

public static final String COOKIES

Constant COOKIES=" SELECT DISTINCT cookieName, cookieValu"{trunked}

See Also:

• Constant Field Values

INSERT_COOKIES

public static final String INSERT_COOKIES

Constant INSERT_COOKIES="INSERT INTO COOKIE (cookieName, cookieV"{trunked}

See Also:

• Constant Field Values

SOURCE_CACHE

public static final String SOURCE_CACHE

Constant SOURCE_CACHE="SELECT source FROM cache WHERE baseUrl "{trunked}

See Also:

• Constant Field Values

CHECK_CACHE

public static final String CHECK_CACHE

Constant CHECK_CACHE="SELECT count(*) FROM cache WHERE baseUr"{trunked}

See Also:

• Constant Field Values

INSERT_CACHE

public static final String INSERT_CACHE

Constant INSERT_CACHE="INSERT INTO CACHE (baseUrl, source, con"{trunked}

See Also:

• Constant Field Values

INPUT

public static final String INPUT

Constant INPUT="SELECT DISTINCT value from INPUT where "{trunked}

See Also:

• Constant Field Values

INPUT_LIMIT

public static final String INPUT_LIMIT

Constant INPUT="SELECT DISTINCT value from INPUT where "{trunked}

See Also:

• Constant Field Values

INSERT_INPUT

public static final String INSERT_INPUT

Constant INSERT_INPUT="INSERT INTO INPUT (name, value) VALUES("{trunked}

See Also:

• Constant Field Values

DELETE_INPUT

public static final String DELETE_INPUT

Constant DELETE_INPUT="DELETE FROM INPUT"

See Also:

• Constant Field Values

DELETE_INPUT2

public static final String DELETE_INPUT2

Constant DELETE_INPUT="DELETE FROM INPUT"

See Also:

• Constant Field Values

DELETE_SOURCE_CACHE

public static final String DELETE_SOURCE_CACHE

Constant DELETE_SOURCE_CACHE="DELETE FROM cache WHERE baseUrl = ? AND"{trunked}

See Also:

• Constant Field Values

DELETE_ALL_CACHE

public static final String DELETE_ALL_CACHE

Constant DELETE_ALL_CACHE="DELETE FROM cache

See Also:

• Constant Field Values

DELETE_LINK

public static final String DELETE_LINK

Constant DELETE_LINK="DELETE FROM LINK_VISITED"

See Also:

• Constant Field Values

INSERT_LINK

public static final String INSERT_LINK

Constant INSERT_LINK="INSERT INTO LINK_VISITED VALUES(?)"

See Also:

• Constant Field Values

LINK

public static final String LINK

Constant LINK="SELECT COUNT(*) FROM LINK_VISITED WHERE"{trunked}

See Also:

• Constant Field Values

WEBSTORAGE_VALUE

public static final String WEBSTORAGE_VALUE

Constant LINK="SELECT NAME FROM WEB_STORAGE WHERE"{trunked}

See Also:

• Constant Field Values

WEBSTORAGE_MAP

public static final String WEBSTORAGE_MAP

Constant LINK="SELECT NAME, VALUE FROM WEB_STORAGE"{trunked}

See Also:

• Constant Field Values

WEBSTORAGE_DELETE_KEY

public static final String WEBSTORAGE_DELETE_KEY

Constant WEBSTORAGE_DELETE_KEY="DELETE FROM WEB_STORAGE WHER"{trunked}

See Also:

• Constant Field Values

DELETE_WEBSTORAGE

public static final String DELETE_WEBSTORAGE

Constant DELETE_WEBSTORAGE="DELETE FROM WEB_STORAGE WHER"{trunked}

See Also:

• Constant Field Values

DELETE_ALL_WEBSTORAGE

public static final String DELETE_ALL_WEBSTORAGE

Constant DELETE_WEBSTORAGE="DELETE FROM WEB_STORAGE WHER"{trunked}

See Also:

• Constant Field Values

WEBSTORAGE

public static final String WEBSTORAGE

Constant WEBSTORAGE="INSERT INTO WEB_STORAGE (key, value, session) "{trunked}

See Also:

• Constant Field Values

WEBSTORAGE_SIZE

public static final String WEBSTORAGE_SIZE

Constant WEBSTORAGE_SIZE="SELECT COUNT(*) FROM LINK_VISITED WHERE"{trunked}

See Also:

• Constant Field Values

Constructor Details

SQLiteCommon

public SQLiteCommon()