from Object_classes import Gen
from Object_classes import Eiwit
from Object_classes import RNA
from Object_classes import EC_nummer
from Object_classes import Pathway
from Object_classes import Cancer_pathway


def geninserts(i_conn, i_cursor, i_genobjects):
    print("ja")
    for object in i_genobjects:
        print("1")
        gen_id = object.Getgen_id()
        print("2")

        gen_naam = object.Getgen_naam()
        print(gen_naam)

        # gen_sequence = object.Getgen_sequence()
        print("4")

        gen_splicing_count_begin = object.Getgen_splicing_count()[0]
        gen_splicing_count_end = object.Getgen_splicing_count()[1]

        # print(gen_splicing_count)
        data=[gen_id, gen_naam, gen_splicing_count_begin, gen_splicing_count_end]
        sql = """
           INSERT INTO gen_A6 (gen_id, gen_naam, gen_splicing_count_begin, gen_splicing_count_end) VALUES(%s, %s, %s);"""
        try:
            i_cursor.execute(sql, data)
            i_conn.commit()
        except IndexError:
            pass
        print("Done! Onto the next one!")
    print("Added Data to the gen_A6 table!")


def eiwitinserts(i_conn, i_cursor, i_eiwitobjects):
    for object in i_eiwitobjects:
        acc_code = object.Getacc_code()
        eiwit_naam = object.Geteiwit_naam()
        acc_sequence = object.Getacc_sequence()
        EC_nummer = object.GetEC_nummer()
        sql = """
           INSERT INTO eiwit_A6 (eiwit_naam, acc_code, EC_nummer, acc_sequence) VALUES (%s, %s, %s, %s);"""
        i_cursor.execute(sql, [eiwit_naam, acc_code, EC_nummer, acc_sequence])
        i_conn.commit()
    print("Added Data to the Eiwit_A6 table!")


def rnainserts(r_conn, r_cursor, r_eiwitobjects, r_genobjects):
    counter = -1
    for object in r_eiwitobjects:
        counter+=1
        gen_id = r_genobjects[counter].Getgen_id()
        gen_splicing_count = r_genobjects[counter].Getgen_splicing_count()
        acc_code = object.Getacc_code()
        # print(gen_id)
        # print(gen_splicing_count)
        # print(acc_code)
        foreign_sql = """
                INSERT INTO RNA_A6 (gen_id, acc_code, gen_splicing_variation) VALUES(%s, %s, %s);"""
        r_cursor.execute(foreign_sql, [gen_id, acc_code, gen_splicing_count])
        r_conn.commit()
    print("Added Data to the RNA_A6 table!")

if __name__ == "__main__":
        pass