SQA | Software Quality Assurance | Code Quality library

I am using the "cryptography" module in Python to create self-signed certificates for testing. I followed the examples here "https://cryptography.io/en/latest/x509/tutorial.html" and "https://gist.github.com/bloodearnest/9017111a313777b9cce5", and have the following code so far --

My current code opens a website and logins. the next step is that I want to select a link on the next page but don't know how to get the code to click on it (first time messing with HTML code). below is a picture of the HTML behind that link. If more info is needed I can update with more pictures.

So I've been working on a scraper. Everything was well until I've tried scraping data for individual link.

Now to explain: I've got a scraper, which scrapes me data about apartments. Now first url is page where the articles are located(approx. 29-30 should be fetched). Now on that page I don't have information about square meters, so I need to run another scraper for each link that is scraped, and scrape square meters from there.

Here is the code that I have:

I can't set profile with automatic download for CSV file when using selenium.

Among the others, I tried solutions presented in the following questions:

• How do I automatically download files from a pop up dialog using selenium-python

• https://sqa.stackexchange.com/questions/2197/how-to-download-a-file-using-seleniums-webdriver
  

On my "regular firefox" I can set the rule to download it automatically, it works, however when geckodriver runs firefox, this rule/profile does not apply.

I have administrator rights. And As I read on another question, my orange bar in firefox is a result of controlling it by webdriver.

Here is sample of my code:

I'm new to this area, but I'm currently working on a lock sheet for the user. The script is working if I'm the owner so the only problem is if I run it on the user side. I read somewhere that I need to use a Web App or doGet function for the sheet to read the script as the owner. I tried these solutions on these threads, but I still can't make it work. I don't know if the script is the problem or I'm the problem so that's why I'm asking this here. I'm hoping that someone can help me with this matter.

Here a replicate spreadsheet that I'm working on: Spreadsheet

Threads that I tried:

• How to enable not authorized users to protect the spreadsheet
• Working with Protected Sheets and Ranges “View Only” mode
• Google Script having a conflict with scripts
• Google Sheets - Run script with Sheet Protection

Here's my script for the Lock function

I'm experiencing an error called code 500. The script works fine if I'm using it in the owner account, but if I'm going to open the file as a user/editor, the code 500 error shows. Here is the link to the sample spreadsheet that I'm working on. I tried asking here but seems like it is a little complicated so I created a new single spreadsheet so that it can be easily identified the error.

Here's the code

I'm facing some issues while running pyiron jobs on my HPC via the pysqa adapter. I had accidentally erased the main pyiron directory containing pyiron, projects and resources folders. I had copied all the three from another cluster. The only thing that I think will cause problem is sqlite.db file in the resources folder. Previously, I had no issues running interactive VASP jobs through the adapter. I'm guessing something happened after the deletion incident.

The pyiron version I'm using is: 0.2.17

Here is a minimal example using an Interactive vasp job that I have tried:

I'm working now on hiding a row if a certain cell is empty. The code for hiding a rows works, but I encountered a problem with it. Here's a sample spreadsheet that I'm trying to do: LINK

As you can see, it will work if column A didn't have any value on it.

But when I put something in column A, it will look like this.

Here's the code for hiding the rows:

I'm trying to hide rows across a multiple sheets. So I have a 6 sheets, but there are 4 similar sheets, the other one is more likely a summary of that 4 sheets and the other one is the sheet with a button. Here's a sample for your reference: LINK

It is working if I will put a HIDE ROWS button on sheets one by one, but it will take a lot of time for me to do it since I need to put it on different spreadsheets. My idea is to put a button per spreadsheet or upon opening it, the rows that are empty will be hidden. The SHOW ROWS button is perfectly working with it.

Here's the script that I'm using: LINK

PROBLEM:

• Hide rows across multiple sheets with similar templates
• Summary sheets rows should be hidden together with 4 sheets (not same rows)

I hope that someone can help me. Thank you in advance!