The Wayback Machine - https://web.archive.org/web/20201111005258/https://github.com/MSBilgin/SQLkolay
Skip to content
master
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
app
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

README.md

SQLkolay

Android library that simplifies working with SQLite database.

Usage

Database Class

public class AppDB extends SQLkolay {
    private static final String databaseName = "app.db";
    private static final int version = 1;

    public TableBooks books = new TableBooks();

    public AppDB(Context context) {
        super(context, databaseName, version);
        registerTables(books);
    }
}

Table Class

public class TableBooks extends Table {
    private static final String tableName = "BOOKS";

    @Column(type = Column.Type.INTEGER_AUTOINC, primary = true)
    private Column id;

    private Column name;
    private Column author;

    @Column(type = Column.Type.NUMBER)
    private Column date;

    @Column(type = Column.Type.REAL)
    private Column price;

    @Column(defval = "'Bilgin'")
    private Column publisher;

    public TableBooks() {
        super(tableName);
    }

    public void add(Book book) {
        ContentValues values = new ContentValues();
        values.put("name", book.name);
        values.put("author", book.author);
        values.put("date", book.publishDate);
        values.put("price", book.price);
        insert(null, values);
    }

    public Book getByID(int id) {
        Book book = new Book();

        String sql = String.format("select * from %s where id=%s", tableName, id);
        Cursor cursor = getDB().rawQuery(sql, null);
        if (cursor.moveToFirst()) {
            book.id = cursor.getInt(cursor.getColumnIndex("id"));
            book.name = cursor.getString(cursor.getColumnIndex("name"));
            book.author = cursor.getString(cursor.getColumnIndex("author"));
            book.price = cursor.getDouble(cursor.getColumnIndex("price"));
            book.publishDate = cursor.getString(cursor.getColumnIndex("date"));
        }
        return book;
    }

}

Thats all...

AppDB appDB = new AppDB(getApplicationContext());
Book book = new Book("Seyahatname", "Evliya Çelebi", "01.01.1600", 2000);
appDB.books.add(book);

Installation

on project's build.gradle

allprojects {
    repositories {
        google()
        jcenter()
        maven { url 'https://jitpack.io' }
    }
}

on app's build.gradle

dependencies {
    implementation 'com.github.msbilgin:sqlkolay:0.6'
}

About

Android library that simplifies working with SQLite database.

Topics

Resources

License

Packages

No packages published

Languages

You can’t perform that action at this time.