package database.migration.etape0.permanente;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import database.dataset.Constante;
import database.migration.SqlFactory;

public class ReadConstant {

	public static Constante from(Connection connection) throws SQLException{
		System.out.println("import constante");
		Statement stm = connection.createStatement();
		ResultSet rs = stm.executeQuery("SELECT * FROM permanente");
		rs.next();
		
		int id = rs.getInt("ID");
		String logo = rs.getString("logo");
		String noTps = rs.getString("noDeTps");
		String noTvq = rs.getString("noDeTvq");
		String messageFacture = rs.getString("messageFacture");
		
		return new Constante(id, 
				             noTps, 
				             noTvq, 
				             "non disponnible", 
				             messageFacture);
	}
	/**
	 * @param args
	 * @throws IOException 
	 * @throws SQLException 
	 * @throws FileNotFoundException 
	 */
	public static void main(String[] args) throws FileNotFoundException, SQLException, IOException {
		System.out.println("connection");
		Connection connection = SqlFactory.connect(SqlFactory.loadProperties("hotel_orford_import.xml"));
		
		Constante constante = from(connection);
		
		System.out.println(constante.toString());
	}

}