OwlCyberSecurity - MANAGER
Edit File: calendaruserproxy.pyc
� �t�ac @ s� d Z d d d d d g Z d d l Z d d l Z d d l m Z d d l m Z d d l m Z m Z m Z d d l m Z d d l m Z m Z m Z d d l m Z d d l m Z d d l m Z m Z d d l m Z m Z m Z d d l m Z d d l m Z m! Z! m" Z" d d l# m$ Z$ m% Z% d d l# m& Z& d d l# m' Z' d d l( m) Z) d d l* m+ Z+ d d l, m Z- d d l. m/ Z0 d d l1 m2 Z2 d d l3 m4 Z4 d d l5 m6 Z6 d d l7 m8 Z8 d d l9 m: Z: m; Z; e e< � Z= e � Z> d e' f d � � YZ? d e f d! � � YZ@ d" e& f d# � � YZA d e+ e? e% e$ f d$ � � YZB d e f d% � � YZC eD ZE d e eC f d& � � YZF d e eC f d' � � YZG e0 jH e0 jI e0 jJ e0 jK � � e0 jL e0 jM e0 jN � � � e0 jO � � � ZP d S(( s- Implements a calendar user proxy principal. t" CalendarUserProxyPrincipalResourcet ProxyDBt ProxyDBServicet ProxySqliteDBt ProxyPostgreSQLDBi����N( t Logger( t RecordType( t succeedt inlineCallbackst returnValue( t getModule( t XMLFilet Elementt renderer( t customxml( t calendarserver_namespace( t configt fullServerPath( t AbstractADBAPIDatabaset ADBAPISqliteMixint ADBAPIPostgreSQLMixin( t normalizeUUID( t formatLinkt formatLinkst formatPrincipals( t DAVPrincipalResourcet DAVResourceWithChildrenMixin( t DirectoryElement( t$ ReadOnlyWritePropertiesResourceMixIn( t Memcacher( t CalDAVComplianceMixIn( t element( t dav_namespace( t responsecode( t NonePropertyStore( t joinURL( t HTTPErrort StatusResponset PermissionsMixInc B s# e Z d � Z e e d d � Z RS( c C s� t j t j t j � � t j t j t j � � � � t j t j t j | j j � � � t j t j t j � � � t j � � f } | t d � t j D� � 7} t t j | � � S( Nc s sT | ]J } t j t j t j | � � t j t j t j � � � t j � � Vq d S( N( t davxmlt ACEt Principalt HReft Grantt Privileget Allt Protected( t .0t principal( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pys <genexpr>Z s ( R' R( R) t AuthenticatedR+ R, t ReadR* t parentt principalURLt WritePropertiesR. t tupleR t AdminPrincipalsR t ACL( t selft aces( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt defaultAccessControlListI s c C s | j � S( N( R; ( R9 t requestt inheritancet expandingt inherited_aces( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt accessControlListd s N( t __name__t __module__R; t Truet Falset NoneR@ ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR& G s t ProxyPrincipalDetailElementc B s> e Z d Z e e j j d � � Z d � Z e d � � Z RS( s� A L{ProxyPrincipalDetailElement} is an L{Element} that can render the details of a L{CalendarUserProxyPrincipalResource}. s+ calendar-user-proxy-principal-resource.htmlc C s t t | � j � | | _ d S( N( t superRF t __init__t resource( R9 RI ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRH t s c C sc | j j j } | j } | j j } y: t | j t j � rT t | j � j � } n | j } Wn t k rw d } n Xy | j } Wn t k r� g } n X| j d | j j d | j j d | d | j j | j � d | d | j d | j � d t | j � � d | j � d t | j � � d t | j � � d | j � j t � d | j � j t � � S( s5 Top-level renderer in the template. t t directoryGUIDt realmt guidt recordTypet shortNamest fullNamet principalUIDR4 t proxyPrincipalUIDt proxyPrincipalURLt alternateURIst groupMemberst groupMemberships( RI R3 t recordt isinstanceRM t uuidt UUIDt strt uppert AttributeErrorRO t fillSlotst servicet realmNamet recordTypeToOldNameRN t displayNameRQ R R4 R RT RU t addCallbackR RV ( R9 R< t tagRW RI R3 RM RO ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR0 x s8 ( RA RB t __doc__R t thisModulet filePatht siblingt loaderRH R R0 ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRF j s t ProxyPrincipalElementc B s e Z d Z e d � � Z RS( sa L{ProxyPrincipalElement} is a renderer for a L{CalendarUserProxyPrincipalResource}. c C s t | j � S( s7 Render the proxy principal's details. ( RF RI ( R9 R< Rd ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt resourceDetail� s ( RA RB Re R Rk ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRj � s c B s e Z d Z e � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z e d � � Z d � Z e d � � Z e d � � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z e e d � � Z d � Z d � Z d � Z e d � � Z RS( s1 Calendar user proxy principal resource. c s� | j � r d � n d � t | j � � � � } t t | � j � t j | � | | _ � | _ | | _ | j j j | _ d | j j � � f | _ t � � f d � | j � D� � | _ d S( s� @param parent: the parent of this resource. @param proxyType: a C{str} containing the name of the resource. t /RJ s %s#%sc 3 s1 | ]' } | j d � r t | � � � Vq d S( Rl N( t startswithR# ( R/ t url( t proxyTypet slash( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pys <genexpr>� s N( t isCollectionR# R4 RG R RH R R3 Ro t _urlt pcollectionRQ t uidR6 RT t _alternate_urls( R9 R3 Ro Rn ( ( Ro Rp s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRH � s c C s d j | j j t | � � S( Ns <{}: {}>( t formatt __class__RA R[ ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt __repr__� s c C s d j | j | j � S( Ns {} [{}]( Rv R3 Ro ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt __str__� s c C s t S( s� Return the SQL database for this group principal. @return: the L{ProxyDB} for the principal collection. ( R ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _index� s c C s{ | j d k r t j j S| j d k r2 t j j S| j d k rK t j j S| j d k rd t j j St t | � j � Sd S( Ns calendar-proxy-reads calendar-proxy-writes calendar-proxy-read-fors calendar-proxy-write-for( Ro R' t ResourceTypet calendarproxyreadt calendarproxywritet calendarproxyreadfort calendarproxywriteforRG R t resourceType( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s7 | r | j d k s+ | r/ | j d k r/ t St Sd S( Ns calendar-proxy-writes calendar-proxy-read( Ro RC RD ( R9 t read_write( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt isProxyType� s c C s t S( N( RC ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRq � s c C s t d � S( N( R RE ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt etag� s c C s( t | d � s! t | � | _ n | j S( Nt _dead_properties( t hasattrR" R� ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt deadProperties� s c c s� t | � t k r | } n | j � } | \ } } | t k r� | d k r� t | j d � r| t t j | j � j � � q� t t t j d | f � � � q� n t t | � j | | � V} t | � d S( Ns record-typeRW s Property %s does not exist.( t typeR6 t qnameR R� R3 R R R t _recordTypeFromProxyTypet descriptionR$ R% R! t NOT_FOUNDRG R t readProperty( R9 t propertyR< R� t namespacet namet result( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� s c C sY t | t j � s t � | j � t d f k r@ | j | | � St t | � j | | � S( Ns group-member-set( RX R' t WebDAVElementt AssertionErrorR� R t setGroupMemberSetRG R t writeProperty( R9 R� R< ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� s c c s g | j D] } t | � ^ q } g } t � } x� | D]� } | j j | � V} | d k so | j � | k r� t t t j d | | j � f � � � n | j | � | j | j � � q8 Wt � } | j � V} | j g | D] } | j � ^ q� � | j � V} | j g | D] } | j � ^ q� | j | � Vt � } | j � V} | j g | D] } | j � ^ q^� | j � V} | j g | D] } | j � ^ q�� | j j j � V| j | � } x8 | D]0 } | j j | � V} | r�| j j � Vq�q�Wt t � d S( NsC Attempt to use a non-existent principal %s as a group member of %s.( t childrenR[ t setRs t _principalForURIRE R4 R$ R% R! t BAD_REQUESTt appendt addRQ RU t updatet expandedGroupMemberst setGroupMemberSetPrincipalsR3 t cacheNotifiert changedt symmetric_differencet principalForUIDR RC ( R9 t new_membersR< t ht memberst principalst newUIDst uriR0 t oldUIDst oldPrincipalst pt newPrincipalst changedUIDsRt ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� $ s< " & & & & c c sY | j j j j | j � | j j � � V} g | D] } | j ^ q2 } | j | � Vd S( N( R3 RW R_ t recordWithShortNameR� RQ t setMembers( R9 R� RW R� t memberRecords( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� ` s c C s t | � S( s9 Customize HTML display of proxy groups. ( Rj ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt htmlElementp s c C s | j S( N( Ro ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRb z s c C s | j S( N( Ru ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRT � s c C s | j S( N( Rr ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR4 � s c C s | j S( N( Rt ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRQ � s c C s | j j � S( N( R3 t principalCollections( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s8 i t j d 6t j d 6t j d 6t j d 6j | j � S( Ns calendar-proxy-reads calendar-proxy-writes calendar-proxy-read-fors calendar-proxy-write-for( t DelegateRecordTypet readDelegateGroupt writeDelegateGroupt readDelegatorGroupt writeDelegatorGroupt getRo ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c c s� g } | j j j j | j � | j j � � V} | d k r� | rS | j � V} n | j � V} xj | D]_ } | d k rg | j s� | j t j k rg | j j | � V} | d k r� | j | � q� qg qg Wn t | � d S( s� Fault in the record representing the sub principal for this proxy type (either read-only or read-write), then fault in the direct members of that record. N( R3 RW R_ R� R� RQ RE t expandedMembersR� t loginAllowedRN t BaseRecordTypet groupRs t principalForRecordR� R ( R9 t expandedt memberPrincipalsRW R� R0 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _directGroupMembers� s ' c C s | j d t � S( NR� ( R� RD ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRU � s c C s | j d t � S( sc Return the complete, flattened set of principals belonging to this group. R� ( R� RC ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s t g � S( N( R ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRV � s c c s� | | j k r t t � n | j j j j | j � | j j � � V} | d k rl | j | j � � V} n t t | � j | � V} t | � d S( s: Optimize this to ignore the owner principal when doing this test. This is a common occurrence as the owner is the one most likely to be looking at their own resources, each of which will have the owner's two proxy principals listed in the ACLs (and this method is called during each ACL L{checkPrivileges} call. @param principal: The principal to check @type principal: L{DirectoryCalendarPrincipalResource} @return: L{True} if principal is a proxy (of the correct type) of our parent @rtype: C{boolean} N( R3 R RD RW R_ R� R� RQ RE t containsUIDRG R t containsPrincipal( R9 R0 RW R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s ( RA RB Re R t logRH Rx Ry Rz R� R� Rq R� R� R R� R� R� R� R� Rb RT R4 RQ R� R� RD R� RU R� RV R� ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR � s8 < c B s8 e Z d Z e � Z d Z d Z d e f d � � YZ d � Z e d � � Z e d � � Z e d � � Z e d � � Z d � Z d � Z e d � � Z d � Z d � Z d � Z d � Z d � Z d � Z e d � � Z e d � � Z e d � � Z e d � � Z d � Z e d � � Z e d � � Z RS( s� A database to maintain calendar user proxy group memberships. SCHEMA: Group Database: ROW: GROUPNAME, MEMBER t 4t CALENDARUSERPROXYt ProxyDBMemcacherc B sG e Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z RS( c C s) t t j | � j | d t j j �d S( Nt key_normalization( RG R R� RH R t Memcachedt ProxyDBKeyNormalization( R9 R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRH � s c C s, | j d t | � f t d j | � � � S( Ns members:%st ,( R� R[ t join( R9 RM R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s, | j d t | � f t d j | � � � S( Ns memberships:%sR� ( R� R[ R� ( R9 RM t memberships( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt setMemberships� s c C s6 d � } | j d t | � f � } | j | � | S( Nc S s4 | r t | j d � � S| d k r) d St � Sd S( NR� ( R� t splitRE ( t value( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _value� s s members:%s( R� R[ Rc ( R9 RM R� t d( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt getMembers� s c C s6 d � } | j d t | � f � } | j | � | S( Nc S s4 | r t | j d � � S| d k r) d St � Sd S( NR� ( R� R� RE ( R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s s memberships:%s( R� R[ Rc ( R9 RM R� R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt getMemberships� s c C s | j d t | � f � S( Ns members:%s( t deleteR[ ( R9 RM ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt deleteMember s c C s | j d t | � f � S( Ns memberships:%s( R� R[ ( R9 RM ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt deleteMembership s ( RA RB RH R� R� R� R� R� R� ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c K s2 t j | | | | t | � t j d � | _ d S( NR ( R RH RC R R� t _memcacher( R9 t dbIDt dbapiNamet dbapiArgst kwargs( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRH s c c s� | j | � V} | d k r% d } n t | � } t | � } | j | � } | j | � } | j | | | � Vx+ t j | | � D] } | j j | � Vq� W| j j | � Vd S( s� Add a group membership record. @param principalUID: the UID of the group principal to add. @param members: a list UIDs of principals that are members of this group. N( ( R� RE R� t differencet changeGroupMembersInDatabaset itertoolst chainR� R� R� ( R9 RQ R� t current_memberst update_memberst remove_memberst add_memberst member( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt setGroupMembers s c c s# | j | � V| j | | � Vd S( s� A blocking call to add a group membership record in the database. @param principalUID: the UID of the group principal to add. @param members: a list UIDs of principals that are members of this group. N( t _delete_from_dbt _add_to_db( R9 RQ R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt setGroupMembersInDatabase0 s c c sH x | D] } | j | | � Vq Wx | D] } | j | | � Vq) Wd S( sS A blocking call to add a group membership record in the database. @param principalUID: the UID of the group principal to add. @param addMembers: a list UIDs of principals to be added as members of this group. @param removeMembers: a list UIDs of principals to be removed as members of this group. N( t _delete_from_db_onet _add_to_db_one( R9 RQ t addMemberst removeMembersR� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� < s c c s^ | j | � V} | j | � V| rZ x | D] } | j j | � Vq+ W| j j | � Vn d S( s{ Remove a group membership record. @param principalUID: the UID of the group principal to remove. N( R� R� R� R� R� ( R9 RQ R� R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt removeGroupK s c s5 � � f d � } � j j � � } | j | � | S( s� Return the list of group member UIDs for the specified principal. @return: a deferred returning a C{set} of members. c sQ | d k r | S� � f d � } � j d � j d � f � } | j | � | S( Nc s[ t g | D] } | d j d � ^ q � � � j j � � � } | j � f d � � | S( Ni s utf-8c s � S( N( ( t _( R� ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt <lambda>l RJ ( R� t encodeR� R� Rc ( t dbmemberst rowR� ( RQ R9 ( R� s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt gotMembersFromDBi s ,s. select MEMBER from GROUPS where GROUPNAME = :1s utf-8( RE t queryt decodeRc ( R� R� R� ( RQ R9 ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt gotCachedMembersd s ( R� R� Rc ( R9 RQ R� R� ( ( RQ R9 s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� ^ s c s5 � � f d � } � j j � � } | j | � | S( s� Return the list of group principal UIDs the specified principal is a member of. @return: a deferred returning a C{set} of memberships. c sQ | d k r | S� � f d � } � j d � j d � f � } | j | � | S( Nc s[ t g | D] } | d j d � ^ q � � � j j � � � } | j � f d � � | S( Ni s utf-8c s � S( N( ( R� ( R� ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � RJ ( R� R� R� R� Rc ( t dbmembershipsR� R� ( RQ R9 ( R� s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt gotMembershipsFromDB� s ,s. select GROUPNAME from GROUPS where MEMBER = :1s utf-8( RE R� R� Rc ( R� R� R� ( RQ R9 ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt gotCachedMemberships} s ( R� R� Rc ( R9 RQ R� R� ( ( RQ R9 s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� w s c c s5 x. | D]& } | j d | j d � | f � Vq Wd S( s� Insert the specified entry into the database. @param principalUID: the UID of the group principal to add. @param members: a list of UIDs or principals that are members of this group. sh insert into GROUPS (GROUPNAME, MEMBER) values (:1, :2) s utf-8N( t executeR� ( R9 RQ R� R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s( | j d | j d � | j d � f � S( s� Insert the specified entry into the database. @param principalUID: the UID of the group principal to add. @param memberUID: the UID of the principal that is being added as a member of this group. s\ insert into GROUPS (GROUPNAME, MEMBER) values (:1, :2) s utf-8( R� R� ( R9 RQ t memberUID( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s | j d | j d � f � S( s� Deletes the specified entry from the database. @param principalUID: the UID of the group principal to remove. s' delete from GROUPS where GROUPNAME = :1s utf-8( R� R� ( R9 RQ ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s( | j d | j d � | j d � f � S( s� Deletes the specified entry from the database. @param principalUID: the UID of the group principal to remove. @param memberUID: the UID of the principal that is being removed as a member of this group. s7 delete from GROUPS where GROUPNAME = :1 and MEMBER = :2s utf-8( R� R� ( R9 RQ R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR� � s c C s | j d | j d � f � S( s� Deletes the specified member entry from the database. @param principalUID: the UID of the member principal to remove. s$ delete from GROUPS where MEMBER = :1s utf-8( R� R� ( R9 RQ ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _delete_from_db_member� s c C s t j S( sE @return: the schema version assigned to this index. ( R t schema_version( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _db_version� s c C s t j S( sF @return: the collection type assigned to this index. ( R t schema_type( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _db_type� s c c sU | j d d d f d t �V| j d d d d t �V| j d d d d t �Vd S( sr Initialise the underlying database tables. @param q: a database cursor to use. t GROUPSt GROUPNAMEt textt MEMBERt ifnotexistst GROUPNAMESt MEMBERSN( R R ( R R ( R ( R ( t _create_tableRC t _create_index( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _db_init_data_tables� s c c s/ t t | � j � V} | j � Vt | � d S( sW Open the database, normalizing all UUIDs in the process if necessary. N( RG R t opent _maybeNormalizeUUIDsR ( R9 R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR � s c c s� | j d � V} | d k r� x� | j d � VD]� \ } } | j d � } t | d � | d <d j | � } t | � } | | k s� | | k r- | j d | | | | g � Vq- q- W| j d � Vn d S( s� Normalize the UUIDs in the proxy database so they correspond to the normalized UUIDs in the main calendar database. s7 select VALUE from CALDAV where KEY = 'UUIDS_NORMALIZED's$ select GROUPNAME, MEMBER from GROUPSt #i s� update GROUPS set GROUPNAME = :1, MEMBER = :2 where GROUPNAME = :3 and MEMBER = :4 s~ insert or ignore into CALDAV (KEY, VALUE) values ('UUIDS_NORMALIZED', 'YES') N( t _db_value_for_sqlRE t _db_all_values_for_sqlR� R R� t _db_execute( R9 t alreadyDonet groupnameR� t grouplistt newGroupNamet newMemberName( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR � s c c sM t | � d k rI | j d d d d t �V| j d d d d t �Vn d S( s� Upgrade the data from an older version of the DB. @param old_version: existing DB's version number @type old_version: str i R R R R R R N( R ( R ( t intR RC ( R9 t old_version( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _db_upgrade_data_tables s c C s | j d � S( sm Empty the underlying database tables. @param q: a database cursor to use. s delete from GROUPS( R ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt _db_empty_data_tables2 s c c so | j s | j � Vn x= g | j d � VD] } | d ^ q+ D] } | j | � Vq? Wt t | � j � Vd S( Ns select GROUPNAME from GROUPSi ( t initializedR R� R� RG R t clean( R9 R� R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR = s .c c s/ t g | j d � VD] } | d ^ q � d S( sK Retrieve all members that have been directly delegated to s" select DISTINCT MEMBER from GROUPSi N( R R� ( R9 R� ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt getAllMembersH s ( RA RB Re R R� R� R� R R� RH R R� R� R� R� R� R� R� R� R� R� R� R� R� R R R R R R R ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR � s4 ) c B s e Z d Z d � Z RS( s5 Sqlite based proxy database implementation. c C sB t t j | � | _ t j | � t j | d d | j f � d S( Nt Proxiest sqlite3( R R t DataRoott dbpathR RH R ( R9 R ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRH W s ( RA RB Re RH ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR R s c B s) e Z d Z d d d d � Z d � Z RS( s; PostgreSQL based augment database implementation. c C sd d d l m } t j | � t j | d | j d d | d | d | d | �| r` | t _ n d S( Ni����( t postgresR t hostt databaset usert password( ( t txdav.base.datastore.subpostgresR R RH R RA R� ( R9 R! R" R# R$ t dbtypeR ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyRH c s c C s t d � S( s� Don't bother normalizing UUIDs for postgres yet; users of postgres databases for proxy data are even less likely to have UUID case-normalization issues than the general population. N( R RE ( R9 ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR n s N( RA RB Re RE RH R ( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyR ^ s (Q Re t __all__R� RY t twext.python.logR t twext.who.idirectoryR R� t twisted.internet.deferR R R t twisted.python.modulesR t twisted.web.templateR R R t twistedcaldavR t twistedcaldav.customxmlR t twistedcaldav.configR R t twistedcaldav.databaseR R R t twistedcaldav.directory.utilR R R R t twistedcaldav.extensionsR R R R t twistedcaldav.memcacherR t twistedcaldav.resourceR t txdav.who.delegatesR� t txdav.xmlR R' t txdav.xml.baseR t txweb2R! t txweb2.dav.nonepropsR" t txweb2.dav.utilR# t txweb2.httpR$ R% RA Rf R� R& RF Rj R R RE R R R R8 R( R) R1 R+ R, R2 R. t authReadACL( ( ( s< /opt/cpanel-ccs/twistedcaldav/directory/calendaruserproxy.pyt <module> sb #4 � +� x