| 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 @ sï d d l Td d l m Z d d l Z d d l Z d d l Z e d d d d d d ƒ Z e j d
d d d
e j d ƒ g d d d g ƒe j
e j e j j
ƒ d „ ƒ ƒ Z e j d d d d
e j d ƒ g d d d g ƒe j
e j e j j
ƒ d „ ƒ ƒ Z d „ Z d „ Z e j d d d d
e j ƒ g d d d g ƒe j
e j e j j ƒ d „ ƒ ƒ Z e j d d d ƒe j
e j ƒ d „ ƒ ƒ Z e j
e j e j ƒ d „ ƒ Z e j
e j j
e j j e j ƒ d „ ƒ Z d S( iÿÿÿÿ( t *( t AppNt namet WbTableUtilst authors
MySQL Teamt versions 1.0s# wb.table.util.copyInsertToClipboardt captions Copy Inserts to Clipboardt inputs db.Tablet groupss Catalog/Utilitiess Menu/Objectsc C sw | j ƒ } | d k rG t j j j | j ƒ ƒ t j ƒ j d ƒ n, t j ƒ j d | j j d | j d ƒ d S( Nt t Readys
The table t .s% has no records for insert statementsi (
t insertst grtt modulest Workbencht copyToClipboardR t gett set_status_textt ownerR ( t tableR ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt copyInsertToClipboard# s ,s+ wb.table.util.copyInsertTemplateToClipboards! Copy Insert Template to Clipboardc C sñ d | j j d | j d } d } xH | j D]= } | d k rU | d | j 7} n | d | j 7} d } q/ W| d 7} d } x: | j D]/ } | d k r© | d
7} n
| d
7} d } qŠ W| d 7} t j j j | ƒ t j ƒ j d ƒ d S( Ns
INSERT INTO `s `.`s ` (i i s `, `t `s `) VALUES (s , t NULLs );R
s , NULL(
R R t columnsR
R R R R R R ( R t codet firstt col( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt copyInsertTemplateToClipboard2 s$
c C sÍ g } | j ƒ j d ƒ } x« | D]£ } | j ƒ j d ƒ \ } } } g } xc | j ƒ j d ƒ D]L } | j ƒ j d ƒ \ } } }
| rb | j | j ƒ |
j ƒ f ƒ qb qb W| j | | f ƒ q" W| S( Ns
t t ,( t stript splitt partitiont append( R t defst tablest tR t sepR t column_defst columnt cnt ct( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt _parse_table_definitionsO s
&c C s» | j } | j d ƒ } | | _ x“ | D]‹ \ } } t j j ƒ } | | _ | j d ƒ re | d n | | _ | r‡ | j | | ƒ n | j | ƒ | j d ƒ r( | j
| ƒ q( q( W| S( Ns db.mysqlR i ( t simpleDatatypest addNewTableR R
t classest db_mysql_ColumnR t
startswitht setParseTypet addColumnt addPrimaryKeyColumn( t catalogt schemaR R t typest tblt cnamet ctypeR( ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt
_create_table_ s "
s wb.table.util.quickTabless Create Multiple Tablesc s² t j d t j ƒ ‰ t j d ƒ } t j t ƒ } | j d ƒ | j d ƒ | j | t t ƒ t j
t j ƒ } | j | t t ƒ ˆ j
| ƒ ˆ j d ƒ t j ƒ } | j d ƒ t j ƒ } | j d ƒ t j t ƒ } t j j | | | ƒ | j d ƒ | j | t t ƒ ˆ j d d ƒ ˆ j ƒ | j d } | j ‡ f d
† ƒ ˆ j d | ƒ r®t | j ƒ ƒ } x0 | D]( \ } }
| r~t | | | |
ƒ q~q~Wd Sd S( Nsì You can create multiple tables by giving their outline in the following format:
table1 *column1 int,column2 varchar(32),column3
table2 column1,column2
table3
...
* denotes a primary key column. Column type is optional.i s Create Multiple Tablest OKt Canceli iX i^ i c s
ˆ j t ƒ S( N( t end_modalt True( ( t form( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt <lambda>– s i ( t mformst Formt Nonet FormDialogFramet newLabelt newBoxt Falset set_spacingt set_paddingt addt
newTextBoxt VerticalScrollBarR> t set_contentt set_titlet newButtont set_textt Utilitiest add_end_ok_cancel_buttonst add_endt set_sizet centert schematat add_clicked_callbackt run_modalR+ t get_string_valueR: ( R4 t labelt boxt textt okt cancelt bboxR5 t tabledefsR R ( ( R? sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt quickTablesInCatalogq s<
s% wb.table.util.openTableTemplateEditors Open Table Templates Editorc C s t j ƒ j ƒ d S( Ni ( t table_templatest TableTemplateManagert edit_templates( ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt openTableTemplateEditor s c C s t j ƒ j | ƒ d S( Ni ( Rb Rc t
edit_template( R ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt openTableTemplateEditorFor§ s c C s t j ƒ j | | ƒ S( N( Rb Rc t$ create_table_like_template_in_schema( R5 t
template_name( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt createTableFromTemplate¬ s ( t wbRA R Rb R
t DefineModulet
ModuleInfot plugint wbinputst
objectOfClasst exportt INTR. t db_TableR R R+ R: t currentCatalogt
db_CatalogRa Re t STRINGRg t db_SchemaRj ( ( ( sN C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\modules\table_utils_grt.pyt <module> s"
0'0' -'. !