Python with SQL

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Python with SQL

Postby tilo23 » Mon Jan 16, 2012 4:00 pm

Is there any module associated (like sqlite3) which would allow the Python script to connect to the database? (I'm not a Python Pro - have just made some research regarding Python usage with SQL queries).
I would like to use Python scripts to make calculations on columns.
Inside the Dilbert's world
tilo23
 
Posts: 19
Joined: Thu Dec 22, 2011 3:56 pm
Location: Berkshire, UK

Postby james.billings » Tue Jan 17, 2012 6:17 pm

The latest version of SQL Data Generator allows you to use Python scripts to generate data for your columns. Simply select the Python generator for the column in question, then write your code.

We have a guide and some examples here
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests