| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/MySQL/MySQL Workbench 6.1 CE/modules/ |
Upload File : |
ó
,¢2Sc @ s2 d d l m Z m Z d d l Z d d l Z d d l m Z m Z m Z m Z m
Z
m Z m Z m
Z
m Z e d d d d d d ƒ Z e j d
d d d
e j ƒ g d d ƒe j e j e j j ƒ d „ ƒ ƒ Z d „ Z e j d d d d
e j ƒ g d d ƒe j e j e j j ƒ d „ ƒ ƒ Z d S( iÿÿÿÿ( t DefineModulet wbinputsN( t
node_valuet node_symbolt
node_childrent find_child_nodet find_child_nodest trim_astt ASTHelpert dump_treet flatten_nodet namet CodeUtilst authors Oracle Corp.t versions 1.0s wb.sqlide.copyAsPHPConnectt captions$ Copy as PHP Code (Connect to Server)t inputt
pluginMenus
SQL/Utilitiesc C sì | j rè | j } | j j d k ra i d d 6d d 6| j d d 6| j d d 6| j d 6} nT i | j d
d 6| j d rŒ | j d n d d 6| j d d 6d d 6| j d 6} d | } t j j | ƒ t j j ƒ j
d
ƒ n d S( sP Copies PHP code to connect to the active MySQL connection to the clipboard.
t MysqlNativeSockets p:localhostt hostiê t portt userNamet usert sockett dbnamet hostNamet s $host="%(host)s";
$port=%(port)s;
$socket="%(socket)s";
$user="%(user)s";
$password="";
$dbname="%(dbname)s";
$con = new mysqli($host, $user, $password, $dbname, $port, $socket)
or die ('Could not connect to the database server' . mysqli_connect_error());
//$con->close();
s Copied PHP code to clipboardi ( t
connectiont driverR t parameterValuest
defaultSchemat mformst Utilitiest set_clipboard_textt Appt gett set_status_text( t editort connt paramst text( ( sM C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\code_utils_grt.pyt copyAsPHPConnect s& !
c C sö d d l m } | j | ƒ } xÐ| D]È} t | ƒ t k rD q& q& | \ } } } } } } t | ƒ }
t |
d ƒ } | r& g } g }
d } x"t | ƒ D]} t | ƒ d k rœ t t | d ƒ d ƒ } | s”t | d ƒ } | rt t | ƒ ƒ d k rt | ƒ d } n t t | d
ƒ d ƒ } | r?t
| ƒ } q d } t | ƒ } | r d d l } | j
d | ƒ } | r‘| j ƒ d } q‘q n t
| ƒ } | j | ƒ qœ qœ Wt | ƒ } | j | ƒ \ } } | | | !} | } t | d
ƒ } xp t | ƒ D]b } | j | ƒ \ } } | | 8} | | 8} | | | !} | | d | | } |
j d | ƒ qWi } xn t | ƒ D]` \ } } | j | ƒ rÃd | | | f | | <| | c d 7<n | j | d ƒ d | | <q}W| | |
f Sq& Wd S( Niÿÿÿÿ( t MysqlSqlFacadet select_item_listi t select_itemt select_aliast identt simple_ident_qi t exprt fields ([a-zA-Z0-9_]*)t variablet ?s %s%ii ( t grt.modulesR* t parseAstFromSqlScriptt typet strR R R R t lenR R
t ret matcht groupst appendR t
get_ast_rangeR t reversedt insertt enumeratet has_keyR# ( t queryR* t ast_listt astt st vt ct _baset _begint _endt trimmed_astR+ t columnst variablest indext nodet aliasR. R R1 R9 t mt helpert begint endt offsett varst vart
duplicatest i( ( sM C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\code_utils_grt.pyt" _parse_column_name_list_from_query8 sd
s wb.sqlide.copyAsPHPQueryAndFetchs) Copy as PHP Code (Iterate SELECT Results)c
C s± | j p | j } t | ƒ } | r6 | \ } } } n d } d } | j d d ƒ j d d ƒ j ƒ } | j d ƒ r‚ | d } n d } d } | rd j g | D] } d | d ^ q¡ ƒ d } d d
t | ƒ d j g | D] } d | d ^ qß ƒ f } n | sd
d g } n d i | j d d ƒ d 6d j g | D] } d | ^ q>ƒ d 6d j d g t | ƒ ƒ d 6| d 6| d 6} t j
j | ƒ t j j
ƒ j d ƒ d S( s" Copies PHP code to execute the query and iterate its results to the clipboard. The code will substitute @variables with
parameter markers (?) and will bind them with matching PHP variables. The results will be bound to PHP variables matching
the SELECTed column names or their aliases.
s
t s
t ;iÿÿÿÿR s $%s = '';i s] $stmt->bind_param('%s', %s); //FIXME: param types: s- string, i- integer, d- double, b- blob
RE s , t $t field1t field2sý $query = "%(query)s";
%(vars)s
%(var_bind)s
if ($stmt = $con->prepare($query)) {
$stmt->execute();
$stmt->bind_result(%(column_list)s);
while ($stmt->fetch()) {
//printf("%(fmt_list)s\n", %(column_list)s);
}
$stmt->close();
}t "s \"RB s $%st column_lists %st fmt_listRV t var_binds Copied PHP code to clipboardi N( t selectedTextt scriptRZ t Nonet replacet stript endswitht joinR8 R R R! R" R# R$ (
t qbuffert sqlt rest column_namest variable_namest variable_assignmentst
variable_bindRW RG R( ( ( sM C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\code_utils_grt.pyt copyAsPHPQueryAndFetchy s. $
.A D ( t wbR R t grtR t sql_reformatterR R R R R R R R R
t
ModuleInfot plugint currentSQLEditort exportt INTt classest db_query_EditorR) RZ t currentQueryBuffert db_query_QueryBufferRr ( ( ( sM C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\code_utils_grt.pyt <module> s @'') A'