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

namespace Tango.Synchronization.Local
{
    /// <summary>
    /// Represents an SQL data base adapter used by <see cref="LocalDBComparer"/>.
    /// </summary>
    /// <seealso cref="System.IDisposable" />
    public interface ILocalDataBase : IDisposable
    {
        /// <summary>
        /// Gets the database source URL/File.
        /// </summary>
        String Source { get; }

        /// <summary>
        /// Gets the database tables collection.
        /// </summary>
        List<DataTable> Tables { get; }

        /// <summary>
        /// Loads the tables (Must be done before any synchronization).
        /// </summary>
        void LoadTables();

        /// <summary>
        /// Clones a table from another database into this database.
        /// </summary>
        /// <param name="otherDB">The other database.</param>
        /// <param name="otherTable">The other table.</param>
        /// <returns></returns>
        DataTable CloneTableFrom(ILocalDataBase otherDB, DataTable otherTable);

        /// <summary>
        /// Replaces the table data with the data from another table.
        /// </summary>
        /// <param name="otherTable">The other table.</param>
        void ReplaceTableData(ILocalDataBase otherDB, DataTable otherTable);

        /// <summary>
        /// Replaces the table data with the data from another table.
        /// </summary>
        /// <param name="otherTable">The other table.</param>
        String GetReplaceTableDataCommand(ILocalDataBase otherDB, DataTable otherTable);

        /// <summary>
        /// Gets the SQL command for <see cref="CloneTableFrom(ILocalDataBase, DataTable)"/>.
        /// </summary>
        /// <param name="otherDB">The other database.</param>
        /// <param name="otherTable">The other table.</param>
        /// <returns></returns>
        String GetCloneTableFromCommand(ILocalDataBase otherDB, DataTable otherTable);

        /// <summary>
        /// Adds the specified column to the specified table.
        /// </summary>
        /// <param name="table">The table.</param>
        /// <param name="column">The column.</param>
        /// <returns></returns>
        DataColumn AddColumn(DataTable table, DataColumn column);

        /// <summary>
        /// Gets the SQL command for <see cref="AddColumn(DataTable, DataColumn)"/>.
        /// </summary>
        /// <param name="table">The table.</param>
        /// <param name="column">The column.</param>
        /// <returns></returns>
        String GetAddColumnCommand(DataTable table, DataColumn column);

        /// <summary>
        /// Adds the specified row to the specified table.
        /// </summary>
        /// <param name="table">The table.</param>
        /// <param name="row">The row.</param>
        void AddRow(DataTable table, DataRow row);

        /// <summary>
        /// Gets the SQL command for <see cref="AddRow(DataTable, DataRow)"/>.
        /// </summary>
        /// <param name="table">The table.</param>
        /// <param name="row">The row.</param>
        /// <returns></returns>
        String GetAddRowCommand(DataTable table, DataRow row);

        /// <summary>
        /// Updates the matching row by the row GUID.
        /// </summary>
        /// <param name="table">The table.</param>
        /// <param name="row">The row.</param>
        void UpdateRow(DataTable table, DataRow row);

        /// <summary>
        /// Gets the SQL command for <see cref="UpdateRow(DataTable, DataRow)"/>.
        /// </summary>
        /// <param name="table">The table.</param>
        /// <param name="row">The row.</param>
        /// <returns></returns>
        String GetUpdateRowCommand(DataTable table, DataRow row);

        /// <summary>
        /// Clears the data base.
        /// </summary>
        void ClearDataBase();
    }
}