server

for instance in instances:

    instance_name=instance.name
    instance_id=instance.id
    instance_flavor_id=instance.flavor['id']
    instance_project_id=instance.tenant_id
    instance_status=instance.status
    instance_created=instance.created
    instance_updated=instance.updated
    flavors=nova.flavors.get(flavor=instance.flavor['id'])
    volumes= instance.to_dict()['os-extended-volumes:volumes_attached']
    qty=find_dbobject_by_id("server","id", instance_id)
    for volume in volumes:
        instance_volume_id=volume['id']
        if qty == 0 :
            sql= ("INSERT INTO server_volume (server_id,volume_id) VALUES (%s,%s)")
            cursor.execute(sql,(instance_id,instance_volume_id))
            connection.commit()
        elif qty ==1 :
            sql_2= "UPDATE server_volume set volume_id = %s where server_id = %s"
            cursor.execute(sql_2,(instance_volume_id,instance_id))
            connection.commit()


    ip=instance.addresses
    for k in ip.keys():
        apps=ip[k]
        floating_ip=[]
        for app in apps:
            if app['OS-EXT-IPS:type']== 'floating':
                instance_floating_ip= app['addr']
            elif app['OS-EXT-IPS:type']== 'fixed':
                print(f"Fixed IP: {app['addr']}")
                fixed_ip=app['addr']



    if qty == 0 :
        sql= ("INSERT INTO server (id,name,flavor_id,project_id,created,updated,status,floating_ip) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)")
        cursor.execute(sql,(instance_id,instance_name,instance_flavor_id,instance_project_id,instance_created,instance_updated,instance_status,instance_floating_ip))
        connection.commit()
    elif qty ==1 :
        sql_2= "UPDATE server set name = %s, flavor_id = %s, project_id = %s,created = %s, updated = %s, status= %s, floating_ip =%s where id = %s"
        cursor.execute(sql_2,(instance_name,instance_flavor_id,instance_project_id,instance_created,instance_updated,instance_status,instance_floating_ip, instance_id))
        connection.commit()