[OFBIZ-6033] InduceModelFromDb field definitions

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 13.07.01
• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Unassigned
• Reporter: Ralf
• Created: 23/Jan/15 09:33
• Updated: 26/Feb/20 14:37

Description

webtools/control/view/ModelInduceFromDb

(1)
creates some fields like this:
invalid-LONGTEXT:2147483647:0

when reading the structure of a mysql (e.g. wordpress) database.
For example for some fields of this structure (in wordpress
/wp-admin/includes/schema.php)

CREATE TABLE $wpdb->posts (
ID bigint(20) unsigned NOT NULL auto_increment,
post_author bigint(20) unsigned NOT NULL default '0',
post_date datetime NOT NULL default '0000-00-00 00:00:00',
post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
post_content longtext NOT NULL,
post_title text NOT NULL,
post_excerpt text NOT NULL,
post_status varchar(20) NOT NULL default 'publish',
comment_status varchar(20) NOT NULL default 'open',
ping_status varchar(20) NOT NULL default 'open',
post_password varchar(20) NOT NULL default '',
post_name varchar(200) NOT NULL default '',
to_ping text NOT NULL,
pinged text NOT NULL,
post_modified datetime NOT NULL default '0000-00-00 00:00:00',
post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00',
post_content_filtered longtext NOT NULL,
post_parent bigint(20) unsigned NOT NULL default '0',
guid varchar(255) NOT NULL default '',
menu_order int(11) NOT NULL default '0',
post_type varchar(20) NOT NULL default 'post',
post_mime_type varchar(100) NOT NULL default '',
comment_count bigint(20) NOT NULL default '0',
PRIMARY KEY (ID),
KEY post_name (post_name),
KEY type_status_date (post_type,post_status,post_date,ID),
KEY post_parent (post_parent),
KEY post_author (post_author)
) $charset_collate;\n";

it creates:
<entity entity-name="WpPosts"
package-name=""
title="None"
copyright="Copyright 2001-2015 The Apache Software Foundation">
<field name="menuOrder" type="numeric"></field>
<field name="postModified" type="date-time"></field>
<field name="postMimeType" type="long-varchar"></field>
<field name="guid" type="long-varchar"></field>
<field name="postAuthor" type="invalid-BIGINT UNSIGNED:20:0"></field>
<field name="postModifiedGmt" type="date-time"></field>
<field name="postName" type="long-varchar"></field>
<field name="commentCount" type="invalid-BIGINT:19:0"></field>
<field name="postDate" type="date-time"></field>
<field name="postContentFiltered" type="invalid-LONGTEXT:2147483647:0"></field>
<field name="pingStatus" type="short-varchar"></field>
<field name="postParent" type="invalid-BIGINT UNSIGNED:20:0"></field>
<field name="toPing" type="very-long"></field>
<field name="postExcerpt" type="very-long"></field>
<field name="commentStatus" type="short-varchar"></field>
<field name="pinged" type="very-long"></field>
<field name="postStatus" type="short-varchar"></field>
<field name="id" type="invalid-BIGINT UNSIGNED:20:0"></field>
<field name="postDateGmt" type="date-time"></field>
<field name="postTitle" type="very-long"></field>
<field name="postPassword" type="short-varchar"></field>
<field name="postContent" type="invalid-LONGTEXT:2147483647:0"></field>
<field name="postType" type="short-varchar"></field>
</entity>

(2) regarding font color:
the output of ModelInduceFromDb seems to be formatted white,
so it is only readable in browsers "view source".

Issue Links

• is related to: OFBIZ-6510 Replace webtools/control/view/ModelInduceFromDb with widgets