Skip to content

Latest commit

 

History

History
46 lines (32 loc) · 911 Bytes

README.md

File metadata and controls

46 lines (32 loc) · 911 Bytes

pymwb

A simple library to read MySQL Workbench MWB files.

Requirements

  • Python 3.7

Installation

You can clone the repository and install the package:

$ git clone https://github.com/marianoesteban/pymwb.git
$ cd pymwb
$ python setup.py install

Usage

Here is an example that prints the basic contents of an MWB file:

import mwb

example_model = mwb.Model('example_file.mwb')

for schema in example_model.schemas:
    print('Schema:', schema.name)
    for table in schema.tables:
        print('\tTable:', table.name)
        for column in table.columns:
            print('\t\t' + column.name + ':', column.datatype)
    for view in schema.views:
        print('\tView:', view.name)

Missing Features

The following features are not yet implemented:

  • Primary keys
  • Foreign keys
  • Relationships
  • Column attributes (not null, unique, binary, etc.)
  • User types