Programming Forums > Script Programming > Python

Infinite Recursion · Oct 21st, 2006, 1:49 AM

Here is something I worked up to show you how to input data in MySQL via the command line in Python... should be easier to follow than the other example.

(Toggle Plain Text)

mysql> desc users;
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| userid | varchar(10) | YES  |     | NULL    |       |
| fname  | varchar(20) | YES  |     | NULL    |       |
| lname  | varchar(25) | YES  |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+

(Toggle Plain Text)

mysql> select * from users;
Empty set (0.00 sec)

Executed below script...

(Toggle Plain Text)

#python db.py test test test


mysql> select * from users;
+--------+-------+-------+
| userid | fname | lname |
+--------+-------+-------+
| test   | test  | test  |
+--------+-------+-------+
1 row in set (0.00 sec)

(Toggle Plain Text)

#! /usr/bin/python

import sys
import MySQLdb

id = sys.argv[1]
fname = sys.argv[2]
lname = sys.argv[3]

class Table:
     def __init__(self, db, name):
            self.db = db
            self.name = name
            self.dbc = self.db.cursor()

     def additem(self, item):
         sql = "INSERT INTO " + self.name + " VALUES ('" + id + "','" + fname + "','" + lname +"')"
         self.dbc.execute(sql)
         return

def main():
    db = MySQLdb.connect(db="DBNAME",host="HOSTNAME",user="USERNAME",passwd="PASSWORD");
    table = Table(db, "TABLENAME")
    table.additem("TABLENAME")

if __name__ == '__main__':
     main()

Let me know if you have trouble working in your specific tables... should be a matter of substitution of table name, fields, etc.

Oct 21st, 2006, 1:49 AM	#21
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,466 Rep Power: 8	Here is something I worked up to show you how to input data in MySQL via the command line in Python... should be easier to follow than the other example. (Toggle Plain Text) mysql> desc users; +--------+-------------+------+-----+---------+-------+ \| Field \| Type \| Null \| Key \| Default \| Extra \| +--------+-------------+------+-----+---------+-------+ \| userid \| varchar(10) \| YES \| \| NULL \| \| \| fname \| varchar(20) \| YES \| \| NULL \| \| \| lname \| varchar(25) \| YES \| \| NULL \| \| +--------+-------------+------+-----+---------+-------+ mysql> desc users; +--------+-------------+------+-----+---------+-------+ \| Field \| Type \| Null \| Key \| Default \| Extra \| +--------+-------------+------+-----+---------+-------+ \| userid \| varchar(10) \| YES \| \| NULL \| \| \| fname \| varchar(20) \| YES \| \| NULL \| \| \| lname \| varchar(25) \| YES \| \| NULL \| \| +--------+-------------+------+-----+---------+-------+ (Toggle Plain Text) mysql> select * from users; Empty set (0.00 sec) mysql> select * from users; Empty set (0.00 sec) Executed below script... (Toggle Plain Text) #python db.py test test test mysql> select * from users; +--------+-------+-------+ \| userid \| fname \| lname \| +--------+-------+-------+ \| test \| test \| test \| +--------+-------+-------+ 1 row in set (0.00 sec) #python db.py test test test mysql> select * from users; +--------+-------+-------+ \| userid \| fname \| lname \| +--------+-------+-------+ \| test \| test \| test \| +--------+-------+-------+ 1 row in set (0.00 sec) (Toggle Plain Text) #! /usr/bin/python import sys import MySQLdb id = sys.argv[1] fname = sys.argv[2] lname = sys.argv[3] class Table: def __init__(self, db, name): self.db = db self.name = name self.dbc = self.db.cursor() def additem(self, item): sql = "INSERT INTO " + self.name + " VALUES ('" + id + "','" + fname + "','" + lname +"')" self.dbc.execute(sql) return def main(): db = MySQLdb.connect(db="DBNAME",host="HOSTNAME",user="USERNAME",passwd="PASSWORD"); table = Table(db, "TABLENAME") table.additem("TABLENAME") if __name__ == '__main__': main() #! /usr/bin/python import sys import MySQLdb id = sys.argv[1] fname = sys.argv[2] lname = sys.argv[3] class Table: def __init__(self, db, name): self.db = db self.name = name self.dbc = self.db.cursor() def additem(self, item): sql = "INSERT INTO " + self.name + " VALUES ('" + id + "','" + fname + "','" + lname +"')" self.dbc.execute(sql) return def main(): db = MySQLdb.connect(db="DBNAME",host="HOSTNAME",user="USERNAME",passwd="PASSWORD"); table = Table(db, "TABLENAME") table.additem("TABLENAME") if __name__ == '__main__': main() Let me know if you have trouble working in your specific tables... should be a matter of substitution of table name, fields, etc. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root." Last edited by Infinite Recursion; Oct 21st, 2006 at 2:44 AM.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Script Programming > Python

Best way to do this?