Count() public static method

public static Count ( string tableName, bool dbconOpened ) : int
tableName string
dbconOpened bool
return int
コード例 #1
0
    public static string [] Stats()
    {
        ArrayList stats = new ArrayList();

        Sqlite.Open();

        /*
         * is good to add the string stuff like "Pings"
         * because then client will show this data or not
         * depending if it matches what want to show.
         * Maintain the ':' as separator
         */
        stats.Add("Pings:" + Sqlite.Count(Constants.ServerPingTable, true).ToString());
        stats.Add("Evaluators:" + Sqlite.Count(Constants.ServerEvaluatorTable, true).ToString());
        stats.Add("Sessions:" + Sqlite.Count(Constants.SessionTable, true).ToString());
        stats.Add("Persons:" + Sqlite.Count(Constants.PersonTable, true).ToString());
        stats.Add("Jumps:" + Sqlite.Count(Constants.JumpTable, true).ToString());
        stats.Add("JumpsRj:" + Sqlite.Count(Constants.JumpRjTable, true).ToString());
        stats.Add("Runs:" + Sqlite.Count(Constants.RunTable, true).ToString());
        stats.Add("RunsInterval:" + Sqlite.Count(Constants.RunIntervalTable, true).ToString());
        stats.Add("ReactionTimes:" + Sqlite.Count(Constants.ReactionTimeTable, true).ToString());
        stats.Add("Pulses:" + Sqlite.Count(Constants.PulseTable, true).ToString());
        stats.Add("MultiChronopic:" + Sqlite.Count(Constants.MultiChronopicTable, true).ToString());

        Sqlite.Close();

        string [] statsString = Util.ArrayListToString(stats);
        return(statsString);
    }