예제 #1
0
        public async Task UpdateTest()
        {
            var services = new ServiceCollection()
                           .AddRoscoePostgres("Host=localhost;Database=test");

            using (var provider = services.BuildServiceProvider())
            {
                var db = new RoscoeDb(provider);

                var organisations = new OrganisationTable("o");

                var subquery = db.Query(() => Guid.Parse("c0cac2b4-4821-4135-900b-4a36b46f0122").DbValue().Value()).Value;

                var query = db.Update(organisations)
                            .Set(organisations.Name, "new name".DbValue())
                            //.From(organisations)
                            //.InnerJoin(organisations, organisations.Id == organisations.Id)
                            .Where(organisations.Id == subquery.DbValue())
                            .Returning(() => new
                {
                    Id   = organisations.Id.Value(),
                    Name = organisations.Name.Value(),
                });

                var sql    = query.ToString();
                var result = await db.ExecuteAsync(query);
            }
        }
예제 #2
0
        public void InsertTest()
        {
            var services = new ServiceCollection()
                           .AddRoscoePostgres("");

            using (var provider = services.BuildServiceProvider())
            {
                var db = new RoscoeDb(provider);

                var organisations = new OrganisationTable("o");

                var selectQuery = db.Query(() => new
                {
                    Id   = organisations.Id.NullValue(),
                    Name = organisations.Name.ToLower().Value(),
                    //IdName = (organisations.Id + organisations.Name).Value(),
                })
                                  .From(organisations);

                var updateQuery = db.Update(organisations)
                                  .Set(organisations.Name, "new name".DbValue())
                                  //.From(organisations)
                                  //.InnerJoin(organisations, organisations.Id == organisations.Id)
                                  .Where(organisations.Name == "")
                ;

                var query = db.InsertValues(organisations, new { organisations.Id, organisations.Name })
                            .Values(new { Id = Guid.NewGuid().DbValue(), Name = "org 1".DbValue() })
                            .OnConflict(organisations.Id, organisations.Name)
                            //.DoNothing()
                            .Update(x => x.Set(organisations.Name, "org 1".DbValue()))
                            .Returning(() => new
                {
                    Id = organisations.Id.Value(),
                });

                var selectSql = selectQuery.ToString();
                var updateSql = updateQuery.ToString();
                var sql       = query.ToString();
            }
        }