HYTOS

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.Common;

using System.Data.SQLite;

using System.Globalization;

using System.Data.SqlClient;

namespace ID2PSN

{

	class AppSQLiteDatabase : AbstractDatabase<SQLiteConnection , SQLiteCommand , SQLiteDataAdapter>

	{

		public string FilePath{get;set;}

        /// <summary>

        /// sqlite connection string

        /// </summary>

        /// <author>humkyung</author>

        /// <date>2019.02.10</date>

        /// <returns></returns>

        protected override string  GetConnectionString()

		{

            return string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", this.FilePath);

		}

        /// <summary>

        /// get table name list

        /// </summary>

        /// <author>humkyung</author>

        /// <date>2021.11.04</date>

        /// <param name="sTableName"></param>

        /// <returns></returns>

        public override List<string> GetTableNames()

        {

            List<string> res = new List<string> { };

            {

                var query = "SELECT NAME FROM sqlite_master WHERE type='table'";

                using (var ds = ExecuteDataSet(GetSqlStringCommand(query)))

                {

                    foreach (DataRow dr in ds.Tables[0].Rows)

                    {

                        res.Add(dr["NAME"].ToString());

                    }

                }

            }

            return res;

        }

        public override List<string> GetCommonTableNames()

        {

            List<string> res = new List<string> { };

            {

                string query = "SELECT T.name AS table_name, C.name AS column_name" +

                    "FROM ARS_COMMON.sys.tables AS T INNER JOIN ARS_COMMON.sys.columns AS C ON T.object_id = C.object_id WHERE T.name = 'PSN_REVISION'";

                using (var ds = ExecuteDataSet(GetSqlStringCommand(query)))

                {

                    foreach (DataRow dr in ds.Tables[0].Rows)

                    {

                        res.Add(dr["column_name"].ToString());

                    }

                }

            }

            return res;

        }

        public override List<string> GetColumnNames(string TableName)

        {

            List<string> res = new List<string> { };

            {

                var query = "PRAGMA table_info('" + TableName + "')";

                using (var ds = ExecuteDataSet(GetSqlStringCommand(query)))

                {

                    foreach (DataRow dr in ds.Tables[0].Rows)

                    {

                        res.Add(dr["NAME"].ToString());

                    }

                }

            }

            return res;

        }

    }

}