|
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
cn = "some connection string"
database(cn2).table("MyTable").copyto.csv("c:\\spam.csv")
colmap = {"PhotoName":1,
"FilePath":2,
"Title":1}
database(cn).table("Photos").mapcolumns(colmap).importfrom.csv("C:\\foo.csv")
database(cn).backupto("C:\\temp\\loungin.bak")
|