| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
�
�"�Xc @ 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( ( sG C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( sG C:\Program Files\MySQL\MySQL Workbench 6.3 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( ( ( sG C:\Program Files\MySQL\MySQL Workbench 6.3 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 ( ( ( sG C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\code_utils_grt.pyt <module> s @'') A'