RepositorySQLiteConnection (Snifflib API)

java.lang.Object
- com.mockturtlesolutions.snifflib.reposconfig.database.RepositorySQLiteConnection

All Implemented Interfaces:

RepositoryConnectivity

Direct Known Subclasses:

DblMatrixSQLiteConnection, ParameterSetSQLiteConnection
```
public class RepositorySQLiteConnection
extends java.lang.Object
implements RepositoryConnectivity
```
Establish a connection with an SQL server and process requests.

Field Summary

Fields
Modifier and Type Field and Description

protected SQLConfig Config

protected java.sql.Connection Connection

Fields
Modifier and Type	Field and Description
`protected SQLConfig`	`Config`
`protected java.sql.Connection`	`Connection`

Constructor Summary

Constructors
Constructor and Description
`RepositorySQLiteConnection(ReposConfig config, java.lang.String repos)`
`RepositorySQLiteConnection(ReposConfig config, java.lang.String repos, boolean connect)`

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`close()` Closes the connection fo the repository.
`void`	`commit()`
`void`	`createAndTransferStorageThreaded(RepositoryStorage storage)` Creates (if not exists) the storage on this connectivity and then transfers it.
`boolean`	`createSkeleton()` Create all tables within the database specified by the given repository.
`java.sql.Statement`	`createStatement()` Create an SQL statement.
`boolean`	`createStorage(java.lang.Class iface, java.lang.String storagename)` Creates a storage instance on the repository.
`boolean`	`createStorage(java.lang.String storagename)`
`boolean`	`databaseExists()`
`java.lang.Class`	`determineClassOf(java.lang.String storagename)` Returns a Class object for the type of storage that would result from instantiating the named storage.
`boolean`	`getAutoCommit()`
`RepositoryMaintenance`	`getCustodian()` Gets an instance appropriate for the creation, deletion or other privilaged or atypical operations on the storages housed within a reporitory.
`java.lang.String`	`getDatabase()`
`java.util.Vector`	`getFields(java.lang.String table)`
`java.lang.Class`	`getFindNameDialogForClass(java.lang.Class storageclass)`
`java.lang.String`	`getLastInsertID(java.lang.String table)` Get the output from `SELECT LAST_INSERT_ID() FROM `;
`RepositoryMaintenance`	`getManager()`
`java.lang.String`	`getMySQLFormat()`
`java.lang.String`	`getPostgreSQLFormat()`
`java.lang.String`	`getRepository()` Returns the name associated with the repository to which the connection is established.
`SQLDatabase`	`getSkeleton()`
`java.lang.String`	`getSQLiteFormat()`
`RepositoryStorage`	`getStorage(java.lang.String storagename)` Gets the storage having the given nickname from the currently connected repository.
`RepositoryStorageNameQuery`	`getStorageNameQuery()` Returns a name query instance appropriate for searching the repository contents for storages matching various search criteria.
`void`	`getStorageThreaded(java.util.concurrent.ConcurrentHashMap out, java.lang.String storagename)`
`java.util.Vector`	`getTables()`
`int`	`getThreadedTransfers()`
`boolean`	`isEmptyRepository()` Verify that the database specified in the given repository is a valid pHtools database.
`boolean`	`isValidRepository()` Verify that the database specified in the given repository is a valid pHtools database.
`void`	`openConnection()`
`java.sql.PreparedStatement`	`prepareStatement(java.lang.String s)`
`void`	`releaseSavepoint(java.sql.Savepoint sp)`
`java.lang.Class`	`resolveStorageFor(java.lang.Class iface)` For the given interface (or less typically class) return the RepositoryStorage class extension for this repsoitory.
`void`	`rollback()`
`void`	`rollback(java.sql.Savepoint sp)`
`void`	`setAutoCommit(boolean f)`
`java.sql.Savepoint`	`setSavepoint()`
`java.sql.Savepoint`	`setSavepoint(java.lang.String sp)`
`void`	`setThreadedTransfers(int n)`
`boolean`	`storageExists(java.lang.String storagename)` Determines if the named storage already exists in the possibly remote repository.
`void`	`tearDownSkeleton()` Removes the skeleton from the database.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - Connection
```
protected java.sql.Connection Connection
```
  - Config
```
protected SQLConfig Config
```
- Constructor Detail
  - RepositorySQLiteConnection
```
public RepositorySQLiteConnection(ReposConfig config,
                          java.lang.String repos)
```
  - RepositorySQLiteConnection
```
public RepositorySQLiteConnection(ReposConfig config,
                          java.lang.String repos,
                          boolean connect)
```
- Method Detail
  - releaseSavepoint
```
public void releaseSavepoint(java.sql.Savepoint sp)
```
  - rollback
```
public void rollback()
```
  - rollback
```
public void rollback(java.sql.Savepoint sp)
```
  - setSavepoint
```
public java.sql.Savepoint setSavepoint()
```
  - setSavepoint
```
public java.sql.Savepoint setSavepoint(java.lang.String sp)
```
  - openConnection
```
public void openConnection()
```
  - getRepository
```
public java.lang.String getRepository()
```
    Description copied from interface: RepositoryConnectivity
    
    Returns the name associated with the repository to which the connection is established. Names are associated to repositories by a ReposConfig instance. In common usage, ReposConfig instances are per-user and persisted by plain text (configuration) files within the user's home directory.
    
    Specified by:
    
    getRepository in interface RepositoryConnectivity
  - getMySQLFormat
```
public java.lang.String getMySQLFormat()
```
  - getSQLiteFormat
```
public java.lang.String getSQLiteFormat()
```
  - getPostgreSQLFormat
```
public java.lang.String getPostgreSQLFormat()
```
  - resolveStorageFor
```
public java.lang.Class resolveStorageFor(java.lang.Class iface)
```
    Description copied from interface: RepositoryConnectivity
    
    For the given interface (or less typically class) return the RepositoryStorage class extension for this repsoitory. For example a RepositorySQLConnection extension for a repository of WidgetStorage's this method might return WidgetStorageSQL.class.
    
    Specified by:
    
    resolveStorageFor in interface RepositoryConnectivity
  - getDatabase
```
public java.lang.String getDatabase()
```
  - createStorage
```
public boolean createStorage(java.lang.Class iface,
                    java.lang.String storagename)
```
    Description copied from interface: RepositoryConnectivity
    
    Creates a storage instance on the repository. The storage created may be persistent depending on the type of repository. The repository itself may be remote or local depeding how it is configured. Storage nicknames are assumed to be unique identifiers of the instance at least within a repository. If a storage by the same nickname already exists within the repository then this method does nothing.
    
    Specified by:
    
    createStorage in interface RepositoryConnectivity
  - getCustodian
```
public RepositoryMaintenance getCustodian()
```
    Description copied from interface: RepositoryConnectivity
    
    Gets an instance appropriate for the creation, deletion or other privilaged or atypical operations on the storages housed within a reporitory.
    
    Specified by:
    
    getCustodian in interface RepositoryConnectivity
  - createStorage
```
public boolean createStorage(java.lang.String storagename)
```
  - prepareStatement
```
public java.sql.PreparedStatement prepareStatement(java.lang.String s)
```
  - getAutoCommit
```
public boolean getAutoCommit()
```
  - setAutoCommit
```
public void setAutoCommit(boolean f)
```
  - commit
```
public void commit()
```
  - close
```
public void close()
```
    Description copied from interface: RepositoryConnectivity
    
    Closes the connection fo the repository.
    
    Specified by:
    
    close in interface RepositoryConnectivity
  - createStatement
```
public java.sql.Statement createStatement()
```
    Create an SQL statement.
  - tearDownSkeleton
```
public void tearDownSkeleton()
```
    Removes the skeleton from the database.
  - getLastInsertID
```
public java.lang.String getLastInsertID(java.lang.String table)
```
    Get the output from `SELECT LAST_INSERT_ID() FROM `;
    - createSkeleton
      
      public boolean createSkeleton()
      
      Create all tables within the database specified by the given repository. Returns true if operation was successful. If the database already exists and contains the valid skeleton then a result of true is returned.
    - getSkeleton
      
      public SQLDatabase getSkeleton()
    - databaseExists
      
      public boolean databaseExists()
    - getFields
      
      public java.util.Vector getFields(java.lang.String table)
    - getTables
      
      public java.util.Vector getTables()
    - isValidRepository
      
      public boolean isValidRepository()
      
      Verify that the database specified in the given repository is a valid pHtools database. Returns true if database has the proper tables and table structures.
    - isEmptyRepository
      
      public boolean isEmptyRepository()
      
      Verify that the database specified in the given repository is a valid pHtools database. Returns true if database has the proper tables and table structures.
    - getManager
      
      public RepositoryMaintenance getManager()
    - getStorageNameQuery
      
      public RepositoryStorageNameQuery getStorageNameQuery()
      
      Description copied from interface: RepositoryConnectivity
      
      Returns a name query instance appropriate for searching the repository contents for storages matching various search criteria.
      
      Specified by:
      
      getStorageNameQuery in interface RepositoryConnectivity
    - getFindNameDialogForClass
      
      public java.lang.Class getFindNameDialogForClass(java.lang.Class storageclass)
      
      Specified by:
      
      getFindNameDialogForClass in interface RepositoryConnectivity
    - determineClassOf
      
      public java.lang.Class determineClassOf(java.lang.String storagename)
      
      Description copied from interface: RepositoryConnectivity
      
      Returns a Class object for the type of storage that would result from instantiating the named storage.
      
      Specified by:
      
      determineClassOf in interface RepositoryConnectivity
      
      Returns:
      if the named storage does not exist
    - getStorage
      
      public RepositoryStorage getStorage(java.lang.String storagename)
      
      Description copied from interface: RepositoryConnectivity
      
      Gets the storage having the given nickname from the currently connected repository. If the named storage does not exist on the connected repository then this method returns null.
      
      Specified by:
      
      getStorage in interface RepositoryConnectivity
      
      Returns:
      null if the named storage does not exist
    - storageExists
      
      public boolean storageExists(java.lang.String storagename)
      
      Description copied from interface: RepositoryConnectivity
      
      Determines if the named storage already exists in the possibly remote repository.
      
      Specified by:
      
      storageExists in interface RepositoryConnectivity
    - getStorageThreaded
      
      public void getStorageThreaded(java.util.concurrent.ConcurrentHashMap out, java.lang.String storagename)
    - createAndTransferStorageThreaded
      
      public void createAndTransferStorageThreaded(RepositoryStorage storage)
      
      Creates (if not exists) the storage on this connectivity and then transfers it. The creation and transfer operations occur as a threaded process. This method is useful if many storages are being transfered and it can be guaranteed that each storage is independent or if a threaded transfer is desired (large single transfer).
    - getThreadedTransfers
      
      public int getThreadedTransfers()
    - setThreadedTransfers
      
      public void setThreadedTransfers(int n)
    Overview
    
    Package
    
    Class
    
    Use
    
    Tree
    
    Deprecated
    
    Index
    
    Help
    Prev Class
    
    Next Class
    
    Frames
    
    No Frames
    
    All Classes
    
    Summary:
    
    Nested |
    
    Field |
    
    Constr |
    
    Method
    
    Detail:
    
    Field |
    
    Constr |
    
    Method
    Copyright © 2011, 2013. Daniel P. Dougherty

Class RepositorySQLiteConnection

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

Connection

Config

Constructor Detail

RepositorySQLiteConnection

RepositorySQLiteConnection

Method Detail

releaseSavepoint

rollback

rollback

setSavepoint

setSavepoint

openConnection

getRepository

getMySQLFormat

getSQLiteFormat

getPostgreSQLFormat

resolveStorageFor

getDatabase

createStorage

getCustodian

createStorage

prepareStatement

getAutoCommit

setAutoCommit

commit

close

createStatement

tearDownSkeleton

getLastInsertID

createSkeleton

getSkeleton

databaseExists

getFields

getTables

isValidRepository

isEmptyRepository

getManager

getStorageNameQuery

getFindNameDialogForClass

determineClassOf

getStorage

storageExists

getStorageThreaded

createAndTransferStorageThreaded

getThreadedTransfers

setThreadedTransfers