xoonips/AL/criteria.cc

/*
 * SQL絎?茵?腟???????我??絎?鐚?筝??号?帥???＞散??膊∞??????criteria?????鴻???臂?/span>
 * 
 * $Revision: 1.2 $
 * $Log: criteria.cc,v $
 * Revision 1.2  2004/11/27 00:39:57  youi
 * orderby???潟?潟?鴻???????水????olumn?＜?潟??紊??違??????????????菴遵??.
 *
 * Revision 1.1  2004/11/24 06:54:31  youi
 * initial version
 *
 * 
 */
#include <stdlib.h>
#include <string.h>

#include "common.h"
#include "criteria.h"

/**
 * SQL??RDERBY??┃絎???荐??吟??????????/span>
 * 
 * @param column ????????
 * @param order ????鐚?????????絎?(????絎??? orderby::ASC)
 * @ref orderby::ASC
 * @ref orderby::DESC
 * 
 */
orderby::orderby( const char* column = "", int order = orderby::ASC ){
    this -> column = 0;
    setValue( &this -> column, column );
    this -> order = order;
    this -> next = 0;
}

/**
 * 
 * ???鴻????????/span>
 * 
 * ???????????＜?≪???????????障????
 * 
 */
orderby::~orderby( ){
    delete this -> column;
}
    
/**
 * 
 * ??????????菴???
 * @return ????????
 * 
 */
const char* orderby::getColumn( ) const { return column; }

/**
 * 
 * ????鐚??障??????????菴???
 * @return ????鐚??障????????
 * @ref orderby::ASC
 * @ref orderby::DESC
 * 
 */
order_t orderby::getOrder( ) const{ return order; }

/**
 * 
 * SQL????我??絎?(LIMIT)??鐚??純?若????(??????????????????)??膊∞??????????/span>
 * ??
 * 
 */
criteria::criteria( )
{
    start = 0;
    rows = 0;
    indexOfOrders = 0;
    ordersLen = 0;
    ordersMax = 16;
    orders = new orderby*[ ordersMax ];
    memset( orders, 0, sizeof( orderby* ) * ordersMax );
}

/**
 * 
 * ???鴻????????/span>
 * 
 * addOrderBy?ц申??????orderby?ゃ?潟?鴻?帥?潟?鴻??В?障??茵?????
 *
 * @ref addOrderBy
 * 
 */
criteria::~criteria( )
{
    if( orders != 0 ){
        for( int i = 0; i < ordersLen; i++ ) delete orders[ i ];
        delete[] orders;
    }
}

/**
 * 
 * SQL絎?茵?腟??????????阪??????膀??蚊??鐚???紮?茵?????違?ф??絎?????. 
 * 
 * @param start ??紮?茵?
 * @param rows 茵???/span>
 * 
 */
void criteria::setLimit( int start , int rows )
{
    this -> start = start;
    this -> rows = rows;
}

/**
 * 
 * ???????????＞散??菴遵??????鐚?QL絎?茵???????????申???????????????????純??/span>
 * ???＞散??????鐚?/span>
 * 
 * @param order orderby???≪??????/span>
 *
 */
void criteria::addOrderBy( orderby *order )
{
    if( ordersMax == ordersLen ){
        //orders?????ｃ?宴???障?с???若?帥?????????э??≦宍????
        orderby** ptr = new orderby*[ ordersMax * 2 ];
        memset( ptr, 0, sizeof( orderby* ) * ordersMax * 2 );
        memcpy( ptr, orders, sizeof( orderby* ) * ordersMax );
        delete[] orders;
        ordersMax *= 2;
        orders = ptr;
    }
    orders[ ordersLen ] = order;
    ordersLen++;
}

/**
 * 
 * ??????rderby???????冴??. 2????札????rderby??extOrderBy?у????冴??.<br>
 * ?祉?????∽?違???鴻???????????????絎???unsafe)?с??
 * 
 * @return ??????rderby
 * @return 0 ????篁ヤ???rderby??????
 * @ref nextOrderBy
 * 
 */
const orderby* criteria::headOrderBy( )
{
    indexOfOrders = 0;
    if( indexOfOrders >= ordersLen ) return 0;
    return orders[ indexOfOrders++ ];
}

/**
 * 
 * orderby???????冴??.<br>
 * ?祉?????∽?違???鴻???????????????絎???unsafe)?с??
 * 
 * @return orderby???ゃ?潟?鴻?帥?潟??/span>
 * @return 0 ????篁ヤ???rderby??????
 * @ref headNextOrderBy
 * 
 */
const orderby* criteria::nextOrderBy( )
{
    if( indexOfOrders >= ordersLen ) return 0;
    return orders[ indexOfOrders++ ];
}

/**
 * 
 * LIMIT荐??鐚???????RDERBY荐???????ゃ???障??.
 * 
 */
void criteria::clearAll( )
{
    for( int i = 0; i < ordersLen; i++ ) delete orders[ i ];
    memset( orders, 0, sizeof( orderby* ) * ordersMax );
    ordersLen = 0;
    start = rows = 0;
}

/**
 * 
 * LIMIT????紮?茵?
 * 
 * @return 
 * 
 */
int criteria::getLimitStart( ) const { return start; }

/**
 * 
 * LIMIT?????/span>
 * 
 * @return 
 * 
 */
int criteria::getLimitRows( ) const{ return rows; }