oas_dev/util/var_overview_sql.py
def create_database_and_add_simulation_table(database):
    """
    Add a table to hold simulations
    :param database:
    :return:
    """
    conn =sqlite3.connect(database)
    sql_create_projects_table = """ CREATE TABLE IF NOT EXISTS Simulations (
                                        model_case text NOT NULL PRIMARY KEY,
                                        model_name text NOT NULL,
                                        case_name text NOT NULL,
                                        path_to_original_data text
                                    ); """#%(mod_tab_name)


        # create a database connection
    if conn is not None:
        # create projects table
        create_table(conn, sql_create_projects_table)
    else:
        print("Error! cannot create the database connection.")
    conn.close()
    return

    Add a table to hold simulations
    :param database:
    :return:
    
Add a table to hold simulations
Add a table to hold simulations
def create_database_and_add_simulation_table(database):
    conn =sqlite3.connect(database)
    sql_create_projects_table = """ CREATE TABLE IF NOT EXISTS Simulations (
                                        model_case text NOT NULL PRIMARY KEY,
                                        model_name text NOT NULL,
                                        case_name text NOT NULL,
                                        path_to_original_data text
                                    ); """
    if conn is not None:
        create_table(conn, sql_create_projects_table)
    else:
        print("Error! cannot create the database connection.")
    conn.close()
    return
def create_database_and_add_simulation_table ( database ) : conn = sqlite3 . connect ( database ) sql_create_projects_table = """ CREATE TABLE IF NOT EXISTS Simulations (
                                        model_case text NOT NULL PRIMARY KEY,
                                        model_name text NOT NULL,
                                        case_name text NOT NULL,
                                        path_to_original_data text
                                    ); """ if conn is not None : create_table ( conn , sql_create_projects_table ) else : print ( "Error! cannot create the database connection." ) conn . close ( ) return
Add a table to hold simulations
Add a table to hold simulations
"""
    Add a table to hold simulations
    :param database:
    :return:
    """ #%(mod_tab_name) # create a database connection # create projects table
None
database
None