Best Python code snippet using avocado_python
excel_helper.py
Source:excel_helper.py
...14 if write:15 self._open_for_write(sheet_name)16 else:17 if sheet_name:18 self._open_for_read(f, content, sheet_name)19 else:20 self._open_for_read(f, content, sheet_number)21 def add_sheet(self, name, sheet_number):22 self.sheet = self.wb.add_sheet(name)23 self.sheet_number = sheet_number24 self.x = 025 self.y = 026 def _open_for_read(self, f, content, sheet):27 if content:28 self.wb = xlrd.open_workbook(file_contents=content)29 else:30 self.wb = xlrd.open_workbook(f)31 if isinstance(sheet, basestring):32 self._goto_sheet(sheet_name=sheet)33 else:34 self._goto_sheet(int(sheet))35 def _open_for_write(self, sheet_name):36 self.wb = xlwt.Workbook(encoding='utf-8')37 self.sheet = self.wb.add_sheet(sheet_name) 38 self.sheet_number = 039 self.x = 140 self.y = 0...
shortmagic.py
Source:shortmagic.py
...25 def _write_command(self):26 command = input("Command: ")27 description = input("Description: ")28 return f"{command} {SEP} {description}\n"29 def _open_for_read(self, file):30 line_cache = []31 file_path = f"{DIR}/{getenv('SHORTCUT_DIR_NAME')}/{file}"32 with open(file_path, "r") as file:33 for line in file.readlines():34 try:35 line_cache.append(line)36 except IndexError:37 pass38 return line_cache39 def _open_for_append(self, file):40 file = f"{DIR}/{getenv('SHORTCUT_DIR_NAME')}/{file}"41 with open(file, "a") as file:42 file.write(self._write_command())43 def _open_for_clean_write(self, file, lines: None = list):44 file = f"{DIR}/{getenv('SHORTCUT_DIR_NAME')}/{file}"45 with open(file, "w") as file:46 file.writelines(lines)47 def _edit_file(self, file):48 coms = self._open_for_read(file)49 com_dict = {}50 for i in coms:51 k, v = i.split(SEP)52 com_dict[k.strip()] = v53 print(f"{k} : {v}")54 while True:55 k = input("Command to edit (typed exactly as seen): ").strip()56 if not com_dict.get(k):57 print("\ncommand is typed incorrectly or does not exist\n")58 continue59 com_dict.pop(k)60 newk, newv = self._write_command().split(SEP)61 com_dict[newk] = newv62 break63 scitems = [f"{k} {SEP} {v}" for k,v in com_dict.items()]64 self._open_for_clean_write(file, scitems)65# Custom ipython magic method documentation at: 66# https://ipython.readthedocs.io/en/stable/config/custommagics.html67@magics_class68class ShortMagic(ShortUtil, Magics):69 def __init__(self, *args, **kwargs):70 super().__init__(*args, **kwargs)71 self.apps = getenv("APPLICATIONS").split()72 self.scdir = DIR.joinpath(getenv("SHORTCUT_DIR_NAME"))73 self._create_files()74 @line_magic75 def sc(self, line):76 "Get a user defined list of IPython shortcuts"77 app = self._interpret_line(line, self.apps)78 if not app:79 return80 file = f"{app}.sct"81 coms = self._open_for_read(file)82 for i in coms:83 line = i.split(SEP)84 print(f"{line[0]} : {line[1]}")85 @line_magic86 def sc_add(self, line):87 "Add to IPython shortcuts file - ishortcuts.txt"88 app = self._interpret_line(line, self.apps)89 if not app:90 return91 file = f"{app}.sct"92 self._open_for_append(file)93 @line_magic94 def sc_edit(self,line):95 breakpoint()...
Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Get 100 minutes of automation test minutes FREE!!