Menü

SQLGenerator v0.2

SQLGenerator v 0.2

Türkçe/İngilizce – Lisanssız
Link : http://www.asestasarim.com/projeler/SQLGeneratorv.02.rar (7,89KB)

Kaynak kodu :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80

#include
#include
#include 
 
int main()
{
    char tabloAdi[20],alfabe[26] = {'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','r','s','t','u','v','y','z','x','w','q'};
    int sutunSayisi,girdiSayisi;
    char SQLQuery[500];
    int i,j,k,dilSecimi;
 
    do{
        printf("Dil seciniz. / Select language : \n 1. Turkce \n 2. English");
        scanf("%d",&dilSecimi);
    } while(dilSecimi != 1 && dilSecimi != 2);
 
    if(dilSecimi == 1){
        printf("Veri girmek istediginiz tablonun adini girin: ");
        scanf("%s",&tabloAdi);
        printf("%s tablosuna kac adet girdi eklemek istediginizi girin: ", tabloAdi);
        scanf("%d",&girdiSayisi);
        printf("%s tablosunda kac adet sutun oldugunu girin: ",tabloAdi);
        scanf("%d",&sutunSayisi);
    } else {
        printf("Insert table name : ");
        scanf("%s",&tabloAdi);
        printf("How many entries do you want to insert table %s : ", tabloAdi);
        scanf("%d",&girdiSayisi);
        printf("How many columns do table %s have : ",tabloAdi);
        scanf("%d",&sutunSayisi);
    }
 
    int sutunlar[sutunSayisi];
 
    for(i = 0 ; i < sutunSayisi ; i++){
        int secim;
        do{
            if(dilSecimi == 1){
                printf("%d. sutun icin veri tipi secin. \n 1. Integer \n 2. String\n>> ", i+1);
            }else{
                printf("Please choose data type of %d. column. \n 1. Integer \n 2. String\n>> ", i+1);
            }
            scanf("%d",&secim);
        } while(secim != 1 && secim != 2);
        sutunlar[i] = secim;
    }
 
    for(j = 0 ; j < girdiSayisi ; j++){
        for(k = 0 ; k < strlen(SQLQuery) ; k++){
            SQLQuery[k] = NULL;
        }
        strcat(SQLQuery, "INSERT INTO ");
        strcat(SQLQuery, tabloAdi);
        strcat(SQLQuery, " VALUES(");
        for(i = 0; i < sutunSayisi ; i++){
            if(sutunlar[i] == 1){
                char gecici[5];
                int sayi = rand();
                strcat(SQLQuery, itoa(sayi,gecici,10));
            } else {
                char isim[13];
                isim[0] = '\'';
                isim[11] = '\'';
                isim[12] = NULL;
                for(k = 1 ; k < 11 ; k++){
                    isim[k] = alfabe[rand()%26];
                }
                strcat(SQLQuery, isim);
            }
            if(i != sutunSayisi -1){
                strcat(SQLQuery, ",");
            }
        }
        strcat(SQLQuery, ");");
        printf("%s\n",SQLQuery);
    }
 
    getch();
    return 0;
}

Yorum yazın: