rosetta.utility.sql_database
index
(built-in)

Bindings for utility::sql_database namespace

 
Classes
       
builtins.object
DatabaseMode
DatabaseSessionManager
TransactionMode
rosetta.cppdb.session(builtins.object)
session
rosetta.cppdb.transaction(builtins.object)
transaction

 
class DatabaseMode(builtins.object)
     Methods defined here:
__init__(...) from builtins.PyCapsule
__init__(rosetta.utility.sql_database.DatabaseMode) -> NoneType
__new__(*args, **kwargs) from builtins.type
Create and return a new object.  See help(type) for accurate signature.

Data and other attributes defined here:
e = <class 'rosetta.utility.sql_database.DatabaseMode.e'>
mysql = e.mysql
postgres = e.postgres
sqlite3 = e.sqlite3

 
class DatabaseSessionManager(builtins.object)
     Methods defined here:
__init__(self, /, *args, **kwargs)
Initialize self.  See help(type(self)) for accurate signature.
__new__(*args, **kwargs) from builtins.type
Create and return a new object.  See help(type) for accurate signature.
assign(...) from builtins.PyCapsule
assign(self : rosetta.utility.sql_database.DatabaseSessionManager,  : rosetta.utility.sql_database.DatabaseSessionManager) -> rosetta.utility.sql_database.DatabaseSessionManager
get_db_session(...) from builtins.PyCapsule
get_db_session(*args, **kwargs)
Overloaded function.
 
1. get_db_session(self : rosetta.utility.sql_database.DatabaseSessionManager, db_mode : rosetta.utility.sql_database.e, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int, db_name : str, pq_schema : str, host : str, user : str, password : str, port : int) -> rosetta.utility.sql_database.session
 
Acquire a database session
 
2. get_db_session(self : rosetta.utility.sql_database.DatabaseSessionManager, db_mode : rosetta.utility.sql_database.e, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int, db_name : str, pq_schema : str, host : str, user : str, password : str, port : int, readonly : bool) -> rosetta.utility.sql_database.session
 
Acquire a database session
 
3. get_db_session(self : rosetta.utility.sql_database.DatabaseSessionManager, db_mode : rosetta.utility.sql_database.e, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int, db_name : str, pq_schema : str, host : str, user : str, password : str, port : int, readonly : bool, db_partition : int) -> rosetta.utility.sql_database.session
 
Acquire a database session
get_instance(...) from builtins.PyCapsule
get_instance() -> rosetta.utility.sql_database.DatabaseSessionManager
 
return singleton instance of session manager
get_session_mysql(...) from builtins.PyCapsule
get_session_mysql(self : rosetta.utility.sql_database.DatabaseSessionManager, database : str, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int, host : str, user : str, password : str, port : int) -> rosetta.utility.sql_database.session
 
Acquire a mysql database session
get_session_postgres(...) from builtins.PyCapsule
get_session_postgres(self : rosetta.utility.sql_database.DatabaseSessionManager, database : str, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int, pq_schema : str, host : str, user : str, password : str, port : int) -> rosetta.utility.sql_database.session
 
Acquire a postgres database session
get_session_sqlite3(...) from builtins.PyCapsule
get_session_sqlite3(*args, **kwargs)
Overloaded function.
 
1. get_session_sqlite3(self : rosetta.utility.sql_database.DatabaseSessionManager, database : str) -> rosetta.utility.sql_database.session
 
Acquire a sqlite3 database session
 
2. get_session_sqlite3(self : rosetta.utility.sql_database.DatabaseSessionManager, database : str, transaction_mode : rosetta.utility.sql_database.e) -> rosetta.utility.sql_database.session
 
Acquire a sqlite3 database session
 
3. get_session_sqlite3(self : rosetta.utility.sql_database.DatabaseSessionManager, database : str, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int) -> rosetta.utility.sql_database.session
 
Acquire a sqlite3 database session
 
4. get_session_sqlite3(self : rosetta.utility.sql_database.DatabaseSessionManager, database : str, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int, readonly : bool) -> rosetta.utility.sql_database.session
 
Acquire a sqlite3 database session
 
5. get_session_sqlite3(self : rosetta.utility.sql_database.DatabaseSessionManager, database : str, transaction_mode : rosetta.utility.sql_database.e, chunk_size : int, readonly : bool, db_partition : int) -> rosetta.utility.sql_database.session
 
Acquire a sqlite3 database session

 
class TransactionMode(builtins.object)
     Methods defined here:
__init__(...) from builtins.PyCapsule
__init__(rosetta.utility.sql_database.TransactionMode) -> NoneType
__new__(*args, **kwargs) from builtins.type
Create and return a new object.  See help(type) for accurate signature.

Data and other attributes defined here:
chunk = e.chunk
e = <class 'rosetta.utility.sql_database.TransactionMode.e'>
none = e.none
standard = e.standard

 
class session(rosetta.cppdb.session)
    
Method resolution order:
session
rosetta.cppdb.session
builtins.object

Methods defined here:
__init__(...) from builtins.PyCapsule
__init__(*args, **kwargs)
Overloaded function.
 
1. __init__(rosetta.utility.sql_database.session) -> NoneType
 
2. __init__(self : rosetta.utility.sql_database.session,  : rosetta.utility.sql_database.session) -> NoneType
__new__(*args, **kwargs) from builtins.type
Create and return a new object.  See help(type) for accurate signature.
assign(...) from builtins.PyCapsule
assign(self : rosetta.utility.sql_database.session,  : rosetta.utility.sql_database.session) -> rosetta.utility.sql_database.session
begin_transaction(...) from builtins.PyCapsule
begin_transaction(rosetta.utility.sql_database.session) -> NoneType
 
indicate that a transaction block has begun.
commit_transaction(...) from builtins.PyCapsule
commit_transaction(rosetta.utility.sql_database.session) -> NoneType
 
indicate that a transaction block has completed. NOTE:
When in chunk transaction mode, this may not actually write to
the database.
force_commit_transaction(...) from builtins.PyCapsule
force_commit_transaction(rosetta.utility.sql_database.session) -> NoneType
 
force a transaction to be committed. This should only
be used when writing data that is required by other processes,
such as protocol and batch ids.
get_chunk_size(...) from builtins.PyCapsule
get_chunk_size(rosetta.utility.sql_database.session) -> int
get_db_mode(...) from builtins.PyCapsule
get_db_mode(rosetta.utility.sql_database.session) -> rosetta.utility.sql_database.e
get_db_name(...) from builtins.PyCapsule
get_db_name(rosetta.utility.sql_database.session) -> str
get_db_partition(...) from builtins.PyCapsule
get_db_partition(rosetta.utility.sql_database.session) -> int
get_pq_schema(...) from builtins.PyCapsule
get_pq_schema(rosetta.utility.sql_database.session) -> str
get_transaction_mode(...) from builtins.PyCapsule
get_transaction_mode(rosetta.utility.sql_database.session) -> rosetta.utility.sql_database.e
is_db_partitioned(...) from builtins.PyCapsule
is_db_partitioned(rosetta.utility.sql_database.session) -> bool
set_chunk_size(...) from builtins.PyCapsule
set_chunk_size(self : rosetta.utility.sql_database.session, chunk_size : int) -> NoneType
set_db_mode(...) from builtins.PyCapsule
set_db_mode(self : rosetta.utility.sql_database.session, db_mode : rosetta.utility.sql_database.e) -> NoneType
set_db_name(...) from builtins.PyCapsule
set_db_name(self : rosetta.utility.sql_database.session, db_name : str) -> NoneType
set_db_partition(...) from builtins.PyCapsule
set_db_partition(self : rosetta.utility.sql_database.session, db_partition : int) -> NoneType
set_pq_schema(...) from builtins.PyCapsule
set_pq_schema(self : rosetta.utility.sql_database.session, pq_schema : str) -> NoneType
set_transaction_mode(...) from builtins.PyCapsule
set_transaction_mode(self : rosetta.utility.sql_database.session, transaction_mode : rosetta.utility.sql_database.e) -> NoneType

Methods inherited from rosetta.cppdb.session:
begin(...) from builtins.PyCapsule
begin(rosetta.cppdb.session) -> NoneType
clear_cache(...) from builtins.PyCapsule
clear_cache(rosetta.cppdb.session) -> NoneType
clear_pool(...) from builtins.PyCapsule
clear_pool(rosetta.cppdb.session) -> NoneType
close(...) from builtins.PyCapsule
close(rosetta.cppdb.session) -> NoneType
commit(...) from builtins.PyCapsule
commit(rosetta.cppdb.session) -> NoneType
create_prepared_statement(...) from builtins.PyCapsule
create_prepared_statement(self : rosetta.cppdb.session, q : str) -> rosetta.cppdb.statement
create_prepared_uncached_statement(...) from builtins.PyCapsule
create_prepared_uncached_statement(self : rosetta.cppdb.session, q : str) -> rosetta.cppdb.statement
create_statement(...) from builtins.PyCapsule
create_statement(self : rosetta.cppdb.session, q : str) -> rosetta.cppdb.statement
driver(...) from builtins.PyCapsule
driver(rosetta.cppdb.session) -> str
engine(...) from builtins.PyCapsule
engine(rosetta.cppdb.session) -> str
escape(...) from builtins.PyCapsule
escape(*args, **kwargs)
Overloaded function.
 
1. escape(self : rosetta.cppdb.session, b : str, e : str) -> str
 
2. escape(self : rosetta.cppdb.session, s : str) -> str
 
3. escape(self : rosetta.cppdb.session, s : str) -> str
is_open(...) from builtins.PyCapsule
is_open(rosetta.cppdb.session) -> bool
once_called(...) from builtins.PyCapsule
once_called(*args, **kwargs)
Overloaded function.
 
1. once_called(rosetta.cppdb.session) -> bool
 
2. once_called(self : rosetta.cppdb.session, state : bool) -> NoneType
open(...) from builtins.PyCapsule
open(self : rosetta.cppdb.session, cs : str) -> NoneType
prepare(...) from builtins.PyCapsule
prepare(self : rosetta.cppdb.session, query : str) -> rosetta.cppdb.statement
recyclable(...) from builtins.PyCapsule
recyclable(*args, **kwargs)
Overloaded function.
 
1. recyclable(rosetta.cppdb.session) -> bool
 
2. recyclable(self : rosetta.cppdb.session, value : bool) -> NoneType
rollback(...) from builtins.PyCapsule
rollback(rosetta.cppdb.session) -> NoneType

 
class transaction(rosetta.cppdb.transaction)
    
Method resolution order:
transaction
rosetta.cppdb.transaction
builtins.object

Methods defined here:
__init__(...) from builtins.PyCapsule
__init__(self : rosetta.utility.sql_database.transactionsession : rosetta.utility.sql_database.session) -> NoneType
__new__(*args, **kwargs) from builtins.type
Create and return a new object.  See help(type) for accurate signature.

Methods inherited from rosetta.cppdb.transaction:
commit(...) from builtins.PyCapsule
commit(rosetta.cppdb.transaction) -> NoneType
rollback(...) from builtins.PyCapsule
rollback(rosetta.cppdb.transaction) -> NoneType

 
Functions
       
database_mode_from_name(...) method of builtins.PyCapsule instance
database_mode_from_name(database_mode : str) -> rosetta.utility.sql_database.e
name_from_database_mode(...) method of builtins.PyCapsule instance
name_from_database_mode(database_mode : rosetta.utility.sql_database.e) -> str
name_from_transaction_mode(...) method of builtins.PyCapsule instance
name_from_transaction_mode(transaction_mode : rosetta.utility.sql_database.e) -> str
transaction_mode_from_name(...) method of builtins.PyCapsule instance
transaction_mode_from_name(transaction_mode : str) -> rosetta.utility.sql_database.e