select *  from qa_task;
select * from qa_case;
SELECT * FROM qa_project;

SELECT * FROM qa_rtype;


insert qa_task(TASK_PID,TASK_TID,TASK_NAME,TASK_CRNAME,TASK_DESCRIPTION,TASK_DETAILS,TASK_NOTE,TASK_CREATIONDT,TASK_UPDATEDT)
values(3,1,'TASKNAME','TASKCRNAME','DESCRIPTION','DETAILS','NOTE',SYSDATE(),SYSDATE())


desc  qa_task;

desc qa_case;


select TASK_ID,TASK_PID,PROJECT_NAME,TASK_TID, OBJECT_NAME,
TASK_NAME,TASK_CRNAME,TASK_DESCRIPTION,TASK_DETAILS,TASK_NOTE,TASK_CREATIONDT,TASK_UPDATEDT
FROM qa_task 
JOIN  QA_PROJECT ON TASK_PID =  PROJECT_ID
JOIN  qa_rtype ON OBJECT_ID = TASK_TID
WHERE  TASK_DELETED_FLAG = 0
and TASK_ID = ?


update qa_task set TASK_NAME=? ,TASK_CRNAME =? ,TASK_DESCRIPTION =? ,TASK_DETAILS =? ,TASK_NOTE =? ,TASK_UPDATEDT =?
where TASK_ID = ?


insert qa_task(TASK_PID,TASK_TID,TASK_NAME,TASK_CRNAME,TASK_DESCRIPTION,TASK_DETAILS,TASK_NOTE,TASK_CREATIONDT,TASK_UPDATEDT)
values(?,?,?,?,?,?,?,?,?)

insert qa_case(CASE_TASKID,CASE_NUM,CASE_PIRORITY,CASE_NAME,CASE_PRECONDITION,CASE_BODY,CASE_ASSERTION,CASE_PASSFLAG,CASE_MEMO,CASE_CREATIONDT,CASE_UPDATEDT)
values(6,1,1,'请求传入的签名为空',null,null,'sinature =200',1,'memo',SYSDATE(),SYSDATE())



update qa_task set TASK_DELETED_FLAG = 1, TASK_DELETED_COMMENT = '逻辑删除', TASK_UPDATEDT = ? where task_id= ?


select  * from  qa_task


update qa_task set TASK_DESCRIPTION= concat(TASK_DESCRIPTION,task_id)


concat("开发人员",EMPLOY_id)

select * from qa_user


delete from qa_user where id !=2

Alter table qa_user add primary key(id);
Alter table qa_user change id id int(10) not null auto_increment;


Alter table qa_user change id id int(10);//删除自增长
Alter table qa_user drop primary key;//删除主建

 alter table qa_user modify column id int not null AUTO_INCREMENT
 
 
 DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '昵称',
  `roles` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '身份',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;



select CASE_ID,CASE_TASKID,TASK_NAME,CASE_NUM,CASE_PIRORITY,CASE_NAME,CASE_PRECONDITION,CASE_BODY,
CASE_ASSERTION,CASE_PASSFLAG,CASE_MEMO,CASE_CREATIONDT,CASE_UPDATEDT
from qa_case
join qa_task on TASK_ID = CASE_TASKID
where CASE_DELETED_FLAG =0 and TASK_DELETED_FLAG = 0
and CASE_TASKID = ?