Is it possible to create auto increment - primary key column? about sqlitebiter HOT 4 CLOSED

Thank you for your reply.

You can add primary key id column as described in the previous comment with sqlitebiter 0.25.0 or newer version. I had added the feature to that version.

Please upgrade sqlitebiter and execute with --add-primary-key <PRIMARY KEY NAME> option like following:

Input: issue60.json

[
    {
        "a": "foo",
        "b": 123
    },
    {
        "a": "bar",
        "b": 456
    }
]

Example execution

$ sqlitebiter --add-primary-key id file issue60.json
[INFO] sqlitebiter file: convert 'issue60.json' to 'issue60' table
[INFO] sqlitebiter file: converted results: source=1, success=1, created-table=1
[INFO] sqlitebiter file: database path: out.sqlite

Output table schema: issue60

from sqlitebiter.

Hi @maheshkumar2150

Did you mean adding primary key autoincrement column to the SQLite file while JSON does not include a key column? like the following example:

Input: issue.json

[
    {
        "a": "foo",
        "b": 123
    },
    {
        "a": "bar",
        "b": 456
    }
]

Output (current behavior)

'issue60' (a INTEGER, b INTEGER);

Output (expected behavior)

'issue60' (id INTEGER PRIMARY KEY AUTOINCREMENT, INTEGER, b INTEGER);

from sqlitebiter.

Yes. Exactly, this is what i wanted to ask.
Is it possible?

from sqlitebiter.

Super! Thank you so much!!

from sqlitebiter.