//////////////////////////////////////////////////////////////////////////
//                    _   _   ____   ____                    
//   Project         | | | | / ___) / ___)                   
//                   | | | || | __ | |                       
//                   | |_| || |_\ || \___                    
//                    \____/ \____| \ ___)     6.0           
//                                                           
//!  \file UGHelperMySQL.h
//!  \brief Class 的接口定义。
//!  \details 文件详细信息。
//!  \author cuiwenzhu
//!  \attention 
//!   Copyright (c) 1996-2008 SuperMap Software Limited Company.  <br> 
//!   All Rights Reserved.
//!  \version 6.0
//////////////////////////////////////////////////////////////////////////


#if !defined(UGHelperMySQL_H)
#define UGHelperMySQL_H

#include "Engine/UGDataset.h"
#include "Engine/UGDatasetRasterInfo.h"
namespace UGC{

class ENGINEMYSQL_API UGHelperMySQL  
{
public:
	//! \brief 默认构造函数
	UGHelperMySQL();
	//! \brief 默认析构函数
	virtual ~UGHelperMySQL();

	//! \brief 获取创建dataset表的sql语句
	static UGString GetCreateDatasetSql(const UGString& strSchema,const UGString& strTableName,
		UGDataset::DatasetType nType,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmTopoRule表的sql语句
	static UGString GetCreateSmTopoRuleSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmTopoRelation表的sql语句
	static UGString GetCreateSmTopoRelationSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmRegister表的sql语句
	static UGString GetCreateSmRegisterSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmImgRegister表的sql语句
	static UGString GetCreateSmImgRegisterSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建序列管理表的sql语句
	static UGString GetCreateSmSequenceManageTableSql(const UGString& strSchema,const UGString& strEngine=_U("InnoDB"));
	static UGString GetSequenceManageProcedureSql(const UGString& strSchema);
	//! \brief 获取创建额外用户信息表的sql语句
	static UGString GetCreateSmUserInfoSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmDataSourceInfo表的sql语句
	static UGString GetCreateSmDataSourceInfoSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmFieldInfo表的sql语句
	static UGString GetCreateSmFieldInfoSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmBandRegister的sql语句
	static UGString GetCreateSmBandRegisterSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));

	//! \brief 获取创建SmEventProperty表的sql语句
	static UGString GetCreateSmEventProperty(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmAuthent表的sql语句
	static UGString GetCreateSmAuthent(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmAction表的sql语句
	static UGString GetCreateSmAction(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmTag表的sql语句
	static UGString GetCreateSmTag(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmSequence表的sql语句
	static UGString GetCreateSmSequence(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmDatasetLocked表的sql语句
	static UGString GetCreateSmDatasetLocked(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmVersion表的sql语句
	static UGString GetCreateSmVersion(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmLog表的sql语句
	static UGString GetCreateSmLog(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmLTUsers表的sql语句
	static UGString GetCreateSmLTUsers(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));

	//metadata
	///! \brief 获取创建元数据表
	static UGString GetCreateSmMetadata(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmVectorMetaTable(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmRasterMetaTable(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
   //! \brief 获取创建元数据表
	static UGString GetCreateSmMetaElementTable(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmMetaTable(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmMaping(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmMetaDSRegister(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmMetaTemplate(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
    

	//! \brief 获取创建元数据表
	static UGString GetCreateSmMetaMapping(const UGString& strSchema,UGint nID,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmMetaVector(const UGString& strSchema,UGint nID,const UGString& strEngine=_U("MyISAM"));
    //! \brief 获取创建元数据表
	static UGString GetCreateSmMetaRaster(const UGString& strSchema,UGint nID,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建元数据表
	static UGString GetCreateSmMetaVectorRegister(const UGString& strSchema,UGint nID,const UGString& strEngine=_U("MyISAM"));	
	//! \brief 获取创建元数据表
	static UGString GetCreateSmMetaRasterRegister(const UGString& strSchema,UGint nID,const UGString& strEngine=_U("MyISAM"));

	//索引
	static UGString GetCreateSmDynamicIndexSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建DynamicIndex表的sql语句
	static UGString GetCreateSmDynamicIndexTableSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	
	//! \brief 获取创建SmTabular表的sql语句
	static UGString GetCreateSmTabularSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM")); 
    //! \brief 获取创建SmPoint表的sql语句
	static UGString GetCreateSmPointSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmLine表的sql语句
	static UGString GetCreateSmLineSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM")); 
    //! \brief 获取创建SmNetwork表的sql语句
	static UGString GetCreateSmNetworkSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM")); 
	//! \brief 获取创建SmRegion表的sql语句
	static UGString GetCreateSmRegionSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM")); 
    //! \brief 获取创建SmText表的sql语句
	static UGString GetCreateSmTextSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmPointGL表的sql语句
	static UGString GetCreateSmPointGLSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM")); 
   //! \brief 获取创建SmPoint的sql语句
	static UGString GetCreateSmPointZSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmCAD表的sql语句
	static UGString GetCreateSmCADSql(const UGString& strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM")); 
	//! \brief 创建Tin数据集
	static UGString GetCreateTinSql(const UGString &strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	//! \brief 创建索引表
	static UGString GetCreateIndexSql(const UGString &strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
	// \brief 判断名字是否过长
	static UGbool IsLongName(const UGString& strName, UGbool bIsNetWorkDT,const UGString& strEngine=_U("MyISAM"));
   //! \brief Raster数据表
	static UGString GetCreateRasterData(const UGDatasetRasterInfo& m_RasterInfo,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));

	//! \brief 创建索引表
	static UGString GetCreateIndex(const UGString& strName,const UGString& strTableName,const UGString& strEngine=_U("MyISAM"));
	//! \brief 获取创建SmRasterAttr表的sql语句
	static UGString GetCreateSmRasterAttrSql(const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));	

	//! \brief 创建模型数据集表
	static UGString GetCreateModelSql(const UGString &strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));

	//! \brief 创建纹理数据集表
	static UGString GetCreateTextureSql(const UGString &strTable,const UGString& strSchema,const UGString& strEngine=_U("MyISAM"));
};
}
#endif // !defined(UGHelperMySQL_H)