package database.migration.etape1.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.Article;
import database.migration.SqlFactory;

/**
 * @author martin
 * depend de ReadCategorie
 */
public class ReadStock {

	public static Set<Article> from(Connection connection) throws SQLException{
		System.out.println("import read stock");
		Set<Article> articleLst = new HashSet<Article>();
		
		Statement stm = connection.createStatement();
		ResultSet rs = stm.executeQuery("SELECT * FROM stock");
		while(rs.next()){
			int id             = rs.getInt("ID"),
			    categorie_id   = rs.getInt("ID_categorie");
			String code        = DataNormalizer.normalize(rs.getString("code")),
				   description = DataNormalizer.normalize(rs.getString("description"));
			boolean taxable    = rs.getInt("taxe") != 0,
					actif      = rs.getInt("actif") != 0;
			Article _article = new Article(id,
					                       code,
					                       description, 
					                       taxable, 
					                       categorie_id, 
					                       actif);
			articleLst.add(_article);
		}
		
		return articleLst;
	}

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

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