/opt/alt/python38/lib64/python3.8/site-packages/playhouse/__pycache__
Edit: /opt/alt/python38/lib64/python3.8/site-packages/playhouse/__pycache__/pool.cpython-38.pyc (7753B)
U
SW @ s. d Z ddlZddlZddlZddlmZ ddlmZ ddlmZ edZ dd Z
G d d
d
e Z G d d d e eZ
G d
d de ZG dd deeZz"ddlmZ G dd deeZW n ek
r Y nX G dd de ZG dd deeZz"ddlmZ G dd deeZW n ek
r( Y nX dS )ap
Lightweight connection pooling for peewee.
In a multi-threaded application, up to `max_connections` will be opened. Each
thread (or, if using gevent, greenlet) will have it's own connection.
In a single-threaded application, only one connection will be created. It will
be continually recycled until either it exceeds the stale timeout or is closed
explicitly (using `.manual_close()`).
By default, all your application needs to do is ensure that connections are
closed when you are finished with them, and they will be returned to the pool.
For web applications, this typically means that at the beginning of a request,
you will open a connection, and when you return a response, you will close the
connection.
Simple Postgres pool example code:
# Use the special postgresql extensions.
from playhouse.pool import PooledPostgresqlExtDatabase
db = PooledPostgresqlExtDatabase(
'my_app',
max_connections=32,
stale_timeout=300, # 5 minutes.
user='postgres')
class BaseModel(Model):
class Meta:
database = db
That's it!
In some situations you may want to manage your connections more explicitly.
Since peewee stores the active connection in a threadlocal, this typically
would mean that there could only ever be one connection open per thread. For
most applications this is desirable, but if you would like to manually manage
multiple connections you can create an *ExecutionContext*.
Execution contexts allow finer-grained control over managing multiple
connections to the database. When an execution context is initialized (either
as a context manager or as a decorated function), a separate connection will
be used for the duration of the wrapped block. You can also choose whether to
wrap the block in a transaction.
Execution context examples (using above `db` instance):
with db.execution_context() as ctx:
# A new connection will be opened or pulled from the pool of available
# connections. Additionally, a transaction will be started.
user = User.create(username='charlie')
# When the block ends, the transaction will be committed and the connection
# will be returned to the pool.
@db.execution_context(with_transaction=False)
def do_something(foo, bar):
# When this function is called, a separate connection is made and will
# be closed when the function returns.
N)
MySQLDatabase)PostgresqlDatabase)SqliteDatabasez peewee.poolc C s" | d k r t | ttfs t| S | S N)
isinstanceintfloat)val r
A/opt/alt/python38/lib64/python3.8/site-packages/playhouse/pool.pymake_intH s r c sf e Zd Zd fdd Zd fdd Z fddZd d
Zd d Zd fdd Zdd Z dd Z
Z S )PooledDatabase Nc sF t || _t || _g | _i | _t | _t| _t t
| j |f| d S r ) r max_connections
stale_timeout _connections_in_useset_closedidconn_keysuperr
__init__)selfdatabaser r kwargs __class__r
r r O s
zPooledDatabase.__init__c s< t t| j|f| |d k r&t|| _|d k r8t|| _d S r )r r
initr r r )r r r r connect_kwargsr r
r r Z s
zPooledDatabase.initc s z t | j\}}| |}W n* tk
rH d }}td Y qY q X | ||rxtd| d }}| j | q | j
r| |rtd| | |d | j | d }}q qq |d kr| j
rt| j| j
krtdtt| j||}t }| |}td| || j|< |S )Nz No connection available in pool.zConnection %s was closed.z!Connection %s was stale, closing.Tz Exceeded maximum connections.zCreated new connection %s.)heapqheappopr r
IndexErrorloggerdebug
_is_closedr discardr _is_stale_closer lenr
ValueErrorr r
_connecttime)r argsr tsconnkeyr r
r r+ b s8
zPooledDatabase._connectc C s t | | jkS r )r, r )r timestampr
r
r r' s zPooledDatabase._is_stalec C s
|| j kS r )r )r r0 r/ r
r
r r% s zPooledDatabase._is_closedFc s | |}|r,| j| tt| | nh|| jkr| j| }| j|= | jrv| |rvt
d| tt| | n t
d| t | j
||f d S )Nz Closing stale connection %s.zReturning %s to pool.)r r addr r
r( r r r' r# r$ r heappushr )r r/
close_connr0 r. r r
r r( s
zPooledDatabase._closec C s4 | }| | | ||s0| j|dd dS )zS
Close the underlying connection without returning it to the pool.
Tr4 N)get_conncloser% r r( )r r/ r
r
r manual_close s zPooledDatabase.manual_closec C s" | j D ]\}}| j|dd qdS )z<
Close all connections managed by the pool.
Tr5 N)r r( )r _r/ r
r
r close_all s zPooledDatabase.close_all)r N)NN)F) __name__
__module__ __qualname__r r r+ r' r% r( r8 r:
__classcell__r
r
r r r
N s , r
c s e Zd Z fddZ ZS )PooledMySQLDatabasec s: t t| ||}|s6z|d W n d}Y nX |S )NFT)r r? r% Zping)r r0 r/ is_closedr r
r r% s
z PooledMySQLDatabase._is_closedr; r< r= r% r> r
r
r r r? s r? c s e Zd Z fddZ ZS )_PooledPostgresqlDatabasec s$ t t| ||}|s t|j}|S r )r rB r% boolclosedr r0 r/ rD r r
r r% s
z$_PooledPostgresqlDatabase._is_closedrA r
r
r r rB s rB c @ s e Zd ZdS )PooledPostgresqlDatabaseNr; r< r= r
r
r
r rF s rF )PostgresqlExtDatabasec @ s e Zd ZdS )PooledPostgresqlExtDatabaseNrG r
r
r
r rI s rI c s e Zd Z fddZ ZS )_PooledSqliteDatabasec s4 t t| ||}|s0z
|j W n Y dS X |S )NT)r rJ r%
total_changesrE r r
r r% s
z _PooledSqliteDatabase._is_closedrA r
r
r r rJ s rJ c @ s e Zd ZdS )PooledSqliteDatabaseNrG r
r
r
r rL s rL )SqliteExtDatabasec @ s e Zd ZdS )PooledSqliteExtDatabaseNrG r
r
r
r rN s rN )__doc__r loggingr, peeweer r r getLoggerr# r objectr
r? rB rF Zplayhouse.postgres_extrH rI ImportErrorrJ rL Zplayhouse.sqlite_extrM rN r
r
r
r
s0 <
f