/usr/share/GNUstep/Documentation/GDL2Intro/Example-model-file.html

<!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.5, http://www.gnu.org/software/texinfo/ -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Example model file (GNUstep Database Library Introduction 0.1)</title>

<meta name="description" content="Example model file (GNUstep Database Library Introduction 0.1)">
<meta name="keywords" content="Example model file (GNUstep Database Library Introduction 0.1)">
<meta name="resource-type" content="document">
<meta name="distribution" content="global">
<meta name="Generator" content="makeinfo">
<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="Creating-with-DBModeler.html#Creating-with-DBModeler" rel="next" title="Creating with DBModeler">
<link href="Model-creation.html#Model-creation" rel="prev" title="Model creation">
<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="Example-model-file"></a>
<div class="header">
<p>
Next: <a href="Creating-with-DBModeler.html#Creating-with-DBModeler" accesskey="n" rel="next">Creating with DBModeler</a>, Previous: <a href="Model-creation.html#Model-creation" accesskey="p" rel="prev">Model creation</a>, Up: <a href="Model-creation.html#Model-creation" accesskey="u" rel="up">Model creation</a> &nbsp; [<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="Example-model-file-1"></a>
<h3 class="section">24.1 Example model file</h3>
<p>Below is a example property list model created with DBModeler,
it contains a Model for a library 2 entities, author and book
</p>
<p>author contains 2 attributes, authorID the primary key number, and name a string
book contains 3 attributes, bookID the primary key number, authorID a
foreign key number, and title a string.
</p>
<p>author and book each contain a relationship
author a to-many relationship to each of the authors books,
and book a to-one relationship to the books author 
for the sake of demonstration i&rsquo;m ignoring books with multiple authors.
</p>
<p>it also contains an adaptor name, and an adaptor specific connection dictionary.
</p>
<pre class="verbatim">{
    EOModelVersion = 2;
    adaptorName = SQLite3;
    connectionDictionary = {
	databasePath = &quot;/tmp/example.db&quot;;
    };
    entities = (
	{
	    attributes = (
		{
		    columnName = authorID;
		    externalType = integer;
		    name = authorID;
		    valueClassName = NSNumber;
		},
		{
		    columnName = name;
		    externalType = varchar;
		    name = name;
		    valueClassName = NSString;
		}
	    );
	    className = EOGenericRecord;
	    classProperties = (
		name,
		toBooks
	    );
	    externalName = authors;
	    name = authors;
	    primaryKeyAttributes = (
		authorID
	    );
	    relationships = (
		{
		    destination = books;
		    isToMany = Y;
		    joinSemantic = EOInnerJoin;
		    joins = (
			{
			    destinationAttribute = authorID;
			    sourceAttribute = authorID;
			}
		    );
		    name = toBooks;
		}
	    );
	},
	{
	    attributes = (
		{
		    columnName = authorID;
		    externalType = integer;
		    name = authorID;
		    valueClassName = NSNumber;
		},
		{
		    columnName = bookID;
		    externalType = integer;
		    name = bookID;
		    valueClassName = NSNumber;
		},
		{
		    columnName = title;
		    externalType = varchar;
		    name = title;
		    valueClassName = NSString;
		}
	    );
	    className = EOGenericRecord;
	    classProperties = (
		title,
		toAuthor
	    );
	    externalName = books;
	    name = books;
	    primaryKeyAttributes = (
		bookID
	    );
	    relationships = (
		{
		    destination = authors;
		    isToMany = N;
		    joinSemantic = EOInnerJoin;
		    joins = (
			{
			    destinationAttribute = authorID;
			    sourceAttribute = authorID;
			}
		    );
		    name = toAuthor;
		}
	    );
	}
    );
    name = library;
}
</pre>



</body>
</html>
gnustep-dl2 0.12.0-15.1build2 / usr / share / GNUstep / Documentation / GDL2Intro / Example-model-file.html
