Kotlin, Postgres: How to store an attribute that is Map to JSONB?How to generate a random alpha-numeric string?How do I efficiently iterate over each entry in a Java Map?How do I read / convert an InputStream into a String in Java?How to get an enum value from a string value in Java?How can I convert a stack trace to a string?How to split a string in JavaHow do I convert a String to an int in Java?Accidentally stored string instead of object in Postgres JSONB columnPostgres - Update and restructure attribute of JSONB type columStoring jsonb data through ecto

A reference to a well-known characterization of scattered compact spaces

What's the point of deactivating Num Lock on login screens?

90's TV series where a boy goes to another dimension through portal near power lines

Is "remove commented out code" correct English?

Should I tell management that I intend to leave due to bad software development practices?

Assassin's bullet with mercury

What killed these X2 caps?

Is it possible to run Internet Explorer on OS X El Capitan?

How is it possible to have an ability score that is less than 3?

How can I make my BBEG immortal short of making them a Lich or Vampire?

Would Slavery Reparations be considered Bills of Attainder and hence Illegal?

Is it legal for company to use my work email to pretend I still work there?

What does it mean to describe someone as a butt steak?

1960's book about a plague that kills all white people

How can I fix/modify my tub/shower combo so the water comes out of the showerhead?

I'm flying to France today and my passport expires in less than 2 months

Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?

How many spell slots should my level 1 wizard/level 1 fighter have?

What is a clear way to write a bar that has an extra beat?

Why is consensus so controversial in Britain?

Why do bosons tend to occupy the same state?

Why do I get two different answers for this counting problem?

Do I have a twin with permutated remainders?

Why are electrically insulating heatsinks so rare? Is it just cost?



Kotlin, Postgres: How to store an attribute that is Map to JSONB?


How to generate a random alpha-numeric string?How do I efficiently iterate over each entry in a Java Map?How do I read / convert an InputStream into a String in Java?How to get an enum value from a string value in Java?How can I convert a stack trace to a string?How to split a string in JavaHow do I convert a String to an int in Java?Accidentally stored string instead of object in Postgres JSONB columnPostgres - Update and restructure attribute of JSONB type columStoring jsonb data through ecto






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















I've looked through a few similar questions but couldn't find what I'm looking for. I'm trying to store an object with essentially this format into a postgres table:



class C 
var id: Int? = null
var name: String? = null
var attributes: Map<String, Any> = mapOf()



All I'll be doing is writing these object and reading them to the table, and also need to filter on one of the attributes. After some research it seemed like JSONB might be a good format to use, so I created a table like:



CREATE TABLE IF NOT EXISTS fake_table (

id INTEGER NOT NULL,
name TEXT NOT NULL,
attributes JSONB NOT NULL,
PRIMARY KEY (id)
);


Not sure how to convert the Map into an object that can be written into the database. Right now my mapper looks something like this:



interface ItemMapper 
@Insert("""
INSERT INTO fake_table (
id, name, attributes
) VALUES (
#id, #name, #attributes
)""")
fun add(item: Item)



and I just need to convert class C into class Item which would be compatible?



class Item 

var id: Int? = null
var name: String? = null
var attributes: someJsonObject? = null /// <------ what to do here?

constructor(c: C)
id = c.id
name = c.name
attributes = c.attributes.magicJSONconverter() // <------- what to do here?




I was able to get this working by converting the attributes to String, but then I am unable to filter the query easily (I believe?), which is a dealbreaker.










share|improve this question




























    0















    I've looked through a few similar questions but couldn't find what I'm looking for. I'm trying to store an object with essentially this format into a postgres table:



    class C 
    var id: Int? = null
    var name: String? = null
    var attributes: Map<String, Any> = mapOf()



    All I'll be doing is writing these object and reading them to the table, and also need to filter on one of the attributes. After some research it seemed like JSONB might be a good format to use, so I created a table like:



    CREATE TABLE IF NOT EXISTS fake_table (

    id INTEGER NOT NULL,
    name TEXT NOT NULL,
    attributes JSONB NOT NULL,
    PRIMARY KEY (id)
    );


    Not sure how to convert the Map into an object that can be written into the database. Right now my mapper looks something like this:



    interface ItemMapper 
    @Insert("""
    INSERT INTO fake_table (
    id, name, attributes
    ) VALUES (
    #id, #name, #attributes
    )""")
    fun add(item: Item)



    and I just need to convert class C into class Item which would be compatible?



    class Item 

    var id: Int? = null
    var name: String? = null
    var attributes: someJsonObject? = null /// <------ what to do here?

    constructor(c: C)
    id = c.id
    name = c.name
    attributes = c.attributes.magicJSONconverter() // <------- what to do here?




    I was able to get this working by converting the attributes to String, but then I am unable to filter the query easily (I believe?), which is a dealbreaker.










    share|improve this question
























      0












      0








      0








      I've looked through a few similar questions but couldn't find what I'm looking for. I'm trying to store an object with essentially this format into a postgres table:



      class C 
      var id: Int? = null
      var name: String? = null
      var attributes: Map<String, Any> = mapOf()



      All I'll be doing is writing these object and reading them to the table, and also need to filter on one of the attributes. After some research it seemed like JSONB might be a good format to use, so I created a table like:



      CREATE TABLE IF NOT EXISTS fake_table (

      id INTEGER NOT NULL,
      name TEXT NOT NULL,
      attributes JSONB NOT NULL,
      PRIMARY KEY (id)
      );


      Not sure how to convert the Map into an object that can be written into the database. Right now my mapper looks something like this:



      interface ItemMapper 
      @Insert("""
      INSERT INTO fake_table (
      id, name, attributes
      ) VALUES (
      #id, #name, #attributes
      )""")
      fun add(item: Item)



      and I just need to convert class C into class Item which would be compatible?



      class Item 

      var id: Int? = null
      var name: String? = null
      var attributes: someJsonObject? = null /// <------ what to do here?

      constructor(c: C)
      id = c.id
      name = c.name
      attributes = c.attributes.magicJSONconverter() // <------- what to do here?




      I was able to get this working by converting the attributes to String, but then I am unable to filter the query easily (I believe?), which is a dealbreaker.










      share|improve this question














      I've looked through a few similar questions but couldn't find what I'm looking for. I'm trying to store an object with essentially this format into a postgres table:



      class C 
      var id: Int? = null
      var name: String? = null
      var attributes: Map<String, Any> = mapOf()



      All I'll be doing is writing these object and reading them to the table, and also need to filter on one of the attributes. After some research it seemed like JSONB might be a good format to use, so I created a table like:



      CREATE TABLE IF NOT EXISTS fake_table (

      id INTEGER NOT NULL,
      name TEXT NOT NULL,
      attributes JSONB NOT NULL,
      PRIMARY KEY (id)
      );


      Not sure how to convert the Map into an object that can be written into the database. Right now my mapper looks something like this:



      interface ItemMapper 
      @Insert("""
      INSERT INTO fake_table (
      id, name, attributes
      ) VALUES (
      #id, #name, #attributes
      )""")
      fun add(item: Item)



      and I just need to convert class C into class Item which would be compatible?



      class Item 

      var id: Int? = null
      var name: String? = null
      var attributes: someJsonObject? = null /// <------ what to do here?

      constructor(c: C)
      id = c.id
      name = c.name
      attributes = c.attributes.magicJSONconverter() // <------- what to do here?




      I was able to get this working by converting the attributes to String, but then I am unable to filter the query easily (I believe?), which is a dealbreaker.







      java postgresql kotlin






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 8 at 23:58









      Matt TakaoMatt Takao

      17010




      17010






















          0






          active

          oldest

          votes












          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072611%2fkotlin-postgres-how-to-store-an-attribute-that-is-mapstring-any-to-jsonb%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55072611%2fkotlin-postgres-how-to-store-an-attribute-that-is-mapstring-any-to-jsonb%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Identity Server 4 is not redirecting to Angular app after login2019 Community Moderator ElectionIdentity Server 4 and dockerIdentityserver implicit flow unauthorized_clientIdentityServer Hybrid Flow - Access Token is null after user successful loginIdentity Server to MVC client : Page Redirect After loginLogin with Steam OpenId(oidc-client-js)Identity Server 4+.NET Core 2.0 + IdentityIdentityServer4 post-login redirect not working in Edge browserCall to IdentityServer4 generates System.NullReferenceException: Object reference not set to an instance of an objectIdentityServer4 without HTTPS not workingHow to get Authorization code from identity server without login form

          2005 Ahvaz unrest Contents Background Causes Casualties Aftermath See also References Navigation menue"At Least 10 Are Killed by Bombs in Iran""Iran"Archived"Arab-Iranians in Iran to make April 15 'Day of Fury'"State of Mind, State of Order: Reactions to Ethnic Unrest in the Islamic Republic of Iran.10.1111/j.1754-9469.2008.00028.x"Iran hangs Arab separatists"Iran Overview from ArchivedConstitution of the Islamic Republic of Iran"Tehran puzzled by forged 'riots' letter""Iran and its minorities: Down in the second class""Iran: Handling Of Ahvaz Unrest Could End With Televised Confessions""Bombings Rock Iran Ahead of Election""Five die in Iran ethnic clashes""Iran: Need for restraint as anniversary of unrest in Khuzestan approaches"Archived"Iranian Sunni protesters killed in clashes with security forces"Archived

          Can't initialize raids on a new ASUS Prime B360M-A motherboard2019 Community Moderator ElectionSimilar to RAID config yet more like mirroring solution?Can't get motherboard serial numberWhy does the BIOS entry point start with a WBINVD instruction?UEFI performance Asus Maximus V Extreme