code to generate sql files

//FIRST ONE
#include <stdio.h>
#include <stdlib.h>
#include <math.h>

int main()
{
    FILE* fptr;
    fptr = fopen("array.sql", "w");
    if(fptr == NULL)
    {
        printf("Couldn't create file.");
        exit(0);
    }

    fprintf(fptr, "INSERT INTO test_array (vertex_id, labels_id)\nVALUES\n");

    for(int i=1; i<=1000000; i++)
    {
        fprintf(fptr, "\t(%d, ARRAY[", i);
        int len = rand()%10+1;
        int prev = 0;

        for(int j=0; j<len; j++)
        {
            if(prev == 10)
            break;

            int insert = prev+(1+(rand()%(10-prev)));

            fprintf(fptr, "%d, ", insert);
        }
        fprintf(fptr, "0]),\n");
    }
    fprintf(fptr, "(1000001, ARRAY[0])");
    fprintf(fptr, ";");
    fclose(fptr);

    return 0;
}


//SECOND ONE
#include <stdio.h>
#include <stdlib.h>
#include <math.h>

int main()
{
    FILE* fptr;
    fptr = fopen("int.sql", "w");
    if(fptr == NULL)
    {
        printf("Couldn't create file.");
        exit(0);
    }

    fprintf(fptr, "INSERT INTO test_int (vertex_id, label_id)\nVALUES\n");

    for(int i=1; i<=1000000; i++)
    {
        fprintf(fptr, "\t(%d, %d),\n", i, rand()%10);
    }
    fprintf(fptr, "(1000001, 0);");
    fclose(fptr);
    return 0;
}