qi$TSrSSKrSSKrSSKrSSKJr SSKrSSKJr SSK J r J r J r SSK JrJr Sr\R""\5r"SS \5r"S S \5rg) ao Implementation of a WebDAV provider that provides a very basic, read-only resource layer emulation of a MySQL database. This module is specific to the WsgiDAV application. It provides a classes ``MySQLBrowserProvider``. Usage:: (see docs/sample_wsgidav.yaml) MySQLBrowserProvider(host, user, passwd, db) host - host of database server user - user_name to access database passwd - passwd to access database db - name of database on database server The ``MySQLBrowserProvider`` provides a very basic, read-only resource layer emulation of a MySQL database. It provides the following interface: - the root collection shared consists of collections that correspond to table names - in each table collection, there is a resource called "_ENTIRE_CONTENTS". This is a non-collection resource that returns a csv representation of the entire table - if the table has a single primary key, each table record will also appear as a non-collection resource in the table collection using the primary key value as its name. This resource returns a csv representation of the record and will also include the record attributes as live properties with attribute name as property name and table name suffixed with colon as the property namespace This is a very basic interface and below is a by no means thorough summary of its limitations: - Really only supports having numbers or strings as primary keys. The code uses a numeric or string comparison that may not hold up if the primary key is a date or some other datatype. - There is no handling for cases like BLOBs as primary keys or such. Well, there is no handling for BLOBs in general. - When returning contents, it buffers the entire contents! A bad way to return large tables. Ideally you would have a FileMixin that reads the database even as the application reads the file object.... - It takes too many database queries to return information. Ideally there should be some sort of caching for metadata at least, to avoid unnecessary queries to the database. N)StringIO)util)HTTP_FORBIDDENDAVError#PRECONDITION_CODE_ProtectedProperty) DAVProvider _DAVResourcereStructuredTextc^\rSrSrSrU4SjrSrSrSrSr Sr S r S r S r S rS rSrU4SjrU4SjrSSjrSrU=r$)MySQLBrowserResourceOzdRepresents a single existing DAV resource instance. See also DAVResource and MySQLBrowserProvider. c4>[TU]X#U5 SUlgN)super__init___cache)selfproviderpath is_collectionenviron __class__s W/home/kali/flask_env/lib/python3.13/site-packages/wsgidav/samples/mysql_dav_provider.pyrMySQLBrowserResource.__init__Us g6 c ZUR=RS- slURRUR5upSnSnSnUcSnOUcSnOSnUS :XaS nS nOS nS nUSLnSU[R"5UR [ R"5RUR5R5SSX4S.S.Ul U(d"[R"5URS'[RSURR-5 g)zXRead resource information into self._cache, for cached access. See DAVResource._init() Unknownz text/htmlNDatabasezDatabase Tableztext/csv_ENTIRE_CONTENTSzDatabase Table Contentsz$CSV Representation of Table ContentszDatabase Recordz"Attributes available as propertiesF)type typeComment)content_length contentTypecreated display_nameetagmodifiedsupport_ranges display_infor)z---> _init, nc=%s)r_count_get_resource_inst_init _split_pathrtimenamehashlibmd5update hexdigestr_loggerdebug_count_initConnection)r tableNameprimKey display_typedisplayTypeCommentr%rs r_initMySQLBrowserResource._initYs  33q83!]]66tyyA  !   %L _+L$K,,8 %K"0 %I" 4 #&yy{ IIKKM((3==?#%1U   &*iikDKK # )DMM,O,OOPrcrURcUR5 URRU5$r)rr;get)rinfos r _get_infoMySQLBrowserResource._get_infos( ;;  JJL{{t$$rc$URS5$)Nr$r@rs rget_content_length'MySQLBrowserResource.get_content_lengths~~.//rc$URS5$)Nr%rCrDs rget_content_type%MySQLBrowserResource.get_content_types~~m,,rc$URS5$)Nr&rCrDs rget_creation_date&MySQLBrowserResource.get_creation_dates~~i((rcUR$r)r/rDs rget_display_name%MySQLBrowserResource.get_display_names yyrc$URS5$)Nr+rCrDs rget_display_info%MySQLBrowserResource.get_display_infos~~n--rc$URS5$)Nr(rCrDs rget_etagMySQLBrowserResource.get_etags~~f%%rc$URS5$)Nr)rCrDs rget_last_modified&MySQLBrowserResource.get_last_modifieds~~j))rc /nURR5nURRUR5up4UcuURR U5nUHSnUR [ UR[R"URU5SUR55 MU OUcURRX#5nUbuURRX#U5nUHSnUR [ UR[R"URU5SUR55 MU URS[ UR[R"URS5SUR55 UR5 U$!UR5 f=f)ziReturn list of (direct) collection member names (UTF-8 byte strings). See DAVResource.get_member_list() TFrr!)r_init_connectionr-r _list_tablesappendr rjoin_urir_find_primary_key _list_fieldsinsertclose)rmembersconnr7r8retlistr/pri_keys rget_member_list$MySQLBrowserResource.get_member_listsh }}--/$ !%!:!:499!E I --44T:#DNN, MM MM$))T:  LL $--99$J&"mm88'RG '0 $ $ dii > % $ !((  dii1CD  JJL JJLs FF66Gc[5nURRUR5up#UGbBURR 5nURR XB5n[ R"XSS9n0nUHnXU'M URU5 US:XaUR[RR5n U RSURR-S-U-5 U R5n U Hn URU 5 M U R!5 O0URR#XBU5n U bURU 5 UR!5 UR%S5 U$)zEOpen content as a stream for reading. See DAVResource.get_content() ignore) extrasactionr!zSELECT * from .r)rrr-rrZ_get_field_listcsv DictWriterwriterowcursorMySQLdbcursors DictCursorexecute_dbfetchallra_get_record_by_primary_keyseek) r filestreamr7r8rc listFields csvwriter dictFields field_namerp result_setrows r get_content MySQLBrowserResource.get_contentsB Z !]]66tyyA  ==113D66tGJzHUIJ( )3:&)   z *,,W__%?%?@/$--2C2CCcIIUV#__. %C&&s+& mm>>tPWX?&&s+ JJL rc@>[TU]US9nURRUR5up4UbeURR 5nURR XS5nUHnURSUSU35 M UR5 U$)zReturn list of supported property names in Clark Notation. Return supported live and dead properties. (See also DAVProvider.get_property_names().) In addition, all table field names are returned as properties. ) is_allprop{z:}) rget_property_namesrr-rrZrlr\ra) rr propNamesr7r8rc fieldlist fieldnamers rr'MySQLBrowserResource.get_property_namessG.*.E !]]66tyyA  ==113D 55dFI&   2i[I;!?@' JJLrc>URRUR5up#Ub[R"U5upEXBS-:XaxURR 5nURR Xb5nXW;a.URRXbX55nUR5 U$UR5 [T U])U5$)aReturn the value of a property. The base implementation handles: - ``{DAV:}lockdiscovery`` and ``{DAV:}supportedlock`` using the associated lock manager. - All other *live* properties (i.e. name starts with ``{DAV:}``) are delegated to self.getLivePropertyValue() - Finally, other properties are considered *dead*, and are handled using the associated property manager, if one is present. :) rr-rrsplit_namespacerZrl_get_field_by_primary_keyrarget_property_value) rr/r7r8ns localNamercrvalrs rr'MySQLBrowserResource.get_property_value s"]]66tyyA   006MB#o&}}557 MM99$J )--AACJJLJ w)$//rc&[[[S9e)zDSet or remove property value. See DAVResource.set_property_value() ) err_condition)rrr)rr/valuedry_runs rset_property_value'MySQLBrowserResource.set_property_value&s  *M  r)r)F)__name__ __module__ __qualname____firstlineno____doc__rr;r@rErHrKrNrQrTrWrfrrrr__static_attributes__ __classcell__rs@rr r Os\ .Q`% 0-).&*,\"H&0:  rr c|^\rSrSrU4SjrSrSrSrSrSr Sr S r S r S r S rS rSrSrSrSrU=r$)MySQLBrowserProvideri5c`>[TU]5 XlX lX0lX@lSUlg)Nr)rr_host_user_passwdrur6)rhostuserpasswddbrs rrMySQLBrowserProvider.__init__6s*    %&"rcURRSURSURSURS3$)Nz for db 'z' on 'z ' (user: 'z')')rrrurrrDs r__repr__MySQLBrowserProvider.__repr__>s=..))*)DHH:VDJJ>##G""7++$rcSnSnUR[RR5nUR SU-5 UR 5nUHnUSS:XdMUc USnUSnM g UR 5 URU5n UR[RR5nU (a7UR SU-S-UR-S -U-S -U-S -U-5 O9UR SU-S-UR-S -U-S -U-S -U-S -5 UR5nUcUR 5 gUR 5 g)NrKeyPRIrTypeFSELECT  FROM rk WHERE  =  = ''T) rprqrrrsrtrvrarrufetchone) rrcr pri_key_valuerepri_field_typerpr~r isNumTypes r_exists_record_by_primary_key2MySQLBrowserProvider._exists_record_by_primary_keyssW__778{Z/0__& C5zU"?!'lG%([N   ..~> W__778  NN((          NN((          oo ; LLN rcSnSnUR[RR5nUR SU-5 UR 5nUHn U SS:XdMUc U SnU SnM g UR 5 URU5n UR[RR5nU (a7UR SU-S-UR-S-U-S -U-S -U-5 O9UR SU-S-UR-S-U-S -U-S -U-S -5 UR5n U cUR 5 g[R"X5n UR 5 U $) Nrrrrrrrrkrrrr) rprqrrrsrtrvrarrurrto_str) rrcrrr}rerrpr~rrrs rr.MySQLBrowserProvider._get_field_by_primary_keysW__778{Z/0__& C5zU"?!'lG%([N   ..~> W__778  NN((          NN((          oo ; LLNkk#/*  rc&0nSnSnUR[RR5nUR SU-5 UR 5nUHn U SS:XdMUc U SnU SnM g UR 5 URU5n UR[RR5nU (a1UR SUR-S-U-S-U-S -U-5 O3UR SUR-S-U-S-U-S -U-S -5 UR5n U cUR 5 gU R5Hn [R"X5XK'M UR 5 U$) NrrrrrzSELECT * FROM rkrrrr) rprqrrrsrtrvrarrurkeysrr) rrcrrdictRetrerrpr~rrfnames rrw/MySQLBrowserProvider._get_record_by_primary_keysW__778{Z/0__& C5zU"?!'lG%([N   ..~> W__778  NN ((         NN ((        oo ; LLNXXZE![[4GN  rcSnUR[RR5nUR SU-5 UR 5nUHnUSnUSnUS:XdMUcUnM g UR 5 U$)Nrrrr)rprqrrrsrtrvra) rrcrrerpr~rrkeyvalues rr^&MySQLBrowserProvider._find_primary_keys}W__778{Z/0__& CG I5zH5 ?'G  rcP/nUR[RR5nUR SU-S-UR -S-U-5 UR 5nUH*nUR[R"Xs55 M, UR5 U$)Nrrrk) rprqrrrsrtrurvr\rrra)rrcrr}rdrpr~rs rr_!MySQLBrowserProvider._list_fieldssW__778y:-8488CcIJVW__& C NN4;;s7 8 rc/nUR5nURS5 UR5nUHnURSUS-5 M UR 5 U$)Nz SHOW TABLESz%sr)rprtrvr\ra)rrcrdrpr~rs rr[!MySQLBrowserProvider._list_tables)sV}%__& C NN43q6? + rcU=RS- slURX5(dgURU5up4USLn[XXR5$)z:Return info dictionary for path. See get_resource_inst() rN)_count_get_resource_instexistsr-r )rrr _tableNamer8rs rget_resource_inst&MySQLBrowserProvider.get_resource_inst3sP %%*%{{4))"..t4 4 #D GGrcURU5up4UcgSnUR5nURU5nX6;aU(aUR5 ggU(a0US:wa*UR XSU5U(aUR5 $$U(aUR5 gg!W(aUR5 ff=f)NTFr!)r-rZr[rar)rrrr7r8rctbllists rrMySQLBrowserProvider.existsBs!--d3   D((*D''-G'   7&8899$7S  t s(B,B,,Cc`URU5up4URX5=(a USL$r)r-r)rrrrr8s rr"MySQLBrowserProvider.is_collectionVs-"..t4 {{4)=go=r)r6rurrr)rrrrrrr-rZrlrrrrwr^r_r[rrrrrrs@rrr5sX'j$ 42h3j1f  H(>>rr)rrmr0r.iorrqwsgidavrwsgidav.dav_errorrrrwsgidav.dav_providerrr __docformat__get_module_loggerrr4r rrrrs`6n   ;"   *^ <^ Lc>;c>r