test/dbapi/UserManager/usertest1.c

   1 #include<CSql.h>
   2 int main()
   3 {
   4     Connection conn;
   5     DbRetVal rv = OK;
   6     //check whether connection open fails for non existing user
   7     rv = conn.open("user1", "passwd");
   8     if (rv == OK) return 1;
   9
  10     printf("connection open failed \n");
  11
  12     //open with dba to create new user
  13     rv = conn.open("root", "manager");
  14     if (rv != OK) return 2;
  15     UserManager *uMgr = conn.getUserManager();
  16     uMgr->createUser("user1", "passwd");
  17     rv = conn.close();
  18     if (rv != OK) return 3;
  19     printf("New user created \n");
  20     //check whether the newly created user name works
  21     rv = conn.open("user1", "passwd");
  22     if (rv != OK) return 4;
  23     rv = conn.close();
  24     if (rv != OK) return 5;
  25     printf("New user login worked \n");
  26
  27     //check whether the newly created user name fails if
  28     //wrong password is passed
  29     rv = conn.open("user1", "wrongpasswd");
  30     if (rv == OK) return 6;
  31
  32     //open with dba to delete the newly created user
  33     rv = conn.open("root", "manager");
  34     if (rv != OK) return 7;
  35     uMgr = conn.getUserManager();
  36     uMgr->deleteUser("user1");
  37     rv = conn.close();
  38     if (rv != OK) return 8;
  39     printf("New user deleted \n");
  40
  41     //check whether it is deleted by connecting with that user
  42     //name and password. It should fail
  43     rv = conn.open("user1", "passwd");
  44     if (rv == OK) return 9;
  45
  46     return 0;
  47 }