Exemple #1
0
        /// <summary>
        /// Provides the list of unknown words and quantities for given
        /// project.
        /// </summary>
        /// <param name="project"></param>
        /// <returns></returns>
        public Dictionary <string, int> GetUnknownWords(Lingva lang, string project)
        {
            Dictionary <string, int> words = new Dictionary <string, int>();

            SQLiteParameter projectParam = new SQLiteParameter("@project");

            projectParam.Value  = project;
            projectParam.DbType = System.Data.DbType.String;

            SQLiteParameter langParam = new SQLiteParameter("@lang");

            langParam.Value  = lang.Language;
            langParam.DbType = System.Data.DbType.String;

            string sql = "SELECT word, SUM(quantity) as sum " +
                         "FROM Words JOIN Files on Words.file = Files.path " +
                         "WHERE project=@project AND lang=@lang " +
                         "GROUP BY word ORDER BY sum DESC LIMIT 100";

            using (SQLiteCommand cmd = new SQLiteCommand(sql, dbConn))
            {
                cmd.Parameters.Add(projectParam);
                cmd.Parameters.Add(langParam);
                SQLiteDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    words[dr.GetString(0)] = dr.GetInt32(1);
                }
                dr.Close();
            }
            return(words);
        }
Exemple #2
0
        /// <summary>
        /// Removes the project from DB.
        /// </summary>
        /// <param name="language"></param>
        /// <param name="project"></param>
        public void RemoveProject(Lingva language, string project)
        {
            SQLiteParameter langParam = new SQLiteParameter("@lang");

            langParam.Value  = language.Language;
            langParam.DbType = System.Data.DbType.String;

            SQLiteParameter projectParam = new SQLiteParameter("@project");

            projectParam.Value  = project;
            projectParam.DbType = System.Data.DbType.String;

            using (SQLiteCommand cmd = new SQLiteCommand(dbConn))
            {
                cmd.Parameters.Add(langParam);
                cmd.Parameters.Add(projectParam);
                // Delete all words from previous analysis.
                cmd.CommandText = "DELETE FROM Words WHERE file IN " +
                                  "(SELECT path FROM Files WHERE lang=@lang AND project=@project)";
                cmd.ExecuteNonQuery();
                // Delete all stats from previous analysis
                cmd.CommandText = "DELETE FROM Files WHERE lang=@lang AND project=@project";
                cmd.ExecuteNonQuery();
            }
        }
Exemple #3
0
        /// <summary>
        /// Removes language from viewModel and model.
        /// </summary>
        /// <param name="languageViewModel"></param>
        public void RemoveLanguage(LingvaViewModel languageViewModel)
        {
            Lingva lang = languageViewModel.CurrentLanguage;

            L.Logger.Debug(string.Format("Removing {0} language from {1}.",
                                         lang.Language, lang.Folder));
            model.RemoveOldLanguage(lang);
        }
Exemple #4
0
        /// <summary>
        /// Adds new language to viewmodel and model.
        /// </summary>
        /// <param name="languageViewModel"></param>
        public void AddNewLanguage(LingvaViewModel languageViewModel)
        {
            L.Logger.Debug("Adding new language.");
            // Use copy constructor.
            Lingva lang = new Lingva(languageViewModel.CurrentLanguage);

            model.AddNewLanguage(lang);
        }
Exemple #5
0
        // Equals override
        public override bool Equals(object obj)
        {
            Lingva item = obj as Lingva;

            if (item == null)
            {
                return(false);
            }

            return(this.Folder == item.Folder);
        }
Exemple #6
0
        /// <summary>
        /// Adds new language and it's folder to DB.
        /// </summary>
        /// <param name="language"></param>
        /// <param name="directory"></param>
        /// <returns></returns>
        public void AddLanguage(Lingva lang)
        {
            string sql = "INSERT INTO Languages VALUES(@lang, @directory)";

            using (SQLiteCommand cmd = new SQLiteCommand(sql, dbConn))
            {
                SQLiteParameter param = new SQLiteParameter("@lang");
                param.Value  = lang.Language;
                param.DbType = System.Data.DbType.String;
                cmd.Parameters.Add(param);

                param        = new SQLiteParameter("@directory");
                param.Value  = lang.Folder;
                param.DbType = System.Data.DbType.String;
                cmd.Parameters.Add(param);

                cmd.ExecuteNonQuery();
            }
        }
Exemple #7
0
        /// <summary>
        /// Removes the stats of the given language from DB.
        /// </summary>
        /// <param name="language"></param>
        public void RemoveLanguage(Lingva language)
        {
            SQLiteParameter param = new SQLiteParameter("@lang");

            param.Value  = language.Language;
            param.DbType = System.Data.DbType.String;

            using (SQLiteCommand cmd = new SQLiteCommand(dbConn))
            {
                cmd.Parameters.Add(param);
                // Delete all words from previous analysis.
                cmd.CommandText = "DELETE FROM Words WHERE file IN " +
                                  "(SELECT path FROM Files WHERE lang=@lang)";
                cmd.ExecuteNonQuery();
                // Delete language and files.
                cmd.CommandText = "DELETE FROM Languages WHERE lang=@lang";
                cmd.ExecuteNonQuery();
            }
        }
Exemple #8
0
        /// <summary>
        /// Return projects for chosen language.
        /// </summary>
        /// <param name="selectedLang"></param>
        /// <returns></returns>
        public List <string> GetProjects(Lingva selectedLang)
        {
            List <string> projects = new List <string>();
            string        sql      = "SELECT project FROM Files WHERE lang=@lang GROUP BY project";

            using (SQLiteCommand cmd = new SQLiteCommand(sql, dbConn))
            {
                SQLiteParameter param = new SQLiteParameter("@lang");
                param.Value  = selectedLang.Language;
                param.DbType = System.Data.DbType.String;
                cmd.Parameters.Add(param);

                SQLiteDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    projects.Add(dr.GetString(0));
                }
                dr.Close();
            }
            return(projects);
        }
Exemple #9
0
        /// <summary>
        /// Returns list of fileStats for given language and project.
        /// </summary>
        /// <param name="language"></param>
        /// <param name="project"></param>
        /// <returns></returns>
        public List <FileStats> GetFilesStats(Lingva language, string project)
        {
            SQLiteParameter langParam = new SQLiteParameter("@lang");

            langParam.Value  = language.Language;
            langParam.DbType = System.Data.DbType.String;

            SQLiteParameter projectParam = new SQLiteParameter("@project");

            projectParam.Value  = project;
            projectParam.DbType = System.Data.DbType.String;

            string sql = "SELECT name, path, size, known, maybe, unknown FROM Files " +
                         "WHERE lang=@lang AND project=@project";
            List <FileStats> stats = new List <FileStats>();

            using (SQLiteCommand cmd = new SQLiteCommand(sql, dbConn))
            {
                cmd.Parameters.Add(langParam);
                cmd.Parameters.Add(projectParam);
                SQLiteDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    stats.Add(new FileStats(
                                  dr.GetString(0),
                                  dr.GetString(1),
                                  language, project)
                    {
                        Size    = dr.GetInt32(2),
                        Known   = dr.GetInt32(3),
                        Maybe   = dr.GetInt32(4),
                        Unknown = dr.GetInt32(5)
                    });
                }
                dr.Close();
            }
            return(stats);
        }
Exemple #10
0
 public Lingva(Lingva other)
 {
     Language = other.Language;
     Folder   = other.Folder;
 }
Exemple #11
0
 // Constructors
 public LingvaViewModel(Lingva language)
 {
     currentLanguage = language;
     validProperties.Add("Language", false);
     validProperties.Add("Folder", false);
 }
Exemple #12
0
 public Lingva(Lingva other)
 {
     Language = other.Language;
     Folder = other.Folder;
 }