Passing values to a function from within a function in python

Question

I need to pass values from one function to the next from within the function.

For example (my IRC bot programmed to respond to commands in the channel):

def check_perms(nick,chan,cmd):
  sql = "SELECT `"+ cmd +"` FROM permissions WHERE nick = '"+ nick +"' and chan = '"+ chan +"'" # This returns 0
  #sql = "SELECT `restart` FROM permissions WHERE nick = 'Me' and chan = '#mychan'" # this works as intended
  cursor.execute(sql)
  result = cursor.fetchall()
  for row in result:
     if (row[0] == 1): # Nick logged in and has permission
        return 1 
     else: # nick does not have permissions
        return 0

def com_restart(nick,chan):
  perm = check_perms(nick,chan,"restart")
  if (perm == 0): # nick did not have permission
     irc.send("NOTICE "+ nick +" :Permission denied.\n")
  elif (perm == 1): # nick has permission
     irc.send("PRIVMSG "+ chan +" :I've been asked to restart myself by "+ nick +".\n")

nick = "Me" # This is determined by a bunch of regex splits and such
chan = "#mychan" # This is determined by regex splits as well
com_restart(nick,chan)

When I try this, though, it seems the values do not get passed to the SQL query, so it returns 0.

Thanks for any help you can provide.

EDIT - Added code that I'm working with as it stands right now.

What do you mean "Doesn't work at all" ? How are you calling y? That looks fine. — richo
– richo, Commented Jan 12, 2012 at 1:53
Do you ever call your functions? If not, nothing will ever happen. — user830639
– user830639, Commented Jan 12, 2012 at 1:53
Your code has multiple problems when it comes to syntax, but apart from that, where are you calling y? You'd need a call like y(foo, bar) after your initialization of foo and bar. — Yuushi
– Yuushi, Commented Jan 12, 2012 at 1:54
Please post real code, real corresponding error messages, real descriptions of what it should do, real descriptions of what actually happens, real anything. — Karl Knechtel
– Karl Knechtel, Commented Jan 12, 2012 at 3:04

eeeeaaii · Accepted Answer · 2012-01-12 03:46:38Z

0

What do you mean the string "sql" "returns zero" -- a string isn't a function or expression so it doesn't "return" anything. A string is just a literal value.

Are you saying that cursor.execute() returns zero? What is "cursor" equal to? Do you correctly initialize the "cursor" object to something somewhere else?

if "cursor" is a global object you may have to declare it as such, like this:

global cursor

otherwise you won't be able to make changes to it.

Other than that I can't figure out what you're doing or what's wrong.

answered Jan 12, 2012 at 3:46

eeeeaaii

3,4506 gold badges32 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Makoto · Accepted Answer · 2012-01-12 04:59:52Z

0

I'm not so sure about this line of code:

sql = "SELECT `"+ cmd +"` FROM permissions WHERE nick = '"+ nick +"' and chan = '"+ chan +"'" # This returns 0

It seems you're trying to make sure that the query strings are in proper format. But that's not necessary. You can concatenate your string query and it would work fine like this:

sql = "SELECT " + cmd + " FROM permissions WHERE nick = " + nick + " and chan = " + chan

Observe that there are no single quotes anywhere in the query statement.

answered Jan 12, 2012 at 4:59

Makoto

107k29 gold badges200 silver badges236 bronze badges

Collectives™ on Stack Overflow

Passing values to a function from within a function in python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related