Exemple #1
0
        public static void AssembleDataset(Database database)
        {
            int marker = 0;

            do
            {
                if ((numberOfTweetsToFetch - marker) < insertSize)
                {
                    insertSize = (numberOfTweetsToFetch - marker);
                }
                Task <List <Status> > statuses = TwitterStuff.GetTwitterData(searchQuery, insertSize, maxID, sinceID);
                statuses.Wait();
                var listOfTweets = statuses.Result;
                maxID = listOfTweets.Min(status => status.StatusID) - 1;
                try
                {
                    database.Insert(listOfTweets);
                    marker += listOfTweets.Count;
                }
                catch
                {
                    Console.WriteLine("SQL INSERT failed. Try again? Press any key...");
                    Console.ReadKey();
                }
            } while (marker < numberOfTweetsToFetch);
        }
Exemple #2
0
        static void Main(string[] args)
        {
            database = new Database();
            while (quit == false)
            {
                Console.Clear();
                Console.WriteLine("Press:\n 1 Get tweets menu\n 2 TEST SQL\n 3 test\n Q Quit");
                ConsoleKeyInfo choice = Console.ReadKey();
                Console.WriteLine();
                switch (choice.KeyChar)
                {
                case '1':
                    GetTweetsUI();
                    break;

                case '2':
                    Console.WriteLine("Max Query Size: {0}", database.GetMaxQuerySize());
                    break;

                case '3':
                    Controlpanel.Init();

                    break;

                case '4':
                    TwitterStuff.GetRawData("dkpol");
                    break;

                case 'q':
                    quit = true;
                    Console.WriteLine("Quitting...");
                    System.Threading.Thread.Sleep(500);
                    break;
                }
            }
        }