#ifndef BZS_DB_PROTOCOL_TDAP_CLIENT_SQLBUILDER_H
#define BZS_DB_PROTOCOL_TDAP_CLIENT_SQLBUILDER_H
/* =================================================================
 Copyright (C) 2012 2013 BizStation Corp All rights reserved.

 This program is free software; you can redistribute it and/or
 modify it under the terms of the GNU General Public License
 as published by the Free Software Foundation; either version 2
 of the License, or (at your option) any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with this program; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
 02111-1307, USA.
 ================================================================= */
#include <bzs/db/protocol/tdap/tdapSchema.h>
#include <string>
#include <vector>

namespace bzs
{
namespace db
{
namespace protocol
{
namespace tdap
{
namespace client
{

class sqlBuilder
{
    static std::string getFieldList(const tabledef* table, std::vector<std::string>& fdl, const clsrv_ver* ver);
    static void insertNisFields(const tabledef* td, std::vector<std::string>& fdl, std::string& s);
    static std::string& getKey(const tabledef* td, std::vector<std::string>& fdl, 
                                    int index, std::string& s, bool specifyKeyNum=false);  
    static std::string getKeyList(const tabledef* table, std::vector<std::string>& fdl);

public:
    /** create statement charset must be server default charset.
     *  server default charset writen in my.cnf.
     *
     *  @param charsetIndexServer server default charset
     */
    static std::string sqlCreateTable(const char* name, tabledef* table,
                               uchar_td charsetIndexServer, const clsrv_ver* ver);
    static std::string sqlCreateTable(const char* fileName, fileSpec* fs,
                               uchar_td charsetIndexServer, const clsrv_ver* ver);

    static std::string sqlCreateIndex(const tabledef* table, int keyNum,
                      bool specifyKeyNum, uchar_td charsetIndexServer, const clsrv_ver* ver);

    static std::string convertString(unsigned int toPage, unsigned int fromPage,
                          const char* p);
};

} // namespace client
} // namespace tdap
} // namespace protocol
} // namespace db
} // namespace bzs

#endif // BZS_DB_PROTOCOL_TDAP_CLIENT_SQLBUILDER_H