def update(self, R2, name): # db에 답을 update시키는 함수 if R2 == 1: conn = pymysql.connect(host='127.0.0.1', user='******', password='******', db='javap', charset='utf8') try: with conn.cursor() as cursor: sql = "update pypeople set answer=answer+1 where person=%s" # answer 기본값이 0이고, 만약 정답이 아니면 +1을 해주지 않는다. cursor.execute(sql, name) conn.commit() finally: conn.close() q2.q2(name)
def q3(): import pandas as pd from q2 import q2 optimal = q2() lamda = optimal[1] data = pd.read_csv("new_data.csv") A = data.iloc[:, :].values reject_list = [] for i in range(data.shape[0]): p = A[i, 4] for j in range(4): p -= lamda[j] * A[i, j] if p < 0: reject_list.append(i + 1) return (reject_list)
from q1 import q1 from q2 import q2 from q3 import q3 from q4 import q4 from q5 import q5 print "Question 1" q1() raw_input() print "Question 2" q2() print "Question 3" q3() print "Question 4" q4() print "Question 5" q5()
tronco_points = np.array([ [-1.5, -1.5, 0], [1.5, -1.5, 0], [1.5, 1.5, 0], [-1.5, 1.5, 0], [-0.65, -0.65, 2.5], [0.65, -0.65, 2.5], [0.65, 0.65, 2.5], [-0.65, 0.65, 2.5], ]) # # PRIMEIRA QUESTÃO q1(cube_points, parallel_points, pyramid_points, tronco_points) # SEGUNDA QUESTÃO cube_points, parallel_points, pyramid_points, tronco_points = q2( cube_points, parallel_points, pyramid_points, tronco_points) # TERCEIRA QUESTÃO c_points, p_points = q3(copy(cube_points), copy(pyramid_points), copy(parallel_points), copy(tronco_points), np.array([3, -3, 3]), True) # QUARTA QUESTÃO q4(c_points, p_points, True) # OPCIONAL eyes = [np.array([i, -3, 3]) for i in np.arange(-2, 8, .5)] for i, eye in enumerate(eyes): # TERCEIRA QUESTÃO c_points, p_points = q3(copy(cube_points), copy(pyramid_points), copy(parallel_points), copy(tronco_points), eye)
def main(): q1() q2() q3() q4()
def test_large_k(): with pytest.raises(ValueError): q2([100, 1, 3000])
def test_example_1(): assert q2([5, 2, 3]) == 'a:1,b:0,c:1'
def test_invalid_argument(): with pytest.raises(TypeError): q2([5, 2, 'k']) with pytest.raises(ValueError): q2([5, 2])
def test_large_q(): with pytest.raises(ValueError): q2([5, 2, 300])