/usr/share/GNUstep/Documentation/GDL2Intro/Creating-with-DBModeler.html is in gnustep-dl2 0.12.0-15.1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 | <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<!-- (C)
Permission is granted to make and distribute verbatim copies of
this manual provided the copyright notice and this permission notice
are preserved on all copies.
Permission is granted to copy and distribute modified versions of this
manual under the conditions for verbatim copying, provided also that
the entire resulting derived work is distributed under the terms of a
permission notice identical to this one.
Permission is granted to copy and distribute translations of this manual
into another language, under the above conditions for modified versions. -->
<!-- Created by GNU Texinfo 6.3, http://www.gnu.org/software/texinfo/ -->
<head>
<title>GNUstep Database Library Introduction 0.1: Creating with DBModeler</title>
<meta name="description" content="GNUstep Database Library Introduction 0.1: Creating with DBModeler">
<meta name="keywords" content="GNUstep Database Library Introduction 0.1: Creating with DBModeler">
<meta name="resource-type" content="document">
<meta name="distribution" content="global">
<meta name="Generator" content="makeinfo">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="index.html#Top" rel="start" title="Top">
<link href="Index.html#Index" rel="index" title="Index">
<link href="index.html#SEC_Contents" rel="contents" title="Table of Contents">
<link href="Model-creation.html#Model-creation" rel="up" title="Model creation">
<link href="Project-creation.html#Project-creation" rel="next" title="Project creation">
<link href="Example-model-file.html#Example-model-file" rel="prev" title="Example model file">
<style type="text/css">
<!--
a.summary-letter {text-decoration: none}
blockquote.indentedblock {margin-right: 0em}
blockquote.smallindentedblock {margin-right: 0em; font-size: smaller}
blockquote.smallquotation {font-size: smaller}
div.display {margin-left: 3.2em}
div.example {margin-left: 3.2em}
div.lisp {margin-left: 3.2em}
div.smalldisplay {margin-left: 3.2em}
div.smallexample {margin-left: 3.2em}
div.smalllisp {margin-left: 3.2em}
kbd {font-style: oblique}
pre.display {font-family: inherit}
pre.format {font-family: inherit}
pre.menu-comment {font-family: serif}
pre.menu-preformatted {font-family: serif}
pre.smalldisplay {font-family: inherit; font-size: smaller}
pre.smallexample {font-size: smaller}
pre.smallformat {font-family: inherit; font-size: smaller}
pre.smalllisp {font-size: smaller}
span.nolinebreak {white-space: nowrap}
span.roman {font-family: initial; font-weight: normal}
span.sansserif {font-family: sans-serif; font-weight: normal}
ul.no-bullet {list-style: none}
-->
</style>
</head>
<body lang="en">
<a name="Creating-with-DBModeler"></a>
<div class="header">
<p>
Previous: <a href="Example-model-file.html#Example-model-file" accesskey="p" rel="prev">Example model file</a>, Up: <a href="Model-creation.html#Model-creation" accesskey="u" rel="up">Model creation</a> [<a href="index.html#SEC_Contents" title="Table of contents" rel="contents">Contents</a>][<a href="Index.html#Index" title="Index" rel="index">Index</a>]</p>
</div>
<hr>
<a name="Creating-with-DBModeler-1"></a>
<h3 class="section">24.2 Creating with DBModeler</h3>
<p>To recreate the example model with DBModeler,
</p>
<p>select Document, New from the main menu then property Add entity twice.
set the name and external names to ’authors’ and ’books’
</p>
<p>select Document, Set Adaptor Info, and select SQLite, and click Ok,
this will bring up the SQLite login panel, where you need to provide it a path
for where to create the model file.
</p>
<p>Each Adaptor will have different requirements, so each login panel is quite
different. Other adaptors may have a server address, username, and database names.
</p>
<p>select the authors entity in the outline view, after expanding the model
add an attribute to authors by selecting Property, Add attribute
set the name and column name to ’authorID’,
and select the switch button with a key icon, to set it as the primary key
for the entity. Set the value class name to NSNumber and the external type to INTEGER
</p>
<p>Add another entity, set the name and column names to ’name’.
Select the switch button which looks like a jewel icon to set it as a Class Property. Set the Value Class Name to NSString and external type to TEXT.
</p>
<p>now do the same with books,
name them bookID, authorID, and title.
make sure bookID is set as the primary key not authorID in the books entity.
And that title is set as a class property.
</p>
<p>title is a NSString/TEXT, where authorID and bookID are NSNumber/INTEGER
</p>
<p>now add a relationship to authors
name it toBooks, and Tools, inspector
in the destination table, select To many, and books as the destination entity.
</p>
<p>select authorID as the source and destination attributes
</p>
<p>add a relationship to books, name it toAuthor.
Select author as the destination entity, and authorID as the source
and destination attributes.
</p>
<p>The select Document, Save, from the main menu.
</p>
<hr>
<div class="header">
<p>
Previous: <a href="Example-model-file.html#Example-model-file" accesskey="p" rel="prev">Example model file</a>, Up: <a href="Model-creation.html#Model-creation" accesskey="u" rel="up">Model creation</a> [<a href="index.html#SEC_Contents" title="Table of contents" rel="contents">Contents</a>][<a href="Index.html#Index" title="Index" rel="index">Index</a>]</p>
</div>
</body>
</html>
|