[Python-announce] python-oracledb 1.1.0

[Anthony Tuininga]

What is python-oracledb?

python-oracledb is a Python extension module that enables access to Oracle
Database for Python and conforms to the Python database API 2.0
specifications with a number of enhancements. This module is intended to
eventually replace cx_Oracle.

Where do I get it?

https://pypi.org/project/oracledb/1.1.0/

The easiest method to install/upgrade python-oracledb is via pip as in

python -m pip install oracledb --upgrade

What's new?

This release adds support for Azure Active Directory OAuth 2.0 and Oracle
Cloud Infrastructure Identity and Access Management (IAM) token
authentication. It also adds support for JSON payloads in Advanced Queuing
(AQ) and addresses a number of smaller enhancements and bug fixes.

See the full release notes for all of the details:
https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-1-0-september-2022

Please provide any feedback via GitHub issues: https://github.com/oracle/
python-oracledb/issues or discussions: https://github.com/oracle/python-
oracledb/discussions
___
Python-announce-list mailing list -- python-announce-list@python.org
To unsubscribe send an email to python-announce-list-le...@python.org
https://mail.python.org/mailman3/lists/python-announce-list.python.org/
Member address: arch...@mail-archive.com

Re: problem downloading python

[Dennis Lee Bieber]

On Wed, 14 Sep 2022 11:42:39 +0200, "carlharrison"
 declaimed the following:

>I am working on a PC with windows 10 and use Eset internet security. I have
>tried downloading  python 3.10.7 for windows. Using a tutorial I see that a
>checkbox should appear called "Add python 3/7 to path" but this does not
>appear whichever version I try to download. I wondered if Eset was stopping
>this somehow and tried it with Eset switched off but the result is the same.
>Can you help?

Download from where? (There are a number of distributions available,
including ones in the M$ "app" store, Visual Studio, etc.)

"Add Python..." is a step when RUNNING the installer. It should not
appear when DOWNLOADING the installer.

The general sequence is:

Download the installer file for the distribution.

RUN the installer program to install Python (and any other stuff
the distribution includes)

Hide the installer program/icons -- since they do NOT run Python
itself. Pure Python is run from a command line/shell interface; it is NOT a
graphical IDE.


-- 
Wulfraed Dennis Lee Bieber AF6VN
wlfr...@ix.netcom.comhttp://wlfraed.microdiversity.freeddns.org/
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: problem downloading python

[Lars Liedtke]

Hello and welcome,

Sadly I don't know about Eset internet security, or why you do not get the 
choice of letting the installer do that, but you could try to add Python 
manually to your PATH like it is described in 
https://www.geeksforgeeks.org/how-to-add-python-to-windows-path/ .

But maybe some more windows savvy people than me might chime in to offer better 
advice ;-) .

Cheers

Lars


Lars Liedtke
Software Entwickler

[Tel.]
[Fax]   +49 721 98993-
[E-Mail]l...@solute.de


solute GmbH
Zeppelinstraße 15
76185 Karlsruhe
Germany


[Logo Solute]


Marken der solute GmbH | brands of solute GmbH
[Marken]
[Advertising Partner]

Geschäftsführer | Managing Director: Dr. Thilo Gans, Bernd Vermaaten
Webseite | www.solute.de 
Sitz | Registered Office: Karlsruhe
Registergericht | Register Court: Amtsgericht Mannheim
Registernummer | Register No.: HRB 110579
USt-ID | VAT ID: DE234663798



Informationen zum Datenschutz | Information about privacy policy
https://www.solute.de/ger/datenschutz/grundsaetze-der-datenverarbeitung.php




Am 14.09.22 um 11:42 schrieb carlharrison:

Dear Sir or Madam,

I am working on a PC with windows 10 and use Eset internet security. I have
tried downloading  python 3.10.7 for windows. Using a tutorial I see that a
checkbox should appear called "Add python 3/7 to path" but this does not
appear whichever version I try to download. I wondered if Eset was stopping
this somehow and tried it with Eset switched off but the result is the same.
Can you help?

Best regards,

Carl Harrison.




--
https://mail.python.org/mailman/listinfo/python-list

Re: Uninstall tool not working.

[DFS]

On 9/13/2022 3:54 PM, Salvatore Bruzzese wrote:

Hi,
I was trying to uninstall version 3.10.7 of python but I've
encountered problems with the uninstall tool.
I open the python setup program, click on the uninstall button but it
doesn't even start deleting python even though it says that the
process has finished.
Feel free to ask for more details in case I didn't explain it correctly.

Thanks in advance for your help.




https://stackoverflow.com/questions/3515673/how-to-completely-remove-python-from-a-windows-machine


--
https://mail.python.org/mailman/listinfo/python-list

Re: Obtain the query interface url of BCS server.

[DFS]

On 9/13/2022 7:29 PM, hongy...@gmail.com wrote:

On Tuesday, September 13, 2022 at 9:33:20 PM UTC+8, DFS wrote:

On 9/13/2022 3:46 AM, hongy...@gmail.com wrote:

On Tuesday, September 13, 2022 at 4:20:12 AM UTC+8, DFS wrote:

On 9/12/2022 5:00 AM, hongy...@gmail.com wrote:

I want to do the query from with in script based on the interface here [1]. For this 
purpose, the underlying posting URL must be obtained, say, the URL corresponding to 
"ITA Settings" button, so that I can make the corresponding query URL and issue 
the query from the script.

However, I did not find the conversion rules from these buttons to the 
corresponding URL. Any hints for achieving this aim?

[1] 
https://www.cryst.ehu.es/cgi-bin/cryst/programs/nph-getgen?list=new=gen=10

Regards,
Zhao

You didn't say what you want to query. Are you trying to download
entire sections of the Bilbao Crystallographic Server?


I am engaged in some related research and need some specific data used by BCS 
server.

What specific data?


All the data corresponding to the total catalog here:
https://www.cryst.ehu.es/cgi-bin/cryst/programs/nph-getgen
  

Is it available elsewhere?


This is an internationally recognized authoritative data source in this field. 
Data from other places, even if there are readily available electronic 
versions, are basically taken from here and are not comprehensive.


Maybe the admins will give you access to the data.


I don't think they will provide such convenience to researchers who have no 
cooperative relationship with them.

You can try. Tell the admins what data you want, and ask them for the
easiest way to get it.

* this link: https://www.cryst.ehu.es/cgi-bin/cryst/programs/nph-getgen
brings up the table of space group symbols.

* choose say #7: Pc

* now click ITA Settings, then choose the last entry "P c 1 1" and it
loads:

https://www.cryst.ehu.es/cgi-bin/cryst/programs//nph-trgen?gnum=007=gp=b,-a-c,c=P%20c%201%201=ita


Not only that, but I want to obtain all such URLs programmatically!


You might be able to fool around with that URL and substitute values and
get back the data you want (in HTML) via Python. Do you really want
HTML results?

Hit Ctrl+U to see the source HTML of a webpage

Right-click or hit Ctrl + Shift + C to inspect the individual elements
of the page


For batch operations, all these manual methods are inefficient.

Yes, but I don't think you'll be able to retrieve the URLs
programmatically. The JavaScript code doesn't put them in the HTML
result, except for that one I showed you, which seems like a mistake on
their part.

So you'll have to figure out the search fields, and your python program
will have to cycle through the search values:

Sample from above
gnum = 007
what = gp
trmat = b,-a-c,c
unconv = P c 1 1
from = ita


The problem is that I must first get all possible combinations of these 
variables.



Shouldn't be too hard, but I've never done some of these things and have 
no code for you:


space group number = gnum = 1 to 230

* use python to put each of those values, one at a time, into the group 
number field on the webpage


* use python to simulate a button click of the ITA Settings button

* it should load the HTML of the list of ITA settings for that space group

* use python to parse the HTML and extract each of the ITA settings. 
The line of HTML has 'ITA number' in it.  Find each of the 'href' values 
in the line(s).


Real HTML from ITA Settings for space group 10:

ITA number bgcolor="#bb">Settingbgcolor="#f0f0f0">10 href="/cgi-bin/cryst/programs//nph-getgen?gnum=010=gp">P 1 
2/m 1bgcolor="#f0f0f0">10 href="/cgi-bin/cryst/programs//nph-trgen?gnum=010=gp=c,a,b=P 
1 1 2/m=ita">P 1 1 2/malign="center" bgcolor="#f0f0f0">10 href="/cgi-bin/cryst/programs//nph-trgen?gnum=010=gp=b,c,a=P 
2/m 1 1=ita">P 2/m 1 1



If you parse it right you'll have these addresses:

"/cgi-bin/cryst/programs//nph-getgen?gnum=010=gp"

"/cgi-bin/cryst/programs//nph-trgen?gnum=010=gp=c,a,b=P 1 
1 2/m=ita"


"/cgi-bin/cryst/programs//nph-trgen?gnum=010=gp=b,c,a=P 2/m 
1 1=ita"



Then you can parse each of these addresses and build a master list of 
the valid combinations of:


gnum, what, trmat, unconv, from


Check into the lxml library, and the 'etree' class.  https://lxml.de



You can also search gen.lib.rus.ec for the crystallography volumes, and 
maybe cut and paste data from them.







wBase = "https://www.cryst.ehu.es/cgi-bin/cryst/programs//nph-trgen;
wGnum = "?gnum=" + findgnum
wWhat = "=" + findWhat
wTrmat = "=" + findTrmat
wUnconv = "=" + findUnconv
wFrom = "=" + findFrom
webpage = wBase + wGnum + wWhat + wTrmat + wUnconv + wFrom

Then if that returns a hit, you'll have to parse the resulting HTML and
extract the exact data you want.



I did something similar a while back using the requests and lxml libraries

#build url
wBase = "http://www.usdirectory.com;
wForm = "/ypr.aspx?fromform=qsearch"
wKeyw = "=" + keyw

Re: Obtain the query interface url of BCS server.

[hongy...@gmail.com]

On Wednesday, September 14, 2022 at 10:41:32 AM UTC+8, DFS wrote:
> On 9/13/2022 7:29 PM, hongy...@gmail.com wrote: 
> > On Tuesday, September 13, 2022 at 9:33:20 PM UTC+8, DFS wrote: 
> >> On 9/13/2022 3:46 AM, hongy...@gmail.com wrote: 
> >>> On Tuesday, September 13, 2022 at 4:20:12 AM UTC+8, DFS wrote: 
>  On 9/12/2022 5:00 AM, hongy...@gmail.com wrote: 
> > I want to do the query from with in script based on the interface here 
> > [1]. For this purpose, the underlying posting URL must be obtained, 
> > say, the URL corresponding to "ITA Settings" button, so that I can make 
> > the corresponding query URL and issue the query from the script. 
> > 
> > However, I did not find the conversion rules from these buttons to the 
> > corresponding URL. Any hints for achieving this aim? 
> > 
> > [1] 
> > https://www.cryst.ehu.es/cgi-bin/cryst/programs/nph-getgen?list=new=gen=10
> >  
> > 
> > Regards, 
> > Zhao 
>  You didn't say what you want to query. Are you trying to download 
>  entire sections of the Bilbao Crystallographic Server? 
> >>> 
> >>> I am engaged in some related research and need some specific data used by 
> >>> BCS server. 
> >> What specific data? 
> > 
> > All the data corresponding to the total catalog here: 
> > https://www.cryst.ehu.es/cgi-bin/cryst/programs/nph-getgen 
> > 
> >> Is it available elsewhere? 
> > 
> > This is an internationally recognized authoritative data source in this 
> > field. Data from other places, even if there are readily available 
> > electronic versions, are basically taken from here and are not 
> > comprehensive. 
> > 
>  Maybe the admins will give you access to the data. 
> >>> 
> >>> I don't think they will provide such convenience to researchers who have 
> >>> no cooperative relationship with them. 
> >> You can try. Tell the admins what data you want, and ask them for the 
> >> easiest way to get it. 
>  * this link: https://www.cryst.ehu.es/cgi-bin/cryst/programs/nph-getgen 
>  brings up the table of space group symbols. 
>  
>  * choose say #7: Pc 
>  
>  * now click ITA Settings, then choose the last entry "P c 1 1" and it 
>  loads: 
>  
>  https://www.cryst.ehu.es/cgi-bin/cryst/programs//nph-trgen?gnum=007=gp=b,-a-c,c=P%20c%201%201=ita
>   
> >>> 
> >>> Not only that, but I want to obtain all such URLs programmatically! 
> >>> 
>  You might be able to fool around with that URL and substitute values and 
>  get back the data you want (in HTML) via Python. Do you really want 
>  HTML results? 
>  
>  Hit Ctrl+U to see the source HTML of a webpage 
>  
>  Right-click or hit Ctrl + Shift + C to inspect the individual elements 
>  of the page 
> >>> 
> >>> For batch operations, all these manual methods are inefficient. 
> >> Yes, but I don't think you'll be able to retrieve the URLs 
> >> programmatically. The JavaScript code doesn't put them in the HTML 
> >> result, except for that one I showed you, which seems like a mistake on 
> >> their part. 
> >> 
> >> So you'll have to figure out the search fields, and your python program 
> >> will have to cycle through the search values: 
> >> 
> >> Sample from above 
> >> gnum = 007 
> >> what = gp 
> >> trmat = b,-a-c,c 
> >> unconv = P c 1 1 
> >> from = ita 
> > 
> > The problem is that I must first get all possible combinations of these 
> > variables.
> Shouldn't be too hard, but I've never done some of these things and have 
> no code for you: 
> 
> space group number = gnum = 1 to 230 
> 
> * use python to put each of those values, one at a time, into the group 
> number field on the webpage 
> 
> * use python to simulate a button click of the ITA Settings button 
> 
> * it should load the HTML of the list of ITA settings for that space group 

This is the trickiest part of the problem. For this purpose, Vladimir gave the 
following suggestion here [1]:

This is trivial with Selenium. Highlight the element by XPATH and extract URL 
with .get_attribute("href")

[1] 
https://discuss.python.org/t/obtain-the-query-interface-url-of-bcs-server/18996/2?u=hongyi-zhao

> * use python to parse the HTML and extract each of the ITA settings. 
> The line of HTML has 'ITA number' in it. Find each of the 'href' values 
> in the line(s). 
> 
> Real HTML from ITA Settings for space group 10: 
> 
> ITA number  bgcolor="#bb">Setting bgcolor="#f0f0f0">10  href="/cgi-bin/cryst/programs//nph-getgen?gnum=010=gp">P 1 
> 2/m 1 bgcolor="#f0f0f0">10  href="/cgi-bin/cryst/programs//nph-trgen?gnum=010=gp=c,a,b=P
>  
> 1 1 2/m=ita">P 1 1 2/m align="center" bgcolor="#f0f0f0">10  href="/cgi-bin/cryst/programs//nph-trgen?gnum=010=gp=b,c,a=P
>  
> 2/m 1 1=ita">P 2/m 1 1 
>  
> 
> If you parse it right you'll have these addresses: 
> 
> "/cgi-bin/cryst/programs//nph-getgen?gnum=010=gp" 
> 
> "/cgi-bin/cryst/programs//nph-trgen?gnum=010=gp=c,a,b=P 1 
> 1 2/m=ita" 
> 
> 

problem downloading python

[carlharrison]

Dear Sir or Madam,

I am working on a PC with windows 10 and use Eset internet security. I have
tried downloading  python 3.10.7 for windows. Using a tutorial I see that a
checkbox should appear called "Add python 3/7 to path" but this does not
appear whichever version I try to download. I wondered if Eset was stopping
this somehow and tried it with Eset switched off but the result is the same.
Can you help?

Best regards,

Carl Harrison.

 

-- 
https://mail.python.org/mailman/listinfo/python-list

Python 3.9.14

[אורי]

Hi,

Python 3.9.14 has been released on Sept. 6, 2022. As I can see written on
https://www.python.org/downloads/release/python-3914/:

According to the release calendar specified in PEP 596, Python 3.9 is now
in the "security fixes only" stage of its life cycle: the 3.9 branch only
accepts security fixes and releases of those are made irregularly in
source-only form until October 2025. Python 3.9 isn't receiving regular bug
fixes anymore, and binary installers are no longer provided for it. Python
3.9.13 was the last full bugfix release of Python 3.9 with binary
installers.


Is there a safe way to install a 64-bit version of Python 3.9.14 on Windows?

Thanks,
Uri.
אורי
u...@speedy.net
-- 
https://mail.python.org/mailman/listinfo/python-list

Re: Virtual PUG-meeting: An applied introduction to Finite State Machines

[dn]

On 14/09/2022 10.18, Sam Ezeh wrote:
> That seems interesting.
> 
> Is this hosted online? And are there any suggested reading materials for
> those who might not be able to attend?


Yes there are - if you'd like to follow the link (below), the published
meeting-details include references.

One of my colleagues on the PUG Leadership Team has organised the
speaker, but I recall mention of "notebooks", etc. So, there may be
further resources which will be made-available during/after the talk
itself...

If you are a 'late-owl' in the (US) Pacific Time-Zone, you may like to
join us 'live'. Sadly, the timings rapidly become anti-social for more
easterly time-zones in the Americas.

If you are anywhere in the rest of the world, you will find that the
meeting falls sometime during your working-day, through to Europeans
at-breakfast!

You'll be most welcome!


> Kind regards,
> Sam Ezeh
> 
> On Tue, 13 Sept 2022 at 22:53, dn  > wrote:
> 
> An applied introduction to Finite State Machines
> 0730 UTC, Wed 21 Sep 2022
> 
> The basics of Finite State Machines and what they are good for. How to
> use FSM for solving optimization problems.
> 
> - A simple traffic jam
> - A bigger traffic jam
> - A sudoku
> 
> After this lecture there won't be any discrete optimization problem you
> won't be able to solve.
> 
> Dr. Bjorn Madsen solves optimization problems using Python, for DoD,
> LEGO, Coca Cola, Airbus and many other companies.
> 
> 
> These meetups have two sessions. At least one is aimed at a beginner
> level - in either Python or FSMs.
> 
> Sign-up and more details from https://www.meetup.com/nzpug-auckland/
> 
> -- 
> Regards,
> =dn
> -- 
> https://mail.python.org/mailman/listinfo/python-list
> 
> 


-- 
Regards,
=dn
-- 
https://mail.python.org/mailman/listinfo/python-list