private StatementResult CreateRandomSingersResults(int count) { var rows = new List <object[]>(count); for (int row = 0; row < count; row++) { var date = new SpannerDate(_random.Next(1900, 2020), _random.Next(1, 13), _random.Next(1, 29)); var picture = new byte[_random.Next(1, 4097)]; _random.NextBytes(picture); rows.Add(new object[] { 1L, date.ToString(), "Alice", "Alice Morrison", "Morrison", ByteString.CopyFrom(picture).ToBase64() }); } return(StatementResult.CreateResultSet( new List <Tuple <V1.TypeCode, string> > { Tuple.Create(V1.TypeCode.Int64, "SingerId"), Tuple.Create(V1.TypeCode.Date, "BirthDate"), Tuple.Create(V1.TypeCode.String, "FirstName"), Tuple.Create(V1.TypeCode.String, "FullName"), Tuple.Create(V1.TypeCode.String, "LastName"), Tuple.Create(V1.TypeCode.Bytes, "Picture"), }, rows )); }
private StatementResult CreateFullNameResultSet(string fullName) => StatementResult.CreateResultSet( new List <Tuple <V1.TypeCode, string> > { Tuple.Create(V1.TypeCode.String, "FullName"), }, new List <object[]> { new object[] { fullName }, } );
private string AddFindSingerResult(string sql) { SpannerMock.AddOrUpdateStatementResult(sql, StatementResult.CreateResultSet( new List <Tuple <V1.TypeCode, string> > { Tuple.Create(V1.TypeCode.Int64, "SingerId"), Tuple.Create(V1.TypeCode.Date, "BirthDate"), Tuple.Create(V1.TypeCode.String, "FirstName"), Tuple.Create(V1.TypeCode.String, "FullName"), Tuple.Create(V1.TypeCode.String, "LastName"), Tuple.Create(V1.TypeCode.Bytes, "Picture"), }, new List <object[]> { new object[] { 1L, null, "Alice", "Alice Morrison", "Morrison", null }, } )); return(sql); }