Ggtcf

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.

java postgresql kotlin

share|improve this question

asked Mar 8 at 23:58

Matt TakaoMatt Takao

17010

add a comment | 

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.

java postgresql kotlin

share|improve this question

asked Mar 8 at 23:58

Matt TakaoMatt Takao

17010

add a comment | 

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

asked Mar 8 at 23:58

Matt TakaoMatt Takao

17010

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

CREATE TABLE IF NOT EXISTS fake_table (

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

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

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?
 

share|improve this question

asked Mar 8 at 23:58

Matt TakaoMatt Takao

17010

share|improve this question

asked Mar 8 at 23:58

Matt TakaoMatt Takao

17010

asked Mar 8 at 23:58

Matt TakaoMatt Takao

17010

asked Mar 8 at 23:58

Matt TakaoMatt Takao

17010