usertest1.c

unix_LINUX下的简单数据库实现

#include<CSql.h>
int main()
{
    Connection conn;
    DbRetVal rv = OK;
    //check whether connection open fails for non existing user
    rv = conn.open("user1", "passwd");
    if (rv == OK) return 1;

    //open with dba to create new user
    rv = conn.open("praba", "manager");
    if (rv != OK) return 2;
    UserManager *uMgr = conn.getUserManager();
    uMgr->createUser("user1", "passwd");
    rv = conn.close();
    if (rv != OK) return 3;

    //check whether the newly created user name works
    rv = conn.open("user1", "passwd");
    if (rv != OK) return 4;
    rv = conn.close();
    if (rv != OK) return 5;

    //check whether the newly created user name fails if 
    //wrong password is passed
    rv = conn.open("user1", "wrongpasswd");
    if (rv == OK) return 6;

    //open with dba to delete the newly created user
    rv = conn.open("praba", "manager");
    if (rv != OK) return 7;
    uMgr = conn.getUserManager();
    uMgr->deleteUser("user1");
    rv = conn.close();
    if (rv != OK) return 8;

    //check whether it is deleted by connecting with that user
    //name and password. It should fail
    rv = conn.open("user1", "passwd");
    if (rv == OK) return 9;

    return 0;
}