Sync Schema

After the database configuration, restart the server.

Open your favourite REST Client and type the information as below.

GET - http://localhost:6060/palmyra/dev/v2/myapp/db/sync

Basic Authentication
credentials - admin/ad

After successful execution, the above invocation shall return 200 status code.

Verify

Query the server using below URL. This should list out the tables loaded in fluwiz platform and ready for access.

GET http://127.0.0.1:6060/palmyra/dev/v2/myapp/type

The response will be as below

[ {
    "type": "Student",
    "table": "student",
    "schema": "fpalmyra",
    "noFields": 5
  }, {
    "type": "Marks",
    "table": "marks",
    "schema": "fpalmyra",
    "noFields": 6
  }]

To view the details of a particular table,

GET http://127.0.0.1:6060/palmyra/dev/v2/myapp/type/Student

The response would be as below.

{
  "type": "Student",
  "table": "student",
  "schema": "fpalmyra",
  "noFields": 5,
  "fields": [
    {
      "attribute": "studentName",
      "column": "student_name",
      "mandatory": true,
      "dataType": "string"
    },
    {
      "attribute": "dob",
      "column": "dob",
      "mandatory": false,
      "dataType": "date"
    },
    {
      "attribute": "studentCode",
      "column": "student_code",
      "mandatory": true,
      "dataType": "string"
    },
    {
      "attribute": "studentClass",
      "column": "student_class",
      "mandatory": false,
      "dataType": "string"
    },
    {
      "attribute": "id",
      "column": "id",
      "mandatory": false,
      "dataType": "int"
    }
  ]
}