3 =hA@sddlmZmZddlmZddlmZddlmZddl m Z ddl m Z ddl ZddlZddlZddlZddlZddlZddlZdd ZejejeejejeGd d d eZGd d d e ZeefddZdS)) HTTPServerBaseHTTPRequestHandler)FIND_LEAF_PAGE_FROM_ROOT) PAGE_READER)INODE)INDEX)TABLENcCstdtjddS)Nz AT^ AWSL r)printsysexit)Zsigframer ./root/work/ibd2sql-ibd2sql-v2.x/ibd2sql/web.pysignal_15_handlersrc@s,eZdZdZdZddZddZddZdS) MY_HANDLERzq idx:[ [ [non-leaf, leaf], # idx1 [non-leaf, leaf], # idx2 ], # filename 1 [], # filename 2 ] NcCs.tjj|j}tjj|j}|j}|jdS)N)urllibparseurlparsepathZparse_qsqueryhandle_html_request)selfZurl_componentsrrr r rdo_GET1szMY_HANDLER.do_GETc Csht|jd}|jj|}tj|}d}d}d}d}d}d} g} |jdkrt|d} |d} |d } |d }|dkr|j| d | d }|d kr"|j| d | dj| r|j| d | d} |j| d | dj }|j| d | dj }|j| d | dj }nd}n|dkr<|j| d}n|d kr|j| d | dj| r|j| d | d} |j| d | dj }|j| d | dj }|j| d | dj }nd}n d|}n0|jdkr t|d} dd|j| d D}|j d|j dd|jtj|||||| |j| d| | d jd} |jj| dS) NzContent-LengthTlz/optfilenoidxnopagenolevelidxrleafkeyFddlrootzunknown error, request:z /file_basecSs*g|]"}|d|d|d|ddqS)namerootnorr")r&rrr"r ).0xr r r _sz&MY_HANDLER.do_POST..z Content-typez text/html) datastatusrZprenextrr$currentr"zutf-8)intZheadersZrfilereadjsonloadsrIDX read_page get_all_rowsread_page_id_nextread_page_id_pre send_response send_header end_headersdumpsencodewfilewrite)rZcontent_lengthZ post_datar,rdatar-rZ next_pageidZ pre_pageidrr"rrZrbdatar r rdo_POST7sT            .zMY_HANDLER.do_POSTcs^jdjddjddjfddttjDd}jj|j d dS) Nr+z Content-typez text/htmlu DDCW's ibd2sql 2.x web console


zutf-8) r<r=r>joinrangelenr7rArBr@)rZ html_contentr )rrrgs  $9zMY_HANDLER.handle_html_request)__name__ __module__ __qualname____doc__r7rrDrr r r rr$s  0rc@s4eZdZddZddZddZddZd d Zd S) IBD2SQL_WEBcCstjd|jdddS)Nz>L r)structunpackr,)rr r rr:szIBD2SQL_WEB.read_page_id_nextcCstjd|jdddS)Nz>LrPr)rRrSr,)rr r rr;szIBD2SQL_WEB.read_page_id_precCs*|jj|}|dkr"|j|dSdSdS)NTF)pgr4 init_data)rpageidr,r r rr8s   zIBD2SQL_WEB.read_pagecCs|j|jS)N)r8r:)rr r rread_page_nextszIBD2SQL_WEB.read_page_nextcCs|j|jS)N)r8r;)rr r r read_page_preszIBD2SQL_WEB.read_page_preN)rKrLrMr:r;r8rYrZr r r rrOs rOcCsd|kr dn|d}d|kr dn|d}|jd|d|g}xh|D]^}t|d} t|d|d |d |d |d d } |jd|d t| } |dddkr| jddn | jdd} g} x| jD]} | j| d}|jd|d d||dkr dnd}| jdkr.| | dddnt| j| d}yt| || |rTdnd| }Wn2t k r}z|j|dwWYdd}~XnX| j |}| j |}t }|j | | | |rdndd|j |t }|j | | | |rdnd d|j |g}x@| j| d!D].}| j|d"d}|d,kr4P|j|qW| j||||||| tjd%|d&d'd|d( qW|d }|j|d | | j| j| jdddd)qJW||_||f}|||}d*|d|d+}t||jdS)-Nhostz0.0.0.0portizlisten :sdipagesizefilename encryptionr"iv) page_sizer`rar"rbinit fsp_flagsSDIr#rr&zidxname:PRIMARYTFi8 FSEG_FRAG_ARRr% PK_NON_LEAF KEY_NON_LEAFzskit it)tableidxidrV page_typePK_LEAFKEY_LEAFelements column_opx DB_TRX_ID DB_ROLL_PTRz>H@B) r'leafnor%r!Zprimaryr&rrr")r`r rFr&r$zi ############################### # ibd2sql web console # ############################### http://z )rrrs)inforrrsegindexmysql_version_idr3r Exceptionr4rO init_indexrWcolumnappendrRrSrFr&get_ddlr7r Z serve_forever) file_listoptlogZ server_classZ handler_classZ BIND_HOSTZ BIND_PORTr7 file_baserkrVinoder r)idxnameZ is_primaryr'rveZrootdataZleafdataZidx_rootZidx_leafr"yZknamer`Zserver_addressZhttpdmsgr r rRUN_IBD2SQL_WEBst &,2        r)Z http.serverrribd2sql.ibd2sqlribd2sql.innodb_page.pageribd2sql.innodb_page.inoderibd2sql.innodb_page.indexribd2sql.innodb_page.tablerZ urllib.parserdatetimesignalrRr5r osrSIGTERMSIGINTrrOrr r r rs*     !