using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace OTSModelSharp.DTLBase
{
    public interface IDBTableBase
    {

        void AddColumn(ColumnDefine col);
		 int GetColumnCount();

		 string GetTableName();
		 void SetTableName(string a_sTableName);
        //void AddColumn(string v, object sTRING);
        string GetColumnName(int a_nColId);
         string GetColumnFullName(int a_nColId);
         string GetColumnNames(bool a_bWithPrimary = true);
         string GetColumnFullNames(bool a_bWithPrimary = true);

         ColumnType GetColumnType(int a_nColId);

         string GetCreateTableCommandString();
		 string GetDeleteTableCommandString();
		 string GetRemoveAllRowsCommandString();

		 string GetInsertCommandFormatString(bool a_bWithPrimary = false);
        KeyValuePair<string, SQLiteParameter[]> GetInsertCommand(bool a_bWithPrimary = false);
         string GetInsertCommandFormatString(List<int> a_colIndexes);
		 string GetUpdateCommandFormatString(List<int> a_updateColIndexes, int a_nConditionColIndex);

        KeyValuePair<string, SQLiteParameter[]> GetUpdateCommand(List<int> a_updateColIndexes, int a_nConditionColIndex);

    }
}