import subprocess
import re

# Get all the Wi-Fi profiles (ssid)
out = subprocess.check_output("netsh wlan show profiles").decode()

# Filter out only profile names from the output
matches = re.findall(r"(All User Profile)(.*)", out)

# List comprehension to remove any \n \r \t and spaces
profiles = [str(match[1]).split(":")[1].strip() for match in matches]


# File object to store passwords with ssid
with open("passwords.txt", "w+") as f:

    # Traversing each profile
    for profile in profiles:
        # try/except block to keep the noscript from crashing if there was an error while execution
        try:
            # Get password using key=clear flag
            get_pass = subprocess.check_output(
                f'netsh wlan show profile "{profile}" key=clear'
            ).decode()

            # Filter out the Password line from the output
            pass_by_profile = re.search(r"(Key Content)(.*)", get_pass)

            # Check if the password is present or wi-fi was open
            if pass_by_profile:
                password = pass_by_profile.group().split(":")[1].strip()
            else:
                password = "THE WIFI IS OPEN"

            # Write the profile name and password to the text file
            f.write(f"{profile} : {password}\n")
        except Exception:
            continue

    var query string = "select "
    query += "name, family "
    query += "from "
    query += "users "
    query += "where 1 = 1 "
    query += "and name = `ali` "
    db.Execute(query)

    var sbQuery strings.Builder
    sbQuery.WriteString("select ")
    sbQuery.WriteString("name, family ")
    sbQuery.WriteString("from ")
    sbQuery.WriteString("users ")
    sbQuery.WriteString("where 1 = 1 ")
    sbQuery.WriteString("and name = `ali` ")
    db.Execute(query)

    var btQuery bytes.Buffer = bytes.Buffer{}
    btQuery.WriteString("select ")
    btQuery.WriteString("name, family ")
    btQuery.WriteString("from ")
    btQuery.WriteString("users ")
    btQuery.WriteString("where 1 = 1 ")
    btQuery.WriteString("and name = `ali` ")
    db.Execute(query)