def get_product(product_id, lang='ru'):
conn = sqlite3.connect(PRODUCTS_DATABASE_PATH)
cur = conn.cursor()
cur.execute("SELECT * FROM product WHERE id = ?", (product_id, ))
product_sql_tpl = cur.fetchone()
cproduct = Product()
cproduct.id = product_id
cproduct.name = get_name(product_id, lang)
cproduct.description = get_description(product_id, lang)
cproduct.dimension = get_dimension(product_sql_tpl[1], lang)
cproduct.default_amount = product_sql_tpl[2]
cproduct.image_filename = product_sql_tpl[3]
cproduct.price = product_sql_tpl[4]
conn.close()
return cproduct
