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

[Nicolas Malin (Jira)]

Ralf created OFBIZ-6033:
---------------------------

             Summary: 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)