user_log_partition.c

一本介绍oracle的书籍

#include <stdio.h>
#include <stdlib.h>
#include <time.h>

#include "const.h"

int Process(char *user);
int CmRandom(int min_val, int max_val);


int main(int argc, char *argv[])
{
    int times, count;
    char user[10];
    time_t start, end, user_start, user_end;

    if(argc!=2)  times=100;
    else  times=atoi(argv[1]);
    if(times==0)  times=100;

    if(DbsConnect())  exit(1);

    time(&start); 
    for(count=0; count<times; count++)
    {
/*
        time(&user_start); 
*/
        sprintf(user, "test%04d", CmRandom(0,9999));
        if(Process(user))
        {
            printf("user_log_partition query %d times fail\n", times);
            exit(1);
        }
        printf("user no.%04d %s finished\n", count+1, user);
/*
        time(&user_end); 
        printf("user %s time cost:%d seconds\n",
            user, user_end-user_start);
*/
    }
    time(&end); 
    printf("time cost total:%d seconds\n", end-start);

    exit(0);
}


int Process(char *user)
{
    char content[500];
    int result, count=0;

    if(DbsUSER_LOG_PARTITION_CUR_Part(DBS_OPEN, user, content)!=DB_OK)
    {
        printf("open cursor fail\n");
        return -1;
    }
    while(1)
    {
        result=DbsUSER_LOG_PARTITION_CUR_Part(DBS_FETCH, user, content);
        if(result!=DB_OK && result!=DB_NOTFOUND)
        {
            printf("fetch cursor fail\n");
            return -1;
        }
        if(result==DB_NOTFOUND)  break;
/*
        count++;
        if(count>=100)  break;
*/
    }
    if(DbsUSER_LOG_PARTITION_CUR_Part(DBS_CLOSE, user, content)!=DB_OK)
    {
        printf("close cursor fail\n");
        return -1;
    }

    return 0;
}


int CmRandom(int min_val, int max_val)
{
    struct timeval uTime;
    int  delta_val;
    int  ret_val;

    gettimeofday(&uTime, NULL);
    srand(uTime.tv_usec);
    delta_val=max_val-min_val+1;
    ret_val=(rand())%delta_val+min_val;

    return ret_val;
}