Example #1
0
        private void LoadBase()
        {
            SQLHandler sqlHand = new SQLHandler(_dbFolderPath);

            var tableList = sqlHand.GetTables();

            foreach (var tableName in tableList)
            {
                if (tableName.Contains("TEXT"))
                {
                    var textList = sqlHand.GetList(
                        tableName: tableName,
                        returnField: "TEXT");

                    _textList.Add(tableName.Replace("TEXT_", string.Empty), textList);
                }

                if (tableName.Contains("URL"))
                {
                    var urlList = sqlHand.GetList(
                        tableName: tableName,
                        returnField: "URL");

                    _urlList.Add(tableName.Replace("URL_", string.Empty), urlList);
                }
            }
        }
Example #2
0
        private void LoadBase(object chatId)
        {
            SQLHandler sqlHand = new SQLHandler(_dbFolderPath);

            _tDataList = sqlHand.GetList <TData>(
                tableName: chatId.ToString());

            foreach (var tData in _tDataList)
            {
                tData.DataID = tData.UserID.Length * tData.Words.Length;
            }
        }
Example #3
0
        private void LoadBase()
        {
            SQLHandler sqlHand = new SQLHandler(_dbFolderPath);

            var tableList = sqlHand.GetTables();

            foreach (var tableName in tableList)
            {
                var textList = sqlHand.GetList(
                    tableName: tableName,
                    returnField: "TEXT");

                _textList.Add(tableName, textList);
            }
        }