SQL table name cannot start with numeric?

[longxudou]

What happens?

I met a bug when I try to convert the following json into sqlite file.

{
"2018Asset": [
{
"RANK": "1",
"id": "item_entertainment_18_212",
"count": "1billion"
}
]
}

What were you expecting to happen?

Convert succeed.

What are the steps to reproduce this issue?

command: sqlitebiter -o 'test.sqlite' file 'test.json'

Any logs, error output, etc?

I turn on the debug mode.
DEBUG | simplesqlite.core:create_table:1261 - CREATE TABLE IF NOT EXISTS '2018Asset' (RANK INTEGER, id TEXT, count TEXT)

Environments

• **Operating System: macos mojave 10.14.6
• Python Version: Python 3.7
• **sqlitebiter Version: v0.31.0
• **Installation Method: pip

Any other comments?

After detecting the table name starting with the number, the command should be 'CREATE TABLE IF NOT EXISTS [2018Asset] ...' instead of 'CREATE TABLE IF NOT EXISTS 2018Asset ...'.
We can escape the table's name by enclosing it with []:

[thombashi]

@DreamerDeo
Thank you for your report.

The issue fixed at sqlitebiter 0.31.1, you can convert the JSON file with this version.
Please upgrade the package and re-execute.