release/src/router/mysql/tests/insert_test.c

   1 /* Copyright (c) 2000-2004 MySQL AB
   2
   3    This program is free software; you can redistribute it and/or modify
   4    it under the terms of the GNU General Public License as published by
   5    the Free Software Foundation; version 2 of the License.
   6
   7    This program is distributed in the hope that it will be useful,
   8    but WITHOUT ANY WARRANTY; without even the implied warranty of
   9    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  10    GNU General Public License for more details.
  11
  12    You should have received a copy of the GNU General Public License
  13    along with this program; if not, write to the Free Software
  14    Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA */
  15
  16 #include <stdio.h>
  17 #include <stdlib.h>
  18 #include "mysql.h"
  19
  20 #define INSERT_QUERY "insert into test (name,num) values ('item %d', %d)"
  21
  22
  23 int main(int argc, char **argv)
  24 {
  25   int   count,num;
  26   MYSQL *sock,mysql;
  27   char  qbuf[160];
  28
  29   if (argc != 3)
  30   {
  31     fprintf(stderr,"usage : insert_test <dbname> <Num>\n\n");
  32     exit(1);
  33   }
  34
  35   mysql_init(&mysql);
  36   if (!(sock = mysql_real_connect(&mysql,NULL,NULL,NULL,argv[1],0,NULL,0)))
  37   {
  38     fprintf(stderr,"Couldn't connect to engine!\n%s\n",mysql_error(&mysql));
  39     perror("");
  40     exit(1);
  41   }
  42   mysql.reconnect= 1;
  43
  44   num = atoi(argv[2]);
  45   count = 0;
  46   while (count < num)
  47   {
  48     sprintf(qbuf,INSERT_QUERY,count,count);
  49     if(mysql_query(sock,qbuf))
  50     {
  51       fprintf(stderr,"Query failed (%s)\n",mysql_error(sock));
  52       exit(1);
  53     }
  54     count++;
  55   }
  56   mysql_close(sock);
  57   exit(0);
  58   return 0;
  59 }