INNOV-AI

    Copy
  #This source code create a table and load data for the demonstration;

#Connect to the database;
sql connect "session1" {cm get "MENTDB";};

#Create the table;
sql dml "session1" (concat "DROP TABLE IF EXISTS coord;
CREATE TABLE coord (
	id bigint NOT NULL AUTO_INCREMENT,
	name varchar(255) NOT NULL ,
	x int NOT NULL,
	x1 int NOT NULL,
	x2 int NOT NULL,
	y int NOT NULL
);");

#insert random data into the table;
for (-> "[i]" 65) (<= [i] 90) (++ "[i]") {

		if (math random 2) {
			-> "[result]" (sql dml "session1" (concat 
				"INSERT INTO public.coord (
					name,
					x,
					x1,
					x2,
					y
				) VALUES (
					" (sql encode (string int_to_char [i])) " ,
					" (sql encode [i]) " ,
					" (sql encode (- [i] 10)) " ,
					" (sql encode (- [i] 20)) " ,
					" (sql encode (+ 1 [i])) "
				);"
			));
		} {
			-> "[result]" (sql dml "session1" (concat 
				"INSERT INTO public.coord (
					name,
					x,
					x1,
					x2,
					y
				) VALUES (
					" (sql encode (string int_to_char [i])) " ,
					" (sql encode [i]) " ,
					" (sql encode (- [i] 10)) " ,
					" (sql encode (- [i] 20)) " ,
					" (sql encode (- [i] 1)) "
				);"
			));
		};
		
};

#Disconnect from the database;
sql disconnect "session1";

    Copy
  "1"

    Copy
  pa rl load "reg1" "MENTDB" "x" "y" "SELECT * FROM public.coord LIMIT 0, 500";
pa rl predict "reg1" 12;

    Copy
  "11.826666666666581"