[ Previous ] [ Contents ] [ Index ] [ Next ]

Ns_PdDbTableList

Overview

Retrieve list of table names

Syntax

    void Ns_PdDbTableList(void *handle, char *includeSystem);

Description

This function should retrieve the list of table names from the database associated with the handle and send this data to the client. The includeSystem parameter indicates whether to include system tables with this list. The function should implement the following protocol:

Returning a successful status of DB_ROWS indicates that the SQL query was the type of query that returned rows (e.g., SELECT), rather than a manipulation statement that does not return rows. If the initial SQL query returns a successful status of DB_ROWS when generating the table names, then this function should:

Psuedo-code Example

    /* Things italicized would be your DBMS-specific structures and 
calls. */
    /* defined in nspd.h */ 
    typedef struct Ns_PdRowData {
    int elSize;
    char *elData;

} Ns_PdRowData; typedef struct Ns_PdRowInfo { int numColumns; Ns_PdRowData *rowData; }; void Ns_PdDbTableList(void *handle, char *tableName) { DBMSState *state = (DBMSState *) handle; Ns_PdRowInfo *getRowInfo, *bindRowInfo; int status = NS_ERROR; int getRowRet; /* Exec SQL and "select" data from a table */ Ns_PdLog(Trace, "gettableinfo(%s):", tableName); sprintf(state->sqlbuf, "select c.column_name, c.column_type, c.column_notnull" " from columns c, tables t" " where t.table_name = '%s'" " and c.column_member = t.table_type;", tableName); status = DBMDExec(state, state->sqlbuf); if (status == DB_ROWS) { if ((bindRowInfo = DBMSBindRow(state)) != NULL) { getRowInfo = Ns_PdNewRowInfo(Ns_PdGetRowInfoNumColumns(bindRowInfo)); if (getRowInfo != NULL) { status = NS_OK; Ns_PdSendString(OK_STATUS); Ns_PdSendRowInfo(bindRowInfo); /* sends list of column names */ while ((getRowRet = DBMSGetRow(handle, getRowInfo)) == NS_OK) { /* send row info */ Ns_PdSendRowInfo(getRowInfo); } Ns_PdSendData(END_DATA, strlen(END_DATA)); /* NULL row terminates rows */ if (getRowRet == DB_END_DATA) { status = NS_OK; } else { Ns_PdLog(Error, "GetTableInfo: incomplete data sent to client (table=%s)", tableName); } /* free the getRowInfo structure when done */ Ns_PdFreeRowInfo(getRowInfo, 0); } /* free the bindRowInfo data and structure when done */ Ns_PdFreeRowInfo(bindRowInfo, 1); } } if (status != NS_OK) { Ns_PdSendException(state->exceptionCode, state->exceptionMsg); } }

Top of Page

[ Previous ] [ Contents ] [ Index ] [ Next ]
Copyright © 1998-99 America Online, Inc.