Auto-detection of the database columns

[ozziest]

This issue has been created by the discussion in #846385235.

Why?

#846385235

• Auto-detection columns in the initialization process.
  • Not easy to implement. We should add auto-detection codes for all databases that Knex.js supports.
  • Easy for developers. They don't have to define anything at all.
  • Great feature for documentation. We can show which model has what kind of columns, even their types.

How

• Inject auto-detection library by the database type (For example, MySQL, MariaDB, etc.)
• Detect all database columns (name, type, is_indexed vs) in the database by tables.
• Bind those columns to the model instances.

Database Column Detectors

• MySQL
• #26 PostgreSQL
• #27 MSSQL
• #28 SQLite
• #29 Oracle
• #30 Amazon Redshift

Common Schema

{
  "name": "id",
  "tableName": "users",
  "isNullable": false,
  "dataType": "Number",
  "defaultValue": null,
  "maxLength": null,
  "numericPrecision": null,
  "numericScale": null,
  "isPrimary": true,
  "isAutoIncrement": true
}

Documentation

• Axe API should be able to list all possible columns in the documentation routes.

Column Checks

• INSERT, UPDATE Handlers
• Fillable Fields
• Form Validations
• Hidden Fields
• Timestamps
• Related Routes
• Query Fields
• Query Sorting
• Query Where Conditions
• Query Relations