Changes between Version 5 and Version 6 of Superset

Timestamp:

12/01/23 15:16:50 (12 months ago)

Author:

krit

Comment:

--

Superset

@@ -41 +41 @@
 }}}
    * 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); 
+}}}