API:EPrints/Database/Pg - Revision history

Pod2wiki at 23:55, 11 January 2022

2022-01-11T23:55:04Z

← Older revision		Revision as of 23:55, 11 January 2022
Line 17:		Line 17:
	<!-- Pod2Wiki=head_description -->		<!-- Pod2Wiki=head_description -->
	==DESCRIPTION==		==DESCRIPTION==
			PostgreSQL database wrapper.

	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
	<span style='display:none'>User Comments</span>		<span style='display:none'>User Comments</span>
Line 24:		Line 26:
	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	</div>		</div>
	<!-- Pod2Wiki=~~head_todo~~ -->		<!-- Pod2Wiki=head_synopsis -->
	===~~TODO~~===		===Synopsis===
			$c->{dbdriver} = 'Pg';
			# $c->{dbhost} = 'localhost';
			$c->{dbname} = 'myrepo';
			$c->{dbuser} = 'bob';
			$c->{dbpass} = 'asecret';
			$c->{dbschema} = 'eprints';

	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
	<span style='display:none'>User Comments</span>		<span style='display:none'>User Comments</span>
Line 33:		Line 42:
	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	</div>		</div>
	<!-- Pod2Wiki=~~item_epadmin_create~~ -->		<!-- Pod2Wiki=head_postgresql_specific_annoyances -->
	====~~epadmin create~~====		===PostgreSQL-specific Annoyances===
			The {{API:PodLink\|file=DBD/Pg\|package_name=DBD::Pg\|section=\|text=DBD::Pg}} <tt>SQL_VARCHAR</tt> type is mapped to <tt>TEXT</tt> instead of <tt>VARCHAR(n)</tt>.

	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
Line 43:		Line 53:
	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	</div>		</div>
	<!-- Pod2Wiki=~~item_index_name~~ -->		<!-- Pod2Wiki=head_constants -->
	====~~$name = $db->index_name( $table, @columns )====~~		==CONSTANTS==
			See [[API:EPrints/Database#CONSTANTS\|EPrints::Database]].

	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
Line 53:		Line 64:
	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	</div>		</div>
	<!-- Pod2Wiki=~~head_postgresql_specific_annoyances~~ -->		<!-- Pod2Wiki=head_instance_variables -->
	==~~=PostgreSQL-specific Annoyances=~~==		==INSTANCE VARIABLES==
	~~The {{~~API:~~PodLink\|file=DBD~~/Pg\|~~package_name=DBD~~::~~Pg\|section=\|text=DBD::Pg}} <tt>SQL_VARCHAR</tt> type is mapped to <tt>TEXT</tt> instead of <tt>VARCHAR(n)</tt>~~.		See [[API:EPrints/Database#INSTANCE_VARIABLES\|EPrints::Database]].

	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
Line 76:		Line 87:
	===connect===		===connect===

	$db->connect()		$db->connect
	Connects to the database.		Connects to the database.

Line 279:		Line 290:
	$sql = $db->sql_LIKE()		$sql = $db->sql_LIKE()
	Returns the syntactic glue to use when making a case-insensitive <tt>ILIKE</tt>.		Returns the syntactic glue to use when making a case-insensitive <tt>ILIKE</tt>.

			<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
			<span style='display:none'>User Comments</span>
			<!-- Edit below this comment -->


			<!-- Pod2Wiki= -->
			</div>
			<!-- Pod2Wiki=head_see_also -->
			==SEE ALSO==
			[[API:EPrints/Database\|EPrints::Database]]

	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>

Pod2wiki at 20:08, 25 December 2021

2021-12-25T20:08:24Z

Show changes

Tdb01r at 09:56, 22 January 2013

2013-01-22T09:56:36Z

← Older revision		Revision as of 09:56, 22 January 2013
Line 8:		Line 8:
	'''EPrints::Database::Pg''' - custom database methods for PostgreSQL DB		'''EPrints::Database::Pg''' - custom database methods for PostgreSQL DB

	~~<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>~~
	~~<span style='display:none'>User Comments</span>~~
	<!-- Edit below this comment -->		<!-- Edit below this comment -->


	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	~~</div>~~
	<!-- Pod2Wiki=head_description -->		<!-- Pod2Wiki=head_description -->
	==DESCRIPTION==		==DESCRIPTION==
	~~<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>~~
	~~<span style='display:none'>User Comments</span>~~
	<!-- Edit below this comment -->		<!-- Edit below this comment -->


	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	~~</div>~~
	<!-- Pod2Wiki=head_todo -->		<!-- Pod2Wiki=head_todo -->
	===TODO===		===TODO===
	~~<div style~~=~~'background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font~~-~~size: 80%~~; '>		* epadmin create
	~~<span style='display:none'>User Comments</span>~~		* $name = $db->index_name( $table, @columns )
	<!-- Edit below this comment -->		<!-- Edit below this comment -->


	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	~~</div>~~
	~~<!-- Pod2Wiki=item_epadmin_create -->~~
	~~====epadmin create====~~

	~~<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>~~
	~~<span style='display:none'>User Comments</span>~~
	~~<!-- Edit below this comment -->~~


	~~<!-- Pod2Wiki= -->~~
	~~</div>~~
	~~<!-- Pod2Wiki=item_index_name -->~~
	~~====$name = $db->index_name( $table, @columns )====~~

	~~<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>~~
	~~<span style='display:none'>User Comments</span>~~
	~~<!-- Edit below this comment -->~~


	~~<!-- Pod2Wiki= -->~~
	~~</div>~~
	<!-- Pod2Wiki=head_postgresql_specific_annoyances -->		<!-- Pod2Wiki=head_postgresql_specific_annoyances -->
	===PostgreSQL-specific Annoyances===		===PostgreSQL-specific Annoyances===
	The {{API:PodLink\|file=DBD/Pg\|package_name=DBD::Pg\|section=\|text=DBD::Pg}} SQL_VARCHAR type is mapped to text instead of varchar(n).		The {{API:PodLink\|file=DBD/Pg\|package_name=DBD::Pg\|section=\|text=DBD::Pg}} SQL_VARCHAR type is mapped to text instead of varchar(n).

	~~<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>~~
	~~<span style='display:none'>User Comments</span>~~
	<!-- Edit below this comment -->		<!-- Edit below this comment -->


	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	~~</div>~~
	<!-- Pod2Wiki=head_methods -->		<!-- Pod2Wiki=head_methods -->
	==METHODS==		==METHODS==
	~~<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>~~
	~~<span style='display:none'>User Comments</span>~~
	<!-- Edit below this comment -->		<!-- Edit below this comment -->


	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	~~</div>~~
	<!-- Pod2Wiki=head_copyright -->		<!-- Pod2Wiki=head_copyright -->
	==COPYRIGHT==		==COPYRIGHT==
	~~<div style='background~~-~~color~~: ~~#e8e8f; margin~~: 0.~~5em 0em 1em 0em; border: solid 1px #cce~~; ~~padding: 0em 1em 0em 1em; font-size: 80%; '>~~		Copyright 2000-2011 University of Southampton.
	~~<span style='display~~:~~none'>User Comments<~~/~~span>~~
			This file is part of EPrints http://www.eprints.org/.

			EPrints is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

			EPrints is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.

			You should have received a copy of the GNU Lesser General Public License along with EPrints. If not, see http://www.gnu.org/licenses/.

	<!-- Edit below this comment -->		<!-- Edit below this comment -->


	<!-- Pod2Wiki= -->		<!-- Pod2Wiki= -->
	~~</div>~~		<!-- Pod2Wiki=_postamble_ -->
	<!-- Pod2Wiki=_postamble_ --><!-- Edit below this comment -->		<!-- Edit below this comment -->

Tdb01r at 15:27, 16 December 2011

2011-12-16T15:27:09Z

← Older revision		Revision as of 15:27, 16 December 2011
Line 1:		Line 1:
	<!-- Pod2Wiki=_preamble_		<!-- Pod2Wiki=_preamble_
	This page has been automatically generated from the EPrints 3.2 source. Any wiki changes made between the 'Pod2Wiki=*' and 'Edit below this comment' comments will be lost.		This page has been automatically generated from the EPrints 3.2 source. Any wiki changes made between the 'Pod2Wiki=*' and 'Edit below this comment' comments will be lost.
	-->{{API}}{{Pod2Wiki}}{{API:Source\|file=EPrints/Database/Pg.pm\|package_name=EPrints::Database::Pg}}[[Category:API\|PG]][[Category:API:EPrints/Database\|PG]][[Category:API:EPrints/Database/Pg\|PG]]<div><!-- Edit below this comment -->		-->{{API}}{{Pod2Wiki}}{{API:Source\|file=perl_lib/EPrints/Database/Pg.pm\|package_name=EPrints::Database::Pg}}[[Category:API\|PG]][[Category:API:EPrints/Database\|PG]][[Category:API:EPrints/Database/Pg\|PG]]<div><!-- Edit below this comment -->

Tdb01r at 10:47, 25 August 2011

2011-08-25T10:47:46Z

← Older revision		Revision as of 10:47, 25 August 2011
Line 66:		Line 66:
	<!-- Pod2Wiki=head_methods -->		<!-- Pod2Wiki=head_methods -->
	==METHODS==		==METHODS==
			<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
			<span style='display:none'>User Comments</span>
			<!-- Edit below this comment -->


			<!-- Pod2Wiki= -->
			</div>
			<!-- Pod2Wiki=head_copyright -->
			==COPYRIGHT==
	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>
	<span style='display:none'>User Comments</span>		<span style='display:none'>User Comments</span>

Tdb01r at 13:07, 17 June 2010

2010-06-17T13:07:00Z

@@ Line 45: / Line 45: @@
 <!-- Pod2Wiki=item_index_name -->
 ====$name = $db-&gt;index_name( $table, @columns )====
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>

Tdb01r at 15:13, 25 February 2010

2010-02-25T15:13:44Z

← Older revision		Revision as of 15:13, 25 February 2010
Line 1:		Line 1:
	<!-- Pod2Wiki=_preamble_		<!-- Pod2Wiki=_preamble_
	This page has been automatically generated from the EPrints 3.2 source. Any wiki changes made between the 'Pod2Wiki=*' and 'Edit below this comment' comments will be lost.		This page has been automatically generated from the EPrints 3.2 source. Any wiki changes made between the 'Pod2Wiki=*' and 'Edit below this comment' comments will be lost.
	-->{{API}}{{Pod2Wiki}}{{API:Source\|file=EPrints/Database/Pg.pm\|package_name=EPrints::Database::Pg}}[[Category:API\|Pg]]<div><!-- Edit below this comment -->		-->{{API}}{{Pod2Wiki}}{{API:Source\|file=EPrints/Database/Pg.pm\|package_name=EPrints::Database::Pg}}[[Category:API\|PG]][[Category:API:EPrints/Database\|PG]][[Category:API:EPrints/Database/Pg\|PG]]<div><!-- Edit below this comment -->

Tdb01r at 13:35, 25 February 2010

2010-02-25T13:35:44Z

@@ Line 8: / Line 8: @@
 '''EPrints::Database::Pg''' - custom database methods for PostgreSQL DB
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
 <span style='display:none'>User Comments</span>

Tdb01r: Created page with '