src/test/java/DBManager/SqliteDbManagerTest.java - master - OlegPovarenkov/SystemAdministratorHelper

src/test/java/DBManager/SqliteDbManagerTest.java

60 строк2 KB

OlegPIE22BO

Initial commit

16 июн 2026, 19:26

16 июн 2026, 19:26d2625e7

/*
 * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
 * Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Class.java to edit this template
 */
package DBManager;

import com.fasterxml.jackson.databind.ObjectMapper;
import org.junit.jupiter.api.Test;
import org.junit.jupiter.api.Assertions;
import com.opsm16.systemadministratorhelper.DBManager.Realiations.SqliteDbManager;
import java.io.File;
import java.sql.SQLException;
import org.junit.jupiter.api.AfterEach;
import org.junit.jupiter.api.BeforeAll;
import org.junit.jupiter.api.TestInstance;

/**
 *
 * @author afonyaopsm16
 */

@TestInstance(TestInstance.Lifecycle.PER_CLASS)
public class SqliteDbManagerTest {
    
    protected final String INSERT_PACKAGE = "DBManager/JSON_INSERT_PACKAGE.json";
    
    protected SqliteDbManager dbManager = new SqliteDbManager();
    protected ObjectMapper objectMapper;
    
    @BeforeAll
    public void initDbManager() {
        dbManager.connectToDb(new File("someCon"));
        objectMapper = new ObjectMapper();
        //Assertions.assertNotNull(dbManager.getConnection());
    }
    
    @Test
    public void baseOperationsTest() throws Exception{
//        DBScriptPackage sqlPackage = objectMapper.readValue(getClass().getClassLoader().getResourceAsStream(INSERT_PACKAGE), DBScriptPackage.class);
//        Assertions.assertEquals("NAME", sqlPackage.getCOLUMNS()[0]);
//        DBResponsePackage response = dbManager.insertIntoTable(sqlPackage);
//        Assertions.assertEquals("1", response.);       
        //dbManager.insertIntoTable(sqlPackage);
    }
    
    @Test
    public void playground() {
        StringBuilder sb = new StringBuilder();
        sb.append("123456");
        sb.delete(sb.length()-2, sb.length());
        System.out.println(sb);
    }
    
    
    @AfterEach
    public void closeDbManager() throws SQLException {
        dbManager.disconnect();
        Assertions.assertTrue(dbManager.getConnection().isClosed());
    }
}