Offset 1, 6 lines modified | Offset 1, 6 lines modified | ||
1 | · | 1 | ·873ac5f85653a8347fbe330db0050b4a·66176·java·optional·jython-stilts_3.5.1-2_all.deb |
2 | ·e7c84247c5c31550d6aefbebb454f7da·1254996·doc·optional·starlink-ttools-java-doc_3.5.1-2_all.deb | 2 | ·e7c84247c5c31550d6aefbebb454f7da·1254996·doc·optional·starlink-ttools-java-doc_3.5.1-2_all.deb |
3 | · | 3 | ·453f1af47bbfaa8dc60f09ba723c264a·5273588·java·optional·starlink-ttools-java_3.5.1-2_all.deb |
4 | · | 4 | ·181b5641f45b74ae4135156bbecf66f8·2379184·doc·optional·stilts-doc_3.5.1-2_all.deb |
5 | ·ad4c67fa8691cfb90b6437054823d7cd·229360·science·optional·stilts_3.5.1-2_all.deb | 5 | ·ad4c67fa8691cfb90b6437054823d7cd·229360·science·optional·stilts_3.5.1-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 4290, 15 lines modified | Offset 4290, 15 lines modified | ||
4290 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4290 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4291 | ······as·well·for·the·connection·to·be·made. | 4291 | ······as·well·for·the·connection·to·be·made. |
4292 | ···user·=·<value>·······(String) | 4292 | ···user·=·<value>·······(String) |
4293 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4293 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4294 | ······current·username. | 4294 | ······current·username. |
4295 | ······[Default:·pbuilder | 4295 | ······[Default:·pbuilder2] |
4296 | ···password·=·<value>·······(String) | 4296 | ···password·=·<value>·······(String) |
4297 | ······Password·for·logging·in·to·SQL·database. | 4297 | ······Password·for·logging·in·to·SQL·database. |
4298 | ···sql·=·<sql>·······(String) | 4298 | ···sql·=·<sql>·······(String) |
4299 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be | 4299 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be |
4300 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") | 4300 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") |
Offset 4497, 15 lines modified | Offset 4497, 15 lines modified | ||
4497 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4497 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4498 | ······as·well·for·the·connection·to·be·made. | 4498 | ······as·well·for·the·connection·to·be·made. |
4499 | ···user·=·<value>·······(String) | 4499 | ···user·=·<value>·······(String) |
4500 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4500 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4501 | ······current·username. | 4501 | ······current·username. |
4502 | ······[Default:·pbuilder | 4502 | ······[Default:·pbuilder2] |
4503 | ···password·=·<value>·······(String) | 4503 | ···password·=·<value>·······(String) |
4504 | ······Password·for·logging·in·to·SQL·database. | 4504 | ······Password·for·logging·in·to·SQL·database. |
4505 | ···dbtable·=·<table-name>·······(String) | 4505 | ···dbtable·=·<table-name>·······(String) |
4506 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the | 4506 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the |
4507 | ······remote·data. | 4507 | ······remote·data. |
Offset 4605, 15 lines modified | Offset 4605, 15 lines modified | ||
4605 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4605 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4606 | ······as·well·for·the·connection·to·be·made. | 4606 | ······as·well·for·the·connection·to·be·made. |
4607 | ···user·=·<value>·······(String) | 4607 | ···user·=·<value>·······(String) |
4608 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4608 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4609 | ······current·username. | 4609 | ······current·username. |
4610 | ······[Default:·pbuilder | 4610 | ······[Default:·pbuilder2] |
4611 | ···password·=·<value>·······(String) | 4611 | ···password·=·<value>·······(String) |
4612 | ······Password·for·logging·in·to·SQL·database. | 4612 | ······Password·for·logging·in·to·SQL·database. |
4613 | ···select·=·<select-stmt>·······(String) | 4613 | ···select·=·<select-stmt>·······(String) |
4614 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT | 4614 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT |
4615 | ······statement·to·identify·which·rows·undergo·updates. | 4615 | ······statement·to·identify·which·rows·undergo·updates. |
Offset 13235, 15 lines modified | Offset 13235, 15 lines modified | ||
13235 | ····env.setValue('format',·_map_env_value(format)) | 13235 | ····env.setValue('format',·_map_env_value(format)) |
13236 | ····env.setValue('client',·_map_env_value(client)) | 13236 | ····env.setValue('client',·_map_env_value(client)) |
13237 | ····mode·=·_stilts.getModeFactory().createObject('samp') | 13237 | ····mode·=·_stilts.getModeFactory().createObject('samp') |
13238 | ····consumer·=·mode.createConsumer(env) | 13238 | ····consumer·=·mode.createConsumer(env) |
13239 | ····_check_unused_args(env) | 13239 | ····_check_unused_args(env) |
13240 | ····consumer.consume(table) | 13240 | ····consumer.consume(table) |
13241 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 13241 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
13242 | ····'''\ | 13242 | ····'''\ |
13243 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 13243 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
13244 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 13244 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
13245 | Parameters: | 13245 | Parameters: |
13246 | ···protocol·=·<jdbc-protocol>·······(String) | 13246 | ···protocol·=·<jdbc-protocol>·······(String) |
Offset 13285, 15 lines modified | Offset 13285, 15 lines modified | ||
13285 | ············of·columns)·for·the·data·being·written. | 13285 | ············of·columns)·for·the·data·being·written. |
13286 | ······[Default:·create] | 13286 | ······[Default:·create] |
13287 | ···user·=·<username>·······(String) | 13287 | ···user·=·<username>·······(String) |
13288 | ······User·name·for·the·SQL·connection·to·the·database. | 13288 | ······User·name·for·the·SQL·connection·to·the·database. |
13289 | ······[Default:·pbuilder | 13289 | ······[Default:·pbuilder2] |
13290 | ···password·=·<passwd>·······(String) | 13290 | ···password·=·<passwd>·······(String) |
13291 | ······Password·for·the·SQL·connection·to·the·database. | 13291 | ······Password·for·the·SQL·connection·to·the·database. |
13292 | ''' | 13292 | ''' |
13293 | ····env·=·_JyEnvironment() | 13293 | ····env·=·_JyEnvironment() |
13294 | ····env.setValue('protocol',·_map_env_value(protocol)) | 13294 | ····env.setValue('protocol',·_map_env_value(protocol)) |
13295 | ····env.setValue('db',·_map_env_value(db)) | 13295 | ····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-11-20·14:21:47.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2024-11-20·14:21:47.000000·debian-binary |
2 | -rw-r--r--···0········0········0·····1232·2024-11-20·14:21:47.000000·control.tar.xz | 2 | -rw-r--r--···0········0········0·····1232·2024-11-20·14:21:47.000000·control.tar.xz |
3 | -rw-r--r--···0········0········0··527 | 3 | -rw-r--r--···0········0········0··5272164·2024-11-20·14:21:47.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·Nov·20·14:21:46 | 178 | ··file·last·modified·on·(DOS·date/time):··········2024·Nov·20·14:21:46 |
179 | ··32-bit·CRC·value·(hex):························· | 179 | ··32-bit·CRC·value·(hex):·························e0c862ef |
180 | ··compressed·size:································92128·bytes | 180 | ··compressed·size:································92128·bytes |
181 | ··uncompressed·size:······························540401·bytes | 181 | ··uncompressed·size:······························540401·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·····597472B7·(1500803767)·'Wed·Nov·20·14:21:46·2024' | 106 | 0002F7·Modification·Time·····597472B7·(1500803767)·'Wed·Nov·20·14:21:46·2024' |
107 | 0002FB·CRC··················· | 107 | 0002FB·CRC···················E0C862EF·(3771228911) |
108 | 0002FF·Compressed·Size·······000167E0·(92128) | 108 | 0002FF·Compressed·Size·······000167E0·(92128) |
109 | 000303·Uncompressed·Size·····00083EF1·(540401) | 109 | 000303·Uncompressed·Size·····00083EF1·(540401) |
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 72262, 15 lines modified | Offset 72262, 15 lines modified | ||
72262 | 532AAB·Extract·Zip·Spec······0A·(10)·'1.0' | 72262 | 532AAB·Extract·Zip·Spec······0A·(10)·'1.0' |
72263 | 532AAC·Extract·OS············00·(0)·'MS-DOS' | 72263 | 532AAC·Extract·OS············00·(0)·'MS-DOS' |
72264 | 532AAD·General·Purpose·Flag··0800·(2048) | 72264 | 532AAD·General·Purpose·Flag··0800·(2048) |
72265 | ·······[Bits·1-2]············0·'Normal·Compression' | 72265 | ·······[Bits·1-2]············0·'Normal·Compression' |
72266 | ·······[Bit·11]··············1·'Language·Encoding' | 72266 | ·······[Bit·11]··············1·'Language·Encoding' |
72267 | 532AAF·Compression·Method····0008·(8)·'Deflated' | 72267 | 532AAF·Compression·Method····0008·(8)·'Deflated' |
72268 | 532AB1·Modification·Time·····597472B7·(1500803767)·'Wed·Nov·20·14:21:46·2024' | 72268 | 532AB1·Modification·Time·····597472B7·(1500803767)·'Wed·Nov·20·14:21:46·2024' |
72269 | 532AB5·CRC··················· | 72269 | 532AB5·CRC···················E0C862EF·(3771228911) |
72270 | 532AB9·Compressed·Size·······000167E0·(92128) | 72270 | 532AB9·Compressed·Size·······000167E0·(92128) |
72271 | 532ABD·Uncompressed·Size·····00083EF1·(540401) | 72271 | 532ABD·Uncompressed·Size·····00083EF1·(540401) |
72272 | 532AC1·Filename·Length·······0009·(9) | 72272 | 532AC1·Filename·Length·······0009·(9) |
72273 | 532AC3·Extra·Length··········0000·(0) | 72273 | 532AC3·Extra·Length··········0000·(0) |
72274 | 532AC5·Comment·Length········0000·(0) | 72274 | 532AC5·Comment·Length········0000·(0) |
72275 | 532AC7·Disk·Start············0000·(0) | 72275 | 532AC7·Disk·Start············0000·(0) |
72276 | 532AC9·Int·File·Attributes···0000·(0) | 72276 | 532AC9·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 4290, 15 lines modified | Offset 4290, 15 lines modified | ||
4290 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4290 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4291 | ······as·well·for·the·connection·to·be·made. | 4291 | ······as·well·for·the·connection·to·be·made. |
4292 | ···user·=·<value>·······(String) | 4292 | ···user·=·<value>·······(String) |
4293 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4293 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4294 | ······current·username. | 4294 | ······current·username. |
4295 | ······[Default:·pbuilder | 4295 | ······[Default:·pbuilder2] |
4296 | ···password·=·<value>·······(String) | 4296 | ···password·=·<value>·······(String) |
4297 | ······Password·for·logging·in·to·SQL·database. | 4297 | ······Password·for·logging·in·to·SQL·database. |
4298 | ···sql·=·<sql>·······(String) | 4298 | ···sql·=·<sql>·······(String) |
4299 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be | 4299 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be |
4300 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") | 4300 | ······repeated,·or·statements·may·be·separated·by·semicolon·(";") |
Offset 4497, 15 lines modified | Offset 4497, 15 lines modified | ||
4497 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4497 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4498 | ······as·well·for·the·connection·to·be·made. | 4498 | ······as·well·for·the·connection·to·be·made. |
4499 | ···user·=·<value>·······(String) | 4499 | ···user·=·<value>·······(String) |
4500 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4500 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4501 | ······current·username. | 4501 | ······current·username. |
4502 | ······[Default:·pbuilder | 4502 | ······[Default:·pbuilder2] |
4503 | ···password·=·<value>·······(String) | 4503 | ···password·=·<value>·······(String) |
4504 | ······Password·for·logging·in·to·SQL·database. | 4504 | ······Password·for·logging·in·to·SQL·database. |
4505 | ···dbtable·=·<table-name>·······(String) | 4505 | ···dbtable·=·<table-name>·······(String) |
4506 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the | 4506 | ······The·name·of·the·table·in·the·SQL·database·which·provides·the |
4507 | ······remote·data. | 4507 | ······remote·data. |
Offset 4605, 15 lines modified | Offset 4605, 15 lines modified | ||
4605 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property | 4605 | ······classpath·and·referenced·in·the·jdbc.drivers·system·property |
4606 | ······as·well·for·the·connection·to·be·made. | 4606 | ······as·well·for·the·connection·to·be·made. |
4607 | ···user·=·<value>·······(String) | 4607 | ···user·=·<value>·······(String) |
4608 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the | 4608 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the |
4609 | ······current·username. | 4609 | ······current·username. |
4610 | ······[Default:·pbuilder | 4610 | ······[Default:·pbuilder2] |
4611 | ···password·=·<value>·······(String) | 4611 | ···password·=·<value>·······(String) |
4612 | ······Password·for·logging·in·to·SQL·database. | 4612 | ······Password·for·logging·in·to·SQL·database. |
4613 | ···select·=·<select-stmt>·······(String) | 4613 | ···select·=·<select-stmt>·······(String) |
4614 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT | 4614 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT |
4615 | ······statement·to·identify·which·rows·undergo·updates. | 4615 | ······statement·to·identify·which·rows·undergo·updates. |
Offset 13235, 15 lines modified | Offset 13235, 15 lines modified | ||
13235 | ····env.setValue('format',·_map_env_value(format)) | 13235 | ····env.setValue('format',·_map_env_value(format)) |
13236 | ····env.setValue('client',·_map_env_value(client)) | 13236 | ····env.setValue('client',·_map_env_value(client)) |
13237 | ····mode·=·_stilts.getModeFactory().createObject('samp') | 13237 | ····mode·=·_stilts.getModeFactory().createObject('samp') |
13238 | ····consumer·=·mode.createConsumer(env) | 13238 | ····consumer·=·mode.createConsumer(env) |
13239 | ····_check_unused_args(env) | 13239 | ····_check_unused_args(env) |
13240 | ····consumer.consume(table) | 13240 | ····consumer.consume(table) |
13241 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder | 13241 | def·mode_tosql(table,·protocol,·db,·dbtable,·host='localhost',·write='create',·user='pbuilder2',·password=None): |
13242 | ····'''\ | 13242 | ····'''\ |
13243 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC | 13243 | Writes·a·new·table·to·an·SQL·database.·You·need·the·appropriate·JDBC |
13244 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). | 13244 | drivers·and·-Djdbc.drivers·set·as·usual·(see·SUN/256). |
13245 | Parameters: | 13245 | Parameters: |
13246 | ···protocol·=·<jdbc-protocol>·······(String) | 13246 | ···protocol·=·<jdbc-protocol>·······(String) |
Offset 13285, 15 lines modified | Offset 13285, 15 lines modified | ||
13285 | ············of·columns)·for·the·data·being·written. | 13285 | ············of·columns)·for·the·data·being·written. |
13286 | ······[Default:·create] | 13286 | ······[Default:·create] |
13287 | ···user·=·<username>·······(String) | 13287 | ···user·=·<username>·······(String) |
13288 | ······User·name·for·the·SQL·connection·to·the·database. | 13288 | ······User·name·for·the·SQL·connection·to·the·database. |
13289 | ······[Default:·pbuilder | 13289 | ······[Default:·pbuilder2] |
13290 | ···password·=·<passwd>·······(String) | 13290 | ···password·=·<passwd>·······(String) |
13291 | ······Password·for·the·SQL·connection·to·the·database. | 13291 | ······Password·for·the·SQL·connection·to·the·database. |
13292 | ''' | 13292 | ''' |
13293 | ····env·=·_JyEnvironment() | 13293 | ····env·=·_JyEnvironment() |
13294 | ····env.setValue('protocol',·_map_env_value(protocol)) | 13294 | ····env.setValue('protocol',·_map_env_value(protocol)) |
13295 | ····env.setValue('db',·_map_env_value(db)) | 13295 | ····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-11-20·14:21:47.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2024-11-20·14:21:47.000000·debian-binary |
2 | -rw-r--r--···0········0········0·····3332·2024-11-20·14:21:47.000000·control.tar.xz | 2 | -rw-r--r--···0········0········0·····3332·2024-11-20·14:21:47.000000·control.tar.xz |
3 | -rw-r--r--···0········0········0··23756 | 3 | -rw-r--r--···0········0········0··2375660·2024-11-20·14:21:47.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 75078, 15 lines modified | Offset 75078, 15 lines modified | ||
75078 | ················ | 75078 | ················ |
75079 | ················<dd> | 75079 | ················<dd> |
75080 | ····················User·name·for·logging·in·to·SQL·database. | 75080 | ····················User·name·for·logging·in·to·SQL·database. |
75081 | Defaults·to·the·current·username. | 75081 | Defaults·to·the·current·username. |
75082 | ····················<p> | 75082 | ····················<p> |
75083 | ························[Default:·<code>pbuilder | 75083 | ························[Default:·<code>pbuilder2</code>] |
75084 | ····················</p> | 75084 | ····················</p> |
75085 | ················</dd> | 75085 | ················</dd> |
75086 | ················ | 75086 | ················ |
75087 | ············</dl> | 75087 | ············</dl> |
75088 | ············ | 75088 | ············ |
75089 | ········</p> | 75089 | ········</p> |
75090 | ········ | 75090 | ········ |
Offset 76021, 15 lines modified | Offset 76021, 15 lines modified | ||
76021 | ················ | 76021 | ················ |
76022 | ················<dd> | 76022 | ················<dd> |
76023 | ····················User·name·for·logging·in·to·SQL·database. | 76023 | ····················User·name·for·logging·in·to·SQL·database. |
76024 | Defaults·to·the·current·username. | 76024 | Defaults·to·the·current·username. |
76025 | ····················<p> | 76025 | ····················<p> |
76026 | ························[Default:·<code>pbuilder | 76026 | ························[Default:·<code>pbuilder2</code>] |
76027 | ····················</p> | 76027 | ····················</p> |
76028 | ················</dd> | 76028 | ················</dd> |
76029 | ················ | 76029 | ················ |
76030 | ················<dt> | 76030 | ················<dt> |
76031 | ····················<strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong> | 76031 | ····················<strong><code>where·=·<sql-condition></code>· <em>(String)</em></strong> |
76032 | ················</dt> | 76032 | ················</dt> |
76033 | ················ | 76033 | ················ |
Offset 76243, 15 lines modified | Offset 76243, 15 lines modified | ||
76243 | ················ | 76243 | ················ |
76244 | ················<dd> | 76244 | ················<dd> |
76245 | ····················User·name·for·logging·in·to·SQL·database. | 76245 | ····················User·name·for·logging·in·to·SQL·database. |
76246 | Defaults·to·the·current·username. | 76246 | Defaults·to·the·current·username. |
76247 | ····················<p> | 76247 | ····················<p> |
76248 | ························[Default:·<code>pbuilder | 76248 | ························[Default:·<code>pbuilder2</code>] |
76249 | ····················</p> | 76249 | ····················</p> |
76250 | ················</dd> | 76250 | ················</dd> |
76251 | ················ | 76251 | ················ |
76252 | ············</dl> | 76252 | ············</dl> |
76253 | ············ | 76253 | ············ |
76254 | ········</p> | 76254 | ········</p> |
76255 | ········ | 76255 | ········ |
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 23150, 15 lines modified | Offset 23150, 15 lines modified | ||
23150 | ······Password·for·logging·in·to·SQL·database. | 23150 | ······Password·for·logging·in·to·SQL·database. |
23151 | ··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) | 23151 | ··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) |
23152 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, | 23152 | ······Text·of·an·SQL·statement·for·execution.·This·parameter·may·be·repeated, |
23153 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. | 23153 | ······or·statements·may·be·separated·by·semicolon·(";")·characters. |
23154 | ··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) | 23154 | ··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) |
23155 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 23155 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
23156 | ······username. | 23156 | ······username. |
23157 | ······[Default:·pbuilder | 23157 | ······[Default:·pbuilder2] |
23158 | *\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* | 23158 | *\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* |
23159 | Here·are·some·examples·of·sqlclient: | 23159 | Here·are·some·examples·of·sqlclient: |
23160 | ······This·sends·two·commands·to·a·SQL·Server·database;·the·first·one·(SET | 23160 | ······This·sends·two·commands·to·a·SQL·Server·database;·the·first·one·(SET |
23161 | ······SHOWPLAN...)·sets·a·flag·which·causes·the·DB·to·return·an·execution·plan | 23161 | ······SHOWPLAN...)·sets·a·flag·which·causes·the·DB·to·return·an·execution·plan |
23162 | ······rather·than·the·result·for·subsequent·queries,·and·the·second·makes·the | 23162 | ······rather·than·the·result·for·subsequent·queries,·and·the·second·makes·the |
23163 | ······query·itself.·Since·the·password·is·not·provided·on·the·command·line,·a | 23163 | ······query·itself.·Since·the·password·is·not·provided·on·the·command·line,·a |
23164 | ······prompt·for·it·will·be·issued·before·execution.·The·result·is·SQL·Server's | 23164 | ······prompt·for·it·will·be·issued·before·execution.·The·result·is·SQL·Server's |
Offset 23482, 15 lines modified | Offset 23482, 15 lines modified | ||
23482 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS | 23482 | ······Currently,·the·only·footprints·available·are·those·provided·by·the·CDS |
23483 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few | 23483 | ······MOC·(Multi-Order·Coverage·map)·service,·which·covers·VizieR·and·a·few |
23484 | ······other·cone·search·services. | 23484 | ······other·cone·search·services. |
23485 | ······[Default:·true] | 23485 | ······[Default:·true] |
23486 | ··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) | 23486 | ··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) |
23487 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 23487 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
23488 | ······username. | 23488 | ······username. |
23489 | ······[Default:·pbuilder | 23489 | ······[Default:·pbuilder2] |
23490 | ··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) | 23490 | ··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) |
23491 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the | 23491 | ······An·SQL·expression·further·limiting·the·rows·to·be·selected·from·the |
23492 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied | 23492 | ······database.·This·will·be·combined·with·the·constraints·on·position·implied |
23493 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should | 23493 | ······by·the·cone·search·centres·and·radii.·The·value·of·this·parameter·should |
23494 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null | 23494 | ······just·be·a·condition,·it·should·not·contain·the·WHERE·keyword.·A·null |
23495 | ······value·indicates·no·additional·criteria. | 23495 | ······value·indicates·no·additional·criteria. |
23496 | *\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* | 23496 | *\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 23556, 15 lines modified | Offset 23556, 15 lines modified | ||
23556 | ······[Default:·true] | 23556 | ······[Default:·true] |
23557 | ··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) | 23557 | ··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) |
23558 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to | 23558 | ······Gives·the·full·text·(including·"SELECT")·of·the·SELECT·statement·to |
23559 | ······identify·which·rows·undergo·updates. | 23559 | ······identify·which·rows·undergo·updates. |
23560 | ··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) | 23560 | ··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) |
23561 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current | 23561 | ······User·name·for·logging·in·to·SQL·database.·Defaults·to·the·current |
23562 | ······username. | 23562 | ······username. |
23563 | ······[Default:·pbuilder | 23563 | ······[Default:·pbuilder2] |
23564 | *\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* | 23564 | *\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* |
23565 | Here·are·some·examples·of·sqlupdate: | 23565 | Here·are·some·examples·of·sqlupdate: |
23566 | ······Fills·in·the·HTMID·column·of·a·table·called·FIRST·in·the·local·MySQL | 23566 | ······Fills·in·the·HTMID·column·of·a·table·called·FIRST·in·the·local·MySQL |
23567 | ······database·RADIO,·using·HTM·pixel·indices·based·on·the·existing·right | 23567 | ······database·RADIO,·using·HTM·pixel·indices·based·on·the·existing·right |
23568 | ······ascension·and·declination·columns·in·that·table.·The·HTMID·column·must | 23568 | ······ascension·and·declination·columns·in·that·table.·The·HTMID·column·must |
23569 | ······exist·prior·to·executing·this·command. | 23569 | ······exist·prior·to·executing·this·command. |
23570 | =============================================================================== | 23570 | =============================================================================== |