class: SQLQuerier

public class: SQLQuerier
Author: franke (initial creation)
Project: Phase: 1.0; Status: Proposed; Version: $Revision: 2050 $ $LastChangedDate: 2009-06-03 12:; Complexity: 1
Dates: Created: 16.07.2009 15:16:00; Modified: 16.07.2009 15:16:00;
Flags: Active: false; IsRoot: false; IsLeaf: false;
Extension Points:
UUID: {7D217EC0-1273-4313-952A-2A0FA5CF36A5}
SQL implementation for the {@link Querier} interface. Currently works with Postgres, but should also work with other relational databases like HSQL, MySQL. For Oracle and SQL Server, maybe some modifications will be needed.
 

Goto: Custom Properties, Fields, Methods

Implements: Querier

See also: Querier

Appears in: cone

Connections
 
Custom Properties
 
SQLQuerier Attributes
Attribute Details
private Connection
  connection
private DataSource
  dataSource
Initial: null
private static const String
  ESCIDOC_CONE_LANGUAGE_DEFAULT
Initial: "escidoc.cone.language.default"
private static const Logger
  logger
Initial: Logger.getLogger(SQLQuerier.class)
 
SQLQuerier Methods
Operation Details
public
create(
   String modelName,
   String id,
   TreeFragment values):void
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
createUniqueIdentifier(
   String model):String
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
delete(
   String modelName,
   String id):void
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
delete(
   List predicates,
   String id):void
Sequential
Tags: throws=Exception
public
details(
   String model,
   String id):TreeFragment
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
details(
   String modelName,
   String id,
   String language):TreeFragment
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
details(
   String modelName,
   String id,
   String language,
   Stack idStack,
   Connection connection):TreeFragment
Sequential
Tags: throws=Exception
public
details(
   String modelName,
   List predicates,
   String id,
   String language,
   Stack idStack,
   Connection connection):TreeFragment
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
private
escape(
   String str):String
Sequential
Notes: Returns a SQL safe representation of the given String.
@return The escaped string
protected
finalize():void
Sequential
Tags: annotations=@Override
throws=Throwable
private
formatSearchString(
   String searchString):String
Sequential
Notes: {@inheritDoc}
public
getAllIds(
   String modelName):List
Sequential
Tags: throws=Exception
public
query(
   String model,
   String query):List
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
query(
   String model,
   String query,
   String language):List
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
query(
   String model,
   String searchString,
   String language,
   int limit):List
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
release():void
Sequential
Tags: throws=Exception
Notes: {@inheritDoc}
public
SQLQuerier():
Sequential
Tags: throws=Exception
Notes: Default constructor initializing the {@link DataSource}.