Sample populating DB algorithm

 nam1=['Yashoda','Dhruv','Abhay']

 midnm=['nandan','vishnu','Aditya']

 las=['dasa','Roshan','kishor']

 i=0 

gen=['M','F']

desgn=['Team coordinator','CEO','Product supervisor','Programmer','Trainer','script writer','Reporter','support','legal advisor','travel agent']

while i<300:

        age=random.randint(18,35) 

        sal=int(random.random()*10000)+2356

        rndf=random.choice(nam1)

        rndm=random.choice(midnm)

        rndl=random.choice(las)

        nam=rndf+' '+rndm+' '+rndl

        gen2=random.choice(gen)

        desegn2=random.choice(desgn)

        desegn2=desegn2.upper()

        sql3=f"insert into employee values({i+1},'{nam}',{age},'{gen2}','{desegn2}',{sal});"

        curso.execute(sql3)

        i+=1

        if i<100:

            print(f'loading {i//3}%',end='\r')

        elif i>100:

            print(f'loading {i//3}%',end='\r ')

else:

    edm()

Comments