package com.juick.tests;

import com.juick.User;
import com.juick.server.UserQueries;
import junit.framework.Assert;
import org.apache.commons.dbcp2.BasicDataSource;
import org.junit.Before;
import org.junit.Test;
import org.springframework.jdbc.core.JdbcTemplate;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;

/**
 * Created by vt on 14.01.2016.
 */
public class ApiTests {
    JdbcTemplate jdbc;
    @Before
    public void setupConnection() {
        Properties conf = new Properties();
        try {
            conf.load(new FileInputStream("/etc/juick/api.conf"));
            BasicDataSource dataSource = new BasicDataSource();
            dataSource.setDriverClassName("com.mysql.jdbc.Driver");
            dataSource.setUrl("jdbc:mysql://localhost/juick?autoReconnect=true&user="
                    + conf.getProperty("mysql_username", "")
                    + "&password=" + conf.getProperty("mysql_password", ""));
            jdbc = new JdbcTemplate(dataSource);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    @Test
    public void userTests() {
        User user = UserQueries.getUserByUID(jdbc, 3694);
        Assert.assertEquals("it should be me", "vt", user.UName);
    }
}