Python create_sql_builder Examples

Example #1

File: load.py Project: Duke-GCB/TF-DNA-PredictionsDB

def run_sql_predictions(config):
    """
    Load just predictions into the databse based on config.
    :param config: pred.Config: global configuration containing what data to download/convert/load.
    """
    update_progress("STAGE: Creating predictions SQL files.")
    sql_builder = create_sql_builder()
    create_sql_for_predictions(config, sql_builder, DataType.PREDICTION, update_progress)
    update_progress("STAGE: Executing predictions SQL files.")
    run_sql_pipeline(config, sql_builder.sql_pipeline)

Example #2

File: load.py Project: Duke-GCB/iMADS

def run_sql_predictions(config):
    """
    Load just predictions into the databse based on config.
    :param config: pred.Config: global configuration containing what data to download/convert/load.
    """
    update_progress("STAGE: Creating predictions SQL files.")
    sql_builder = create_sql_builder()
    create_sql_for_predictions(config, sql_builder, DataType.PREDICTION,
                               update_progress)
    update_progress("STAGE: Executing predictions SQL files.")
    run_sql_pipeline(config, sql_builder.sql_pipeline)

Example #3

File: load.py Project: Duke-GCB/TF-DNA-PredictionsDB

def run_sql_models_command(config):
    """
    Load just models into the database based on config.
    This is a subset of run_sql_command.
    :param config: pred.Config: global configuration containing what data to download/convert/load.
    """
    update_progress("STAGE: Creating model SQL files.")
    sql_builder = create_sql_builder()
    create_sql_for_model_files(config, sql_builder)
    update_progress("STAGE: Executing model SQL files.")
    run_sql_pipeline(config, sql_builder.sql_pipeline)

Example #4

File: load.py Project: Duke-GCB/iMADS

def run_sql_models_command(config):
    """
    Load just models into the database based on config.
    This is a subset of run_sql_command.
    :param config: pred.Config: global configuration containing what data to download/convert/load.
    """
    update_progress("STAGE: Creating model SQL files.")
    sql_builder = create_sql_builder()
    create_sql_for_model_files(config, sql_builder)
    update_progress("STAGE: Executing model SQL files.")
    run_sql_pipeline(config, sql_builder.sql_pipeline)