-- 生成entity-property
select
t2.entity_name,
GROUP_CONCAT(
concat(
'\r\n\/**\r\n* ',
t4.column_comment,
'\r\n*\/\r\n',
'private ',
t2.property_type,
' ',
underlineToCamel(t4.column_name),
';\r\n\r\n'
)
) as entity_script
from (
select distinct
t3.table_name,
t3.entity_name,
t3.column_name,
t3.column_comment,
case when t3.column_type like '%varchar%' or t3.column_type like '%date%' then 'String '
when t3.column_type like '%int%' then 'int '
when t3.column_type like '%decimal%' then 'float '
else 'String ' end as property_type
from caogao_stu_teacher_to_create_table t3
where model_name = 'xxxx'
) t2
join information_schema.columns t4 on t4.table_name = t2.table_name and t4.column_name = t2.column_name
group by t2.entity_name