Gramps SQL Database - Revision history

Patsyblefebre: Gramps

2013-02-01T05:44:45Z

Gramps

Patsyblefebre: Patsyblefebre moved page GRAMPS SQL Database to Gramps SQL Database: Gramps

2013-02-01T05:39:52Z

Patsyblefebre moved page GRAMPS SQL Database to Gramps SQL Database: Gramps

Patsyblefebre: Gramps

2013-01-28T01:04:19Z

Gramps

Patsyblefebre: Category:GEPS|S

2013-01-05T09:11:27Z

Category:GEPS|S

Patsyblefebre: /* Database Structure */ /trunk/gramps/webapp/grampsdb/models.py

2013-01-05T09:10:52Z

‎Database Structure: /trunk/gramps/webapp/grampsdb/models.py

Patsyblefebre: /* GRAMPS SQL database Overview */ /trunk/gramps/webapp/ can not work out the other links

2013-01-05T09:08:57Z

‎GRAMPS SQL database Overview: /trunk/gramps/webapp/ can not work out the other links

Romjerome: /* GRAMPS SQL database Overview */

2010-08-02T10:03:28Z

‎GRAMPS SQL database Overview

Romjerome: /* Database Structure */

2010-08-02T09:58:32Z

‎Database Structure

Romjerome at 08:37, 27 June 2010

2010-06-27T08:37:22Z

Dsblank: /* Newer Version */

2010-03-06T14:37:20Z

‎Newer Version

@@ Line 1: / Line 1: @@
-This page documents the format of a SQL database version of the GRAMPS BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]]  for GRAMPS, and for supplying data to other applications, such as a [[GEPS 013: Gramps Webapp]].
+This page documents the format of a SQL database version of the Gramps BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]]  for Gramps, and for supplying data to other applications, such as a [[GEPS 013: Gramps Webapp]].
-= GRAMPS SQL database Overview =
+= Gramps SQL database Overview =
 There are two versions of exporting a SQL database: an ExportDjango version and an ExportSql/ImportSql version. Currently, the ExportDjango is the latest SQL design. You can access the older functionality through the ''ExportSql'' and ''ImportSql'' programs of the [[Third-party Plugins]] and the newer ExportDjango in SVN in [http://svn.code.sf.net/p/gramps/code/trunk/gramps/webapp/ /trunk/gramps/webapp/], [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/templates/ src/data/templates/] and [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/javascript/ /src/data/javascript/].
@@ Line 59: / Line 59: @@
 </pre>
-If you change the data, you can then read it back in and GRAMPS will reflect the changes.
+If you change the data, you can then read it back in and Gramps will reflect the changes.
 NOTE: You should only attempt editing textual fields or fields for which you know the meaning. For example, in the above, do not change the handle fields, but you can change one's gender.
@@ Line 67: / Line 67: @@
 ''This section describes the latest SQL schema in the SVN branch.''
-The GRAMPS BSDDB data is broken up into the following tables. The structure and names of the tables and fields were designed to match the naming and operation of the GRAMPS source code. All of the tables have singular form names (e.g., 'person' rather than 'people').
+The Gramps BSDDB data is broken up into the following tables. The structure and names of the tables and fields were designed to match the naming and operation of the Gramps source code. All of the tables have singular form names (e.g., 'person' rather than 'people').
 The schema is created in the [http://svn.code.sf.net/p/gramps/code/trunk/gramps/webapp/grampsdb/models.py /trunk/gramps/webapp/grampsdb/models.py] file as Python code.

← Older revision		Revision as of 01:04, 28 January 2013
Line 1:		Line 1:
−	This page documents the format of a SQL database version of the GRAMPS BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]] for GRAMPS, and for supplying data to other applications, such as a [[GEPS 013: ~~GRAMPS~~ Webapp]].	+	This page documents the format of a SQL database version of the GRAMPS BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]] for GRAMPS, and for supplying data to other applications, such as a [[GEPS 013: Gramps Webapp]].

	= GRAMPS SQL database Overview =		= GRAMPS SQL database Overview =

@@ Line 1: / Line 1: @@
 This page documents the format of a SQL database version of the GRAMPS BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]]  for GRAMPS, and for supplying data to other applications, such as a [[GEPS 013: GRAMPS Webapp]].
@@ Line 668: / Line 666: @@
 );
 </pre>

@@ Line 71: / Line 71: @@
 The GRAMPS BSDDB data is broken up into the following tables. The structure and names of the tables and fields were designed to match the naming and operation of the GRAMPS source code. All of the tables have singular form names (e.g., 'person' rather than 'people').
-The schema is created in the [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/web/grampsdb/models.py?&content-type=text%2Fplain webapp/grampsweb/grampsdb/models.py] file as Python code.
+The schema is created in the [http://svn.code.sf.net/p/gramps/code/trunk/gramps/webapp/grampsdb/models.py /trunk/gramps/webapp/grampsdb/models.py] file as Python code.
 == markertype ==

@@ Line 5: / Line 5: @@
 = GRAMPS SQL database Overview =
-There are two versions of exporting a SQL database: an ExportDjango version and an ExportSql/ImportSql version. Currently, the ExportDjango is the latest SQL design. You can access the older functionality through the ''ExportSql'' and ''ImportSql'' programs of the [[Third-party Plugins]] and the newer ExportDjango in SVN in [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/web/ /trunk/src/web/], [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/templates/ src/data/templates/] and [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/javascript/ /src/data/javascript/].
+There are two versions of exporting a SQL database: an ExportDjango version and an ExportSql/ImportSql version. Currently, the ExportDjango is the latest SQL design. You can access the older functionality through the ''ExportSql'' and ''ImportSql'' programs of the [[Third-party Plugins]] and the newer ExportDjango in SVN in [http://svn.code.sf.net/p/gramps/code/trunk/gramps/webapp/ /trunk/gramps/webapp/], [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/templates/ src/data/templates/] and [http://gramps.svn.sourceforge.net/viewvc/gramps/trunk/src/data/javascript/ /src/data/javascript/].
 == Older version sample usage ==

← Older revision		Revision as of 08:37, 27 June 2010
Line 1:		Line 1:
		+	[[Category:GEPS\|S]]
		+
	This page documents the format of a SQL database version of the GRAMPS BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]] for GRAMPS, and for supplying data to other applications, such as a [[GEPS 013: GRAMPS Webapp]].		This page documents the format of a SQL database version of the GRAMPS BSDDB datastore. This can be seen as a step towards a [[GEPS 010: SQL Backend]] for GRAMPS, and for supplying data to other applications, such as a [[GEPS 013: GRAMPS Webapp]].

@@ Line 21: / Line 21: @@
 == Newer Version ==
-Please see the README file in the [http://gramps.svn.sourceforge.net/viewvc/gramps/branches/geps/gep-013-server/webapp/grampsweb/README?view=markup branches/geps/gep-013-server/webapp/grampsweb/README]. You can run the ExportDjango plugin in this branch once you have the setup finished.
+You can run the ExportDjango plugin in gramps32 once you have the setup finished.
 After initial Django setup in the README in in branch, you can: