Datasource

sqlite

6min

With SQLite, you can write your datasources as SQL queries. You can use the queries in datasources to create a select statement and get the data from the tables you need to use in your ﻿ file. You can use it directly in the ﻿ file, where the UI component configuration is or you can use it as a global datasource. 
If you are not familiar with datasources yet, see the Data﻿ section.
﻿Configuration options﻿
When setting up a sqlite datasource, you have use the datasource in the following ways: 
In your ﻿ file as a locally configured datasource under the datasource section.
In the global datasource file, that will allow you to use it across all the ﻿ files. The global datasource files are located under the datasources folder in ﻿.
﻿Examples and code snippets ﻿
View common examples of using sqlite below,  you can use these as a guideline to configure the same in your solutions.
sqlite in a jig file
﻿
Datasource with type sqlite to select name, and email from the employee's table and to display the list of employees.
Example:
See the full example on GitHub. 
sqlite-jig
|
datasources:
  employees-dynamic:
    type: datasource.sqlite
    options:
      provider: DATA_PROVIDER_DYNAMIC
      entities:
        - entity: default/employees
      query: |
        SELECT
          id,
          '$.firstname',
          '$.email'
        FROM [default/employees]

datasources:
  employees-dynamic:
    type: datasource.sqlite
    options:
      provider: DATA_PROVIDER_DYNAMIC
      entities:
        - entity: default/employees
      query: |
        SELECT
          id,
          '$.firstname',
          '$.email'
        FROM [default/employees]
﻿
sqlite as a global datasource
﻿
﻿
Datasource with type sqlite as global datasource to select name, and email from the employee's table and to display the list of employees.
﻿
Example:
See the full example on Github. 
﻿
sqlite-global-datasource
list-jig.jigx
|
type: "datasource.sqlite"
options:
    provider: DATA_PROVIDER_DYNAMIC
    entities:
    - entity: default/employees
    query: |
    SELECT
        id,
        '$.firstname',
        '$.email'
    FROM [default/employees]
type: "datasource.sqlite"
options:
    provider: DATA_PROVIDER_DYNAMIC
    entities:
    - entity: default/employees
    query: |
    SELECT
        id,
        '$.firstname',
        '$.email'
    FROM [default/employees]
﻿
See also
﻿Developer reference﻿
﻿