[
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)
