ThinkPHP6支持金仓数据库（Kingbase）解决无法使用模型查询问题

CREATE OR REPLACE FUNCTION public .pgsql_type(a_type   varchar )   RETURNS varchar AS
DECLARE
v_type   varchar ;
BEGIN
     IF a_type=  'int8' THEN
          v_type:=  'bigint' ;
     ELSIF a_type=  'int4' THEN
          v_type:=  'integer' ;
     ELSIF a_type=  'int2' THEN
          v_type:=  'smallint' ;
     ELSIF a_type=  'bpchar' THEN
          v_type:=  'char' ;
ELSE
          v_type:=a_type;
END IF;
RETURN v_type;
END

CREATE OR REPLACE FUNCTION public .table_msg(a_schema_name   varchar , a_table_name   varchar )   RETURNS SETOF tablestruct   AS
DECLARE
v_ret   public .tablestruct;

v_oid oid;

v_sql text;

v_rec RECORD;

v_key   varchar ;

BEGIN
    SELECT
    pg_class.oid   INTO v_oid
    FROM
    pg_class
INNER JOIN pg_namespace   ON
    (
        pg_class.relnamespace = pg_namespace.oid
            AND lower (pg_namespace.nspname) = a_schema_name
    )
    WHERE
    pg_class.relname = a_table_name;

IF   NOT FOUND   THEN
         RETURN ;
END IF;

v_sql =   '
     SELECT
           sys_attribute.attname AS fields_name,
           sys_attribute.attnum AS fields_index,
           pgsql_type(sys_type.typname::varchar) AS fields_type,
           sys_attribute.atttypmod-4 as fields_length,
           CASE WHEN sys_attribute.attnotnull THEN ' 'not null' '
           ELSE ' '' '
           END AS fields_not_null,
           sys_attrdef.adbin AS fields_default,
           sys_description.description AS fields_comment 
     FROM
           sys_attribute 
           INNER JOIN sys_class ON sys_attribute.attrelid = sys_class.oid 
           INNER JOIN sys_type ON sys_attribute.atttypid = sys_type.oid 
           LEFT OUTER JOIN sys_attrdef ON sys_attrdef.adrelid = sys_class.oid AND sys_attrdef.adnum = sys_attribute.attnum 
           LEFT OUTER JOIN sys_description ON sys_description.objoid = sys_class.oid AND sys_description.objsubid = sys_attribute.attnum
     WHERE
           sys_attribute.attnum > 0 
           AND attisdropped <> ATTISLOCAL 
ORDER BY sys_attribute.attnum' ;

FOR v_rec   IN EXECUTE v_sql LOOP
         v_ret.fields_name = v_rec.fields_name;

v_ret.fields_type = v_rec.fields_type;

IF v_rec.fields_length > 0   THEN
            v_ret.fields_length := v_rec.fields_length;
ELSE
            v_ret.fields_length :=   NULL ;
END IF;

v_ret.fields_not_null = v_rec.fields_not_null;

v_ret.fields_default = v_rec.fields_default;

v_ret.fields_comment = v_rec.fields_comment;

SELECT
    constraint_name   INTO v_key
FROM
    information_schema.key_column_usage
WHERE
    table_schema = a_schema_name
    AND table_name = a_table_name
    AND column_name = v_rec.fields_name;

IF FOUND   THEN
            v_ret.fields_key_name = v_key;
ELSE
            v_ret.fields_key_name =   '' ;
END IF;

RETURN NEXT v_ret;
END LOOP;

RETURN ;
END

CREATE OR REPLACE FUNCTION public .table_msg(a_table_name   varchar )   RETURNS SETOF tablestruct   AS
DECLARE
v_ret tablestruct;
BEGIN
FOR v_ret   IN SELECT *   FROM table_msg(  'public' ,a_table_name) LOOP
    RETURN NEXT v_ret;
END LOOP;
    RETURN ;
END

try {
            $data =\app\home\model\User::select();
            dump(  $data );
        }  catch (\Exception   $e ) {
            dump(  $e ->getMessage());
        }


        \app\home\model\User::create([  "user_name" =>  "123456" ,
            "user_pwd" =>  "123456" ,
            "mobile" =>  "abc" ,
            "full_name" =>  "abc" ,
        ]);