There is my functional test

from rest_framework import status
from rest_framework.test import APITestCase

__all__ = ['OAuthTestCase']

ADDRESS_FOR_TEST = 'http://127.0.0.1:8000/api/v1/request/'


class ApiOAuthTestCase (APITestCase):

     def setUp (self):
         User.objects.create_user (username = user_name, password = user_password)

         self.my_message = {
             'grant_type': 'password',
             'username': "user_name",
             'password': "user_password",
             'client_id': "secret_ket",
             'client_secret': "clietn_id",
         }

     def test_token (self):
         response = self.client.post (ADDRESS_FOR_TEST, self.my_message)
         self.assertEqual (response.status_code, status.HTTP_201_CREATED)

When passing this test, error 400 appears. Can you please tell me how to access the response content from response?

POSTMAN, Soap UI are the best

First of all, there is no reason to save letters in the variable name, which is a bad programming practice.

Second, use the https://pt.stackoverflow.com/q/172909/132 .

Third, avoid https://pt.wikipedia.org/wiki/Inje%C3%A7%C3%A3o_de_SQL when using https://docs.oracle.com/javase/9/docs/api/java/sql/PreparedStatement.html .

Fourth, prefer to use https://pt.stackoverflow.com/q/113840/132 to accomplish this kind of thing.

Supposing the fields of your table cliente be it id, nome, telefone and cpf, your code is more or less like this:

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Optional;
public class ClienteDAO {

private static String POR_NOME =

"SELECT id, nome, telefone, cpf FROM cliente WHERE nome = ?";
private static String POR_ID =
        "SELECT id, nome, telefone, cpf FROM cliente WHERE id = ?";

private final Connection conexao;

public ClienteDAO(Connection conexao) {
    this.conexao = conexao;
}

private Cliente popular(ResultSet rs) throws SQLException {
    int id = rs.getInt(1);
    String nome = rs.getString(2);
    String telefone = rs.getString(3);
    String cpf = rs.getString(4);
    return Cliente.criar(id, nome, telefone, cpf);
}

private List<Cliente> listar(PreparedStatement statment) throws SQLException {
    try (ResultSet rs = statement.executeQuery()) {
        List<Cliente> resultado = new ArrayList<>();
        while (rs.next()) {
            Cliente c = popular(rs);
            resultado.add(c);
        }
        return resultado;
    }
}

private Optional<Cliente> ler(PreparedStatement statment) throws SQLException {
    try (ResultSet rs = statement.executeQuery()) {
        if (rs.next()) return Optional.of(popular(rs));
        return Optional.empty();
    }
}

public List<Cliente> porNome(String nome) throws SQLException {
    try (PreparedStatement statement = conexao.prepareStatement(POR_NOME)) {
        statement.setString(1, nome);
        return listar(statement);
    }
}

public Optional<Cliente> porId(int id) throws SQLException {
    try (PreparedStatement statement = conexao.prepareStatement(POR_ID)) {
        statement.setInt(1, id);
        return ler(statement);
    }
}

}

Other methods that bring table results cliente are added to this same class. You will do something similar to the other classes. The public methods will correspond to each type of consultation that your DAO is capable of faazer and will use the private methods ler(PrepaparedStatement) and listar(PreparedStatement) to form the results.

Note that the results can be a List<Cliente> for the case where there may be several (or none) result. For the case where there can only be one or no results, you use Optional<Cliente>.

There must also be a method criar in class Cliente that creates an instance containing all necessary data. I talk more about it https://pt.stackoverflow.com/a/252986/132 .

Then you will join the DAOs more or less like this:

import java.sql.DriverManager;

import java.sql.SQLException;

public class ParametrosDeConexao {
private final String url;
private final String usuario;
private final String senha;

public ParametrosDeConexao(String url, String usuario, String senha) {
    this.url = url;
    this.usuario = usuario;
    this.senha = senha;
}

public Connection conectar() throws SQLException {
    return DriverManager.getConnection(url, usuario, senha);
}

}

import java.sql.Connection;

import java.sql.SQLException;

public class CamadaDeDados implements AutoCloseable {

private final Connection conexao;

private final ClienteDAO clientes;

private final FuncionarioDAO funcionarios;

private final LivroDAO livros;
public CamadaDeDados(ParametrosDeConexao params) throws SQLException {
    this.conexao = params.conectar();
    this.clientes = new ClienteDAO(conexao);
    this.funcionarios = new FuncionarioDAO(conexao);
    this.livros = new LivroDAO(conexao);
}

public ClienteDAO clientes() {
    return clientes;
}

public FuncionarioDAO funcionarios() {
    return funcionarios;
}

public LivroDAO livros() {
    return livros;
}

@Override
public void close() throws SQLException {
    conexao.close();
}

}

Now that we have the access layer to organized data, you can do this:

private ParametrosDeConexao params() {

return new ParametrosDeConexao(url, usuario, senha);

}

private void seuMetodo() {

String nomeCliente = (String) cbNomeCliente.getSelectedItem();

String nomeFuncionario = (String) cbNomeFuncionario.getSelectedItem();

String nomeLivro = (String) cbNomeLivro.getSelectedItem();
int idCliente, idFuncionario, idLivro;
try (CamadaDeDados c = new CamadaDeDados(params())) {
    idCliente = c.clientes().porNome(nomeCliente).get(0).getId();
    idFuncionario = c.funcionarios().porNome(nomeFuncionario).get(0).getId();
    idLivro = c.livros().porNome(nomeLivro).get(0).getId();
} catch (SQLException x) {
    JOPtionPane.showMessageDialog(null, x.getMessage());
}

}

The ideal would be for you to use the MVC design pattern, so that the presentation logic (which deals with JComboBoxes es JOptionPanes) did not stick to its modeling logic (which implements the rules and concepts of books, employees and customers). However, I would need more information about your project to show you how to do this, and that would already be the case of asking another question, because that is well beyond the purpose of this one.

Those get(0) that I had to put probably not ideal, being unwanted things. However, to get rid of them, I would need more information about your project. With those get(0) what I did was simply assume that there will always be one and only one result, but this is something dangerous to assume because the name listing methods can bring more than a result or may not bring any, which means we might not find the ids sought or find more than one id, and if that happens, then you will have to see what you will do.

In professional projects well done using JDBC, you will never or almost never just search for id in the database. Almost always you will want to get the whole tuple. That's why DAO methods return List<Cliente> and Optional<Cliente> rather than just int. So I also suspect that your approach to research by id is not correct.

Note that if url, usuario and senha are fixed and immutable, you can put the ParametrosDeConexao in a variable private static final and always reuse the same instance.

Each time you use a type object CamadaDeDados inside try-with-resources, you will be running an operation with the database in a single connection. It is also the ideal place to implement transaction control when/if you need it.

I am developing an application of integration between the city hall of my city and a system for a company, NFS-e generation optimization. It consists of using the City Hall Web Service to send, using SOAP, XML files to be validated. That is, the past parameter will be an XML file.

Since I've never created this kind of application, I'm sure about how to do it. For example:

How I use the services provided ( http://grphml.santacruz.rs.gov.br/thema-nfse-hml/ ) and do SOAP communication in PHP? Supposing I have the XML file ready and structured correctly, how do I pass it as a parameter to the Web Service services?

I don't want the solution of anything, only tips and examples that can help me.

Can anyone help me? In a listview where the data comes from an internet database I can’t let it be automatic so that all values coming are included, the only way is by adding one to one, however when it’s a customer list it can increase and the size won’t be the same anymore, so how do I leave it in a loop?

The bank code is this:

<?php
header("Access-Control-Allow-Origin: *");
require_once('api.php');
if($_POST['buscar'] == "123"){

$lista = $user->getList()->fetchAll();

foreach($lista as $show){

echo "$show->nome" . ":";
}

}
if($_POST['buscar'] == "123"){

echo ";";

$lista = $user->getList()->fetchAll();

foreach($lista as $show){
echo "$show-&gt;telefone1" . ":";

}

}
if($_POST['buscar'] == "123"){

echo ";";
$lista = $user->getList()->fetchAll();

foreach($lista as $show){
echo "$show-&gt;telefone2" . ":";

}

}
if($_POST['buscar'] == "123"){

echo ";";
$lista = $user->getList()->fetchAll();

foreach($lista as $show){
echo "$show-&gt;endereco" . ":";

}

}
if($_POST['buscar'] == "123"){
echo ";";

$lista = $user->getList()->fetchAll();

foreach($lista as $show){
echo "$show-&gt;nota" . ":";

}

}
if($_POST['buscar'] == "123"){
echo ";";

$lista = $user->getList()->fetchAll();

foreach($lista as $show){
echo "$show-&gt;id" . ":";

}

}
if($_POST['buscar'] == "123"){
echo ";";

$lista = $user->getList()->fetchAll();

foreach($lista as $show){
$xlat2 = $show-&gt;lat;
$xlog2 = $show-&gt;log;
$dist = $xlat2 . "," . $xlog2.

echo intval($dist) . ":";

}
}

After the received data it turns each item into an array:

@Override

protected void onPostExecute(String resultado) {

array = resultado.split(";");

nome = array[0].split(":");

telefone1 = array[1].split(":");

telefone2 = array[2].split(":");

local = array[3].split(":");

nota = array[4].split(":");

id2 = array[5].split(":");

distancia = array[6].split(":");

    criarListagem();
}

And then create the listing:

public void criarListagem() {

ListView lista = (ListView) findViewById(R.id.lista);

List<User> users = todosOsUsers();

AdapterListaPersonalizado adapter = new

AdapterListaPersonalizado(users, this);

lista.setAdapter(adapter);

}

public List<User> todosOsUsers() {
return new ArrayList&lt;&gt;(Arrays.asList(
        new User(" Nome: " + nome[0], " Telefone 1: " + telefone1[0], " Telefone 2: " + telefone2[0], " Local: " + local[0], nota[0], " Distância≅ " + distancia[0] + " m"),
        new User(" Nome: " + nome[1], " Telefone 1: " + telefone1[1], " Telefone 2: " + telefone2[1], " Local: " + local[1], nota[1], " Distância≅ " + distancia[1] + " m"),
        new User(" Nome: " + nome[2], " Telefone 1: " + telefone1[2], " Telefone 2: " + telefone2[2], " Local: " + local[2], nota[2], " Distância≅ " + distancia[2] + " m"),
        new User(" Nome: " + nome[3], " Telefone 1: " + telefone1[3], " Telefone 2: " + telefone2[3], " Local: " + local[3], nota[3], " Distância≅ " + distancia[3] + " m"),
        new User(" Nome: " + nome[4], " Telefone 1: " + telefone1[4], " Telefone 2: " + telefone2[4], " Local: " + local[4], nota[4], " Distância≅ " + distancia[4] + " m"),
        new User(" Nome: " + nome[5], " Telefone 1: " + telefone1[5], " Telefone 2: " + telefone2[5], " Local: " + local[5], nota[5], " Distância≅ " + distancia[5] + " m"),
        new User(" Nome: " + nome[6], " Telefone 1: " + telefone1[6], " Telefone 2: " + telefone2[6], " Local: " + local[6], nota[6], " Distância≅ " + distancia[6] + " m"),
        new User(" Nome: " + nome[7], " Telefone 1: " + telefone1[7], " Telefone 2: " + telefone2[7], " Local: " + local[7], nota[7], " Distância≅ " + distancia[7] + " m"),
        new User(" Nome: " + nome[8], " Telefone 1: " + telefone1[8], " Telefone 2: " + telefone2[8], " Local: " + local[8], nota[8], " Distância≅ " + distancia[8] + " m"),
        new User(" Nome: " + nome[9], " Telefone 1: " + telefone1[9], " Telefone 2: " + telefone2[9], " Local: " + local[9], nota[9], " Distância≅ " + distancia[9] + " m"),
        new User(" Nome: " + nome[10], " Telefone 1: " + telefone1[10], " Telefone 2: " + telefone2[10], " Local: " + local[10], nota[10], " Distância≅ " + distancia[10] + " m")));

}

I put a file in SVG to have an animation as if creating it in lines (unfortunately in the example below is not working, but in my file is.)

With this code below, as soon as I enter the page, the animation already begins and happens until the drawing completes.

How do I make the animation of the drawing start as soon as I get close to it? Why the drawing gets close to the footer on my site, and how the animation starts as soon as I get on the page, I'm losing it.

The animation is similar to this site https://gardenestudio.com.br/index.php , however, instead of being with mouse scrolling, it is with scroll/page height.

document.addEventListener('DOMContentLoaded', function() {
    var svg4 = new Walkway({
      selector: '#Layer_1',
      duration: 3500,
      redrawOnFocus: true

    });

    svg4.draw();

    document.addEventListener('dblclick', function() {
      svg.redraw();
      svg4.redraw();
    }, false);
  });</code></pre><pre class="snippet-code-css lang-css prettyprint-override"><code>svg {

width: 157px;

height: 157px;

fill: red;

margin-left: 130px;

}
svg path {

stroke: #310B3B;

}
svg:not(:root) {

overflow: visible;

}
path {

fill: transparent;

}
svg > span {

position: absolute;

top: 0;

right: 0;

}
path, line, polyline {

stroke: #fff;

stroke-width: 1px;

}
polyline {

stroke-width: 4px;

}
#Layer_1 path {

stroke-width: 6.5px;

}

<script src="https://github.com/ConnorAtherton/walkway/blob/master/src/walkway.js"></script>

<svg version="1.1" id="Layer_1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" x="0px" y="0px"

viewBox="0 0 512 512" style="enable-background:new 0 0 512 512;" xml:space="preserve">

<g>

<path d="M435.2,392.533c-23.526,0-42.667,19.14-42.667,42.667s19.14,42.667,42.667,42.667c23.526,0,42.667-19.14,42.667-42.667

S458.726,392.533,435.2,392.533z M435.2,460.8c-14.114,0-25.6-11.486-25.6-25.6s11.486-25.6,25.6-25.6s25.6,11.486,25.6,25.6

S449.314,460.8,435.2,460.8z"/>

<path d="M494.933,387.029V102.4c0-9.412-7.654-17.067-17.067-17.067h-85.333c-9.412,0-17.067,7.654-17.067,17.067v230.4

c0,4.71,3.814,8.533,8.533,8.533h17.067c4.719,0,8.533-3.823,8.533-8.533c0-4.71-3.814-8.533-8.533-8.533h-8.533V307.2h8.533

c4.719,0,8.533-3.823,8.533-8.533s-3.814-8.533-8.533-8.533h-8.533v-17.067h25.6c4.719,0,8.533-3.823,8.533-8.533

S422.852,256,418.133,256h-25.6v-17.067h8.533c4.719,0,8.533-3.823,8.533-8.533c0-4.71-3.814-8.533-8.533-8.533h-8.533V204.8

h8.533c4.719,0,8.533-3.823,8.533-8.533s-3.814-8.533-8.533-8.533h-8.533v-17.067h8.533c4.719,0,8.533-3.823,8.533-8.533

c0-4.71-3.814-8.533-8.533-8.533h-8.533v-17.067h25.6c4.719,0,8.533-3.823,8.533-8.533c0-4.71-3.814-8.533-8.533-8.533h-25.6

V102.4h85.333v268.988c-12.22-8.201-26.88-12.988-42.667-12.988c-42.351,0-76.8,34.458-76.8,76.8

c0,15.778,4.796,30.455,12.979,42.667H136.533v-85.333H153.6v25.6c0,4.71,3.823,8.533,8.533,8.533

c4.71,0,8.533-3.823,8.533-8.533v-25.6h17.067v8.533c0,4.71,3.823,8.533,8.533,8.533s8.533-3.823,8.533-8.533v-8.533h17.067

v8.533c0,4.71,3.823,8.533,8.533,8.533s8.533-3.823,8.533-8.533v-8.533H256v8.533c0,4.71,3.823,8.533,8.533,8.533

c4.719,0,8.533-3.823,8.533-8.533v-8.533h17.067v25.6c0,4.71,3.814,8.533,8.533,8.533s8.533-3.823,8.533-8.533v-25.6h17.067

v8.533c0,4.71,3.814,8.533,8.533,8.533c4.719,0,8.533-3.823,8.533-8.533V384c0-4.71-3.814-8.533-8.533-8.533H136.533

c-9.89,0-17.067,7.177-17.067,17.067v85.333c0,9.89,7.177,17.067,17.067,17.067h250.496C400.213,505.583,416.964,512,435.2,512

c42.351,0,76.8-34.458,76.8-76.8C512,416.964,505.583,400.222,494.933,387.029z M435.2,494.933

c-32.93,0-59.733-26.795-59.733-59.733s26.803-59.733,59.733-59.733c32.93,0,59.733,26.795,59.733,59.733

S468.13,494.933,435.2,494.933z"/>

<path d="M443.733,59.733c0-4.71-3.814-8.533-8.533-8.533H102.4C102.4,22.963,79.437,0,51.2,0S0,22.963,0,51.2v409.6

C0,489.037,22.963,512,51.2,512h42.667c4.71,0,8.533-3.823,8.533-8.533c0-4.71-3.823-8.533-8.533-8.533H51.2

c-18.825,0-34.133-15.309-34.133-34.133c0-18.824,15.309-34.133,34.133-34.133s34.133,15.309,34.133,34.133

c0,4.71,3.823,8.533,8.533,8.533c4.71,0,8.533-3.823,8.533-8.533V68.267h332.8C439.919,68.267,443.733,64.444,443.733,59.733z

M85.333,422.741C76.262,414.601,64.324,409.6,51.2,409.6s-25.062,5.001-34.133,13.141V51.2

c0-18.825,15.309-34.133,34.133-34.133S85.333,32.375,85.333,51.2V422.741z"/>

<path d="M326.767,116.966c1.664,1.664,3.849,2.5,6.033,2.5c2.185,0,4.369-0.836,6.033-2.5c3.337-3.337,3.337-8.73,0-12.066

l-17.058-17.058c-0.794-0.794-1.732-1.417-2.782-1.852c-2.082-0.862-4.437-0.862-6.519,0c-1.05,0.435-1.988,1.058-2.782,1.852

L292.634,104.9c-3.337,3.337-3.337,8.73,0,12.066c3.337,3.336,8.73,3.336,12.066,0l2.5-2.5v197.734l-2.5-2.5

c-3.337-3.336-8.73-3.336-12.066,0c-3.337,3.337-3.337,8.73,0,12.066l17.058,17.058c0.794,0.794,1.732,1.417,2.782,1.852

c1.041,0.435,2.15,0.657,3.26,0.657c1.109,0,2.219-0.222,3.26-0.657c1.05-0.435,1.988-1.058,2.782-1.852l17.058-17.058

c3.337-3.337,3.337-8.73,0-12.066c-3.336-3.336-8.73-3.336-12.066,0l-2.5,2.5V114.466L326.767,116.966z"/>

</g>

</svg>

This is one of Laravel's cool (and confusing things).

These methods do not exist, they are short versions of the method where, what comes after this keyword is the name of the column that is part of where.

That is,

$query->whereRole('algumValor')

is exactly the same thing as

$query->where('role', 'algumValor')

How does Laravel ride these methods?

This has already been answered in: https://pt.stackoverflow.com/q/151674/18246

It's not necessary. A https://www.codeigniter.com/user_guide/libraries/sessions.html?highlight=session#flashdata informs that this type of data is self-destruct (Then extracted from the documentation, in free translation):

CoedIgniter supports "flashdata", or session data that are only available for the next request and will be automatically deleted.

If you are using the method set_flashdata()from the session library to mark, you no longer need to do anything to erase that data.

It is very simple, take the category and then list the subjects related to it:

Example 1:

categoria = Categoria.objects.get(id=1)
assuntos_da_categoria = categoria.assunto_set.all()

Or filter directly:

Example 2:

assuntos_da_categoria = Assunto.objects.filter(categoria__id=1)

How to change the color of the edge of a Group-box?

Because I need to put a very clear background color...that is the edge of the Group-box q I have almost not appear because they are a very clear ash as well. ...

I needed to change to a darker color as I can't change the color of the background..

Does anyone have any suggestions???

I have the following lines:

import static org.junit.Assert.*;
import org.openqa.selenium.WebElement;
public class ClasseTeste extends Navegadores {

public static void verificarTitulo() {

abrirChrome();

String titulo = driver.getTitle();

assertTrue(titulo.contains("google"));

fecharNavegador();

}

}

So how much I run the main:

public static void main( String[] args ) {

verificarTitulo();

}

This occurs:

Exception in thread "main" java.lang.NoClassDefFoundError: org/junit/Assert

at teste.NovoProjeto.ClasseTeste.verificarTitulo(ClasseTeste.java:11)

at teste.NovoProjeto.Main.main(Main.java:8)

Caused by: java.lang.ClassNotFoundException: org.junit.Assert

at java.net.URLClassLoader$1.run(Unknown Source)

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

... 2 more

Can anyone help me with that?

I am studying Android programming in Java, and what concerns me is that I will only be able to pick up a portion of the job market, because there are IOS and Windows Phone phones and that does not use Java Language, I learned from a Java tool called NDK (Native Development Kit) it is a set of tools that allows developing native codes in C or C++

I wonder if through NDK it is possible to make apps for Windows Phone?