�`^c@s!dZddlZddlZddlZddlZddlZejddkrdddlZnzejd(kr�ddlZn\ddl Z e j
�Zej�z)e j
ddd d
e�ddlZWdej�X[yddlmZWn!ek
rddlmZnXdefd
��YZdefd��YZdd)d��YZdefd��YZdefd��YZdefd��YZdefd��YZdZdZd�ZdZdZ dZ!d �Z"d!�Z#d"�Z$d#�Z%d$�Z&d%�Z'd&d*d'��YZ(dS(+s$Id$i�Niiiitignoretmessages1the cPickle module has been removed in Python 3.0tcategory(tdbtTableDBErrorcBseZRS((t__name__t
__module__(((s$/sys/lib/python2.7/bsddb/dbtables.pyR>stTableAlreadyExistscBseZRS((RR(((s$/sys/lib/python2.7/bsddb/dbtables.pyR@stCondcBseZdZd�ZRS(s!This condition matches everythingcCsdS(Ni((tselfts((s$/sys/lib/python2.7/bsddb/dbtables.pyt__call__Fs(RRt__doc__R(((s$/sys/lib/python2.7/bsddb/dbtables.pyRDst ExactCondcBs eZdZd�Zd�ZRS(s)Acts as an exact match condition functioncCs
||_dS(N(t
strtomatch(R R((s$/sys/lib/python2.7/bsddb/dbtables.pyt__init__KscCs
||jkS(N(R(R R
((s$/sys/lib/python2.7/bsddb/dbtables.pyRMs(RRRRR(((s$/sys/lib/python2.7/bsddb/dbtables.pyR
Is t
PrefixCondcBs eZdZd�Zd�ZRS(s9Acts as a condition function for matching a string prefixcCs
||_dS(N(tprefix(R R((s$/sys/lib/python2.7/bsddb/dbtables.pyRRscCs|t|j� |jkS(N(tlenR(R R
((s$/sys/lib/python2.7/bsddb/dbtables.pyRTs(RRRRR(((s$/sys/lib/python2.7/bsddb/dbtables.pyRPs tPostfixCondcBs eZdZd�Zd�ZRS(s:Acts as a condition function for matching a string postfixcCs
||_dS(N(tpostfix(R R((s$/sys/lib/python2.7/bsddb/dbtables.pyRYscCs|t|j�|jkS(N(RR(R R
((s$/sys/lib/python2.7/bsddb/dbtables.pyR[s(RRRRR(((s$/sys/lib/python2.7/bsddb/dbtables.pyRWs tLikeCondcBs&eZdZejd�Zd�ZRS(s�
Acts as a function that will match using an SQL 'LIKE' style
string. Case insensitive and % signs are wild cards.
This isn't perfect but it should work for the simple common cases.
cCsfd}x$|D]}|j|d|�}q
W|jdd�|_tjd|jd|�|_dS(Ns.*+()[]?s\t%s.*t^t$(treplacetlikestrtretcompile(R Rtre_flagstchars_to_escapetchar((s$/sys/lib/python2.7/bsddb/dbtables.pyRds
cCs|jj|�S(N(Rtmatch(R R
((s$/sys/lib/python2.7/bsddb/dbtables.pyRls(RRRRt
IGNORECASERR(((s$/sys/lib/python2.7/bsddb/dbtables.pyR^st__TABLE_NAMES__s._COLUMNS__cCs|tS(N(t_columns(ttable((s$/sys/lib/python2.7/bsddb/dbtables.pyt_columns_keyuss._DATA_.s ._ROWID_.icCs|t|t|S(N(t_data(R$tcoltrowid((s$/sys/lib/python2.7/bsddb/dbtables.pyt _data_key�scCs|t|tS(N(R&(R$R'((s$/sys/lib/python2.7/bsddb/dbtables.pyt_search_col_data_key�scCs|tS(N(R&(R$((s$/sys/lib/python2.7/bsddb/dbtables.pyt_search_all_data_key�scCs|t|tS(N(t_rowid(R$R(((s$/sys/lib/python2.7/bsddb/dbtables.pyt
_rowid_key�scCs|tS(N(R,(R$((s$/sys/lib/python2.7/bsddb/dbtables.pyt_search_rowid_key�scCs`|jt�dksT|jt�dksT|jt�dksT|jt�dkrXdSdSdS(s�Verify that the given string does not contain any
metadata strings that might interfere with dbtables database operation.
iiN(tfindt_table_names_keyR#R&R,(R
((s$/sys/lib/python2.7/bsddb/dbtables.pytcontains_metastrings�st
bsdTableDBcBs�eZdddddd�Zd�Zd�Zdd�Zd�Zd�Zd�Zd �Z d
�Z
d�Zd�Zd
�Z
d�Ziid�Zid�Zid�Zd�Zd�ZRS(ii�cs"d|_tj}|r(|tjO}ntjtjBtjBtjB|B} y|tjO}Wnt k
rnnX|r�| tj
B} ntj�|_|jj
tj�|jj||| B�|r�|tjO}ntj|j�|_|jjd�|jjtj�|jj|tj||B|�||_tjddkr�dtfd��Y�dtf�fd��Y}
|
|j�|_n|jj�}yVt|jd�t|�s�|jd |jj�ttjgd�d
|�nWn|j ��nX|j!�i|_"dS(s�bsdTableDB(filename, dbhome, create=0, truncate=0, mode=0600)
Open database name in the dbhome Berkeley DB directory.
Use keyword arguments when calling this constructor.
iiitcursor_py3kcBs,eZd�Zd�Zd�Zd�ZRS(cSs
||_dS(N(t _dbcursor(R tdbcursor((s$/sys/lib/python2.7/bsddb/dbtables.pyR�scSs
|jj�S(N(R4tclose(R ((s$/sys/lib/python2.7/bsddb/dbtables.pyR6�scSsT|jjt|d��}|dk rP|djd�|djd�f}n|S(Ns iso8859-1ii(R4t set_rangetbytestNonetdecode(R tsearchtv((s$/sys/lib/python2.7/bsddb/dbtables.pyR7�s
cSsNt|jd��}|dk rJ|djd�|djd�f}n|S(Ntnextis iso8859-1i(tgetattrR4R9R:(R R<((s$/sys/lib/python2.7/bsddb/dbtables.pyt__next__�s
(RRRR6R7R?(((s$/sys/lib/python2.7/bsddb/dbtables.pyR3�s tdb_py3kcs}eZd�Zd
�fd�Zd
d�Zdd
d�Zd
d�Zd
dd�Zd
dd�Z d
d�Z
d �ZRS(cSs
||_dS(N(t_db(R R((s$/sys/lib/python2.7/bsddb/dbtables.pyR�scs�|jjd|��S(Nttxn(RAtcursor(R RB(R3(s$/sys/lib/python2.7/bsddb/dbtables.pyRC�scSs%t|jd�t|d�d|�S(Nthas_keys iso8859-1RB(R>RAR8(R tkeyRB((s$/sys/lib/python2.7/bsddb/dbtables.pyRD�sicSsLt|d�}|dk r-t|d�}n|jj||d|d|�S(Ns iso8859-1tflagsRB(R8R9RAtput(R REtvalueRFRB((s$/sys/lib/python2.7/bsddb/dbtables.pyRG�scSs(t|d�}|jj||d|�S(Ns iso8859-1RB(R8RARG(R RERHRB((s$/sys/lib/python2.7/bsddb/dbtables.pyt put_bytes�scSsOt|d�}|jj|d|d|�}|dk rK|jd�}n|S(Ns iso8859-1RBRF(R8RAtgetR9R:(R RERBRFR<((s$/sys/lib/python2.7/bsddb/dbtables.pyRJ�s
cSs+t|d�}|jj|d|d|�S(Ns iso8859-1RBRF(R8RARJ(R RERBRF((s$/sys/lib/python2.7/bsddb/dbtables.pyt get_bytes�scSs%t|d�}|jj|d|�S(Ns iso8859-1RB(R8RAtdelete(R RERB((s$/sys/lib/python2.7/bsddb/dbtables.pyRL�scSs
|jj�S(N(RAR6(R ((s$/sys/lib/python2.7/bsddb/dbtables.pyR6�sN(RRRR9RCRDRGRIRJRKRLR6((R3(s$/sys/lib/python2.7/bsddb/dbtables.pyR@�s RDRIRBN(#R9Rt DB_THREADt DB_CREATEt
DB_INIT_MPOOLtDB_INIT_LOCKtDB_INIT_LOGtDB_INIT_TXNtDB_AUTO_COMMITtAttributeErrort
DB_RECOVERtDBEnvtenvt
set_lk_detecttDB_LOCK_DEFAULTtopentDB_TRUNCATEtDBtset_get_returns_nonet set_flagstDB_DUPtDB_BTREEt
dbfilenametsystversion_infotobjectt txn_beginR>R0RGtpickletdumpstaborttcommitt_bsdTableDB__tablecolumns(R tfilenametdbhometcreatettruncatetmodetrecovertdbflagstmyflagstflagsforenvR@RB((R3s$/sys/lib/python2.7/bsddb/dbtables.pyR�sF "
'#
cCs|j�dS(N(R6(R ((s$/sys/lib/python2.7/bsddb/dbtables.pyt__del__scCsT|jdk r(|jj�d|_n|jdk rP|jj�d|_ndS(N(RR9R6RW(R ((s$/sys/lib/python2.7/bsddb/dbtables.pyR6s
cCs|jj|�dS(N(RWttxn_checkpoint(R tmins((s$/sys/lib/python2.7/bsddb/dbtables.pyt
checkpointscCs|jj�dS(N(Rtsync(R ((s$/sys/lib/python2.7/bsddb/dbtables.pyRx scCs�dGH|jj�}y]|j�\}}xDti||6�GH|j�}|r_|\}}q,|j�dSq,Wntjk
r�|j�nXdS(s*Print the database to stdout for debuggings5******** Printing raw database for debugging ********N(RRCtfirsttreprR=R6tDBNotFoundError(R tcurREtdataR=((s$/sys/lib/python2.7/bsddb/dbtables.pyt _db_print#s
cCs�d}y^t|�r$td��nx)|D]!}t|�r+td��q+q+Wt|�}t|jd�|�r�td�n|jj�}t|jd|jj �|t
j|d�d|�t
jt|jd|jj
�td|d tj��}|j|�|jjtd|�t|jd|jj �tt
j|d�d|�|j�d}WnXtjk
r�}|r�|j�ntjd
kr�t|d�q�t|jd�nXdS(s�CreateTable(table, columns) - Create a new table in the database.
raises TableDBError if it already exists or for other DB errors.
s-bad table name: contains reserved metastringss.bad column name: contains reserved metastringsRDstable already existsRIiRBRKRFiiN(ii(R9R1t
ValueErrorR%R>RRRWReRGRfRgtloadsRJR0tDB_RMWtappendRLRitDBErrorRhRbRcRtargs(R R$tcolumnsRBtcolumntcolumnlist_keyt tablelisttdberror((s$/sys/lib/python2.7/bsddb/dbtables.pytCreateTable5s:
'
cCs|t|�rtd�nt|�}t|jd�|�s@gSt|jd|jj�|�}|rttj|�SgSdS(s\Return a list of columns in the given table.
[] if the table doesn't exist.
s-bad table name: contains reserved metastringsRDRKN(R1RR%R>RRJRfR�(R R$R�tpickledcolumnlist((s$/sys/lib/python2.7/bsddb/dbtables.pytListTableColumnses
cCs-|jjt�}|r%tj|�SgSdS(s)Return a list of tables in this database.N(Rtget_getR0RfR�(R tpickledtablelist((s$/sys/lib/python2.7/bsddb/dbtables.pyt
ListTablesws
c
Cs�y|j||�Wn�tk
r�d}y+t|�}|jj�}tjt|j d|j j
�|d|dt j��}i}x|D]}|||<q�Wtj|�}x*|D]"}||kr�|j
|�q�q�W||kr7|j j|d|�t|j d|j j�|tj|d�d|�n|j�d}|j|�Wq�t jk
r�} |r}|j�ntjd kr�t| d�q�t| jd�q�XnXdS(
sCreateOrExtendTable(table, columns)
Create a new table in the database.
If a table of this name already exists, extend it to have any
additional columns present in the given list as well as
all of its current columns.
RKRBRFRIiiiN(ii(R�RR9R%RWReRfR�R>RRJR�tcopyR�RLRGRgRit_bsdTableDB__load_column_infoR�RhRbRcRR�(
R R$R�RBR�t
oldcolumnlistt
oldcolumnhashtct
newcolumnlistR�((s$/sys/lib/python2.7/bsddb/dbtables.pytCreateOrExtendTables>
'
cCs�y+t|jd|jj�t|��}Wn$tjk
rQtd|f�nX|sktd|f�ntj|�|j|<dS(s'initialize the self.__tablecolumns dictRKsunknown table: %rN( R>RRJR%R{RRfR�Rj(R R$ttcolpickles((s$/sys/lib/python2.7/bsddb/dbtables.pyt__load_column_info�scCs�d}x�|s�g}x-tt�D]}|jtjdd��q"Wtjdt|�}tjddkr�|j d�}ny/|j
jt||�d d|dt
j�Wnt
jk
r�q Xd}q W|S(
s"Create a new unique row identifierii�tBis iso8859-1RBRFiN(txranget_rowid_str_lenR�trandomtrandinttstructtpackRbRcR:RRGR-R9tDB_NOOVERWRITEtDBKeyExistError(R R$RBtuniquetblisttxtnewid((s$/sys/lib/python2.7/bsddb/dbtables.pyt__new_rowid�s !
c Cs�d}yt|jd�t|��s3td�n||jkrR|j|�nx=|j�D]/}|j|j|�s_td|f�q_q_W|j j
�}|j|d|�}x?|j�D]1\}}|jj
t|||�|d|�q�W|j�d}Wn�tjk
r�}tj�}|rV|j�|jjt||��ntjd kr|t|d|d�q�t|jd|d�nXdS(
s�Insert(table, datadict) - Insert a new row into the table
using the keys+values from rowdict as the column values.
RDs
unknown tablesunknown column: %rRBiiiN(ii(R9R>RR%RRjR�tkeystcountRWRet_bsdTableDB__new_rowidtitemsRGR)RiR�Rbtexc_infoRhRLR-RcR�( R R$trowdictRBR�R(tdataitemR�tinfo((s$/sys/lib/python2.7/bsddb/dbtables.pytInsert�s.)
cCs�yA|j|g|�}|j�}x|j�D]}d}y�x�|D]�}|jj�}yJ|jjt|||�d|�} |jjt|||�d|�Wntj k
r�d} nX||| �} | dk r|jj
t|||�| d|�n|j�d}qGWWq1|r5|j�n�q1Xq1WWnEtj
k
r�}
tjdkrut|
d�q�t|
jd�nXdS(sModify(table, conditions={}, mappings={}) - Modify items in rows matching 'conditions' using mapping functions in 'mappings'
* table - the table name
* conditions - a dictionary keyed on column names containing
a condition callable expecting the data string as an
argument and returning a boolean.
* mappings - a dictionary keyed on column names containing a
condition callable expecting the data string as an argument and
returning the new string for that column.
RBiiiN(ii(t_bsdTableDB__SelectR�R9RWReRRJR)RLR{RGRiRhR�RbRcRR�(R R$t
conditionstmappingstmatching_rowidsR�R(RBR�R�R�((s$/sys/lib/python2.7/bsddb/dbtables.pytModifys@
c Csiy|j|g|�}|j|}x�j�D]�d}y�|jj�}xK|D]C}y&|jjt|||�d|�WqWtj k
r�qWXqWWy#|jjt
||�d|�Wntj k
r�nX|j�d}Wq2tjk
r}|r|j
�n�q2Xq2WWnEtjk
rd}tjdkrQt|d�qet|jd�nXdS(sDelete(table, conditions) - Delete items matching the given
conditions from the table.
* conditions - a dictionary keyed on column names containing
condition functions expecting the data string as an
argument and returning a boolean.
RBiiiN(ii(R�RjR�R9RWReRRLR)R{R-RiR�RhRbRcRR�( R R$R�R�R�R(RBR�R�((s$/sys/lib/python2.7/bsddb/dbtables.pytDeleteBs6
#
cCs�yT||jkr"|j|�n|dkr>|j|}n|j|||�}WnEtjk
r�}tjdkr�t|d�q�t|j d�nX|j
�S(s�Select(table, columns, conditions) - retrieve specific row data
Returns a list of row column->value mapping dictionaries.
* columns - a list of which column data to return. If
columns is None, all columns will be returned.
* conditions - a dictionary keyed on column names
containing callable conditions expecting the data string as an
argument and returning a boolean.
iiiN(ii(RjR�R9R�RR�RbRcRR�tvalues(R R$R�R�R�R�((s$/sys/lib/python2.7/bsddb/dbtables.pytSelectos
cCs�||jkr|j|�n|dkr;|j|}nxA||j�D]/}|j|j|�sLtd|f�qLqLWi}i}d�}tjd kr�|j �}|j
|�nvg}xm|j �D]_} xVt|�D];\}
}||| �}|dkr�j|
| �Pq��|j
| �q�W|jj�}
d}xH|D]@\}}|d}t||�}||kr�d}nd}y�|
j|�\}}x�|t|� |krW|t}||krB|s�|�r||kri||<n|r?||||<q?qB||kr5||=n|||<n|
j�\}}q�WWqQtjk
r�}|jdtjkrQ�qQqQqQXqQW|
j�~t|�dkr�x�|j �D]�\}}x�|D]�}||kr��ny&|jjt|||��||<Wq�tjk
r{}tjd
krR|dtjkrn�qnn|jdtjkrn�nd||<q�Xq�Wq�Wn|S(s�__Select() - Used to implement Select and Delete (above)
Returns a dictionary keyed on rowids containing dicts
holding the row data for columns listed in the columns param
that match the given conditions.
* conditions is a dictionary keyed on column names
containing callable conditions expecting the data string as an
argument and returning a boolean.
sunknown column: %rcSs|d}|d}t|�t|�kr�d�}t|t�rrt|t�rr|t|j�t|j��St|t�r�t|t�r�|t|j�t|j��SdSt|t�r�dSt|t�r�dSt|t�r�St|t�r�SdS(NicSs$||krdS||kr dSdS(Nii�i((tatb((s$/sys/lib/python2.7/bsddb/dbtables.pytcmp�s
ii�(ttypet
isinstanceRRRRRR
(tatupletbtupleR�R�R�((s$/sys/lib/python2.7/bsddb/dbtables.pytcmp_conditions�s$
iiii�iN(ii(ii(RjR�R9ttablecolumnsR�R�RRbRcR�tsortt enumeratetinsertR�RRCR*R7RR�R=R�R�tDB_NOTFOUNDR6RJR)(R R$R�R�R�R�trejected_rowidsR�t
conditionlisttitjtktrR|t
column_numt conditiont searchkeytsavethiscolumndataRER}R(R�trowdata((s$/sys/lib/python2.7/bsddb/dbtables.pyt__Select�s�
c Cs6d}y�jj�}|jjt|�d|�|jj|�}t|�}xXy|j|�\}}Wntj k
r�PnX|t
|� |kr�Pn|j�qUt|�}xXy|j|�\}}Wntj k
r�PnX|t
|� |krPn|j�q�|j�t
jt|jd|jj�td|dtj��}y|j|�Wntk
r{nX|jjtd|�t|jd|jj�tt
j|d�d|�|j�d}||jkr�j|=nWn<tjk
r1}|r|j�nt|jd��nXdS(s(Remove an entire table from the databaseRBRKRFRIiN(R9RWReRRLR%RCR+R7R{RR.R6RfR�R>RJR0R�tremoveRRGRgRiRjR�RhRR�( R R$RBR|t table_keyRER}R�R�((s$/sys/lib/python2.7/bsddb/dbtables.pytDropsT
(RRRRtR6RwRxR~R�R�R�R�R�R�R�R�R�R�R�R�(((s$/sys/lib/python2.7/bsddb/dbtables.pyR2�s& r 0 : ,6- �ii((()t_cvsidRRbR�R�R�RcRftcPickletwarningstcatch_warningstwt __enter__tfilterwarningstDeprecationWarningt__exit__tbsddb3RtImportErrortbsddbt
StandardErrorRRRR
RRRR0R#R%R&R,R�R)R*R+R-R.R1R2(((s$/sys/lib/python2.7/bsddb/dbtables.pyt<module>sV
|