API:EPrints/Database/mysql - Revision history

Pod2wiki at 23:47, 11 January 2022

2022-01-11T23:47:19Z

Pod2wiki at 23:46, 11 January 2022

2022-01-11T23:46:29Z

Pod2wiki at 23:45, 11 January 2022

2022-01-11T23:45:14Z

Pod2wiki at 20:08, 25 December 2021

2021-12-25T20:08:35Z

Pod2wiki at 14:15, 25 December 2021

2021-12-25T14:15:22Z

Show changes

Tdb01r at 09:56, 22 January 2013

2013-01-22T09:56:37Z

Show changes

Tdb01r at 15:27, 16 December 2011

2011-12-16T15:27:08Z

Tdb01r at 10:47, 25 August 2011

2011-08-25T10:47:45Z

Tdb01r at 15:13, 25 February 2010

2010-02-25T15:13:43Z

Tdb01r at 13:26, 25 February 2010

2010-02-25T13:26:20Z

@@ Line 60: / Line 60: @@
 <!-- Pod2Wiki=head_constants -->
 ==CONSTANTS==
-See [[API:EPrints/Database|EPrints::Database#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%; '>
@@ Line 71: / Line 71: @@
 <!-- Pod2Wiki=head_instance_variables -->
 ==INSTANCE VARIABLES==
-See [[API:EPrints/Database|EPrints::Database#INSTANCE_VARIABLES]].
+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%; '>

@@ Line 15: / Line 15: @@
 <!-- Pod2Wiki= -->
 </div>
-<!-- Pod2Wiki=head_synopsis -->
+<!-- Pod2Wiki=head_description -->
-==SYNOPSIS==
+==DESCRIPTION==
-  $c-&gt;{dbdriver} = 'mysql';
+MySQL database wrapper.
-  # $c-&gt;{dbhost} = 'localhost';
-  # $c-&gt;{dbport} = '3316';
+Foreign keys will be defined if you use a DB engine that supports them  (e.g. InnoDB).
-  $c-&gt;{dbname} = 'myrepo';
 <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>
@@ Line 32: / Line 28: @@
 <!-- Pod2Wiki= -->
 </div>
-<!-- Pod2Wiki=head_description -->
+<!-- Pod2Wiki=head_synopsis -->
-==DESCRIPTION==
+===Synopsis===
-MySQL database wrapper.
+    $c-&gt;{dbdriver} = 'mysql';
+    # $c-&gt;{dbhost} = 'localhost';
-Foreign keys will be defined if you use a DB engine that supports them  (e.g. InnoDB).
+    # $c-&gt;{dbport} = '3316';
+    $c-&gt;{dbname} = 'myrepo';
 <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>

@@ Line 36: / Line 36: @@
 MySQL database wrapper.
-Foreign keys will be defined if you use a DB engine that supports them (e.g. InnoDB).
+Foreign keys will be defined if you use a DB engine that supports them  (e.g. InnoDB).
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
@@ Line 50: / Line 50: @@
 MySQL is (by default) lax about truncation.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
@@ Line 426: / Line 448: @@
 This method gets the entire <tt>SHOW INDEX</tt> response and builds a  look-up table of keys with their <tt>ordered</tt> columns. This ensures even  if MySQL is weird and returns out of order results we won't break.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>

@@ Line 335: / Line 335: @@
   $sql = $db-&gt;prepare_regexp( $col, $value )
-The syntax used for regular expressions varies across databases. This method takes two quoted string and returns a SQL expression that will apply the quoted regexp <tt>$val</tt> to the quoted column <tt>$column</tt>.
+Oracle use the syntax:
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
@@ Line 401: / Line 405: @@
   $type_info = $db-&gt;type_info( $data_type )
 See {{API:PodLink|file=DBI|package_name=DBI|section=type_info|text=DBI/type_info}}.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>

@@ Line 1: / Line 1: @@
 <!-- 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.
-  -->{{API}}{{Pod2Wiki}}{{API:Source|file=EPrints/Database/mysql.pm|package_name=EPrints::Database::mysql}}[[Category:API|MYSQL]][[Category:API:EPrints/Database|MYSQL]][[Category:API:EPrints/Database/mysql|MYSQL]]<div><!-- Edit below this comment -->
+  -->{{API}}{{Pod2Wiki}}{{API:Source|file=perl_lib/EPrints/Database/mysql.pm|package_name=EPrints::Database::mysql}}[[Category:API|MYSQL]][[Category:API:EPrints/Database|MYSQL]][[Category:API:EPrints/Database/mysql|MYSQL]]<div><!-- Edit below this comment -->

← Older revision	Revision as of 13:26, 25 February 2010
Line 1:	Line 1:
	+	<!-- 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.
	+	-->{{API}}{{Pod2Wiki}}{{API:Source\|file=EPrints/Database/mysql.pm\|package_name=EPrints::Database::mysql}}[[Category:API\|mysql]]<div><!-- Edit below this comment -->

	+
	+	<!-- Pod2Wiki=_private_ --><!-- Pod2Wiki=head_name -->
	+	==NAME==
	+	'''EPrints::Database::mysql''' - custom database methods for MySQL 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 -->
	+
	+
	+	<!-- Pod2Wiki= -->
	+	</div>
	+	<!-- Pod2Wiki=head_description -->
	+	==DESCRIPTION==
	+	MySQL 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%; '>
	+	<span style='display:none'>User Comments</span>
	+	<!-- Edit below this comment -->
	+
	+
	+	<!-- Pod2Wiki= -->
	+	</div>
	+	<!-- Pod2Wiki=head_mysql_specific_annoyances -->
	+	===MySQL-specific Annoyances===
	+	MySQL does not support sequences.
	+
	+	MySQL is (by default) lax about truncation.
	+
	+	<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_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=item_get_server_version -->
	+	===get_server_version===
	+
	+	$version = $db->get_server_version
	+	Return the database server version.
	+
	+	<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_create_counters -->
	+	===create_counters===
	+
	+	$n = $db->create_counters()
	+	Create and initialise the counters.
	+
	+	<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_has_table -->
	+	===has_table===
	+
	+	$boolean = $db->has_table( $tablename )
	+	Return true if the a table of the given name exists in the database.
	+
	+	<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_has_column -->
	+	===has_column===
	+
	+	$boolean = $db->has_column( $tablename, $columnname )
	+	Return true if the a table of the given name has a column named $columnname in the database.
	+
	+	<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_has_counter -->
	+	===has_counter===
	+
	+	$success = $db->has_counter( $counter )
	+	Returns true if $counter exists.
	+
	+	<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_counter_next -->
	+	===counter_next===
	+
	+	$n = $db->counter_next( $counter )
	+	Return the next unused value for the named counter. Returns undef if the counter doesn't exist.
	+
	+	<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_counter_minimum -->
	+	===counter_minimum===
	+
	+	$db->counter_minimum( $counter, $value )
	+	Ensure that the counter is set no lower that $value. This is used when importing eprints which may not be in scrict sequence.
	+
	+	<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_counter_reset -->
	+	===counter_reset===
	+
	+	$db->counter_reset( $counter )
	+	Return the counter. Use with cautiuon.
	+
	+	<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=_postamble_ --><!-- Edit below this comment -->