BigBrotherBot v1.8.0
System Development Information for the BigBrotherBot project.

b3::storage::database::DatabaseStorage Class Reference

Inheritance diagram for b3::storage::database::DatabaseStorage:
b3::storage::Storage b3::storage::Storage

List of all members.

Classes

class  Cursor

Public Member Functions

def __init__
def getField
def getVar
def getConnection
def closeConnection
def shutdown
def connect
def status
def queryFromFile
def query
def getCounts
def getClient
def getClientsMatching
def setClient
def setClientAlias
def getClientAlias
def getClientAliases
def setClientIpAddresse
def getClientIpAddress
def getClientIpAddresses
def setClientPenalty
def getClientPenalty
def getClientPenalties
def getClientLastPenalty
def getClientFirstPenalty
def disableClientPenalties
def numPenalties
def getGroups
def getGroup
def executeSql
def __init__
def getField
def getVar
def getConnection
def closeConnection
def shutdown
def connect
def status
def queryFromFile
def query
def getCounts
def getClient
def getClientsMatching
def setClient
def setClientAlias
def getClientAlias
def getClientAliases
def setClientIpAddresse
def getClientIpAddress
def getClientIpAddresses
def setClientPenalty
def getClientPenalty
def getClientPenalties
def getClientLastPenalty
def getClientFirstPenalty
def disableClientPenalties
def numPenalties
def getGroups
def getGroup
def executeSql

Public Attributes

 console
 db
 dsn
 dsnDict

Private Member Functions

def _query
def _createPenaltyFromRow
def _query
def _createPenaltyFromRow

Private Attributes

 _connections
 _lastConnectAttempt
 _count

Static Private Attributes

tuple _reName = re.compile(r'([A-Z])')
tuple _reVar = re.compile(r'_([a-z])')
int _lastConnectAttempt = 0
list _connections = []
 _lock = None
int _count = 0
 _groups = None

Constructor & Destructor Documentation

def b3::storage::database::DatabaseStorage::__init__ (   self,
  dsn,
  console 
)
def b3::storage::database::DatabaseStorage::__init__ (   self,
  dsn,
  console 
)

Member Function Documentation

def b3::storage::database::DatabaseStorage::_createPenaltyFromRow (   self,
  g 
) [private]
def b3::storage::database::DatabaseStorage::_createPenaltyFromRow (   self,
  g 
) [private]
def b3::storage::database::DatabaseStorage::_query (   self,
  query,
  bindata = None 
) [private]
def b3::storage::database::DatabaseStorage::_query (   self,
  query,
  bindata = None 
) [private]
def b3::storage::database::DatabaseStorage::closeConnection (   self)
def b3::storage::database::DatabaseStorage::closeConnection (   self)
def b3::storage::database::DatabaseStorage::connect (   self)
def b3::storage::database::DatabaseStorage::connect (   self)
def b3::storage::database::DatabaseStorage::disableClientPenalties (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::disableClientPenalties (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::executeSql (   self,
  filename 
)
This method executes an external sql file
def b3::storage::database::DatabaseStorage::executeSql (   self,
  filename 
)
This method executes an external sql file
def b3::storage::database::DatabaseStorage::getClient (   self,
  client 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClient (   self,
  client 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientAlias (   self,
  alias 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientAlias (   self,
  alias 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientAliases (   self,
  client 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientAliases (   self,
  client 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientFirstPenalty (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientFirstPenalty (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientIpAddress (   self,
  ipalias 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientIpAddress (   self,
  ipalias 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientIpAddresses (   self,
  client 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientIpAddresses (   self,
  client 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientLastPenalty (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientLastPenalty (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientPenalties (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientPenalties (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientPenalty (   self,
  penalty 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientPenalty (   self,
  penalty 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientsMatching (   self,
  match 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getClientsMatching (   self,
  match 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getConnection (   self)
def b3::storage::database::DatabaseStorage::getConnection (   self)
def b3::storage::database::DatabaseStorage::getCounts (   self)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getCounts (   self)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getField (   self,
  name 
)
def b3::storage::database::DatabaseStorage::getField (   self,
  name 
)
def b3::storage::database::DatabaseStorage::getGroup (   self,
  group 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getGroup (   self,
  group 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getGroups (   self)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getGroups (   self)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::getVar (   self,
  name 
)
def b3::storage::database::DatabaseStorage::getVar (   self,
  name 
)
def b3::storage::database::DatabaseStorage::numPenalties (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::numPenalties (   self,
  client,
  type = 'Ban' 
)

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::query (   self,
  query,
  bindata = None 
)
def b3::storage::database::DatabaseStorage::query (   self,
  query,
  bindata = None 
)
def b3::storage::database::DatabaseStorage::queryFromFile (   self,
  file,
  silent = False 
)
This method executes an external sql file on the current database
def b3::storage::database::DatabaseStorage::queryFromFile (   self,
  file,
  silent = False 
)
This method executes an external sql file on the current database
def b3::storage::database::DatabaseStorage::setClient (   self,
  client 
)
id int(11)   PRI NULL auto_increment 
ip varchar(16) YES   NULL   
greeting varchar(128) YES   NULL   
connections int(11) YES   NULL   
time_edit int(11) YES   NULL   
guid varchar(32)   MUL     
pbid varchar(32) YES   NULL   
name varchar(32) YES   NULL   
time_add int(11) YES   NULL   
auto_login int(11) YES   NULL   
mask_level int(11) YES   NULL   
group_bits int(11) 

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::setClient (   self,
  client 
)
id int(11)   PRI NULL auto_increment 
ip varchar(16) YES   NULL   
greeting varchar(128) YES   NULL   
connections int(11) YES   NULL   
time_edit int(11) YES   NULL   
guid varchar(32)   MUL     
pbid varchar(32) YES   NULL   
name varchar(32) YES   NULL   
time_add int(11) YES   NULL   
auto_login int(11) YES   NULL   
mask_level int(11) YES   NULL   
group_bits int(11) 

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::setClientAlias (   self,
  alias 
)
id  int(10)  UNSIGNED No    auto_increment              
num_used  int(10)  UNSIGNED No  0                
alias  varchar(32)   No                  
client_id  int(10)  UNSIGNED No  0                
time_add  int(10)  UNSIGNED No  0                
time_edit  int(10)  UNSIGNED No  0            

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::setClientAlias (   self,
  alias 
)
id  int(10)  UNSIGNED No    auto_increment              
num_used  int(10)  UNSIGNED No  0                
alias  varchar(32)   No                  
client_id  int(10)  UNSIGNED No  0                
time_add  int(10)  UNSIGNED No  0                
time_edit  int(10)  UNSIGNED No  0            

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::setClientIpAddresse (   self,
  ipalias 
)
id  int(10)  UNSIGNED No    auto_increment              
num_used  int(10)  UNSIGNED No  0                
ip  int(10)   UNSIGNED No                  
client_id  int(10)  UNSIGNED No  0                
time_add  int(10)  UNSIGNED No  0                
time_edit  int(10)  UNSIGNED No  0            

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::setClientIpAddresse (   self,
  ipalias 
)
id  int(10)  UNSIGNED No    auto_increment              
num_used  int(10)  UNSIGNED No  0                
ip  int(10)   UNSIGNED No                  
client_id  int(10)  UNSIGNED No  0                
time_add  int(10)  UNSIGNED No  0                
time_edit  int(10)  UNSIGNED No  0            

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::setClientPenalty (   self,
  penalty 
)
id  int(10)  UNSIGNED No    auto_increment              
type  enum('Ban', 'TempBan', 'Kick', 'Warning')   No  Ban                
duration  int(10)  UNSIGNED No  0                
inactive  tinyint(1)  UNSIGNED No  0                
admin_id  int(10)  UNSIGNED No  0                
time_add  int(10)  UNSIGNED No  0                
time_edit  int(10)  UNSIGNED No  0                
time_expire  int(11)   No  0                
reason  varchar(255)   No                  
keyword  varchar(16)   No                  
client_id  int(10)  UNSIGNED No  0       

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::setClientPenalty (   self,
  penalty 
)
id  int(10)  UNSIGNED No    auto_increment              
type  enum('Ban', 'TempBan', 'Kick', 'Warning')   No  Ban                
duration  int(10)  UNSIGNED No  0                
inactive  tinyint(1)  UNSIGNED No  0                
admin_id  int(10)  UNSIGNED No  0                
time_add  int(10)  UNSIGNED No  0                
time_edit  int(10)  UNSIGNED No  0                
time_expire  int(11)   No  0                
reason  varchar(255)   No                  
keyword  varchar(16)   No                  
client_id  int(10)  UNSIGNED No  0       

Reimplemented from b3::storage::Storage.

def b3::storage::database::DatabaseStorage::shutdown (   self)
def b3::storage::database::DatabaseStorage::shutdown (   self)
def b3::storage::database::DatabaseStorage::status (   self)
def b3::storage::database::DatabaseStorage::status (   self)

Member Data Documentation

tuple b3::storage::database::DatabaseStorage::_reName = re.compile(r'([A-Z])') [static, private]
tuple b3::storage::database::DatabaseStorage::_reVar = re.compile(r'_([a-z])') [static, private]

The documentation for this class was generated from the following files:
 All Classes Namespaces Files Functions Variables Properties