o Nrf#ã@s@ddlZddlZddlZdd„Zdd„Zd dd„Zd d d „ZdS) éNc Cs’t |¡}| ¡}| d¡ ¡}|durt|ƒdkr|d}nd}|d|d|d|d|d |d |d |d dg|dg|d œ }| ¡|S)NúSELECT * from tileset_infoé éÚrééééééé) Ú zoom_stepÚ max_lengthÚassemblyÚ chrom_namesÚ chrom_sizesÚ tile_sizeÚmax_zoomÚ max_widthÚmin_posÚmax_posÚheader)Úsqlite3ÚconnectÚcursorÚexecuteÚfetchoneÚlenÚclose)Údb_fileÚconnÚcÚrowrÚ tileset_info©r$úY/var/www/html/software/conda/envs/catlas/lib/python3.10/site-packages/clodius/db_tiles.pyÚget_tileset_infos(  õ r&c Csvt |¡}| ¡}| d¡ ¡}|d|d|d|d|d|d|d|d ddg|d|dgd œ }| ¡|S) Nrrrrrr r r r ) r rrrrrrrrr)rrrrrr)rr r!r"r#r$r$r%Úget_2d_tileset_info"s ö r'rc CsHt|ƒ}t |¡}| ¡}|dd|}||}|||} d ||| ¡} | | ¡ ¡} t t ¡} | D]i} z | d  d¡}Wn t yL| d}Ynw|t   | d||¡}| d}| d}t|||ƒD]3}||}|d|}|}||krœ||krœ| || d| d| d| d|| d  d ¡d œg7<qiq4| ¡| S) a™ Retrieve a contiguous set of tiles from a db tile file. Parameters ---------- db_file: str The filename of the sqlite db file zoom: int The zoom level tile_x_pos: int The position of the first tile num_tiles: int The number of tiles to retrieve Returns ------- tiles: {pos: tile_value} A set of tiles, indexed by position rrzê SELECT startPos, endPos, chrOffset, importance, fields, uid FROM intervals,position_index WHERE intervals.id=position_index.id AND zoomLevel <= {} AND rEndPos >= {} AND rStartPos <= {} r úutf-8rrrr ú )ÚxStartÚxEndÚ chrOffsetÚ importanceÚuidÚfields)r&rrrÚformatrÚfetchallÚcolÚ defaultdictÚlistÚdecodeÚAttributeErrorÚmathÚfloorÚrangeÚsplitr)rÚzoomÚ tile_x_posZ num_tilesr#r r!Ú tile_widthZtile_start_posZ tile_end_posÚqueryÚrowsÚnew_rowsÚrr.Ztile_posÚx_startÚx_endÚiÚ tile_x_startÚ tile_x_endr$r$r%Ú get_tiles8sP  ÿø   ÿ  úþ€úrGcCs t|ƒ}t |¡}| ¡}|dd|} | |} | || } | |} | || } d || | | | ¡}| |¡ ¡}t t ¡}|D]‰}z |d  d¡}Wn t yX|d}Ynw|d}|d}|d}|d}t |||ƒD]X}t |||ƒD]N}|| }|d| }|| }|d| }||krÇ||krÇ||krÇ||krÇ|||f|d|d|d|d|d |d ||d |d   d ¡dœ g7<qyqpq@| ¡|S)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 rra9 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 <= {} r r(rrrr r rr r)) r*r+ZyStartZyEndr,r-r.Úidr/)r&rrrr0rr1r2r3r4r5r6r9r:r)rr;r<Z tile_y_posZnumxZnumyr#r r!r=Ztile_x_start_posZtile_x_end_posZtile_y_start_posZtile_y_end_posr>r?r@rAr.rBrCZy_startZy_endrDÚjrErFZ tile_y_startZ tile_y_endr$r$r%Ú get_2d_tiles‡sh    ÿô   ÿ    ÷ÿ€òÿrJ)r)rr)Ú collectionsr2r7rr&r'rGrJr$r$r$r%Ús O