tf#8ddlZddlZddlZdZdZddZddZy)Nc 4tj|}|j}|jdj }|t |dk(r|d}nd}|d|d|d|d|d |d |d |d dg|dg|d }|j |S)NSELECT * from tileset_info r) zoom_step max_lengthassembly chrom_names chrom_sizes tile_sizemax_zoom max_widthmin_posmax_posheader)sqlite3connectcursorexecutefetchonelenclose)db_fileconncrowr tileset_infos Z/var/www/html/software/conda/envs/higlass/lib/python3.12/site-packages/clodius/db_tiles.pyget_tileset_infor's ??7 #D A ))0 1 : : = {} AND rStartPos <= {} r utf-8rrr r  )xStartxEnd chrOffset importanceuidfields)r'rrrformatrfetchallcol defaultdictlistdecodeAttributeErrormathfloorrangesplitr )r!zoom tile_x_pos num_tilesr%r"r# tile_widthtile_start_pos tile_end_posqueryrowsnew_rowsrr2tile_posx_startx_endi tile_x_start tile_x_ends r& get_tilesrO8s($G,L ??7 #D Ak*Q$Y6J*,N!I $::L   nl   99U  $ $ &Dt$H  A$++g&C AaD>,AZ+O PPA$!z: #9: Az>La%:-JH#(="#$A$ !!%&qT&'d""#A$**T"2  ' "  8 JJL O7 A$C sEE E c(t|}tj|}|j}|dd|zz } | |z} | || zz} | |z} | || zz} dj || | | | }|j |j }tjt}|D]} |djd}|d}|d}|d}|d}t|||zD]}t|||zD]u}|| z}|dz| z}|| z}|dz| z}||ks#||k\s)||ks/||k\s5|||fxx|d|d|d|d|d |d ||d |d jd d gz cc<w|j|S#t$r|d}YwxYw)a% Retrieve a contiguous set of tiles from a 2D db tile file. Parameters ---------- db_file: str The filename of the sqlite db file zoom: int The zoom level tile_x_pos: int The x position of the first tile tile_y_pos: int The y position of the first tile numx: int The width of the block of tiles to retrieve numy: int The height of the block of tiles to retrieve Returns ------- tiles: {pos: tile_value} A set of tiles, indexed by position rr a9 SELECT fromX, toX, fromY, toY, chrOffset, importance, fields, uid, intervals.id FROM intervals, position_index WHERE intervals.id=position_index.id AND zoomLevel <= {} AND rToX >= {} AND rFromX <= {} AND rToY >= {} AND rFromY <= {} rr,rrr r r rr r-) r.r/yStartyEndr0r1r2idr3)r'rrrr4rr5r6r7r8r9r:r=r>r )r!r?r@ tile_y_posnumxnumyr%r"r#rBtile_x_start_postile_x_end_postile_y_start_postile_y_end_posrErFrGrHr2rJrKy_starty_endrLjrMrN tile_y_start tile_y_ends r& get_2d_tilesr`s0$G,L ??7 #D Ak*Q$Y6J!J.% ):;N!J.% ):;N   0@.  99U  $ $ &Dt$H & A$++g&CA$!A$!z:#45 A:zD'89  :~ !ez1  :~ !ez1 j(-*,-aV$&'d$%aD&'d$%aD)*1*+A$#&"#A$&'djj&6  ) $  &N JJL OM A$C s)FFF)r)rr) collectionsr6r;rr'r*rOr`r(r&rcs% 8,L^br(