How to generate SqliteHelpers classes from Sql script?

Question

Is there a way to generate SqliteHelpers classes from SQL script without creating theme manualy ? in other words i have a database with 20 tables that i need to use in an android application with Sqlite database and don't want to create manualy SqliteHelper classe for every table.

Welcome to SO. It will help if you post: What have you tried so far? Do you have any starting code you are stuck with? — Ramzi Khahil
– Ramzi Khahil, Commented Jan 10, 2015 at 20:08
Thank you ! I just start with android developement and i don't know if there is a way to generate SqlHelper's Classes from sql script. I created the first one for a table Book but it will take a lot of time to create SqliteHelper's for all the other tables. — asa
– asa, Commented Jan 10, 2015 at 20:12
Good luck. When you ask questions here, post also stuff that you have tried, or relevant links you have found. This will help us help you faster. Also you will less likely be down voted. Read the FAQ maybe. — Ramzi Khahil
– Ramzi Khahil, Commented Jan 10, 2015 at 20:17
Don't create multiple helpers. Just one per database file, with all tables in one helper. — laalto
– laalto, Commented Jan 11, 2015 at 8:12

Dalmas · Accepted Answer · 2015-01-10 20:15:19Z

1

If you have that many tables, I would suggest you to use an ORM instead of creating the Sqlite helpers by yourself. The two most popular ones are currently ORMLite and GreenDAO. They allow you to write nice code like this (example taken from the ORMLite home page) :

@DatabaseTable(tableName = "accounts")
public class Account {
    @DatabaseField(id = true)
    private String name;

    @DatabaseField(canBeNull = false)
    private String password;
}

The ORM does all the work, you just create a class with some fields and it will bind them to a database automatically without having to write a single line of SQL.

edited Jan 10, 2015 at 20:15

answered Jan 10, 2015 at 20:09

Dalmas

26.6k9 gold badges71 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

asa Over a year ago

I guess that it's like JPA in javaEE?

Dalmas Over a year ago

@asa Yes, JPA is an ORM (object relational mapping). Just know that the android ORMs support much less advanced features than JPA. But you can always use raw SQL queries.

asa Over a year ago

I will use ORMLite then ;) Thank you !

asa Over a year ago

Can we generate pojo classes from tables with ORMLite like we can do with JPA tools??

asa Over a year ago

I generate all the entities i need using JPA and now i will change JPA's annotations with ORMLite's annotations

Collectives™ on Stack Overflow

How to generate SqliteHelpers classes from Sql script?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related