package database.migration.etape0.modeDePaiement;

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 java.util.ArrayList;
import java.util.List;

import database.dataset.Modedepaiement;
import database.migration.SqlFactory;

public class ReadModeDePaiement {

	public static List<Modedepaiement> from(Connection connection) throws SQLException{
		System.out.println("import mode de paiement");
		List<Modedepaiement> lst = new ArrayList<>();
		Statement stm = connection.createStatement();
		ResultSet rs = stm.executeQuery("SELECT * FROM methode_encaissement");
		while (rs.next()){
			int id = rs.getInt("ID");
			String methode = rs.getString("methode");
			
			lst.add(new Modedepaiement(id, methode));
		}
		return lst;
	}

	public static void main (String...strings) throws FileNotFoundException, SQLException, IOException{
		System.out.println("connection");
		Connection connection = SqlFactory.connect(SqlFactory.loadProperties("hotel_orford_import.xml"));
		
		for (Modedepaiement method : from(connection))
			System.out.println(method.toString());
		
	}
}