private static string GetAbcPostField() => "easy as 123"; // mimic an in-memory function
private static void InitializeAccountSchema(GraphQLSchema <EfContext> schema)
{
var account = schema.AddType <Account>();
account.AddField(a => a.Id);
account.AddField(a => a.Name);
account.AddField(a => a.Paid);
account.AddField(a => a.SomeGuid);
account.AddField(a => a.ByteArray);
account.AddField(a => a.AccountType);
account.AddListField(a => a.Users);
account.AddListField("activeUsers", (db, a) => a.Users.Where(u => u.Active));
account.AddListField("usersWithActive", new { active = false }, (db, args, a) => a.Users.Where(u => u.Active == args.active));
account.AddField("firstUserWithActive", new { active = false }, (db, args, a) => a.Users.FirstOrDefault(u => u.Active == args.active));
schema.AddField("account", new { id = 0 }, (db, args) => db.Accounts.FirstOrDefault(a => a.Id == args.id));
schema.AddField
("accountPaidBy", new { paid = default(DateTime) },
(db, args) => db.Accounts.AsQueryable().FirstOrDefault(a => a.PaidUtc <= args.paid));
schema.AddListField("accountsByGuid", new { guid = Guid.Empty },
(db, args) => db.Accounts.AsQueryable().Where(a => a.SomeGuid == args.guid));
schema.AddListField("accountsByType", new { accountType = AccountType.None },
(db, args) => db.Accounts.AsQueryable().Where(a => a.AccountType == args.accountType));
schema.AddEnum <AccountType>(prefix: "accountType_");
//add this enum just so it is part of the schema
schema.AddEnum <MaterialType>(prefix: "materialType_");
}
/// <summary>
/// Initialization of Beer Schema
/// </summary>
/// <param name="schema"></param>
private static void InitializeBeerSchema(GraphQLSchema <BeerContext> schema)
{
var beer = schema.AddType <Beers>();
beer.AddField(b => b.Id);
beer.AddField(b => b.Name);
beer.AddField(b => b.AverageRatings);
beer.AddListField("beerRatings", (db, b) => b.BeerRatings);
beer.AddField(t => t.BeerTypes);
beer.AddField("beerType", (db, u) => u.BeerTypes.Name);
schema.AddListField("Beers", db => db.Beers);
schema.AddField("Beer", new { id = 0 }, (db, args) => db.Beers.FirstOrDefault(u => u.Id == args.id));
schema.AddListField("FindBeer", new { match = string.Empty }, (db, args) => db.Beers.Where(b => b.Name.ToLower().Contains(args.match.ToLower())));
}
private static void InitializeCharacterSchema(GraphQLSchema <EfContext> schema)
{
schema.AddType <Character>().AddAllFields();
schema.AddType <Human>().AddAllFields();
schema.AddType <Stormtrooper>().AddAllFields();
schema.AddType <Droid>().AddAllFields();
schema.AddType <Vehicle>().AddAllFields();
schema.AddField("hero", new { id = 0 }, (db, args) => db.Heros.SingleOrDefault(h => h.Id == args.id));
schema.AddListField("heros", db => db.Heros.AsQueryable());
}
public RepositorioDeConsulta() //ModeloPeliculas modelo)
{
var modelo = new ModeloPeliculas(); // = modelo;
var pel = modelo.Peliculas.FirstOrDefault();
_schema = GraphQL <ModeloPeliculas> .CreateDefaultSchema(() => modelo);
var pelicula = _schema.AddType <Pelicula>();
pelicula.AddField(p => p.Id);
pelicula.AddField(p => p.Nombre);
_schema.AddListField("peliculas", db => db.Peliculas);
_schema.AddField("pelicula", new { id = 0 }, (db, args) => db.Peliculas.Where(p => p.Id == args.id).FirstOrDefault());
_schema.Complete();
}
public GraphQLSchemaProvider()
{
var options2 = new DbContextOptionsBuilder <AdventureWorksDbContext>();
options2.UseSqlServer(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
GraphQLSchema <AdventureWorksDbContext> schema = GraphQL <AdventureWorksDbContext> .CreateDefaultSchema(() => new AdventureWorksDbContext(options2.Options));
schema.AddType <Employee>().AddAllFields();
schema.AddListField("employees", db => db.Employees);
schema.AddField("employee", new { id = 0 }, (db, args) => db.Employees.FirstOrDefault(u => u.EmployeeID == args.id));
schema.AddType <JobCandidate>().AddAllFields();
schema.AddType <Shift>().AddAllFields();
schema.AddType <Department>().AddAllFields();
schema.Complete();
gql = new GraphQL <AdventureWorksDbContext>(schema);
}
public static void InitializeUserSchema(GraphQLSchema <MemContext> schema)
{
var user = schema.AddType <User>();
user.AddField(u => u.Id);
user.AddField(u => u.Name);
user.AddField(u => u.Account);
user.AddField(u => u.NullRef);
user.AddField("total", (db, u) => db.Users.Count);
user.AddField("accountPaid", (db, u) => u.Account.Paid);
user.AddPostField("abc", () => GetAbcPostField());
user.AddPostField("sub", () => new Sub {
Id = 1
});
schema.AddType <Sub>().AddField(s => s.Id);
schema.AddListField("users", db => db.Users.AsQueryable());
schema.AddField("user", new { id = 0 }, (db, args) => db.Users.AsQueryable().FirstOrDefault(u => u.Id == args.id));
}
public GraphQLService(IContext dbContext)
{
GraphQLSchema <TestContext> schema = GraphQL <TestContext> .CreateDefaultSchema(() => dbContext.Context as TestContext);
var user = schema.AddType <User>();
user.AddAllFields();
user.AddField("totalUsers", (db, u) => db.Users.Count());
user.AddField("accountPaid", (db, u) => u.Account.Paid);
schema.AddType <Account>().AddAllFields();
schema.AddListField("users", db => db.Users);
schema.AddField("user", new { id = 0 }, (db, args) => db.Users.Where(u => u.Id == args.id).FirstOrDefault());
schema.Complete();
graphQL = new GraphQL <TestContext>(schema);
}
private static string GetAbcPostField() => "easy as 123"; // mimic an in-memory function
public static void InitializeAccountSchema(GraphQLSchema <MemContext> schema)
{
var account = schema.AddType <Account>();
account.AddField(a => a.Id);
account.AddField(a => a.Name);
account.AddField(a => a.Paid);
account.AddField(a => a.SomeGuid);
account.AddField(a => a.ByteArray);
account.AddListField(a => a.Users);
account.AddListField("activeUsers", (db, a) => a.Users.Where(u => u.Active));
account.AddListField("usersWithActive", new { active = false }, (db, args, a) => a.Users.Where(u => u.Active == args.active));
account.AddField("firstUserWithActive", new { active = false }, (db, args, a) => a.Users.FirstOrDefault(u => u.Active == args.active));
schema.AddField("account", new { id = 0 }, (db, args) => db.Accounts.AsQueryable().FirstOrDefault(a => a.Id == args.id));
schema.AddField
("accountPaidBy", new { paid = default(DateTime) },
(db, args) => db.Accounts.AsQueryable().FirstOrDefault(a => a.PaidUtc <= args.paid));
schema.AddListField("accountsByGuid", new { guid = Guid.Empty },
(db, args) => db.Accounts.AsQueryable().Where(a => a.SomeGuid == args.guid));
}