示例#1
0
        public void Create()
        {
            var     client    = BigQueryClient.Create(_fixture.ProjectId);
            string  datasetId = _fixture.DatasetId;
            var     routineId = _fixture.CreateRoutineId();
            Routine routine   = new Routine
            {
                DefinitionBody = "SELECT 1;",
                Description    = "test routine",
            };

            routine.SetRoutineLanguage(RoutineLanguage.Sql);
            routine.SetRoutineType(RoutineType.StoredProcedure);

            var created = client.CreateRoutine(datasetId, routineId, routine);
            var fetched = client.GetRoutine(datasetId, routineId);

            Assert.Equal(created.Resource.ETag, fetched.Resource.ETag);
        }
示例#2
0
        public void Create()
        {
            var    client    = BigQueryClient.Create(_fixture.ProjectId);
            string datasetId = _fixture.DatasetId;
            var    routineId = _fixture.CreateRoutineId();
            var    routine   = CreateTestRoutineInMemory();

            var created = client.CreateRoutine(datasetId, routineId, routine);
            var fetched = client.GetRoutine(datasetId, routineId);

            Assert.Equal(created.Resource.ETag, fetched.Resource.ETag);
        }