package com.winvector.db;
import java.io.File;
import java.io.PrintStream;
import java.net.URI;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Properties;
import com.winvector.db.DBIterable.RSIterator;
//import com.winvector.db.DBIterable.TypeInfo;
import com.winvector.db.DBUtil.DBHandle;
import com.winvector.util.BurstMap;
import com.winvector.util.TrivialReader;
public class DBDump {
public static long runQuery(final String query, final PrintStream p, final DBHandle handle) throws SQLException {
final Statement stmt = handle.createReadStatement();
final RSIterator source = new RSIterator(stmt.executeQuery(query));
final String sep = "\t";
boolean first = true;
long rowNum = 0;
while(source.hasNext()) {
final BurstMap row = source.next();
if(first) {
boolean firstCol = true;
for(final String ki: row.keySet()) {
if(firstCol) {
firstCol = false;
} else {
p.print(sep);
}
//final TypeInfo columnInfo = source.getJavaClassName(ki);
p.print(TrivialReader.safeStr(ki) /* + ":" + columnInfo.sqlColumnType */);
}
p.println();
first = false;
}
boolean firstCol = true;
for(final String ki: row.keySet()) {
if(firstCol) {
firstCol = false;
} else {
p.print(sep);
}
final String vi = row.getAsString(ki);
p.print(TrivialReader.safeStr(vi));
}
p.println();
++rowNum;
// System.out.println(row);
}
stmt.close();
return rowNum;
}
public static void main(final String[] args) throws Exception {
System.out.println("start DBDump\t" + new Date());
System.out.println("\tfor details see: http://www.win-vector.com/blog/2011/01/sql-screwdriver/");
System.out.println("\tfor latest version see: https://github.com/WinVector/SQLScrewdriver");
final URI propsURI = new URI(args[0]);
final String query = args[1];
final File resFile = new File(args[2]);
if(args.length!=3) {
System.out.println("use: com.winvector.db.DBDump dbPropsXMLURI query resultFile");
System.exit(1);
}
System.out.println("\tDBProperties XML:\t" + propsURI.toString());
System.out.println("\tquery:\t" + query);
System.out.println("\tresultFile:\t" + resFile.getAbsolutePath());
final Properties props = DBUtil.loadProps(propsURI);
final DBHandle handle = DBUtil.buildConnection(propsURI.toString(),props,true);
System.out.println("\tdb:\t" + handle);
final PrintStream p = TrivialReader.openPrintStream(resFile);
final long nRows = runQuery(query,p,handle);
p.close();
handle.conn.close();
System.out.println("done DBDump, wrote\t" + nRows + " rows\t" + new Date());
}
}