o Nrfã@s0ddlZdd„Zdd„Zd dd„Zd d d „ZdS) éNcCsÜt |¡}| ¡}| d¡ ¡}tt|jŽƒ}d|vrd}n t||  d¡ƒ}d|vr.d}n||  d¡}|d|d|d|d|d |d dg|dg||t t|d   d ¡d d„|d  d ¡Dƒƒƒddœ }|  ¡|S)NzSELECT * from tileset_infoÚversionéÚheaderÚréééééú cSsg|]}t|ƒ‘qS©)Úint)Ú.0Úcsr r ú\/var/www/html/software/conda/envs/catlas/lib/python3.10/site-packages/clodius/tiles/beddb.pyÚ "sz tileset_info..éÚ2) Z zoom_stepÚ max_lengthZassemblyZ tile_sizeZmax_zoomÚ max_widthZmin_posZmax_posrrZ chromsizesZ info_version) Úsqlite3ÚconnectÚcursorÚexecuteZfetchoneÚnextÚzipÚ descriptionr ÚindexÚlistÚsplitÚclose)Údb_fileÚconnrÚrowZcolnamesrrÚts_infor r rÚ tileset_infos6 &ÿòr%c Cs–g}|D]D}| d¡d}| d¡}t|dƒ}t|dƒ}d}i} g} td|ƒD]} d||| } t|||| ƒ} | | 7} q*||| fg7}q|S)a; Generate tiles from this dataset. Parameters ---------- filepath: str The filename of the sqlite db file tile_ids: [str...] A list of tile ids of the form Returns ------- tiles: [(tile_id, tile_value),...] A list of values indexed by the tile position ú|rÚ.rr)rr ÚrangeÚ get_1D_tiles) ÚfilepathZtile_idsZ to_returnZtile_idZtile_no_optionsÚpartsÚzoomZxposZ extra_zoomÚnew_rowsÚjZ higher_xposZold_rowsr r rÚtiles+s    r/rc Csht|ƒ}|d}t |¡}| ¡}|dd|}||} | ||} d || | ¡} |dkr5d || | ¡} |dkr@d || | ¡} | | ¡ ¡} g} | D]b}z |d d ¡}Wn tyc|d}Ynw|d }|d }t |||ƒD]9}||}|d |}||kr¬||kr¬|d |d |d|d||d   d ¡dœ}|dkr§|d|d<| |g7} qsqK|  ¡| 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 rrrúê SELECT startPos, endPos, chrOffset, importance, fields, uid FROM intervals,position_index WHERE intervals.id=position_index.id AND zoomLevel <= {} AND rEndPos >= {} AND rStartPos <= {} á3 SELECT startPos, endPos, chrOffset, importance, fields, uid FROM intervals,position_index WHERE intervals.id=position_index.id AND rStartZoomLevel <= {} AND rEndZoomLevel >= 0 AND rEndPos >= {} AND rStartPos <= {} r á9 SELECT startPos, endPos, chrOffset, importance, fields, uid, name FROM intervals,position_index WHERE intervals.id=position_index.id AND rStartZoomLevel <= {} AND rEndZoomLevel >= 0 AND rEndPos >= {} AND rStartPos <= {} rúutf-8rrrr ©ZxStartZxEndZ chrOffsetZ importanceÚuidÚfieldsrÚname) r%rrrÚformatrÚfetchallÚdecodeÚAttributeErrorr(rr )r!r,Z tile_x_posZ num_tilesr$rr"ÚcZ tile_widthZtile_start_posZ tile_end_posÚqueryÚrowsr-Úrr5Zx_startZx_endÚiZ tile_x_startZ tile_x_endÚto_addr r rr)Vsh  ÿø  ÿ÷  ÿ÷  ÿ  ú  €ïr)c Cst|ƒ}|d}t |¡}| ¡}d}d |||¡} |dkr%d |||¡} |dkr0d |||¡} |dur;| d  |¡7} | | ¡ ¡} g} | D]>} z | d  d ¡} Wn ty^| d } Ynw| d | d | d| d| | d  d¡dœ}|dkr| d|d<| |g7} qF|  ¡| S)aP List the entries between start and end Parameters ---------- db_file: str The filename of the sqlite db file start_pos: int The start position from where to retrieve data end_pos: int The end position to get data max_entries: int The maximum number of results to return ri †r0rr1r r2Nz LIMIT {}rr3rrrr r4rr7) r%rrrr8rr9r:r;rr )r!ÚstartÚendZ max_entriesr$rr"r<r,r=r>r-r?r5rAr r rÚ list_itemsÅsX ÿø  ÿ÷  ÿ÷   ÿ ú  rD)r)N)rr%r/r)rDr r r rÚs ' +o