add_htm_ids_to_mysql_database_table (function) ∞
-
add_htm_ids_to_mysql_database_table
(raColName, declColName, tableName, dbConn, log, primaryIdColumnName='primaryId', cartesian=False, batchSize=50000, reindex=False, dbSettings=False)[source] ∞ Given a database connection, a name of a table and the column names for RA and DEC, generates ID for one or more HTM level in the table
Key Arguments
raColName
– ra in sexegesimaldeclColName
– dec in sexegesimaltableName
– name of table to add htmid info todbConn
– database hosting the above tablelog
– loggerprimaryIdColumnName
– the primary id for the tablecartesian
– add cartesian columns. Default FalsebatchSize
– the size of the batches of rows to add HTMIds to concurrently. Default 2500reindex
– reindex the entire tabledbSettings
– yaml settings for database
Return
None
Usage
from HMpTy.mysql import add_htm_ids_to_mysql_database_table add_htm_ids_to_mysql_database_table( raColName="raDeg", declColName="decDeg", tableName="my_big_star_table", dbConn=dbConn, log=log, primaryIdColumnName="primaryId", reindex=False )