Typed column

[pmithrandir]

Hello,

I saw your answer in issue #12

I would like to know if it would be possible to add a type mapping function in order to end up with typed column in the sqlite file.
Especially for dates, I use datetime type and having pure number / text is not really the same.
What would be your feedback on that ? Would it be possible / easy ?

I imagine something like
java pg2sqlite -m mapping.yaml

Regards

[caiiiycuk]

Did you also check #19? Regarding to text format you can change between number and text: https://github.com/caiiiycuk/postgresql-to-sqlite?tab=readme-ov-file#timestamps

[pmithrandir]

Hello,

I don't think issue is just with dates.

All columns should be typed in my example.(boolean, varchar, datetime, ...)

This is why I was thinking about a mapping system.

Regards,
Pierre

[caiiiycuk]

Still didn't get it. How do you add types in sqlite if there are no types, at the end it will be a string-like column.
You want to add some conversion logic at insert step? Do you want to call custom function that do some magic before insertion?

def map(String value, String columnName) {
  // do something with value
  return value;
}

I don't think you can do much with yaml file. Or maybe you can give an example of this mapping.yaml