= Superset =

 * 1. start container
{{{
docker run -d -p 8080:8088 -e "SUPERSET_SECRET_KEY=krit_Superset" --name superset apache/superset
}}}
 * 2. setup local admin account
{{{
docker exec -it superset superset fab create-admin \
              --username admin \
              --firstname Superset \
              --lastname Admin \
              --email admin@superset.com \
              --password admin
}}}
 * 3. migrate locad DB to latest
{{{
docker exec -it superset superset db upgrade
}}}
 * 4. Load Examples
{{{
docker exec -it superset superset load_examples
}}}
 * 5. Setup roles
{{{
docker exec -it superset superset init
}}}

Login and take a look -- navigate to http://localhost:8080/login/ -- u/p: [admin/admin]

 * Note to access dashboard with out login just change config file '''//app/superset/config.py'''. [[br]] 
   * 1. Uncomment #AUTH_ROLE_PUBLIC = 'Public" 
   * 2. PUBLIC_ROLE_LIKE: Optional[str] = 'Gamma'
{{{
AUTH_ROLE_PUBLIC = 'Public'
PUBLIC_ROLE_LIKE: Optional[str] = 'Gamma'
}}}
   * 3. re int superset with
{{{
docker exec -it superset superset init
}}}
   * 4. Then edit role on menu Public to remove access on database/dashboard/ ... etc

---------------------------------

sqlite create table
{{{
sqlite> CREATE TABLE npk (id int primary key autoincrement, dt datetime default current_timestamp, site_id TEXT, lat REAL, lon REAL, temp REAL, ph REAL, humd REAL, ec REAL, n REAL, p REAL, k REAL, sal REAL);
}}}
insert data to table
{{{
sqlite> INSERT INTO npk ( dt, site_id, lat, lon, temp, ph, humd, ec, n, p, k, sal ) VALUES(DateTime('now', 'localtime'), "stv_1",13.84366667, 100.50775, 25, 7.0, 53.0, 0.1, 76, 82, 93, 1.4); 
}}}