aCadence.error_this = aCadence.error_this[0:trunc] survey = repr(trunc) points_per_curve = len(aCadence.error_this) curve_info = [ points_per_curve, source_class, 0, 0, 0, 0, None, survey, 0, period ] for i in range(50): tfe = ComputeTfe(aRRLyraeFund, aCadence) create_database.enter_record(curve_info, curve_info_names, tfe, cursor) ## extract features sql_cmd = """SELECT source_id FROM sources""" cursor.execute(sql_cmd) db_info = cursor.fetchall() source_ids = tolist(db_info) noise_dict = noisification.get_noisification_dict() derive_features.derive_features_par(source_ids, noise_dict, cursor, connection, number_processors=2, delete_existing=True) # take a look at the features sql_cmd = """SELECT * FROM features_short""" cursor.execute(sql_cmd) db_info = cursor.fetchall() for i in db_info: print i # output all sources to R file for analysis
sql_cmd = """UPDATE features SET n_points=(SELECT number_points FROM sources WHERE features.source_id = sources.source_id)""" cursor.execute(sql_cmd) connection.commit() ########## ########## DERIVE FEATURES FOR THE DATA ########## sql_cmd = """SELECT source_id FROM sources""" cursor.execute(sql_cmd) connection.commit() db_info = cursor.fetchall() source_ids = tolist(db_info) noise_dict = noisification.get_noisification_dict() derive_features.derive_features_par(source_ids,noise_dict,cursor,connection,number_processors=2,delete_existing=True) connection.commit() ########## ########## OUTPUT RESULTS ########## ## output all sources to R file for analysis sql_cmd = """SELECT source_id FROM sources""" cursor.execute(sql_cmd) db_info = cursor.fetchall() source_ids = tolist(db_info) db_output.outputRfile(source_ids,cursor,'../data_processed/job_talk.dat') ## output tfes