package database.migration.etape0.categorie_article;

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.HashSet;
import java.util.Set;

import tool.regEx.DataNormalizer;
import database.dataset.Categorie_article;
import database.migration.SqlFactory;

public class ReadCategorieStock {

	public static Set<Categorie_article> from(Connection connection) throws SQLException{
		System.out.println("import categorie article");
		Set<Categorie_article> categorie_articleLst = new HashSet<Categorie_article>();
		
		Statement stm = connection.createStatement();
		ResultSet rs = stm.executeQuery("SELECT * FROM categorie");
		while(rs.next()){
			int id             = rs.getInt("ID");
			String description = DataNormalizer.normalize(rs.getString("categorie"));
			Categorie_article _categorie_article = new Categorie_article(id,description);
			categorie_articleLst.add(_categorie_article);
		}
		
		return categorie_articleLst;
	}

	public static void main(String...strings) throws FileNotFoundException, SQLException, IOException{

		Connection connection = SqlFactory.connect(SqlFactory.loadProperties("hotel_orford_import.xml"));
		
		for (Categorie_article a : from(connection))
			System.out.println(a.toString());
		
		System.out.println("bonne journée");
	}
}