HCP IoT Showcase using Sphero • Part 1: Overview • Part 2: Controlling Sphero using Raspberry Pi and Xbox 360 controller • Part 3: Maze Setup (Hardware) • Part 4: Unit Test (Gathering & Sending Data) • Part 5: Unit Test (MQTT) • Part 6: Integration Test • Part 7: XS Application • |
{
"exposed": true,
"authentication": [{
"method": "Form"
}],
"mime_mapping": [{
"extension": "jpg",
"mimetype": "image/jpeg"
}],
"force_ssl": false,
"enable_etags": false,
"prevent_xsrf": false,
"anonymous_connection": null,
"cors": [{
"enabled":true,
"allowMethods": ["GET","POST","DELETE","PUT"],
"allowOrigin": ["*"],
"maxAge":"3600"
}],
"cache_control": "no-cache, no-store",
"default_file": "index.html"
}
namespace userreg.data;
@Schema: 'SYSTEM'
context userreg {
type SString: String(60);
@Catalog.tableType: #COLUMN
Entity userreg {
key ID: String(10);
USERNAME: SString;
COMPANYNAME: SString;
};
context procedures{
type userreg {
ID: String(10);
USERNAME: SString;
COMPANYNAME: SString;
};
type errors {
HTTP_STATUS_CODE : Integer;
ERROR_MESSAGE : String(100);
DETAIL : String(100);
};
};
}
schema= "SYSTEM";
start_with= 1;
maxvalue= 1000000000;
nomaxvalue=false;
minvalue= 1;
nominvalue=true;
cycles= false;
depends_on_table= "userreg.data::userreg.userreg";
PROCEDURE
"SYSTEM"."userreg.data::createuser" (
IN intab "SYSTEM"."userreg.data::userreg.procedures.userreg",
OUT outtab "SYSTEM"."userreg.data::userreg.procedures.errors"
)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER AS
--DEFAULT SCHEMA <schema>
--READS SQL DATA AS
begin
declare lv_users_no string;
declare lv_username string;
declare lv_companyname string;
select ID, USERNAME, COMPANYNAME into lv_users_no, lv_username, lv_companyname from :intab;
if :lv_username = '' then
outtab = select 500 as http_status_code,
'Invalid user name ' || lv_username as error_message,
'No Way! User name field must not be empty' as detail from dummy;
else
insert into "userreg.data::userreg.userreg"
values ("userreg.data::userseq".NEXTVAL, lv_username, lv_companyname);
end if;
end;
service {
"userreg.data::userreg.userreg" as "user"
create using "userreg.data::createuser";
}
CREATE VIEW LEADERBOARD_VIEW
AS
SELECT "userreg.data::userreg.userreg"."ID" AS UID,
"userreg.data::userreg.userreg"."USERNAME",
"userreg.data::userreg.userreg"."COMPANYNAME",
NANO100_BETWEEN(
MIN("T_IOT_CA1B914529DC3EE0E16F"."C_TIMESTAMP"),
MAX("T_IOT_CA1B914529DC3EE0E16F"."C_TIMESTAMP")
) AS TIMELAP
FROM "T_IOT_CA1B914529DC3EE0E16F"
INNER JOIN "userreg.data::userreg.userreg"
ON "T_IOT_CA1B914529DC3EE0E16F"."C_USERNAME" = "userreg.data::userreg.userreg"."ID"
GROUP BY "userreg.data::userreg.userreg"."ID",
"userreg.data::userreg.userreg"."USERNAME",
"userreg.data::userreg.userreg"."COMPANYNAME";
service {
"SYSTEM"."LEADERBOARD_VIEW" keys generate local "GeneratedID";
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
10 | |
9 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
4 |