예제 #1
0
        // [END print_results]

        private static void Main(string[] args)
        {
            BigquerySample sample    = new BigquerySample();
            string         projectId = null;

            if (args.Length == 0)
            {
                Console.WriteLine(usage);
            }
            else
            {
                projectId = args[0];
                // Create a new Bigquery client authorized via Application Default
                // Credentials.
                BigqueryService bigquery = sample.CreateAuthorizedClient();

                IList <TableRow> rows = sample.ExecuteQuery(
                    "SELECT TOP(corpus, 10) as title, COUNT(*) as unique_words " +
                    "FROM [publicdata:samples.shakespeare]", bigquery, projectId);

                sample.PrintResults(rows);
            }
            Console.WriteLine("\nPress any key...");
            Console.ReadKey();
        }
예제 #2
0
        // [END print_results]

        private static void Main(string[] args)
        {
            SamplesUtil.InvokeMain(() =>
            {
                var sample = new BigquerySample();
                sample.MainFunction(args);
            });
        }
예제 #3
0
        public void TestShakespeare()
        {
            var sample = new BigquerySample();
            var bigquery = sample.CreateAuthorizedClient();
            var rows = sample.ExecuteQuery(
                "SELECT TOP(corpus, 10) as title, COUNT(*) as unique_words " +
                "FROM [publicdata:samples.shakespeare]", bigquery,
                System.Environment.GetEnvironmentVariable("GOOGLE_PROJECT_ID"));

            // Make sure the results look like shakespeare.
            bool foundKingLear = false;
            bool foundHamlet = false;
            foreach (TableRow row in rows)
            {
                foreach (TableCell field in row.F)
                {
                    foundKingLear = foundKingLear || "kinglear".Equals(field.V);
                    foundHamlet = foundHamlet || "hamlet".Equals(field.V);
                }
            }
            Assert.IsTrue(foundHamlet);
            Assert.IsTrue(foundKingLear);
        }
예제 #4
0
        public void TestShakespeare()
        {
            var sample   = new BigquerySample();
            var bigquery = sample.CreateAuthorizedClient();
            var rows     = sample.ExecuteQuery(
                "SELECT TOP(corpus, 10) as title, COUNT(*) as unique_words " +
                "FROM [publicdata:samples.shakespeare]", bigquery,
                System.Environment.GetEnvironmentVariable("GOOGLE_PROJECT_ID"));

            // Make sure the results look like shakespeare.
            bool foundKingLear = false;
            bool foundHamlet   = false;

            foreach (TableRow row in rows)
            {
                foreach (TableCell field in row.F)
                {
                    foundKingLear = foundKingLear || "kinglear".Equals(field.V);
                    foundHamlet   = foundHamlet || "hamlet".Equals(field.V);
                }
            }
            Assert.IsTrue(foundHamlet);
            Assert.IsTrue(foundKingLear);
        }