OpenSim::Data::SQLite::SQLiteManager Class Reference

SQLite Manager. More...

Inheritance diagram for OpenSim::Data::SQLite::SQLiteManager:

OpenSim::Data::SQLite::SQLiteUtil List of all members.

Public Member Functions

 SQLiteManager (string connect)
 
  • Initialises and creates a new SQLite connection and maintains it.
  • use default URI if connect string is empty.

void Close ()
 Shuts down the database connection.
IDbCommand Query (string sql, Dictionary< string, string > parameters)
 Runs a query with protection against SQL Injection by using parameterised input.
RegionProfileData getRow (IDataReader reader)
 Reads a region row from a database reader.
bool insertRow (RegionProfileData profile)
 Inserts a new region into the database.

Detailed Description

SQLite Manager.


Constructor & Destructor Documentation

OpenSim::Data::SQLite::SQLiteManager::SQLiteManager ( string  connect  )  [inline]

Parameters:
connect connect string


Member Function Documentation

void OpenSim::Data::SQLite::SQLiteManager::Close (  )  [inline]

Shuts down the database connection.

IDbCommand OpenSim::Data::SQLite::SQLiteManager::Query ( string  sql,
Dictionary< string, string >  parameters 
) [inline]

Runs a query with protection against SQL Injection by using parameterised input.

Parameters:
sql The SQL string - replace any variables such as WHERE x = "y" with WHERE x =
parameters The parameters - index so that is indexed as 'y'
Returns:
A SQLite DB Command

RegionProfileData OpenSim::Data::SQLite::SQLiteManager::getRow ( IDataReader  reader  )  [inline]

Reads a region row from a database reader.

Parameters:
reader An active database reader
Returns:
A region profile

bool OpenSim::Data::SQLite::SQLiteManager::insertRow ( RegionProfileData  profile  )  [inline]

Inserts a new region into the database.

Parameters:
profile The region to insert
Returns:
Success?


The documentation for this class was generated from the following file:
Generated on Mon Jan 5 01:00:39 2009 for OpenSim by  doxygen 1.5.1