BlokSQLite API - Speedgot

BlokSQLite API -----

Almost automatic. Useful API.

BlokSQLiteAPI
A SQLite API to manage sqlite databases.
create, insert, get

1.0.7-b is stable

Code (Text):

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

<dependency>
<groupId>com.github.Obliviated</groupId>
<artifactId>BlokSQLiteAPI</artifactId>
<version>1.0.7-b</version>
</dependency>

BlokSQLite API manages sqlite databases almost using only methods and objects. Please PM me. If you liked or have any idea, You can leave any comment.

Why BlokSQLiteAPI?

Because, this api preventes hard-codes with smart logic.
Because, this api handles all boring things instead of you.
Because, this api fixes some detailed database bugs for you.
Because, this api is fast and lightweight.
Because, this api is tested in live.

Connect database

Create SQLHandler class of your plugin.
Extend mc.obliviate.bloksqliteapi.SQLHandler
Call super method and create your database. The paramater is folder path of database.
Call super connect method to connect database. The paramater of this method is name of the database.
Override onConnect() method to use on connect event. We need it to call a create table method.
Create a createTable() method and create your table. (I explained below)

Code (Text):

public class AnySQLManagerClass extends SQLHandler {
public AnySQLManagerClass(MyPlugin plugin) {
super(plugin.getDataFolder().getAbsolutePath());
connect();
}

public void connect() {
super.connect("database");
}

@Override
public void onConnect() {
Bukkit.getLogger().info("SQLite DB Connected successfully");
createTable();
}

public SQLTable createTable() {
//table stuff
}

}

Create a table object

First param, specify your table name
Second param, specify name of field that you'll use instead of ID
Third param, add a field to your table. You know. Fields has some properties, data type, not null, unique, primary key... You can specify this properties too.
No no no! You don't need (goddamn) the long 'create table...' text. You given us what we need. Just call create() method. I coded that API to do not write that text. I hate it i hate.

Code (Text):

public SQLTable createTable() {

final SQLTable sqlTable = new SQLTable("school3", "no")

// isNotNull, isUnique, isPrimaryKey
.addField("no", DataType.INTEGER, true, true, true)

//Other params is false as default
.addField("name", DataType.TEXT)
.addField("class", DataType.TEXT);

return sqlTable.create();
}

Data Usage
Let's test our database. The mission is "Put a student named 'Hamza', if the student already exist then change name of student with 'Adnan'."

Specify an id to make an example. i choose 306. (because that is my school number xd)
Check your table and ask 'is this id inserted before?'

Code (Text):

public void test(SQLTable sqltable) {

int id = 306;

if (sqltable.exist(id)) {
}
}

3. If the answer is yes, you must update. Your table already has another fields you need. So, you can specify fields only that you want to change.

Code (Text):

public void test(SQLTable sqltable) {

int id = 306;

if (sqltable.exist(id)) {
sqltable.update(sqltable.createUpdate(id).putData("name", "ali"));
}
}

4. If the answer is no, you must insert. Your table does not have another fields you need. So you must specify all fields.

Code (Text):

public void test(SQLTable sqltable) {

int id = 306;

if (sqltable.exist(id)) {
sqltable.update(sqltable.createUpdate(id).putData("name", "Adnan"));
} else {
sqltable.insert(sqltable.createUpdate(id).putData("name", "Hamza").putData("class", "12E").putData("no", id));
}
}

5. That is guide so i must show you all things. Next mission is: Delete data you putted.

Code (Text):

6. Perfect. Also there is shorter a way too. But that way only puts student named 'Hamza'. Does not changes names. But if you want to know is updated or inserted, the insertOrUpdate() method returns true if updated.

Code (Text):

public void test(SQLTable sqltable) {

int id = 306;

sqltable.insertOrUpdate(sqltable.createUpdate(id).putData("name","Hamza").putData("class","12E").putData("no",id));

sqltable.delete(306);

}

7. If you want to get result set

Code (Text):

public void test(SQLTable sqltable) {

int id = 306;

ResultSet rs = sqltable.select(id);

}

Fast getter methods.

Code (Text):

playerDataTable.getBoolean(uuid.toString(),"isEnabled");
playerDataTable.getInteger(uuid.toString(),"skywarsKills");
playerDataTable.getString(uuid.toString(),"displayName");

Gets boolean value of "isEnabled" column of row that has " uuid.toString()" value (in the id column).

Increase or decrease value.

Code (Text):

playerDataTable.increaseValue(uuid.toString(), "points", 10)
playerDataTable.increaseValue(uuid.toString(), "kills", 1)

playerDataTable.decreaseValue(uuid.toString(), "money", 300)

Developed for:
Play.BlokDunyasi.Network

HostingDunyam (Sponsored): https://hostingdunyam.com.tr/

View on SpigotMC

Resource Information

Author:

----------

Total Downloads: 301

First Release: Jul 8, 2021

Last Update: Jan 17, 2022

Category: ---------------

All-Time Rating:

3 ratings

Version -----

Released: --------------------

Downloads: ------

Version Rating:

----------------------

-- ratings