Twining is for databases

Overview
Twining aims to be an IronPython DSL for working with databases.

Goals
Easy copying of table and query content to files and additional databases. Easy access to common operations like database backup. Multiple export formats including CSV and XML.

Some common operations
#export data to CSV
cn = "some connection string"
database(cn2).table("MyTable").copyto.csv("c:\\spam.csv")
#import data from CSV
colmap = {"PhotoName":1, "FilePath":2, "Title":1}
database(cn).table("Photos").mapcolumns(colmap).importfrom.csv("C:\\foo.csv")
#do a simple database backup
database(cn).backupto("C:\\temp\\loungin.bak")

An overview with code View Twining.py View Unit Tests Download Latest Submit Feedback