view release on metacpan or  search on metacpan

t/04_actions.t  view on Meta::CPAN

    columns:
      -
        autoincrement: '0'
        comment: ''
        datatype: INT
        default_value: ''
        length: '-1'
        name: group_id
        not_null: '1'
        precision: '-1'
      -
        autoincrement: '0'
        comment: ''
        datatype: VARCHAR
        default_value: ''
        length: '45'
        name: name
        not_null: '1'
        precision: '-1'
    foreign_keys: {}
    indexes:
      -
        columns:
          - group_id
        name: PRIMARY
        type: PRIMARY
      -
        columns:
          - name
        name: name_UNIQUE
        type: UNIQUE
    name: groups
    primary_key:
      - group_id
  -
    columns:
      -
        autoincrement: '0'
        comment: ''
        datatype: INT
        default_value: ''
        length: '-1'
        name: user_id
        not_null: '1'
        precision: '-1'
      -
        autoincrement: '0'
        comment: ''
        datatype: INT
        default_value: ''
        length: '-1'
        name: group_id
        not_null: '1'
        precision: '-1'
    foreign_keys:
      groups:
        -
          foreign: group_id
          me: group_id
          on_delete: restrict
          on_update: cascade
      users:
        -
          foreign: idusers
          me: user_id
          on_delete: cascade
          on_update: 'no action'
    indexes:
      -
        columns:
          - user_id
          - group_id
        name: PRIMARY
        type: PRIMARY
      -
        columns:
          - group_id
        name: fk_users_has_groups_groups1_idx
        type: INDEX
      -
        columns:
          - user_id
        name: fk_users_has_groups_users_idx
        type: INDEX
    name: user_groups
    primary_key:
      - user_id
      - group_id
|;

my $parser = MySQL::Workbench::Parser->new( file => $mwb );
is_string $parser->dump, $check;

done_testing();