Offset 1, 6 lines modified | Offset 1, 6 lines modified | ||
1 | · | 1 | ·1c8ff58befadec60dd622adb09c2f37f·65800·java·optional·jython-stilts_3.5-2_all.deb |
2 | ·3035e192c43c717f5ed86d4118e28581·1234876·doc·optional·starlink-ttools-java-doc_3.5-2_all.deb | 2 | ·3035e192c43c717f5ed86d4118e28581·1234876·doc·optional·starlink-ttools-java-doc_3.5-2_all.deb |
3 | ·5 | 3 | ·ab559231885436495032fddae24ca826·5250368·java·optional·starlink-ttools-java_3.5-2_all.deb |
4 | · | 4 | ·0d762fee86caec00ece99b03d2797cd3·2378144·doc·optional·stilts-doc_3.5-2_all.deb |
5 | ·33062afd6586926fa9d37d1e4cf4227b·227048·science·optional·stilts_3.5-2_all.deb | 5 | ·33062afd6586926fa9d37d1e4cf4227b·227048·science·optional·stilts_3.5-2_all.deb |
Offset 1486, 15 lines modified | Offset 1486, 15 lines modified | ||
1486 | ········env·=·_JyEnvironment() | 1486 | ········env·=·_JyEnvironment() |
1487 | ········env.setValue('format',·_map_env_value(format)) | 1487 | ········env.setValue('format',·_map_env_value(format)) |
1488 | ········env.setValue('client',·_map_env_value(client)) | 1488 | ········env.setValue('client',·_map_env_value(client)) |
1489 | ········mode·=·_stilts.getModeFactory().createObject('samp') | 1489 | ········mode·=·_stilts.getModeFactory().createObject('samp') |
1490 | ········consumer·=·mode.createConsumer(env) | 1490 | ········consumer·=·mode.createConsumer(env) |
1491 | ········_check_unused_args(env) | 1491 | ········_check_unused_args(env) |
1492 | ········consumer.consume(self) | 1492 | ········consumer.consume(self) |
1493 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 1493 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
1494 | ········'''\ | 1494 | ········'''\ |
1495 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 1495 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
1496 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 1496 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
1497 | ···· | 1497 | ···· |
1498 | ····Parameters: | 1498 | ····Parameters: |
1499 | ···· | 1499 | ···· |
1500 | ·······protocol·=·<jdbc-protocol>·······(String) | 1500 | ·······protocol·=·<jdbc-protocol>·······(String) |
Offset 1536, 15 lines modified | Offset 1536, 15 lines modified | ||
1536 | ················of·columns)·for·the·data·being·written. | 1536 | ················of·columns)·for·the·data·being·written. |
1537 | ···· | 1537 | ···· |
1538 | ··········[Default:·create] | 1538 | ··········[Default:·create] |
1539 | ···· | 1539 | ···· |
1540 | ·······user·=·<username>·······(String) | 1540 | ·······user·=·<username>·······(String) |
1541 | ··········User·name·for·the·SQL·connection·to·the·database. | 1541 | ··········User·name·for·the·SQL·connection·to·the·database. |
1542 | ···· | 1542 | ···· |
1543 | ··········[Default:·pbuilder | 1543 | ··········[Default:·pbuilder2] |
1544 | ···· | 1544 | ···· |
1545 | ·······password·=·<passwd>·······(String) | 1545 | ·······password·=·<passwd>·······(String) |
1546 | ··········Password·for·the·SQL·connection·to·the·database. | 1546 | ··········Password·for·the·SQL·connection·to·the·database. |
1547 | ····''' | 1547 | ····''' |
1548 | ········env·=·_JyEnvironment() | 1548 | ········env·=·_JyEnvironment() |
1549 | ········env.setValue('protocol',·_map_env_value(protocol)) | 1549 | ········env.setValue('protocol',·_map_env_value(protocol)) |
1550 | ········env.setValue('db',·_map_env_value(db)) | 1550 | ········env.setValue('db',·_map_env_value(db)) |
Offset 4287, 15 lines modified | Offset 4287, 15 lines modified | ||
4287 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4287 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4288 | ······as·well·for·the·connection·to·be·made. | 4288 | ······as·well·for·the·connection·to·be·made. |
4289 | ···user·=·<value>·······(String) | 4289 | ···user·=·<value>·······(String) |
4290 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4290 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4291 | ······current·username. | 4291 | ······current·username. |
4292 | ······[Default:·pbuilder | 4292 | ······[Default:·pbuilder2] |
4293 | ···password·=·<value>·······(String) | 4293 | ···password·=·<value>·······(String) |
4294 | ······Password·for·logging·in·to·SQL·database. | 4294 | ······Password·for·logging·in·to·SQL·database. |
4295 | ···sql·=·<sql>·······(String) | 4295 | ···sql·=·<sql>·······(String) |
4296 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be | 4296 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be |
4297 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") | 4297 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") |
Offset 4493, 15 lines modified | Offset 4493, 15 lines modified | ||
4493 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4493 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4494 | ······as·well·for·the·connection·to·be·made. | 4494 | ······as·well·for·the·connection·to·be·made. |
4495 | ···user·=·<value>·······(String) | 4495 | ···user·=·<value>·······(String) |
4496 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4496 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4497 | ······current·username. | 4497 | ······current·username. |
4498 | ······[Default:·pbuilder | 4498 | ······[Default:·pbuilder2] |
4499 | ···password·=·<value>·······(String) | 4499 | ···password·=·<value>·······(String) |
4500 | ······Password·for·logging·in·to·SQL·database. | 4500 | ······Password·for·logging·in·to·SQL·database. |
4501 | ···dbtable·=·<table-name>·······(String) | 4501 | ···dbtable·=·<table-name>·······(String) |
4502 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the | 4502 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the |
4503 | ······remote·data. | 4503 | ······remote·data. |
Offset 4601, 15 lines modified | Offset 4601, 15 lines modified | ||
4601 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4601 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4602 | ······as·well·for·the·connection·to·be·made. | 4602 | ······as·well·for·the·connection·to·be·made. |
4603 | ···user·=·<value>·······(String) | 4603 | ···user·=·<value>·······(String) |
4604 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4604 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4605 | ······current·username. | 4605 | ······current·username. |
4606 | ······[Default:·pbuilder | 4606 | ······[Default:·pbuilder2] |
4607 | ···password·=·<value>·······(String) | 4607 | ···password·=·<value>·······(String) |
4608 | ······Password·for·logging·in·to·SQL·database. | 4608 | ······Password·for·logging·in·to·SQL·database. |
4609 | ···select·=·<select-stmt>·······(String) | 4609 | ···select·=·<select-stmt>·······(String) |
4610 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT | 4610 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT |
4611 | ······statement·to·identify·which·rows·undergo·updates. | 4611 | ······statement·to·identify·which·rows·undergo·updates. |
Offset 13131, 15 lines modified | Offset 13131, 15 lines modified | ||
13131 | ····env.setValue('format',·_map_env_value(format)) | 13131 | ····env.setValue('format',·_map_env_value(format)) |
13132 | ····env.setValue('client',·_map_env_value(client)) | 13132 | ····env.setValue('client',·_map_env_value(client)) |
13133 | ····mode·=·_stilts.getModeFactory().createObject('samp') | 13133 | ····mode·=·_stilts.getModeFactory().createObject('samp') |
13134 | ····consumer·=·mode.createConsumer(env) | 13134 | ····consumer·=·mode.createConsumer(env) |
13135 | ····_check_unused_args(env) | 13135 | ····_check_unused_args(env) |
13136 | ····consumer.consume(table) | 13136 | ····consumer.consume(table) |
13137 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 13137 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
13138 | ····'''\ | 13138 | ····'''\ |
13139 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 13139 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
13140 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 13140 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
13141 | Parameters: | 13141 | Parameters: |
13142 | ···protocol·=·<jdbc-protocol>·······(String) | 13142 | ···protocol·=·<jdbc-protocol>·······(String) |
Offset 13181, 15 lines modified | Offset 13181, 15 lines modified | ||
13181 | ············of·columns)·for·the·data·being·written. | 13181 | ············of·columns)·for·the·data·being·written. |
13182 | ······[Default:·create] | 13182 | ······[Default:·create] |
13183 | ···user·=·<username>·······(String) | 13183 | ···user·=·<username>·······(String) |
13184 | ······User·name·for·the·SQL·connection·to·the·database. | 13184 | ······User·name·for·the·SQL·connection·to·the·database. |
13185 | ······[Default:·pbuilder | 13185 | ······[Default:·pbuilder2] |
13186 | ···password·=·<passwd>·······(String) | 13186 | ···password·=·<passwd>·······(String) |
13187 | ······Password·for·the·SQL·connection·to·the·database. | 13187 | ······Password·for·the·SQL·connection·to·the·database. |
13188 | ''' | 13188 | ''' |
13189 | ····env·=·_JyEnvironment() | 13189 | ····env·=·_JyEnvironment() |
13190 | ····env.setValue('protocol',·_map_env_value(protocol)) | 13190 | ····env.setValue('protocol',·_map_env_value(protocol)) |
13191 | ····env.setValue('db',·_map_env_value(db)) | 13191 | ····env.setValue('db',·_map_env_value(db)) |
Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
1 | -rw-r--r--···0········0········0········4·2024-10-14·19:50:59.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2024-10-14·19:50:59.000000·debian-binary |
2 | -rw-r--r--···0········0········0·····1228·2024-10-14·19:50:59.000000·control.tar.xz | 2 | -rw-r--r--···0········0········0·····1228·2024-10-14·19:50:59.000000·control.tar.xz |
3 | -rw-r--r--···0········0········0··5248 | 3 | -rw-r--r--···0········0········0··5248948·2024-10-14·19:50:59.000000·data.tar.xz |
Offset 172, 15 lines modified | Offset 172, 15 lines modified | ||
172 | ··minimum·file·system·compatibility·required:·····MS-DOS,·OS/2·or·NT·FAT | 172 | ··minimum·file·system·compatibility·required:·····MS-DOS,·OS/2·or·NT·FAT |
173 | ··minimum·software·version·required·to·extract:···1.0 | 173 | ··minimum·software·version·required·to·extract:···1.0 |
174 | ··compression·method:·····························deflated | 174 | ··compression·method:·····························deflated |
175 | ··compression·sub-type·(deflation):···············normal | 175 | ··compression·sub-type·(deflation):···············normal |
176 | ··file·security·status:···························not·encrypted | 176 | ··file·security·status:···························not·encrypted |
177 | ··extended·local·header:··························no | 177 | ··extended·local·header:··························no |
178 | ··file·last·modified·on·(DOS·date/time):··········2024·Oct·14·19:50:58 | 178 | ··file·last·modified·on·(DOS·date/time):··········2024·Oct·14·19:50:58 |
179 | ··32-bit·CRC·value·(hex):························· | 179 | ··32-bit·CRC·value·(hex):·························a6591b03 |
180 | ··compressed·size:································91126·bytes | 180 | ··compressed·size:································91126·bytes |
181 | ··uncompressed·size:······························536153·bytes | 181 | ··uncompressed·size:······························536153·bytes |
182 | ··length·of·filename:·····························9·characters | 182 | ··length·of·filename:·····························9·characters |
183 | ··length·of·extra·field:··························0·bytes | 183 | ··length·of·extra·field:··························0·bytes |
184 | ··length·of·file·comment:·························0·characters | 184 | ··length·of·file·comment:·························0·characters |
185 | ··disk·number·on·which·file·begins:···············disk·1 | 185 | ··disk·number·on·which·file·begins:···············disk·1 |
186 | ··apparent·file·type:·····························binary | 186 | ··apparent·file·type:·····························binary |
Offset 100, 15 lines modified | Offset 100, 15 lines modified | ||
100 | 0002F1·Extract·Zip·Spec······0A·(10)·'1.0' | 100 | 0002F1·Extract·Zip·Spec······0A·(10)·'1.0' |
101 | 0002F2·Extract·OS············00·(0)·'MS-DOS' | 101 | 0002F2·Extract·OS············00·(0)·'MS-DOS' |
102 | 0002F3·General·Purpose·Flag··0800·(2048) | 102 | 0002F3·General·Purpose·Flag··0800·(2048) |
103 | ·······[Bits·1-2]············0·'Normal·Compression' | 103 | ·······[Bits·1-2]············0·'Normal·Compression' |
104 | ·······[Bit·11]··············1·'Language·Encoding' | 104 | ·······[Bit·11]··············1·'Language·Encoding' |
105 | 0002F5·Compression·Method····0008·(8)·'Deflated' | 105 | 0002F5·Compression·Method····0008·(8)·'Deflated' |
106 | 0002F7·Modification·Time·····594E9E5D·(1498324573)·'Mon·Oct·14·19:50:58·2024' | 106 | 0002F7·Modification·Time·····594E9E5D·(1498324573)·'Mon·Oct·14·19:50:58·2024' |
107 | 0002FB·CRC··················· | 107 | 0002FB·CRC···················A6591B03·(2790857475) |
108 | 0002FF·Compressed·Size·······000163F6·(91126) | 108 | 0002FF·Compressed·Size·······000163F6·(91126) |
109 | 000303·Uncompressed·Size·····00082E59·(536153) | 109 | 000303·Uncompressed·Size·····00082E59·(536153) |
110 | 000307·Filename·Length·······0009·(9) | 110 | 000307·Filename·Length·······0009·(9) |
111 | 000309·Extra·Length··········0000·(0) | 111 | 000309·Extra·Length··········0000·(0) |
112 | 00030B·Filename··············'XXXXXXXXX' | 112 | 00030B·Filename··············'XXXXXXXXX' |
113 | # | 113 | # |
114 | #·WARNING:·Offset·0x30B:·Filename·'XXXXXXXXX' | 114 | #·WARNING:·Offset·0x30B:·Filename·'XXXXXXXXX' |
Offset 72144, 15 lines modified | Offset 72144, 15 lines modified | ||
72144 | 52CEC1·Extract·Zip·Spec······0A·(10)·'1.0' | 72144 | 52CEC1·Extract·Zip·Spec······0A·(10)·'1.0' |
72145 | 52CEC2·Extract·OS············00·(0)·'MS-DOS' | 72145 | 52CEC2·Extract·OS············00·(0)·'MS-DOS' |
72146 | 52CEC3·General·Purpose·Flag··0800·(2048) | 72146 | 52CEC3·General·Purpose·Flag··0800·(2048) |
72147 | ·······[Bits·1-2]············0·'Normal·Compression' | 72147 | ·······[Bits·1-2]············0·'Normal·Compression' |
72148 | ·······[Bit·11]··············1·'Language·Encoding' | 72148 | ·······[Bit·11]··············1·'Language·Encoding' |
72149 | 52CEC5·Compression·Method····0008·(8)·'Deflated' | 72149 | 52CEC5·Compression·Method····0008·(8)·'Deflated' |
72150 | 52CEC7·Modification·Time·····594E9E5D·(1498324573)·'Mon·Oct·14·19:50:58·2024' | 72150 | 52CEC7·Modification·Time·····594E9E5D·(1498324573)·'Mon·Oct·14·19:50:58·2024' |
72151 | 52CECB·CRC··················· | 72151 | 52CECB·CRC···················A6591B03·(2790857475) |
72152 | 52CECF·Compressed·Size·······000163F6·(91126) | 72152 | 52CECF·Compressed·Size·······000163F6·(91126) |
72153 | 52CED3·Uncompressed·Size·····00082E59·(536153) | 72153 | 52CED3·Uncompressed·Size·····00082E59·(536153) |
72154 | 52CED7·Filename·Length·······0009·(9) | 72154 | 52CED7·Filename·Length·······0009·(9) |
72155 | 52CED9·Extra·Length··········0000·(0) | 72155 | 52CED9·Extra·Length··········0000·(0) |
72156 | 52CEDB·Comment·Length········0000·(0) | 72156 | 52CEDB·Comment·Length········0000·(0) |
72157 | 52CEDD·Disk·Start············0000·(0) | 72157 | 52CEDD·Disk·Start············0000·(0) |
72158 | 52CEDF·Int·File·Attributes···0000·(0) | 72158 | 52CEDF·Int·File·Attributes···0000·(0) |
Offset 1486, 15 lines modified | Offset 1486, 15 lines modified | ||
1486 | ········env·=·_JyEnvironment() | 1486 | ········env·=·_JyEnvironment() |
1487 | ········env.setValue('format',·_map_env_value(format)) | 1487 | ········env.setValue('format',·_map_env_value(format)) |
1488 | ········env.setValue('client',·_map_env_value(client)) | 1488 | ········env.setValue('client',·_map_env_value(client)) |
1489 | ········mode·=·_stilts.getModeFactory().createObject('samp') | 1489 | ········mode·=·_stilts.getModeFactory().createObject('samp') |
1490 | ········consumer·=·mode.createConsumer(env) | 1490 | ········consumer·=·mode.createConsumer(env) |
1491 | ········_check_unused_args(env) | 1491 | ········_check_unused_args(env) |
1492 | ········consumer.consume(self) | 1492 | ········consumer.consume(self) |
1493 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 1493 | ····def·mode_tosql(self,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
1494 | ········'''\ | 1494 | ········'''\ |
1495 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 1495 | ····Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
1496 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 1496 | ····drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
1497 | ···· | 1497 | ···· |
1498 | ····Parameters: | 1498 | ····Parameters: |
1499 | ···· | 1499 | ···· |
1500 | ·······protocol·=·<jdbc-protocol>·······(String) | 1500 | ·······protocol·=·<jdbc-protocol>·······(String) |
Offset 1536, 15 lines modified | Offset 1536, 15 lines modified | ||
1536 | ················of·columns)·for·the·data·being·written. | 1536 | ················of·columns)·for·the·data·being·written. |
1537 | ···· | 1537 | ···· |
1538 | ··········[Default:·create] | 1538 | ··········[Default:·create] |
1539 | ···· | 1539 | ···· |
1540 | ·······user·=·<username>·······(String) | 1540 | ·······user·=·<username>·······(String) |
1541 | ··········User·name·for·the·SQL·connection·to·the·database. | 1541 | ··········User·name·for·the·SQL·connection·to·the·database. |
1542 | ···· | 1542 | ···· |
1543 | ··········[Default:·pbuilder | 1543 | ··········[Default:·pbuilder2] |
1544 | ···· | 1544 | ···· |
1545 | ·······password·=·<passwd>·······(String) | 1545 | ·······password·=·<passwd>·······(String) |
1546 | ··········Password·for·the·SQL·connection·to·the·database. | 1546 | ··········Password·for·the·SQL·connection·to·the·database. |
1547 | ····''' | 1547 | ····''' |
1548 | ········env·=·_JyEnvironment() | 1548 | ········env·=·_JyEnvironment() |
1549 | ········env.setValue('protocol',·_map_env_value(protocol)) | 1549 | ········env.setValue('protocol',·_map_env_value(protocol)) |
1550 | ········env.setValue('db',·_map_env_value(db)) | 1550 | ········env.setValue('db',·_map_env_value(db)) |
Offset 4287, 15 lines modified | Offset 4287, 15 lines modified | ||
4287 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4287 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4288 | ······as·well·for·the·connection·to·be·made. | 4288 | ······as·well·for·the·connection·to·be·made. |
4289 | ···user·=·<value>·······(String) | 4289 | ···user·=·<value>·······(String) |
4290 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4290 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4291 | ······current·username. | 4291 | ······current·username. |
4292 | ······[Default:·pbuilder | 4292 | ······[Default:·pbuilder2] |
4293 | ···password·=·<value>·······(String) | 4293 | ···password·=·<value>·······(String) |
4294 | ······Password·for·logging·in·to·SQL·database. | 4294 | ······Password·for·logging·in·to·SQL·database. |
4295 | ···sql·=·<sql>·······(String) | 4295 | ···sql·=·<sql>·······(String) |
4296 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be | 4296 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be |
4297 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") | 4297 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") |
Offset 4493, 15 lines modified | Offset 4493, 15 lines modified | ||
4493 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4493 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4494 | ······as·well·for·the·connection·to·be·made. | 4494 | ······as·well·for·the·connection·to·be·made. |
4495 | ···user·=·<value>·······(String) | 4495 | ···user·=·<value>·······(String) |
4496 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4496 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4497 | ······current·username. | 4497 | ······current·username. |
4498 | ······[Default:·pbuilder | 4498 | ······[Default:·pbuilder2] |
4499 | ···password·=·<value>·······(String) | 4499 | ···password·=·<value>·······(String) |
4500 | ······Password·for·logging·in·to·SQL·database. | 4500 | ······Password·for·logging·in·to·SQL·database. |
4501 | ···dbtable·=·<table-name>·······(String) | 4501 | ···dbtable·=·<table-name>·······(String) |
4502 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the | 4502 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the |
4503 | ······remote·data. | 4503 | ······remote·data. |
Offset 4601, 15 lines modified | Offset 4601, 15 lines modified | ||
4601 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4601 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4602 | ······as·well·for·the·connection·to·be·made. | 4602 | ······as·well·for·the·connection·to·be·made. |
4603 | ···user·=·<value>·······(String) | 4603 | ···user·=·<value>·······(String) |
4604 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4604 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4605 | ······current·username. | 4605 | ······current·username. |
4606 | ······[Default:·pbuilder | 4606 | ······[Default:·pbuilder2] |
4607 | ···password·=·<value>·······(String) | 4607 | ···password·=·<value>·······(String) |
4608 | ······Password·for·logging·in·to·SQL·database. | 4608 | ······Password·for·logging·in·to·SQL·database. |
4609 | ···select·=·<select-stmt>·······(String) | 4609 | ···select·=·<select-stmt>·······(String) |
4610 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT | 4610 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT |
4611 | ······statement·to·identify·which·rows·undergo·updates. | 4611 | ······statement·to·identify·which·rows·undergo·updates. |
Offset 13131, 15 lines modified | Offset 13131, 15 lines modified | ||
13131 | ····env.setValue('format',·_map_env_value(format)) | 13131 | ····env.setValue('format',·_map_env_value(format)) |
13132 | ····env.setValue('client',·_map_env_value(client)) | 13132 | ····env.setValue('client',·_map_env_value(client)) |
13133 | ····mode·=·_stilts.getModeFactory().createObject('samp') | 13133 | ····mode·=·_stilts.getModeFactory().createObject('samp') |
13134 | ····consumer·=·mode.createConsumer(env) | 13134 | ····consumer·=·mode.createConsumer(env) |
13135 | ····_check_unused_args(env) | 13135 | ····_check_unused_args(env) |
13136 | ····consumer.consume(table) | 13136 | ····consumer.consume(table) |
13137 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 13137 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
13138 | ····'''\ | 13138 | ····'''\ |
13139 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 13139 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
13140 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 13140 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
13141 | Parameters: | 13141 | Parameters: |
13142 | ···protocol·=·<jdbc-protocol>·······(String) | 13142 | ···protocol·=·<jdbc-protocol>·······(String) |
Offset 13181, 15 lines modified | Offset 13181, 15 lines modified | ||
13181 | ············of·columns)·for·the·data·being·written. | 13181 | ············of·columns)·for·the·data·being·written. |
13182 | ······[Default:·create] | 13182 | ······[Default:·create] |
13183 | ···user·=·<username>·······(String) | 13183 | ···user·=·<username>·······(String) |
13184 | ······User·name·for·the·SQL·connection·to·the·database. | 13184 | ······User·name·for·the·SQL·connection·to·the·database. |
13185 | ······[Default:·pbuilder | 13185 | ······[Default:·pbuilder2] |
13186 | ···password·=·<passwd>·······(String) | 13186 | ···password·=·<passwd>·······(String) |
13187 | ······Password·for·the·SQL·connection·to·the·database. | 13187 | ······Password·for·the·SQL·connection·to·the·database. |
13188 | ''' | 13188 | ''' |
13189 | ····env·=·_JyEnvironment() | 13189 | ····env·=·_JyEnvironment() |
13190 | ····env.setValue('protocol',·_map_env_value(protocol)) | 13190 | ····env.setValue('protocol',·_map_env_value(protocol)) |
13191 | ····env.setValue('db',·_map_env_value(db)) | 13191 | ····env.setValue('db',·_map_env_value(db)) |
Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
1 | -rw-r--r--···0········0········0········4·2024-10-14·19:50:59.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2024-10-14·19:50:59.000000·debian-binary |
2 | -rw-r--r--···0········0········0·····3332·2024-10-14·19:50:59.000000·control.tar.xz | 2 | -rw-r--r--···0········0········0·····3332·2024-10-14·19:50:59.000000·control.tar.xz |
3 | -rw-r--r--···0········0········0··23746 | 3 | -rw-r--r--···0········0········0··2374620·2024-10-14·19:50:59.000000·data.tar.xz |
Offset 9042, 15 lines modified | Offset 9042, 15 lines modified | ||
9042 | ················</dt> | 9042 | ················</dt> |
9043 | ················ | 9043 | ················ |
9044 | ················<dd> | 9044 | ················<dd> |
9045 | ····················User·name·for·the·SQL·connection·to·the·database. | 9045 | ····················User·name·for·the·SQL·connection·to·the·database. |
9046 | ····················<p> | 9046 | ····················<p> |
9047 | ························[Default:·<code>pbuilder | 9047 | ························[Default:·<code>pbuilder2</code>] |
9048 | ····················</p> | 9048 | ····················</p> |
9049 | ················</dd> | 9049 | ················</dd> |
9050 | ················ | 9050 | ················ |
9051 | ················<dt> | 9051 | ················<dt> |
9052 | ····················<strong><code>password·=·<passwd></code>· <em>(String)</em></strong> | 9052 | ····················<strong><code>password·=·<passwd></code>· <em>(String)</em></strong> |
9053 | ················</dt> | 9053 | ················</dt> |
9054 | ················ | 9054 | ················ |
Offset 74750, 15 lines modified | Offset 74750, 15 lines modified | ||
74750 | ················ | 74750 | ················ |
74751 | ················<dd> | 74751 | ················<dd> |
74752 | ····················User·name·for·logging·in·to·SQL·database. | 74752 | ····················User·name·for·logging·in·to·SQL·database. |
74753 | Defaults·to·the·current·username. | 74753 | Defaults·to·the·current·username. |
74754 | ····················<p> | 74754 | ····················<p> |
74755 | ························[Default:·<code>pbuilder | 74755 | ························[Default:·<code>pbuilder2</code>] |
74756 | ····················</p> | 74756 | ····················</p> |
74757 | ················</dd> | 74757 | ················</dd> |
74758 | ················ | 74758 | ················ |
74759 | ············</dl> | 74759 | ············</dl> |
74760 | ············ | 74760 | ············ |
74761 | ········</p> | 74761 | ········</p> |
74762 | ········ | 74762 | ········ |
Offset 75694, 15 lines modified | Offset 75694, 15 lines modified | ||
75694 | ················ | 75694 | ················ |
75695 | ················<dd> | 75695 | ················<dd> |
75696 | ····················User·name·for·logging·in·to·SQL·database. | 75696 | ····················User·name·for·logging·in·to·SQL·database. |
75697 | Defaults·to·the·current·username. | 75697 | Defaults·to·the·current·username. |
75698 | ····················<p> | 75698 | ····················<p> |
75699 | ························[Default:·<code>pbuilder | 75699 | ························[Default:·<code>pbuilder2</code>] |
75700 | ····················</p> | 75700 | ····················</p> |
75701 | ················</dd> | 75701 | ················</dd> |
75702 | ················ | 75702 | ················ |
75703 | ················<dt> | 75703 | ················<dt> |
75704 | ····················<strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong> | 75704 | ····················<strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong> |
75705 | ················</dt> | 75705 | ················</dt> |
75706 | ················ | 75706 | ················ |
Offset 75916, 15 lines modified | Offset 75916, 15 lines modified | ||
75916 | ················ | 75916 | ················ |
75917 | ················<dd> | 75917 | ················<dd> |
75918 | ····················User·name·for·logging·in·to·SQL·database. | 75918 | ····················User·name·for·logging·in·to·SQL·database. |
75919 | Defaults·to·the·current·username. | 75919 | Defaults·to·the·current·username. |
75920 | ····················<p> | 75920 | ····················<p> |
75921 | ························[Default:·<code>pbuilder | 75921 | ························[Default:·<code>pbuilder2</code>] |
75922 | ····················</p> | 75922 | ····················</p> |
75923 | ················</dd> | 75923 | ················</dd> |
75924 | ················ | 75924 | ················ |
75925 | ············</dl> | 75925 | ············</dl> |
75926 | ············ | 75926 | ············ |
75927 | ········</p> | 75927 | ········</p> |
75928 | ········ | 75928 | ········ |
Offset 3501, 15 lines modified | Offset 3501, 15 lines modified | ||
3501 | ············of·the·same·name·already·exists,·it·is·dropped·first. | 3501 | ············of·the·same·name·already·exists,·it·is·dropped·first. |
3502 | ··········*·append:·Appends·to·an·existing·table.·An·error·results·if·the·named | 3502 | ··········*·append:·Appends·to·an·existing·table.·An·error·results·if·the·named |
3503 | ············table·has·the·wrong·structure·(number·or·types·of·columns)·for·the | 3503 | ············table·has·the·wrong·structure·(number·or·types·of·columns)·for·the |
3504 | ············data·being·written. | 3504 | ············data·being·written. |
3505 | ······[Default:·create] | 3505 | ······[Default:·create] |
3506 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<u\x8us\x8se\x8er\x8rn\x8na\x8am\x8me\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 3506 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<u\x8us\x8se\x8er\x8rn\x8na\x8am\x8me\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
3507 | ······User·name·for·the·SQL·connection·to·the·database. | 3507 | ······User·name·for·the·SQL·connection·to·the·database. |
3508 | ······[Default:·pbuilder | 3508 | ······[Default:·pbuilder2] |
3509 | ··p\x8pa\x8as\x8ss\x8sw\x8wo\x8or\x8rd\x8d·=\x8=·<\x8<p\x8pa\x8as\x8ss\x8sw\x8wd\x8d>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 3509 | ··p\x8pa\x8as\x8ss\x8sw\x8wo\x8or\x8rd\x8d·=\x8=·<\x8<p\x8pa\x8as\x8ss\x8sw\x8wd\x8d>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
3510 | ······Password·for·the·SQL·connection·to·the·database. | 3510 | ······Password·for·the·SQL·connection·to·the·database. |
3511 | =============================================================================== | 3511 | =============================================================================== |
3512 | *\x8**\x8**\x8**\x8**\x8*·7\x87·C\x8Cr\x8ro\x8os\x8ss\x8sm\x8ma\x8at\x8tc\x8ch\x8hi\x8in\x8ng\x8g·*\x8**\x8**\x8**\x8**\x8* | 3512 | *\x8**\x8**\x8**\x8**\x8*·7\x87·C\x8Cr\x8ro\x8os\x8ss\x8sm\x8ma\x8at\x8tc\x8ch\x8hi\x8in\x8ng\x8g·*\x8**\x8**\x8**\x8**\x8* |
3513 | STILTS·offers·flexible·and·efficient·facilities·for·crossmatching·tables. | 3513 | STILTS·offers·flexible·and·efficient·facilities·for·crossmatching·tables. |
3514 | Crossmatching·is·identifying·different·rows,·which·may·be·in·the·same·or | 3514 | Crossmatching·is·identifying·different·rows,·which·may·be·in·the·same·or |
3515 | different·tables,·that·refer·to·the·same·item.·In·an·astronomical·context·such | 3515 | different·tables,·that·refer·to·the·same·item.·In·an·astronomical·context·such |
Offset 23042, 15 lines modified | Offset 23042, 15 lines modified | ||
23042 | ······Password·for·logging·in·to·SQL·database. | 23042 | ······Password·for·logging·in·to·SQL·database. |
23043 | ··s\x8sq\x8ql\x8l·=\x8=·<\x8<s\x8sq\x8ql\x8l>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 23043 | ··s\x8sq\x8ql\x8l·=\x8=·<\x8<s\x8sq\x8ql\x8l>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
23044 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, | 23044 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, |
23045 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. | 23045 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. |
23046 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<v\x8va\x8al\x8lu\x8ue\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 23046 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<v\x8va\x8al\x8lu\x8ue\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
23047 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 23047 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
23048 | ······username. | 23048 | ······username. |
23049 | ······[Default:·pbuilder | 23049 | ······[Default:·pbuilder2] |
23050 | *\x8**\x8**\x8**\x8*·B\x8B.\x8.2\x821\x81.\x8.2\x82·E\x8Ex\x8xa\x8am\x8mp\x8pl\x8le\x8es\x8s·*\x8**\x8**\x8**\x8* | 23050 | *\x8**\x8**\x8**\x8*·B\x8B.\x8.2\x821\x81.\x8.2\x82·E\x8Ex\x8xa\x8am\x8mp\x8pl\x8le\x8es\x8s·*\x8**\x8**\x8**\x8* |
23051 | Here·are·some·examples·of·sqlclient: | 23051 | Here·are·some·examples·of·sqlclient: |
23052 | ······This·sends·two·commands·to·a·SQL·Server·database;·the·first·one·(SET | 23052 | ······This·sends·two·commands·to·a·SQL·Server·database;·the·first·one·(SET |
23053 | ······SHOWPLAN...)·sets·a·flag·which·causes·the·DB·to·return·an·execution·plan | 23053 | ······SHOWPLAN...)·sets·a·flag·which·causes·the·DB·to·return·an·execution·plan |
23054 | ······rather·than·the·result·for·subsequent·queries,·and·the·second·makes·the | 23054 | ······rather·than·the·result·for·subsequent·queries,·and·the·second·makes·the |
23055 | ······query·itself.·Since·the·password·is·not·provided·on·the·command·line,·a | 23055 | ······query·itself.·Since·the·password·is·not·provided·on·the·command·line,·a |
23056 | ······prompt·for·it·will·be·issued·before·execution.·The·result·is·SQL·Server's | 23056 | ······prompt·for·it·will·be·issued·before·execution.·The·result·is·SQL·Server's |
Offset 23374, 15 lines modified | Offset 23374, 15 lines modified | ||
23374 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS | 23374 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS |
23375 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few | 23375 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few |
23376 | ······other·cone·search·services. | 23376 | ······other·cone·search·services. |
23377 | ······[Default:·true] | 23377 | ······[Default:·true] |
23378 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<v\x8va\x8al\x8lu\x8ue\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 23378 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<v\x8va\x8al\x8lu\x8ue\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
23379 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 23379 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
23380 | ······username. | 23380 | ······username. |
23381 | ······[Default:·pbuilder | 23381 | ······[Default:·pbuilder2] |
23382 | ··w\x8wh\x8he\x8er\x8re\x8e·=\x8=·<\x8<s\x8sq\x8ql\x8l-\x8-c\x8co\x8on\x8nd\x8di\x8it\x8ti\x8io\x8on\x8n>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 23382 | ··w\x8wh\x8he\x8er\x8re\x8e·=\x8=·<\x8<s\x8sq\x8ql\x8l-\x8-c\x8co\x8on\x8nd\x8di\x8it\x8ti\x8io\x8on\x8n>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
23383 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the | 23383 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the |
23384 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied | 23384 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied |
23385 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should | 23385 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should |
23386 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null | 23386 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null |
23387 | ······value·indicates·no·additional·criteria. | 23387 | ······value·indicates·no·additional·criteria. |
23388 | *\x8**\x8**\x8**\x8*·B\x8B.\x8.2\x822\x82.\x8.2\x82·E\x8Ex\x8xa\x8am\x8mp\x8pl\x8le\x8es\x8s·*\x8**\x8**\x8**\x8* | 23388 | *\x8**\x8**\x8**\x8*·B\x8B.\x8.2\x822\x82.\x8.2\x82·E\x8Ex\x8xa\x8am\x8mp\x8pl\x8le\x8es\x8s·*\x8**\x8**\x8**\x8* |
Offset 23448, 15 lines modified | Offset 23448, 15 lines modified | ||
23448 | ······[Default:·true] | 23448 | ······[Default:·true] |
23449 | ··s\x8se\x8el\x8le\x8ec\x8ct\x8t·=\x8=·<\x8<s\x8se\x8el\x8le\x8ec\x8ct\x8t-\x8-s\x8st\x8tm\x8mt\x8t>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 23449 | ··s\x8se\x8el\x8le\x8ec\x8ct\x8t·=\x8=·<\x8<s\x8se\x8el\x8le\x8ec\x8ct\x8t-\x8-s\x8st\x8tm\x8mt\x8t>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
23450 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to | 23450 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to |
23451 | ······identify·which·rows·undergo·updates. | 23451 | ······identify·which·rows·undergo·updates. |
23452 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<v\x8va\x8al\x8lu\x8ue\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) | 23452 | ··u\x8us\x8se\x8er\x8r·=\x8=·<\x8<v\x8va\x8al\x8lu\x8ue\x8e>\x8>·?\x8 ?\x8 ?\x8 ?\x8 ?\x8 ?\x8 (\x8(S\x8St\x8tr\x8ri\x8in\x8ng\x8g)\x8) |
23453 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 23453 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
23454 | ······username. | 23454 | ······username. |
23455 | ······[Default:·pbuilder | 23455 | ······[Default:·pbuilder2] |
23456 | *\x8**\x8**\x8**\x8*·B\x8B.\x8.2\x823\x83.\x8.2\x82·E\x8Ex\x8xa\x8am\x8mp\x8pl\x8le\x8es\x8s·*\x8**\x8**\x8**\x8* | 23456 | *\x8**\x8**\x8**\x8*·B\x8B.\x8.2\x823\x83.\x8.2\x82·E\x8Ex\x8xa\x8am\x8mp\x8pl\x8le\x8es\x8s·*\x8**\x8**\x8**\x8* |
23457 | Here·are·some·examples·of·sqlupdate: | 23457 | Here·are·some·examples·of·sqlupdate: |
23458 | ······Fills·in·the·HTMID·column·of·a·table·called·FIRST·in·the·local·MySQL | 23458 | ······Fills·in·the·HTMID·column·of·a·table·called·FIRST·in·the·local·MySQL |
23459 | ······database·RADIO,·using·HTM·pixel·indices·based·on·the·existing·right | 23459 | ······database·RADIO,·using·HTM·pixel·indices·based·on·the·existing·right |
23460 | ······ascension·and·declination·columns·in·that·table.·The·HTMID·column·must | 23460 | ······ascension·and·declination·columns·in·that·table.·The·HTMID·column·must |
23461 | ······exist·prior·to·executing·this·command. | 23461 | ······exist·prior·to·executing·this·command. |
23462 | =============================================================================== | 23462 | =============================================================================== |