123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219 |
- <?php
- /**
- * sfMessageSource_Database class file.
- *
- * This program is free software; you can redistribute it and/or modify
- * it under the terms of the BSD License.
- *
- * Copyright(c) 2004 by Qiang Xue. All rights reserved.
- *
- * To contact the author write to {@link mailto:qiang.xue@gmail.com Qiang Xue}
- * The latest version of PRADO can be obtained from:
- * {@link http://prado.sourceforge.net/}
- *
- * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
- * @version $Id: sfMessageSource_Database.class.php 9128 2008-05-21 00:58:19Z Carl.Vondrick $
- * @package symfony
- * @subpackage i18n
- */
- /**
- * sfMessageSource_Database class.
- *
- * This is the base class for database based message sources like MySQL or SQLite.
- *
- * @author Xiang Wei Zhuo <weizhuo[at]gmail[dot]com>
- * @version v1.0, last update on Fri Dec 24 16:18:44 EST 2004
- * @package symfony
- * @subpackage i18n
- */
- abstract class sfMessageSource_Database extends sfMessageSource
- {
- /**
- * For a given DSN (database connection string), return some information about the DSN.
- *
- * This function comes from PEAR's DB package.
- *
- * @param string $dns DSN format, similar to PEAR's DB
- * @return array DSN information.
- */
- protected function parseDSN($dsn)
- {
- if (is_array($dsn))
- {
- return $dsn;
- }
- $parsed = array(
- 'phptype' => false,
- 'dbsyntax' => false,
- 'username' => false,
- 'password' => false,
- 'protocol' => false,
- 'hostspec' => false,
- 'port' => false,
- 'socket' => false,
- 'database' => false
- );
- // Find phptype and dbsyntax
- if (($pos = strpos($dsn, '://')) !== false)
- {
- $str = substr($dsn, 0, $pos);
- $dsn = substr($dsn, $pos + 3);
- }
- else
- {
- $str = $dsn;
- $dsn = NULL;
- }
- // Get phptype and dbsyntax
- // $str => phptype(dbsyntax)
- if (preg_match('|^(.+?)\((.*?)\)$|', $str, $arr))
- {
- $parsed['phptype'] = $arr[1];
- $parsed['dbsyntax'] = (empty($arr[2])) ? $arr[1] : $arr[2];
- }
- else
- {
- $parsed['phptype'] = $str;
- $parsed['dbsyntax'] = $str;
- }
- if (empty($dsn))
- {
- return $parsed;
- }
- // Get (if found): username and password
- // $dsn => username:password@protocol+hostspec/database
- if (($at = strrpos($dsn,'@')) !== false)
- {
- $str = substr($dsn, 0, $at);
- $dsn = substr($dsn, $at + 1);
- if (($pos = strpos($str, ':')) !== false)
- {
- $parsed['username'] = rawurldecode(substr($str, 0, $pos));
- $parsed['password'] = rawurldecode(substr($str, $pos + 1));
- }
- else
- {
- $parsed['username'] = rawurldecode($str);
- }
- }
- // Find protocol and hostspec
- // $dsn => proto(proto_opts)/database
- if (preg_match('|^([^(]+)\((.*?)\)/?(.*?)$|', $dsn, $match))
- {
- $proto = $match[1];
- $proto_opts = (!empty($match[2])) ? $match[2] : false;
- $dsn = $match[3];
- // $dsn => protocol+hostspec/database (old format)
- }
- else
- {
- if (strpos($dsn, '+') !== false)
- {
- list($proto, $dsn) = explode('+', $dsn, 2);
- }
- if (strpos($dsn, '/') !== false)
- {
- list($proto_opts, $dsn) = explode('/', $dsn, 2);
- }
- else
- {
- $proto_opts = $dsn;
- $dsn = null;
- }
- }
- // process the different protocol options
- $parsed['protocol'] = (!empty($proto)) ? $proto : 'tcp';
- $proto_opts = rawurldecode($proto_opts);
- if ($parsed['protocol'] == 'tcp')
- {
- if (strpos($proto_opts, ':') !== false)
- {
- list($parsed['hostspec'], $parsed['port']) = explode(':', $proto_opts);
- }
- else
- {
- $parsed['hostspec'] = $proto_opts;
- }
- }
- else if ($parsed['protocol'] == 'unix')
- {
- $parsed['socket'] = $proto_opts;
- }
- // Get dabase if any
- // $dsn => database
- if (!empty($dsn))
- {
- // /database
- if (($pos = strpos($dsn, '?')) === false)
- {
- $parsed['database'] = $dsn;
- // /database?param1=value1¶m2=value2
- }
- else
- {
- $parsed['database'] = substr($dsn, 0, $pos);
- $dsn = substr($dsn, $pos + 1);
- if (strpos($dsn, '&') !== false)
- {
- $opts = explode('&', $dsn);
- }
- else
- { // database?param1=value1
- $opts = array($dsn);
- }
- foreach ($opts as $opt)
- {
- list($key, $value) = explode('=', $opt);
- if (!isset($parsed[$key]))
- { // don't allow params overwrite
- $parsed[$key] = rawurldecode($value);
- }
- }
- }
- }
- return $parsed;
- }
- /**
- * Gets all the variants of a particular catalogue.
- *
- * @param string $catalogue catalogue name
- * @return array list of all variants for this catalogue.
- */
- public function getCatalogueList($catalogue)
- {
- $variants = explode('_', $this->culture);
- $catalogues = array($catalogue);
- $variant = null;
- for ($i = 0, $max = count($variants); $i < $max; $i++)
- {
- if (strlen($variants[$i]) > 0)
- {
- $variant .= $variant ? '_'.$variants[$i] : $variants[$i];
- $catalogues[] = $catalogue.'.'.$variant;
- }
- }
- return array_reverse($catalogues);
- }
- public function getId()
- {
- return md5($this->source);
- }
- }
|