403Webshell
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/db_mssql_migration_grt.pyc
�
�"�Xcf@s�ddlZddlZddlmZddlZddlmZddlmZm	Z	eddddd	d
�Z
ddefd
defddefddefddefddefddefddefddefddefddefddefddefddefddefddefddefddefd defd!d"efd#d"efd$d"efd%defd&defd'defd(d)efd*d"efd+d,efd-defd.d/efd0d/efd1d2efd3d2efd4d/efd5d/efd6d7efd8d9efd:d;efd<d=efd>d?efd@dAefdBdCefdDdEefdFdGefdHdIefdJdKefdLdMefdNdOefdPdQefdRdSefdTdUefdVdWefdXdYefdZd[efd\d]efd^d_efd`daefdbdcefdddeefdfdgefdhdiefdjdkefdldmefdndoefdpdqefdrdsefdtduefdvdwefdxdyefdzd{efd|d}efd~defd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efd�d�efgdZ
d�ad�efd���YZe�Ze
jej�d���Ze
jejejejj�d���Ze
jejjejjejj�d���Ze
jejjejjejjejj�d���Ze
jejjejjejjejj�d���Ze
jejejjejjejj�d���Ze
jejj ejjejj!ejj�d���Z"e
jejj#ejjejj$ejj�d���Z%e
jejj&ejjejj'ejj�d���Z(e
jejj)ejjejj*ejj�d���Z+e
jejjejjejj�d���Z,e
jej-ejj.fejj�d���Z/dS(�i����N(tDefineModule(tGenericMigration(tfind_object_with_nametVersiontnametDbMssqlMigrationtauthorsOracle Corp.tversions1.0tSQL_Latin1_General_Cp437_BINtutf8_general_citSQL_Latin1_General_Cp437_CS_AStSQL_Latin1_General_Cp437_CI_ASt#SQL_Latin1_General_Pref_CP437_CI_AStSQL_Latin1_General_Cp437_CI_AItSQL_Latin1_General_Cp850_BINtutf8_bintSQL_Latin1_General_Cp850_CS_AStSQL_Latin1_General_Cp850_CI_ASt#SQL_Latin1_General_Pref_CP850_CI_AStSQL_Latin1_General_Cp850_CI_AItSQL_1Xcompat_CP850_CI_AStLatin1_General_BINt
latin1_bintSQL_Latin1_General_Cp1_CS_AStSQL_Latin1_General_Cp1_CI_ASt!SQL_Latin1_General_Pref_CP1_CI_AStSQL_Latin1_General_Cp1_CI_AItSQL_AltDiction_Cp850_CS_AStSQL_AltDiction_Pref_CP850_CI_AStSQL_AltDiction_Cp850_CI_AIt!SQL_Scandinavian_Pref_Cp850_CI_AStutf8_swedish_citSQL_Scandinavian_Cp850_CS_AStSQL_Scandinavian_Cp850_CI_AStSQL_AltDiction_Cp850_CI_AStLatin1_General_CS_AStLatin1_General_CI_AStDanish_Norwegian_CS_AStutf8_danish_citFinnish_Swedish_CS_AStIcelandic_CS_AStutf8_icelandic_cit
Hungarian_BINtSQL_Latin1_General_Cp1250_CS_AStcp1250_general_citSQL_Latin1_General_Cp1250_CI_AStSQL_Czech_Cp1250_CS_AStcp1250_czech_cstSQL_Czech_Cp1250_CI_AStSQL_Hungarian_Cp1250_CS_AStSQL_Hungarian_Cp1250_CI_AStSQL_Polish_Cp1250_CS_AStsql_polish_cp1250_cs_astSQL_Polish_Cp1250_CI_AStsql_polish_cp1250_ci_astSQL_Romanian_Cp1250_CS_AStsql_romanian_cp1250_cs_astSQL_Romanian_Cp1250_CI_AStsql_romanian_cp1250_ci_astSQL_Croatian_Cp1250_CS_AStsql_croatian_cp1250_cs_astSQL_Croatian_Cp1250_CI_AStsql_croatian_cp1250_ci_astSQL_Slovak_Cp1250_CS_AStsql_slovak_cp1250_cs_astSQL_Slovak_Cp1250_CI_AStsql_slovak_cp1250_ci_astSQL_Slovenian_Cp1250_CS_AStsql_slovenian_cp1250_cs_astSQL_Slovenian_Cp1250_CI_AStsql_slovenian_cp1250_ci_astCyrillic_General_BINtcyrillic_general_bintSQL_Latin1_General_Cp1251_CS_AStsql_latin1_general_cp1251_cs_astSQL_Latin1_General_Cp1251_CI_AStsql_latin1_general_cp1251_ci_astSQL_Ukrainian_Cp1251_CS_AStsql_ukrainian_cp1251_cs_astSQL_Ukrainian_Cp1251_CI_AStsql_ukrainian_cp1251_ci_ast	Greek_BINt	greek_bintSQL_Latin1_General_Cp1253_CS_AStsql_latin1_general_cp1253_cs_astSQL_Latin1_General_Cp1253_CI_AStsql_latin1_general_cp1253_ci_astSQL_MixDiction_Cp1253_CS_AStsql_mixdiction_cp1253_cs_astSQL_AltDiction_Cp1253_CS_AStsql_altdiction_cp1253_cs_astSQL_Latin1_General_Cp1253_CI_AItsql_latin1_general_cp1253_ci_aitTurkish_BINtturkish_bintSQL_Latin1_General_Cp1254_CS_AStsql_latin1_general_cp1254_cs_astSQL_Latin1_General_Cp1254_CI_AStsql_latin1_general_cp1254_ci_ast
Hebrew_BINt
hebrew_bintSQL_Latin1_General_Cp1255_CS_AStsql_latin1_general_cp1255_cs_astSQL_Latin1_General_Cp1255_CI_AStsql_latin1_general_cp1255_ci_ast
Arabic_BINt
arabic_bintSQL_Latin1_General_Cp1256_CS_AStsql_latin1_general_cp1256_cs_astSQL_Latin1_General_Cp1256_CI_AStsql_latin1_general_cp1256_ci_astSQL_Latin1_General_Cp1257_CS_AStsql_latin1_general_cp1257_cs_astSQL_Latin1_General_Cp1257_CI_AStsql_latin1_general_cp1257_ci_astSQL_Estonian_Cp1257_CS_AStsql_estonian_cp1257_cs_astSQL_Estonian_Cp1257_CI_AStsql_estonian_cp1257_ci_astSQL_Latvian_Cp1257_CS_AStsql_latvian_cp1257_cs_astSQL_Latvian_Cp1257_CI_AStsql_latvian_cp1257_ci_astSQL_Lithuanian_Cp1257_CS_AStsql_lithuanian_cp1257_cs_astSQL_Lithuanian_Cp1257_CI_AStsql_lithuanian_cp1257_ci_astSQL_Danish_Pref_Cp1_CI_AStsql_danish_pref_cp1_ci_astSQL_SwedishPhone_Pref_Cp1_CI_AStsql_swedishphone_pref_cp1_ci_astSQL_SwedishStd_Pref_Cp1_CI_AStsql_swedishstd_pref_cp1_ci_astSQL_Icelandic_Pref_Cp1_CI_AStsql_icelandic_pref_cp1_ci_astJapanese_BINtjapanese_bintJapanese_CI_AStjapanese_ci_astKorean_Wansung_BINtkorean_wansung_bintKorean_Wansung_CI_AStkorean_wansung_ci_astChinese_Taiwan_Stroke_BINtchinese_taiwan_stroke_bintChinese_Taiwan_Stroke_CI_AStchinese_taiwan_stroke_ci_astChinese_PRC_BINtchinese_prc_bintChinese_PRC_CI_AStchinese_prc_ci_astJapanese_CS_AStjapanese_cs_astKorean_Wansung_CS_AStkorean_wansung_cs_astChinese_Taiwan_Stroke_CS_AStchinese_taiwan_stroke_cs_astChinese_PRC_CS_AStchinese_prc_cs_astThai_BINtthai_bint
Thai_CI_ASt
thai_ci_ast
Thai_CS_ASt
thai_cs_astSQL_EBCDIC037_CP1_CS_AStsql_ebcdic037_cp1_cs_astSQL_EBCDIC273_CP1_CS_AStsql_ebcdic273_cp1_cs_astSQL_EBCDIC277_CP1_CS_AStsql_ebcdic277_cp1_cs_astSQL_EBCDIC278_CP1_CS_AStsql_ebcdic278_cp1_cs_astSQL_EBCDIC280_CP1_CS_AStsql_ebcdic280_cp1_cs_astSQL_EBCDIC284_CP1_CS_AStsql_ebcdic284_cp1_cs_astSQL_EBCDIC285_CP1_CS_AStsql_ebcdic285_cp1_cs_astSQL_EBCDIC297_CP1_CS_AStsql_ebcdic297_cp1_cs_asitMSSQLMigrationcBsSeZed�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
RS(c	CsCtjdtj�}|}d}|jd�r?|jd�s]|jd�rm|jd�rm|dd!}n|r�|j|�r�|jtjdd	��}d
||f}nt	|�dkr�t
d7a
|}|d tt
�}|d
||f7}n|r?|r?tj
j�}d|_||_|jj|�n|S(Ns
^[^/\\.]+$tt"t[t]ii����s/\.t___u�Schema and table names cannot contain "/", "\", ".", or characters that are not permitted in file names. The identifier [%s] was changed to `%s`. i@i>u.Identifier `%s` is too long, truncated to `%s`(tretcompiletUt
startswithtendswithtmatcht	translatetstringt	maketranstlenttruncated_identifier_serialtstrtgrttclassestGrtLogEntryt	entryTypeRtentriestappend(	tselft
mssql_nametlogtdots_allowedtmysql_valid_regext
mysql_nametlog_messagetoriginal_mysql_nametentry((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pytmigrateIdentifier�s*
		cCsUtt|�j|||�}|j||jj|jj||�\|_|_|S(N(tsuperR�tmigrateTableToMySQLtmigrateCharsetCollationtownertdefaultCharacterSetNametdefaultCollationName(R�tstatetsourceTablettargetSchemattargetTable((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR��s3cCs|}|jr|jj}|dkr?|dkr�d}q�nh|d
kr�|jdkr�d}t|jjd�|_d|_|jd||d||f�q�n|r|jd	�r||kryt	|�Wqd
}|jd||d|�qXqn|S(Nt	TIMESTAMPs	getdate()tCURRENT_TIMESTAMPtDATETIMEt
SMALLDATETIMEi����is=Default value is %s, so type was changed from %s to TIMESTAMPt'R�is!Default value %s is not supported(sDATETIMER�(
t
simpleTypeRtdefaultValueRt
targetCatalogtsimpleDatatypestlengthtaddMigrationLogEntryR�tfloat(R�R�t
default_valuet
source_columnt
target_columnttarget_default_valuetsource_datatype((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pytmigrateColumnDefaultValue�s*		"c
Cs_|j}td�|jD��}|j}|r`|jr`|jj}|jj|jj�n|r(tj	|j
�}|jj�}t
jdd|j||jf�d}	|dEkr�|jddd�r�d	|_n|dFkrJ|jdkrd}	q�d|jkod
knr)d
}	q�|j
jdkrAdnd
}	nn|dGkr_d}	nY|dHkr�d|jko�d
knr�d}	q�d}	n|dIkr�|}	d|_n�|dkr�|}	d|_d|jkr�|jjd�q�n�|dkr`d
}	d|_d|jkr7|jjd�n|jd||d||	|jf�nX|dkr�d
}	d|_|jd||d||	|jf�n|dJkr"|jdkrd}	|jdkr�d}	n0|jdkr�d}	n|jd kr
d}	nd|_q�d}	n�|d!kr7d"}	n�|d"krg|jd#kr�d$}	d|_q�nQ|dKkr�d}	|jj|_|jj|_n|d'kr�d(}	n	|d)kr�|jdkr�d(}	n�|dLkr6d*}	d|_|jdd.d/�r�|d+kr�|jdkr'|jnd.|_q�n�|dMkrZ|jrQd2nd)}	n^|d3krxd3}	d|_n@|d4kr�d4}	d|_|jdd.d/�r�|jdkr�|jnd.|_q�n�|d5krd}	d6|_|jd||d7�n�|d8kr.d}	|jd||d9�n�|dNkrCd:}	nu|d<krwd
}	d=|_|jd6||d>�nA|d?kr�d}	|jd6||d||	|jf�n|}	|j|	�r�||	|_nMt
jdd@dA|	|f�|jdB||dC|j|jj|f�tStS|jdB||dD|j|jj|jf�tStS(ONcss$|]}|jj�|fVqdS(N(Rtupper(t.0tdatatype((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pys	<genexpr>�st	Migrations4Migrating source column '%s' - type: %s, length: %s
R�tNCHARtNVARCHARiitutf8mb4tVARCHARi����tLONGTEXTitTEXTtNTEXTtCHARtBIGINTtINTtSMALLINTtTINYINTtUNSIGNEDtUNIQUEIDENTIFIERi@tUNIQUEs,Source column type %s was migrated to %s(%s)tSYSNAMEi�tDECIMALtNUMERICit	MEDIUMINTi
tREALtFLOATitDOUBLEtMONEYt
SMALLMONEYtIMAGEtLONGBLOBt	VARBINARYR�R�t	DATETIME2tDATETIMEOFFSETiiR�t
ROWVERSIONtBINARYtDATEtTIMEtBITis1Source column type BIT was migrated to TINYINT(1)tXMLs+Source column type XML was migrated to TEXTtGEOMETRYt	GEOGRAPHYtHIERARCHYIDi�s;Source column type HIERARCHYID was migrated to VARCHAR(255)tSQL_VARIANTs MSSQL migrateTableColumnsToMySQLs#Can't find datatype %s for type %s
is<Could not migrate column "%s" in "%s": Unknown datatype "%s"s2Could not migrate type of column "%s" in "%s" (%s)(sNCHARsNVARCHAR(sVARCHARsNVARCHAR(sTEXTR�(sCHARsNCHAR(sBIGINTsINTsSMALLINT(sDECIMALsNUMERIC(R
R(sDATETIMEs
SMALLDATETIMERR(s	TIMESTAMPR(RR( R�tdictR�R�tuserTypet
actualTypetflagstextendRtfromgrtRRR�R�t
log_debug3R�t#is_supported_mysql_version_at_leasttcharacterSetNametmajorNumbert	precisionR�R�tscaletnumericPrecisiontnumericScalet	isNotNullthas_keytlog_warningR�tFalsetTruetformattedRawType(
R�R�R�R�R�tmysql_simpleTypestsource_typettarget_versionR�ttarget_datatype((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pytmigrateDatatypeForColumn�s�		#!		!														!'	'	

		
 c
Cs,x%|jD]}x|jD]}x�|jD]�}d&}d&}|j|�}|rftj||�}n|r*|r*|jjj	�}	|d'kr�|dkr�|j
dks�|j
dkr�d}q�d|j
}q�n|d(kr�|dkr�d	}q�n�|d)kr%|d
kr�d|j
}q�n�|d
kr:d}n�|dkrOd}n�|d*kr�|jdkr�d|	dkrdn|	}q�ni|dkr�d}nT|d+kr�d}n?|dkr�d}n*|dkr�d}n|d,kr�d#}n|rd$||jj
d%|j<qq*q*WqWq
W|S(-s]
        Create datatype cast expression for target column based on source datatype.
        R�R�i�i����sCAST(? as NVARCHAR(MAX))sCAST(? as NVARCHAR(%d))R�R�sCAST(? as NTEXT)R�R�sCAST(? as NCHAR(%d))RsCAST(? as VARCHAR(64))RsCAST(? as VARCHAR(128))RRis
CAST(? as %s)R	RRsCAST(? as NVARCHAR(max))RRs?.STAsText()RsCAST(? as VARCHAR(max))RRRR�RsCONVERT(VARBINARY(MAX), ?, 0)s%s as ?scolumnTypeCastExpression:%sN(sVARCHARsNVARCHAR(sTEXTsNTEXT(sCHARsNCHAR(sDECIMALsNUMERIC(sGEOMETRYs	GEOGRAPHY(sBINARYs	VARBINARYs	TIMESTAMPs
ROWVERSION(tschematattablestcolumnstNonetlookupSourceObjectRtgetColumnDataTypeR�RR�R�R)R�t
customData(
R�R�ttarget_catalogR�R�R�ttype_cast_expressionR�R�R5((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pytmigrateUpdateForChangesXsR			"					-cCs.|r$|jd||d|�dS||fS(Nis(Collation %s migrated to utf8_general_ciR�R	(R�R	(R�(R�R�tcharsett	collationt
source_objectt
target_object((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR��s
cCsXtj||||�}|rT|jrT|jj}|dkrQ|j|_qQqTn|S(NRRRR�(sINTsTINYINTsSMALLINTsBIGINT(RtmigrateTableColumnToMySQLR�Rtidentityt
autoIncrement(R�R�R�R�R�R�((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRE�s	cCstj||||�}|S(N(RtmigrateTableForeignKeyToMySQL(R�R�t	source_fkR�t	target_fk((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRH�s(t__name__t
__module__R/R�R�R�R6R@R�RERH(((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR��s			�	5			cCsdS(NtMssql((((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pytgetTargetDBMSName�scCstj||�S(N(tinstanceR�(RR�((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR��scCstj||�S(N(ROtmigrateCatalog(R�t
sourceCatalog((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRP�scCstj|||�S(N(ROt
migrateSchema(R�tsourceSchemaR�((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRR�scCstj|||�S(N(ROR�(R�R�t
target_schema((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR��scCstj|||�S(N(ROtmigrateTableToMySQL2ndPass(R�R�R�((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRU�scCstj|||�S(N(RORH(R�RIR�((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRH�scCstj|||�S(N(ROtmigrateTriggerToMySQL(R�tsource_triggerttarget_table((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRV�scCstj|||�S(N(ROtmigrateViewToMySQL(R�tsource_viewRT((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyRY�scCstj|||�S(N(ROtmigrateRoutineToMySQL(R�tsource_routineRT((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR[�scCstj||�S(N(ROR@(R�R>((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyR@�scCs"tjtjtjjj�}|S(N(R�tListtOBJECTR�tdb_migration_MigrationParametert__grtclassname__(R�tlist((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pytgetMigrationOptions�s(0R�R�twbRR�tdb_generic_migration_grtRtworkbench.utilsRRt
ModuleInfoR/R0tMSSQL_COLLATION_MAPR�R�ROtexporttSTRINGRNR�tGrtLogObjectR�t
db_Catalogtdb_migration_MigrationRPt	db_SchemaRRtdb_TableR�RRUtdb_mysql_ForeignKeyt
db_ForeignKeyRHtdb_mysql_Triggert
db_TriggerRVt
db_mysql_Viewtdb_ViewRYtdb_mysql_Routinet
db_RoutineR[R@tLISTR_Rb(((sOC:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.pyt<module>s��*	*099699990

Youez - 2016 - github.com/yon3zu
LinuXploit