[Tͪ#n$;<:a4sX [Q 0nI0E 28e;b_ ()9 ^03/!'ӟ}e.zhfZsCOGOQ C %nR|y[epn\Mes~}Cfa"yũKQ~׍\M6٦Ǘ#4;)kv8P(kMldum]D +N]fbJqWu~sV '`'RV߯>ڋ:|WtfV^}8P^!(5PMR YlruD F.T.Rv*x[D7[gd8vpՎ3)(uvO̾Rk 4sCg^^?ܡxml8M.WfF:O v$aF-/MAD3wBo5[6Om;;+%gUXeZ 0\dց'B(?S(\}{7dݼ x(]gvPJ-2QLT~AN)B49xfD*$Og^%A1bncaLtK'mj_)}XKxwjGV|Lo$W `^O/ Jjk,a*eg)(ysrʅszZE}ť0\{Ĭ rF;£ ߵA$8Rs:P`"rr|+_ߪ:~:ϭ}@OD]yX'gn#8s sQīaLiSuevh{}TP;Fn䱮CI ?-$;"*_auEțJNx -WT67},RnFI  (Ok>Ʉ?&߸{Zc G٤I;/;ki*z8vcHds<-Ө[x[d]9nt.gZ[>2adߜH5o8Ih/JQMC\ TǶc_bKeZjE(:pr ɌkGa·JfBG|h➊MR(Ej';X;4=엶.ĥ ' Q\靬"g%z,FqO e 1xwϔ?|jM8myK&&oԚMe&alm7Arl,cAL+I~,8^XrNf.tNf`eӏsrU:H4hU!@Ȗm2j/(S{bY: +#YE\L|fz+5Ga+gGp ! vP&Ej槜DlUׁ3BLk(#mvPS4K5ڡ\o{^3fVsӞǷ&K8zSNGZw~p~γc =c3پ?\v' ^-EP4) ca8]͹輓|RD! YJDhr7mI1`nw̆7G;cT9) п͹輓|RD!*p;`f-8{Kau h Tq;*^@]vmdd-SA\lR0Q =@YFBWmhB㙞U:NyȍtI)ވWNsn3fL̝o*حٸ[)S oC];v~2,̭x Qn Y6]3)29@]n6vcfi~b VMQ8B(`&IL93~30 [s2!c^J 7_jCRa!s0{mByot I4Nkߋ_ 1ıi-YFoQjŜ9vY$wdd &eզr8޵y93~30 [s2#2f_uUB}[9H(]yG -g)vգԤVJE{b7PT)y<)v3\>yTڽ!AݍC0吝q@0F3Y(0F90q{0twz9Hi ^r|Z.xz eaYs[ڂnk SilXR/]\jt mZK2 9vwr _s!48Gt`)M9f*c6~.Y6CwD|31gZoRmn3N O~˛[  vȎ/׏ǛD$a &, ;tmzV5+ܞ+,}&z;%d"ɰÆgPpA>*l`P+yBx\{m's*qY(ilGU Ȩ,!+١i 4Ȏbh LSg_aFwRUVYy)km92v,oJqD@BG/X)Kd%,`VX "/Q+Giuؘ9 750ӌkX{9} Nͣ|ԑ6 YޔҺVBHL:@Y_%SۀsWp]\ᆻ0ub{CmB{jl`ARa2}y '8%Mf2ٚa5FI Iv nh[Widy9 K@6[J6vso^yʉw H5|CfT+R!ɤt, JD,Cq B@܁+ {6".JRI *fDD#mvPS4K5ڡ,(eK*]0umk|x9iGOm|劯Y5sqwi⏃-V!sG ʛ9夶4oncvHY6DY7-ѕ毕JGEF>'_+ lPƽctoDn!ݬZy8V "pQ7#ISb%)sSO.F<1ϱ{p9; zIL.2jgmJ S7#+6a҈&7cX"9V/FEj''}}l19-5˝/8^pb}MsҞ1t PcpsJ8XV5H/sS9h5ZS(M cHC.C.8O veyN&޼$xq?˳(}qZCpe 'server', 'database', 'table' * @param string $db_alias Aliases of db * * @return bool Whether it succeeded */ public function exportDBCreate($db, $export_type, $db_alias = '') { return true; } /** * Outputs the content of a table in NHibernate format * * @param string $db database name * @param string $table table name * @param string $crlf the end of line sequence * @param string $error_url the url to go back in case of error * @param string $sql_query SQL query for obtaining data * @param array $aliases Aliases of db/table/columns * * @return bool Whether it succeeded */ public function exportData( $db, $table, $crlf, $error_url, $sql_query, $aliases = array() ) { $CG_FORMATS = $this->_getCgFormats(); $CG_HANDLERS = $this->_getCgHandlers(); $format = $GLOBALS['codegen_format']; if (isset($CG_FORMATS[$format])) { $method = $CG_HANDLERS[$format]; return PMA_exportOutputHandler( $this->$method($db, $table, $crlf, $aliases) ); } return PMA_exportOutputHandler(sprintf("%s is not supported.", $format)); } /** * Used to make identifiers (from table or database names) * * @param string $str name to be converted * @param bool $ucfirst whether to make the first character uppercase * * @return string identifier */ public static function cgMakeIdentifier($str, $ucfirst = true) { // remove unsafe characters $str = preg_replace('/[^\p{L}\p{Nl}_]/u', '', $str); // make sure first character is a letter or _ if (!preg_match('/^\pL/u', $str)) { $str = '_' . $str; } if ($ucfirst) { $str = ucfirst($str); } return $str; } /** * C# Handler * * @param string $db database name * @param string $table table name * @param string $crlf line separator * @param array $aliases Aliases of db/table/columns * * @return string containing C# code lines, separated by "\n" */ private function _handleNHibernateCSBody($db, $table, $crlf, $aliases = array()) { $db_alias = $db; $table_alias = $table; $this->initAlias($aliases, $db_alias, $table_alias); $lines = array(); $result = $GLOBALS['dbi']->query( sprintf( 'DESC %s.%s', PMA\libraries\Util::backquote($db), PMA\libraries\Util::backquote($table) ) ); if ($result) { /** @var TableProperty[] $tableProperties */ $tableProperties = array(); while ($row = $GLOBALS['dbi']->fetchRow($result)) { $col_as = $this->getAlias($aliases, $row[0], 'col', $db, $table); if (!empty($col_as)) { $row[0] = $col_as; } $tableProperties[] = new TableProperty($row); } $GLOBALS['dbi']->freeResult($result); $lines[] = 'using System;'; $lines[] = 'using System.Collections;'; $lines[] = 'using System.Collections.Generic;'; $lines[] = 'using System.Text;'; $lines[] = 'namespace ' . ExportCodegen::cgMakeIdentifier($db_alias); $lines[] = '{'; $lines[] = ' #region ' . ExportCodegen::cgMakeIdentifier($table_alias); $lines[] = ' public class ' . ExportCodegen::cgMakeIdentifier($table_alias); $lines[] = ' {'; $lines[] = ' #region Member Variables'; foreach ($tableProperties as $tableProperty) { $lines[] = $tableProperty->formatCs( ' protected #dotNetPrimitiveType# _#name#;' ); } $lines[] = ' #endregion'; $lines[] = ' #region Constructors'; $lines[] = ' public ' . ExportCodegen::cgMakeIdentifier($table_alias) . '() { }'; $temp = array(); foreach ($tableProperties as $tableProperty) { if (!$tableProperty->isPK()) { $temp[] = $tableProperty->formatCs( '#dotNetPrimitiveType# #name#' ); } } $lines[] = ' public ' . ExportCodegen::cgMakeIdentifier($table_alias) . '(' . implode(', ', $temp) . ')'; $lines[] = ' {'; foreach ($tableProperties as $tableProperty) { if (!$tableProperty->isPK()) { $lines[] = $tableProperty->formatCs( ' this._#name#=#name#;' ); } } $lines[] = ' }'; $lines[] = ' #endregion'; $lines[] = ' #region Public Properties'; foreach ($tableProperties as $tableProperty) { $lines[] = $tableProperty->formatCs( ' public virtual #dotNetPrimitiveType# #ucfirstName#' . "\n" . ' {' . "\n" . ' get {return _#name#;}' . "\n" . ' set {_#name#=value;}' . "\n" . ' }' ); } $lines[] = ' #endregion'; $lines[] = ' }'; $lines[] = ' #endregion'; $lines[] = '}'; } return implode($crlf, $lines); } /** * XML Handler * * @param string $db database name * @param string $table table name * @param string $crlf line separator * @param array $aliases Aliases of db/table/columns * * @return string containing XML code lines, separated by "\n" */ private function _handleNHibernateXMLBody( $db, $table, $crlf, $aliases = array() ) { $db_alias = $db; $table_alias = $table; $this->initAlias($aliases, $db_alias, $table_alias); $lines = array(); $lines[] = ''; $lines[] = ''; $lines[] = ' '; $result = $GLOBALS['dbi']->query( sprintf( "DESC %s.%s", PMA\libraries\Util::backquote($db), PMA\libraries\Util::backquote($table) ) ); if ($result) { while ($row = $GLOBALS['dbi']->fetchRow($result)) { $col_as = $this->getAlias($aliases, $row[0], 'col', $db, $table); if (!empty($col_as)) { $row[0] = $col_as; } $tableProperty = new TableProperty($row); if ($tableProperty->isPK()) { $lines[] = $tableProperty->formatXml( ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' ); } else { $lines[] = $tableProperty->formatXml( ' ' . "\n" . ' ' . "\n" . ' ' ); } } $GLOBALS['dbi']->freeResult($result); } $lines[] = ' '; $lines[] = ''; return implode($crlf, $lines); } /* ~~~~~~~~~~~~~~~~~~~~ Getters and Setters ~~~~~~~~~~~~~~~~~~~~ */ /** * Getter for CodeGen formats * * @return array */ private function _getCgFormats() { return $this->_cgFormats; } /** * Setter for CodeGen formats * * @param array $CG_FORMATS contains CodeGen Formats * * @return void */ private function _setCgFormats($CG_FORMATS) { $this->_cgFormats = $CG_FORMATS; } /** * Getter for CodeGen handlers * * @return array */ private function _getCgHandlers() { return $this->_cgHandlers; } /** * Setter for CodeGen handlers * * @param array $CG_HANDLERS contains CodeGen handler methods * * @return void */ private function _setCgHandlers($CG_HANDLERS) { $this->_cgHandlers = $CG_HANDLERS; } }