📄 dblook_test.out
字号:
INTEGER NOT NULLnullnull<autoincval>11----T4_2I1INTEGER2<systemid><autoincval>nullnull----T4_2J2INTEGER NOT NULLnullnull<autoincval>nullnull----T4_2K3INTEGER NOT NULLGENERATED_BY_DEFAULT<systemid><autoincval>11----T8FKCHAR2CHAR(5)nullnull<autoincval>nullnull----T8SOMEINT1INTEGER NOT NULLnullnull<autoincval>nullnull----tWithKeysC1CHAR(5) NOT NULLnullnull<autoincval>nullnull----tWithKeysI2INTEGERnullnull<autoincval>nullnull----tWithKeysVC3VARCHAR(10)nullnull<autoincval>nullnull------- Columns for Statements ---========== SYSCONGLOMERATES ==========BARMULTI WORD NAME<systemnumber>MULTI WORD NAMEfalsenullfalse<systemid>----BART1<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BART1<systemnumber>T1falsenullfalse<systemid>----BART3<systemnumber>IX2trueBTREE (1 DESC, 3 DESC)false<systemid>----BART3<systemnumber>T3falsenullfalse<systemid>----BART3_2<systemnumber>T3_2falsenullfalse<systemid>----BART4<systemnumber>IX4trueUNIQUE BTREE (3)false<systemid>----BART4<systemnumber>T4falsenullfalse<systemid>----BART4_2<systemnumber>T4_2falsenullfalse<systemid>----BART8<systemnumber><systemname>trueBTREE (2)true<systemid>----BART8<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BART8<systemnumber>T8falsenullfalse<systemid>----BARtWithKeys<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BARtWithKeys<systemnumber>IX3trueBTREE (1 DESC)false<systemid>----BARtWithKeys<systemnumber>tWithKeysfalsenullfalse<systemid>----========== SYSCONSTRAINTS ==========<systemname>T8<systemname>FBARE0----<systemname>T8<systemname>PBARE0----<systemname>tWithKeys<systemname>CBARE0----<systemname>tWithKeys<systemname>PBARE1----NOTEVILtWithKeysNOTEVILCBARE0----UNQT1UNQUBARE0----========== SYSDEPENDS ==========<systemname><Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname>Constraint<systemname>Constraint----<systemid><StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8StoredPreparedStatementT8Table----<systemid><Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>BAR.REFTRIG -> <Table>BAR.T8TriggerT8Table----========== SYSFILES ==================== SYSFOREIGNKEYS ==========<systemname><systemid><systemname>UR----========== SYSKEYS ==========<systemname><systemid>----<systemname><systemid>----UNQ<systemid>----========== SYSSCHEMAS ==========APPAPPAPP----BARBARAPP----========== SYSSTATEMENTS ==========<systemid><systemname>BART<validityflag>select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE <systemid>APPnull----========== SYSTABLES ==========MULTI WORD NAMEMULTI WORD NAMETBARR----SYNONYM2SYNONYM2ABARR----SYNONYM3SYNONYM3ABARR----T1T1TBARR----T3T3TBARR----T3_2T3_2TBARR----T4T4TBARR----T4_2T4_2TBARR----T8T8TBARR----tWithKeystWithKeysTBARR----========== SYSTRIGGERS ==========<systemid>REFTRIGBAR<systemid>DASET8null<systemid>nullselect * from oldtabletruefalseOLDTABLEnull----========== SYSVIEWS ==========Database 'wombat_new' deleted.--*******************************************Dumping DDL for all objects with schema 'BAR'that are related to tables 'T3', 'tWithKeys',and 'MULTI WORD NAME':*******************************************File dblook.log was empty.Creating database 'wombat_new' from ddl script 'wombat.sql'Dumping system tables for 'wombat_new'----------------=================---------------System Tables for: wombat_new----------------=================---------------========== SYSALIASES ==========<systemid>SYNONYM2BARnullSSfalse"BAR"."MULTI WORD NAME"<systemname>----<systemid>SYNONYM3BARnullSSfalse"APP"."T11"<systemname>----========== SYSCHECKS ==========<systemname>(i > 0)(2)----NOTEVIL(vc != 'evil')(3)----========== SYSCOLUMNS ==========--- Columns for Tables ---MULTI WORD NAMEC1CHAR(2)nullnull<autoincval>nullnull----T3B2BLOB(20)nullnull<autoincval>nullnull----T3ID3INTEGER NOT NULLnullnull<autoincval>24----T3P11VARCHAR(10)'okie'<systemid><autoincval>nullnull----tWithKeysC1CHAR(5) NOT NULLnullnull<autoincval>nullnull----tWithKeysI2INTEGERnullnull<autoincval>nullnull----tWithKeysVC3VARCHAR(10)nullnull<autoincval>nullnull------- Columns for Statements ---========== SYSCONGLOMERATES ==========BARMULTI WORD NAME<systemnumber>MULTI WORD NAMEfalsenullfalse<systemid>----BART3<systemnumber>IX2trueBTREE (1 DESC, 3 DESC)false<systemid>----BART3<systemnumber>T3falsenullfalse<systemid>----BARtWithKeys<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BARtWithKeys<systemnumber>IX3trueBTREE (1 DESC)false<systemid>----BARtWithKeys<systemnumber>tWithKeysfalsenullfalse<systemid>----========== SYSCONSTRAINTS ==========<systemname>tWithKeys<systemname>CBARE0----<systemname>tWithKeys<systemname>PBARE0----NOTEVILtWithKeysNOTEVILCBARE0----========== SYSDEPENDS ==================== SYSFILES ==================== SYSFOREIGNKEYS ==================== SYSKEYS ==========<systemname><systemid>----========== SYSSCHEMAS ==========APPAPPAPP----BARBARAPP----========== SYSSTATEMENTS ==================== SYSTABLES ==========MULTI WORD NAMEMULTI WORD NAMETBARR----SYNONYM2SYNONYM2ABARR----SYNONYM3SYNONYM3ABARR----T3T3TBARR----tWithKeystWithKeysTBARR----========== SYSTRIGGERS ==================== SYSVIEWS ==========Database 'wombat_new' deleted.--*******************************************Dumping DDL for all objects related to 'T1'and 'TWITHKEYS':*******************************************File dblook.log was empty.Creating database 'wombat_new' from ddl script 'wombat.sql'FAILED: to execute cmd from DDL script:create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as bTable 'BAR.T3' does not exist.Dumping system tables for 'wombat_new'----------------=================---------------System Tables for: wombat_new----------------=================---------------========== SYSALIASES ==========<systemid>SYNONYM1APPnullSSfalse"APP"."T1"<systemname>----<systemid>SYNONYM2BARnullSSfalse"BAR"."MULTI WORD NAME"<systemname>----<systemid>SYNONYM3BARnullSSfalse"APP"."T11"<systemname>----========== SYSCHECKS ==================== SYSCOLUMNS ==========--- Columns for Tables ---T1C2CHAR(8)nullnull<autoincval>nullnull----T1C2CLOB(15)nullnull<autoincval>nullnull----T1D3DATEnullnull<autoincval>nullnull----T1F4DOUBLE NOT NULLnullnull<autoincval>nullnull----T1I1INTEGERnullnull<autoincval>nullnull----T1P11VARCHAR(10) NOT NULLnullnull<autoincval>nullnull----V2C2CLOB(15)nullnull<autoincval>nullnull----V2P11VARCHAR(10) NOT NULLnullnull<autoincval>nullnull------- Columns for Statements ---========== SYSCONGLOMERATES ==========APPT1<systemnumber>IX1trueBTREE (4, 1)false<systemid>----APPT1<systemnumber>T1falsenullfalse<systemid>----BART1<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----BART1<systemnumber>T1falsenullfalse<systemid>----========== SYSCONSTRAINTS ==========UNQT1UNQUBARE0----========== SYSDEPENDS ==========<systemid><StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1StoredPreparedStatementT1Table----<systemid><Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1TriggerT1Table----V2<View>APP.V2 -> <ColumnsInTable>BAR.T1ViewT1ColumnsInTable----========== SYSFILES ==================== SYSFOREIGNKEYS ==================== SYSKEYS ==========UNQ<systemid>----========== SYSSCHEMAS ==========APPAPPAPP----BARBARAPP----Foo BarFoo BarAPP----========== SYSSTATEMENTS ==========<systemid><systemname>Foo BarT<validityflag>values (1), (2)<systemid>APPnull----========== SYSTABLES ==========SYNONYM1SYNONYM1AAPPR----SYNONYM2SYNONYM2ABARR----SYNONYM3SYNONYM3ABARR----T1T1TAPPR----T1T1TBARR----V2V2VAPPR----========== SYSTRIGGERS ==========<systemid>TRIG2Foo Bar<systemid>DBSET1null<systemid>nullvalues (1), (2)falsefalsenullnull----========== SYSVIEWS ==========V2create view v2 as select * from bar.t1NAPP----Database 'wombat_new' deleted.--*******************************************Dumping DDL for all objects with schema'"Quoted"Schema"':*******************************************File dblook.log was empty.Creating database 'wombat_new' from ddl script 'wombat.sql'Dumping system tables for 'wombat_new'----------------=================---------------System Tables for: wombat_new----------------=================---------------========== SYSALIASES ==================== SYSCHECKS ==================== SYSCOLUMNS ==========--- Columns for Tables ---tee""HeeN1CHAR(1) NOT NULLnullnull<autoincval>nullnull------- Columns for Statements ---========== SYSCONGLOMERATES =========="Quoted"Schema"tee""Hee<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>----"Quoted"Schema"tee""Hee<systemnumber>Ix"5trueBTREE (1 DESC)false<systemid>----"Quoted"Schema"tee""Hee<systemnumber>tee""Heefalsenullfalse<systemid>----========== SYSCONSTRAINTS ==========<systemname>tee""Hee<systemname>P"Quoted"Schema"E0----========== SYSDEPENDS ==========<systemid><StoredPreparedStatement>"Quoted"Schema".<sysname> -> <Table>"Quoted"Schema".tee""HeeStoredPreparedStatementtee""HeeTable----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname>Trigger<systemid>StoredPreparedStatement----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""HeeTriggertee""HeeTable----========== SYSFILES ==================== SYSFOREIGNKEYS ==================== SYSKEYS ==========<systemname><systemid>----========== SYSSCHEMAS =========="Quoted"Schema""Quoted"Schema"APP----APPAPPAPP----========== SYSSTATEMENTS ==========<systemid><systemname>"Quoted"Schema"T<validityflag>values(8)<systemid>APPnull----========== SYSTABLES ==========tee""Heetee""HeeT"Quoted"Schema"R----========== SYSTRIGGERS ==========<systemid>"trig"One""Quoted"Schema"<systemid>IAREtee""Heenull<systemid>nullvalues(8)falsefalsenullnull----========== SYSVIEWS ==========Database 'wombat_new' deleted.--*******************************************Dumping DDL w/ invalid url, and writingerror to the log:*******************************************File dblook.log was NOT empty. Contents are:############## Begin File Contents ################java.sql.SQLException: No suitable driver-- **--> DEBUG: No suitable driver############## End File Contents ################Creating database 'wombat_new' from ddl script 'wombat.sql'Dumping system tables for 'wombat_new'----------------=================---------------System Tables for: wombat_new----------------=================---------------========== SYSALIASES ==================== SYSCHECKS ==================== SYSCOLUMNS ==========--- Columns for Tables ------ Columns for Statements ---========== SYSCONGLOMERATES ==================== SYSCONSTRAINTS ==================== SYSDEPENDS ==================== SYSFILES ==================== SYSFOREIGNKEYS ==================== SYSKEYS ==================== SYSSCHEMAS ==========APPAPPAPP----========== SYSSTATEMENTS ==================== SYSTABLES ==================== SYSTRIGGERS ==================== SYSVIEWS ==========Database 'wombat_new' deleted.-= Start dblook Message Tests =-Database 'wombat' deleted.Creating database 'wombat' from ddl script 'dblook_makeDB_2.sql'************Msg Test 1************--*******************************************Dumping full schema for 'wombat'to file 'wombat.sql':*******************************************File wombat.sql was NOT empty. Contents are:############## Begin File Contents ################-- ============================-- This file was created using Derby's dblook utility.-- Timestamp: xxxxxxFILTERED-TIMESTAMPxxxxx-- Source database is: <dbPath>-- Connection URL is: <dbURL>-- appendLogs: false-- ------------------------------------------------ DDL Statements for schemas-- ----------------------------------------------CREATE SCHEMA "BAR"-- ------------------------------------------------ DDL Statements for jars-- **** NOTE **** In order for jar files to be loaded correctly,-- you must either 1) ensure that the DBJARS directory (created-- automatically by dblook) exists where it was created (i.e. at-- the path shown in the statements below), or else 2) change the-- path in the statements below to reflect the current location of-- DBJARS. If the DBJARS directory does not exist, or if it-- has been moved and the path is not correct, the following DDL-- statements will throw errors, and the jar files will NOT be-- loaded.-- ----------------------------------------------CALL SQLJ.INSTALL_JAR(<maskedOutJarDesc>)-- ------------------------------------------------ DDL Statements for stored procedures-- ----------------------------------------------CREATE PROCEDURE "APP"."PROC1" (INOUT A CHAR(10),IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4 EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3' -- ------------------------------------------------ DDL Statements for functions-- ----------------------------------------------CREATE FUNCTION "APP"."GATP" (SCH VARCHAR(128),TBL VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties' -- ------------------------------------------------ DDL Statements for tables-- ----------------------------------------------CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5))-- ------------------------------------------------ DDL Statements for indexes-- ----------------------------------------------CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC)-- ------------------------------------------------ DDL Statements for Synonyms-- ----------------------------------------------CREATE SYNONYM "APP"."SYN1" FOR "BAR"."T1"-- ------------------------------------------------ DDL Statements for keys-- ------------------------------------------------ primary/uniqueALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C")-- foreignALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION-- ------------------------------------------------ DDL Statements for checks-- ----------------------------------------------ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil')-- ------------------------------------------------ DDL Statements for views-- ----------------------------------------------SET SCHEMA "APP"create view v1 (dum, dee, dokie) as select a.c, a.i, a.vc from bar.t1 as a-- Reverting back to default schema 'APP'SET SCHEMA "APP"-- ------------------------------------------------ DDL Statements for triggers-- ----------------------------------------------CREATE TRIGGER "APP"."TRIGONE" AFTER INSERT ON "BAR"."T1" FOR EACH ROW MODE DB2SQL update bar.t1 set i = 4 where i = 2############## End File Contents ################File dblook.log was empty.************Msg Test 2************File wombat.sql was NOT empty. Contents are:############## Begin File Contents ################-- ============================-- This file was created using Derby's dblook utility.-- Timestamp: xxxxxxFILTERED-TIMESTAMPxxxxx-- Source database is: <dbPath>-- Connection URL is: <dbURL>-- The dblook utility will consider only specified tables.-- Specified schema is: bar-- appendLogs: false-- ------------------------------------------------ DDL Statements for schemas-- ----------------------------------------------CREATE SCHEMA "BAR";-- ------------------------------------------------ DDL Statements for tables-- ----------------------------------------------CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5));-- ------------------------------------------------ DDL Statements for indexes-- ----------------------------------------------CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC);-- ------------------------------------------------ DDL Statements for keys-- ------------------------------------------------ primary/uniqueALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C");-- foreignALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION;-- ------------------------------------------------ DDL Statements for checks-- ----------------------------------------------ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil');############## End File Contents ################File dblook.log was empty.************Msg Test 3************ USAGE: java org.apache.derby.tools.dblook -d <sourceDBUrl> [OPTIONS] where the source URL is the full URL, including the connection protocol and any connection attributes that might apply. For example, use 'jdbc:derby:myDB', or 'jdbc:derby://localhost:1527/myDB;user=usr;'. options include: -z <schemaName> to specify a schema to which the DDL generation should be limited. Only database objects with that schema will have their DDL generated. -t <tableOne> <tableTwo> ... to specify a list of tables for which the DDL will be generated; any tables not in the list will be ignored. -td <value> to specify what should be appended to the end of each DDL statement. This defaults to ';'. -noview to prevent the generation of DDL for views. -append to keep from overwriting the output files. -verbose to have error messages printed to the console (in addition to the log file). If not specified, errors will only be printed to the log file. -o <filename> to specify the file name to which the generated DDL will be written. If not specified, default is the console. ************Msg Test 4************-- Timestamp: xxxxxxFILTERED-TIMESTAMPxxxxx-- Source database is: <dbPath>-- Connection URL is: <dbURL>-- appendLogs: false-- ------------------------------------------------ DDL Statements for schemas-- ----------------------------------------------CREATE SCHEMA "BAR" #-- ------------------------------------------------ DDL Statements for jars-- **** NOTE **** In order for jar files to be loaded correctly,-- you must either 1) ensure that the DBJARS directory (created-- automatically by dblook) exists where it was created (i.e. at-- the path shown in the statements below), or else 2) change the-- path in the statements below to reflect the current location of-- DBJARS. If the DBJARS directory does not exist, or if it-- has been moved and the path is not correct, the following DDL-- statements will throw errors, and the jar files will NOT be-- loaded.-- ----------------------------------------------CALL SQLJ.INSTALL_JAR(<maskedOutJarDesc>)-- ------------------------------------------------ DDL Statements for stored procedures-- ----------------------------------------------CREATE PROCEDURE "APP"."PROC1" (INOUT A CHAR(10),IN B INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL DYNAMIC RESULT SETS 4 EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.inoutparams3' #-- ------------------------------------------------ DDL Statements for functions-- ----------------------------------------------CREATE FUNCTION "APP"."GATP" (SCH VARCHAR(128),TBL VARCHAR(128)) RETURNS VARCHAR(1000) LANGUAGE JAVA PARAMETER STYLE JAVA CONTAINS SQL CALLED ON NULL INPUT EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.TestPropertyInfo.getAllTableProperties' #-- ------------------------------------------------ DDL Statements for tables-- ----------------------------------------------CREATE TABLE "BAR"."T1" ("C" CHAR(5) NOT NULL, "I" INTEGER, "VC" VARCHAR(10), "FKCHAR" CHAR(5)) #-- ------------------------------------------------ DDL Statements for indexes-- ----------------------------------------------CREATE INDEX "BAR"."IX1" ON "BAR"."T1" ("I" DESC) #-- ------------------------------------------------ DDL Statements for Synonyms-- ----------------------------------------------CREATE SYNONYM "APP"."SYN1" FOR "BAR"."T1" #-- ------------------------------------------------ DDL Statements for keys-- ------------------------------------------------ primary/uniqueALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" PRIMARY KEY ("C") #-- foreignALTER TABLE "BAR"."T1" ADD CONSTRAINT "xxxxGENERATED-IDxxxx" FOREIGN KEY ("FKCHAR") REFERENCES "BAR"."T1" ("C") ON DELETE NO ACTION ON UPDATE NO ACTION #-- ------------------------------------------------ DDL Statements for checks-- ----------------------------------------------ALTER TABLE "BAR"."T1" ADD CONSTRAINT "NOTEVIL" CHECK (vc != 'evil') #-- ------------------------------------------------ DDL Statements for views-- ----------------------------------------------SET SCHEMA "APP" #create view v1 (dum, dee, dokie) as select a.c, a.i, a.vc from bar.t1 as a #-- Reverting back to default schema 'APP'SET SCHEMA "APP" #-- ------------------------------------------------ DDL Statements for triggers-- ----------------------------------------------CREATE TRIGGER "APP"."TRIGONE" AFTER INSERT ON "BAR"."T1" FOR EACH ROW MODE DB2SQL update bar.t1 set i = 4 where i = 2 #************Msg Test 5************File dblook.log was NOT empty. Contents are:############## Begin File Contents ################-- **--> DEBUG: Failed to load jar file <jarFilePath>java.io.FileNotFoundException: <filePath>############## End File Contents ################[ Done. ]⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -