modapplicationposter.py

def run(workbookname, usernamecolletter=None, subreddit=None, notifyme=False, useragent=None, username=None, password=None):
    """
    Main instance

    The user that is OAuthed or LoginAuthed must be an approved contributor to the sub to post apps
    and must be an approved submitter to the sub. Just making it a mod won't work.

    :param usernamecolletter: the letter of the column that denotes the applicant's username.
    If not specified, it will make the title have the timestamp instead of the user's name. This
    script assumes that the timestamp row is the first row, so it uses appropiate grammar to comply.
    :param notifyme: whether or not to send inbox replies to the account that is making the posts. default is False.
    :param subreddit: the sub to post to (string or praw.objects.Subreddit object). While it is a
    keyword argument, that's only cause technicalities. IT IS REQUIRED.
    :param useragent: optional useragent to specify. The default is
    'Mod application to subreddit poster posting to /r/{subreddit} by /u/13steinj'
    :params username, password: A username and password to specify if you wish to use LoginAuth.
    If OAuth is available, OAuth will have priority. If it fails, login auth will be used.
    IN PRAW4 LOGIN AUTH WILL BE DEPRECATED, JUST AS A REMINDER IN CASE YOU SAY THIS SCRIPT DOESN'T WORK WHEN IT'S OUT
    
    :returns: The amount of posts made and the sub they were made to.
    """
    if subreddit == None:
        raise TypeError("run() missing required keyword argument subreddit, dipshit")
    import praw
    import openpyxl
    useragent = (useragent or 
                 ("Mod application to subreddit "
                  "poster posting to /r/{0} by /u/13steinj".format(subreddit)))
    r = praw.Reddit(useragent)
    try:
        import OAuth2Util
        o = OAuth2Util.OAuth2Util(r)
        o.refresh(force=True)
    except Exception as e:
        if e.__class__ == ImportError and username and password:
            print("OAuth2Util not installed, using login")
            r.login(username, password)
        elif username and password:
            print("OAuth2Util failure, attempting to use login")
            r.login(username, password)
            print("Success")
        else:
            raise
    workbook = openpyxl.load_workbook('{0}.xlsx'.format(workbookname))
    sheets = workbook.get_sheet_names()
    if len(sheets) > 1:
        sheetlist = '\n'.join(['{0}: {1}'.format((sheets.index(i)+1), i) for i in sheets])
        num = input("Which sheet would you like?\n{0}\n".format(sheetlist))
        try:
            num = int(num)
            if num <= 0:
                raise IndexError("What a dipshit this user is. If only we could replace them with more code...")
            sheet = sheets[num-1]
        except ValueError:
            raise ValueError("You had to choose a number, dipshit")
        except IndexError:
            raise IndexError("That sheet doesn't exist, dipshit.")
    else:
        sheet = sheets[0]
    spreadsheet = workbook[sheet]
    rows = list(spreadsheet.rows)
    questionrow = rows.pop(0)
    questionvals = {cell.column: cell.value for cell in questionrow if cell.value is not None}
    if usernamecolletter and usernamecolletter not in questionvals:
        raise KeyError("That usernamecolumnletter doesn't exist, dipshit")
    rownum = 0
    for row in rows:
        # clear out username, title, and body for next run
        rownum += 1
        username = None
        body = ''
        # make body
        for cell in row:
            if cell.column not in questionvals:
                continue
            body += "#{0}\n\n".format(questionvals[cell.column])
            body += "{0}\n\n---\n\n".format(cell.value if cell.value else "*No Answer*")
            if username:
                continue
            else:
                username = cell.value if cell.column == usernamecolletter else None
        titleinfo = "at {0}".format(row[0].value) if not username else "by {0}".format(username)
        title = "Moderator Application #{0} {1}".format(rownum, titleinfo)
        post = r.submit(subreddit, title, text=body, send_replies=notifyme)
        print("Submitted {0}".format(post.permalink))
    print("I've just posted {0} applications, dipshit. I'm done now. Call me when you want me again. But you could at least ask me out to dinner first, you rascal!".format(rownum))
    return rownum, subreddit

theinfo.md

Named theinfo.md because if it was README.md github gists has a bug that changes the title name of the gist to README.md

praw and openpyxl must be installed. OAuth2Util is optional. In a terminal with root access:

pip3 install openpyxl
pip3 install praw
pip3 install praw-OAuth2Util

Recommended usage is as follows:

Place the Microsoft Office(xlsx) (not Microsoft Office Legacy(xls), those don't work as well or may not at all, don't know) and this script in the same folder. If you have an OAuth2Util oauth.ini, put that in here to. The script will attempt to use OAuth if it can, else it will default to the username ad password arguments, if possible, else raise an error.

To run, either:

Open python3 in a terminal, depending on the OS it's either python3 or py -3. Type

>>> from modapplicationposter import run
>>> run('nameofworkbookwithoutxlsx', 'columnletterforusernamesifapplicable',
... subreddit='subreddityouarepostingtowithout/r/' **kw)

You can also do this in a terminal/cmd:

python3 -c "from modapplicationposter import run; run('nameofworkbookwithoutxlsx', 'columnletterforusernamesifapplicable', subreddit='subreddityouarepostingtowithout/r/' **kw)"

Note: Like above, you may need to replace python3 with py -3

**kw are any of the other params as mentioned by the docstring in modapplicationposter.py.

Note: If you get some weird language when you get an error, it's because I was drunk when I first wrote this, and when I continued and was sober, I found it funny and kept it in.

Also: READ THE DOCSTRING

Quick question: How hard would it be to make it leave out the 'badword' keyword from the table if it returns zero results?

I just ran one with a long list of words and the table is a bazillion lines long. Haha.

If you get bored and want to mess with this, I just used this again and had a couple of suggestions.

In this section, it would be really useful to have the age of the account in Years, Months, Days format.

It would also be helpful to sort the table buy quantity of bad words, and the following table by the quantity of posts/comments.