[jira] [Updated] (OFBIZ-6033) InduceModelFromDb field definitions

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-6033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sharan Foga updated OFBIZ-6033:
-------------------------------
    Sprint: Bug Crush Event - 21/2/2015

> InduceModelFromDb field definitions
> ------------------------------------
>
>                 Key: OFBIZ-6033
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6033
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: 13.07.01
>            Reporter: Ralf
>            Priority: Minor
>
> 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".

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)