Get remote db model based on local model about postgrest-csharp HOT 6 CLOSED

If that works I’ll push it into the next version for you!

from postgrest-csharp.

Available in v2.1.0!

from postgrest-csharp.

You mean something like this?

var supabotMessages = await client.Table<Message>().Filter("id", Postgrest.Constants.Operator.Equals, id).Get();

from postgrest-csharp.

Well sort of yeah. Just without the verbosity of "id", Postgrest.Constants.Operator.Equals, id.
The primary keys are already annotated so I was hoping there would be a way to skip the verbose filter statements. For multi col keys in particular it's quite the hassle to create dicts and stuff.

 [Table("my_model")]
    public class MyModel: BaseModel
    {
        [PrimaryKey("id_2")]
        public string Id1 { get; set; }

        [PrimaryKey("id_2")]
        public string Id2{ get; set; }

        [PrimaryKey("id_3")]
        public string Id3 { get; set; }

        [Column("my_col")]
        public short MyCol{ get; set; }
       //....
   }

would result in a query like:

var filters = new Dictionary<string, string>()
           {
                {"id_1", localModel.Id1 },
                {"id_2", localModel.Id2 },
                {"id_3", localModel.Id3 },
            };
var dbModel = postgrestClient.Table<MyModel>().Match(filters).Get();

where to me it feels like the dict creation part should be able to be created automatically based on the [PrimaryKey(xx)] annotations.

Hope that makes sense :D

from postgrest-csharp.

Oh yes! Very nice.

I've added the following on the master branch.

var moviePerson = new MoviePerson { Id = 1, MovieId = 1, PersonId = 1 };
var findMoviePerson = await client.Table<MoviePerson>().Match(moviePerson).Single();

Is that better? (This tangentially required better supporting composite primary keys, which is appreciated!)

from postgrest-csharp.

Awesome, yeah the syntax looks very nice, thank you👌

from postgrest-csharp.