passing variable from one script to another on python

Question

I have two scripts, qyeryfunction.py and generatecharts.py. I would like to get the results of the week_number variable from queryfunction and put them in weeks in generatecharts.py. How can I do this?

#queryfunction.py
import MySQLdb

try:
    db = MySQLdb.connect("localhost","myusr","mypass","mydb")
except MySQLdb.DatabaseError:
    print 'Cant connect to database, check if MySQL service is running'

class WeekQuery:
    def __init__(self, name):
        self.name = name

    def query(self):
        try:
            cursor = db.cursor()
            cursor.callproc(self)
            results = cursor.fetchall()
            week_number = [i[0] for i in cursor.description]
        except MySQLdb.ProgrammingError:
            print 'Data unavailable'
            cursor.close()
        return results

and

#generatecharts.py
from queryfunction import WeekQuery, query

#class GenerateCharts():

n = WeekQuery('my_first_query')
g = WeekQuery('my_second_query')

first_data = query(n.name)
second_data = query(g.name)
weeks = ???

101 · Accepted Answer · 2014-12-17 02:55:59Z

3

You can just return the week_number variable from the query function in queryfunction.py as well:

return (results, week_number)

And you'd have to change generatecharts.py slightly to accept a tuple as the return value. This will assign results to first_data and week_number to weeks:

first_data, weeks = query(n.name)

edited Dec 17, 2014 at 2:55

answered Dec 17, 2014 at 2:48

101

9,0576 gold badges47 silver badges71 bronze badges

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

2 Comments

Robert Over a year ago

Thank you for your help, I didn't expect that it will be as easy.

101 Over a year ago

No worries, glad it helped :^)

Collectives™ on Stack Overflow

passing variable from one script to another on python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related