actuallySoheil/DatabaseAPI

A simple MySQL and SQLite database API for anyone whos frustrated with the sql's syntax for Minecraft plugins.

DatabaseAPI

A simple MySQL and SQLite database API for anyone whos frustrated with the sql's syntax for Minecraft plugins.

Example Code:

// databaseManager have to only registered once.
val databaseManager = new DatabaseManager();

// here we create the table.
databaseManager.createTable("Test", "name VARCHAR(40) NOT NULL, age INT DEFAULT 1");

// we set the row if there isn't any matching with that unique id.
// use DatabaseContainer to define the columns (no need to put the uniqueId)
databaseManager.setIfAbsent("Test", new DatabaseContainer("name", "age"), player.getUniqueId(), "SomeonesName", 18);

There are more. (DatabaseManager class)

• Use prepareStatement() method, to prepare any statement of choice.
• Use createTable() method, to create a table.
• Use update() method, to update existing row in database table.
• Use exists() method, to check if a row exists.
• Use delete() method, to delete a row with maching uniqueId.
• Use get() method, to get a row.
• Use setIfAbsent() method, to set a row if it doesn't exist.

How to use

Add repository and dependencies to maven.

<repositories>
        
    <repository>
        <id>jitpack.io</id>
        <url>https://jitpack.io</url>
     </repository>
        
</repositories>

<dependencies>
        
    <!-- DatabaseAPI -->
    <dependency>
        <groupId>com.github.WixiDev</groupId>
        <artifactId>DatabaseAPI</artifactId>
        <version>LATEST_COMMIT_TAG</version>
    <dependency>

    <!-- Lombok -->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.28</version>
        <scope>provided</scope>
    </dependency>
            
    <!-- MySQL-Connector -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.33</version>
        <scope>provided</scope>
    </dependency>
            
</dependencies>

Pro TIP:

Use SQLite Viewer App to see your rows and tables. It's free!

Was it helpful? consider giving a star!