
select CURRENT_Page;

DECLARE _Page_Demo '{"size":"A4"}';

select _Page_Demo,_Page_Demo->'size';


set _Page_Demo->'size'='A2';

select _Page_Demo;


set CURRENT_Page=_Page_Demo;

select CURRENT_Page;

DECLARE CURRENT_Page '{"size":"A4","rotate":0}';
/*size: A0, A1, A2, A3, A4, A5, A6, Legal, Letter, nxn (for instance, 8.5x1.4 means 8.5" x 14")*/
/* Rotate integer (Optional; inheritable) The number of degrees by which the page shall be rotated clockwise when displayed or printed. The value shall be a multiple of 90. Default value: 0.*/
select CURRENT_Page;

DECLARE CURRENT_Font '{"name":"Courier"}';
/* name: Courier, Courier-Bold, Courier-BoldOblique, Courier-Oblique, Helvetica, Helvetica-Bold, Helvetica-BoldOblique, Helvetica-Oblique,Times-Roman, Times-Bold, Times-BoldItalic, Times-Italic, and so on*/
/* size */
DECLARE _Font_Demo '{"name":"Times-Roman"}';
set CURRENT_Font=_Font_Demo;




drop database if exists testpdf;

*create database if not exists testpdf;


create table if not exists testpdf.page1 (size varchar(2) default 'A5' );


create database if not exists testpdf;




create table if not exists testpdf.page1 (nothing int);


DECLARE CURRENT_TextFormat '{"fontSize":12}';

set CURRENT_Page->'size'='A6';

*select textline,* from testpdf;

select * from testpdf;

insert into testpdf.page1 (textline) values('A demo line');

insert into testpdf.page1 (textline) values('Another demo line');

select * from testpdf.page1;
select STRING_AGG(textline,'\r\n') as content from testpdf.page1;

create table if not exists testpdf.page2 select 'A demo line for create page2' as textline;

create table if not exists testpdf.page3 (textline longvarchar) select 'A demo line for create page3';

create table if not exists testpdf.page4 (textline longvarchar) select 'A demo line for create page4';
select * from testpdf.page4;
drop table if exists testpdf.page4;
create table if not exists testpdf.page4 (nothing int);
select * from testpdf.page4;

insert into testpdf.page2 (textline) values('demo line for page2');
select * from testpdf.page2;

insert into testpdf (PageNo,CoordinateY,textline) values(3,300,'demo line for page3');

flush database if exists testpdf;

alter table testpdf.page3 modify size longvarchar default 'A4';

alter table testpdf modify size longvarchar default 'A4';

select CURRENT_TextFormat;

select pageno,textline from testpdf.page2;

truncate table testpdf.page2;/* become a blank page */

select * from testpdf.page3;

delete from testpdf.page1 where textline='A demo line' ; /* remove one textline */

delete from testpdf.page3; /* remove all textline */

insert into testpdf (PageNo,CoordinateY,CoordinateX,textline) values(3,120,10,'Who');

flush database if exists testpdf;

insert into testpdf (PageNo,CoordinateY,textline) values(3,100,'New demo line for page3');

insert into testpdf (PageNo,CoordinateY,CoordinateX,textline) values(3,120,12,'Why');
insert into testpdf (PageNo,CoordinateY,CoordinateX,textline) values(3,120,50,'Not');

select *,Words from testpdf.page3;


update testpdf.page3 set Words#>'{1,text}'='not'  where CoordinateY=120 and  Words#>'{1,text}'='Not';


select * from testpdf;

update testpdf.page3 set textline=textline+'?' where CoordinateY<=100;

select * from testpdf;

select PageNo,CoordinateX,CoordinateY,textline,words,words#>'{0}',words->0->'x',words#>'{0,x}',words#>'{0,y}',words#>'{0,text}' from testpdf.page3;



flush database if exists testpdf;


#drop database if exists testpdf;







