Inserting records into sqlite database only when the database is first created

Question

I want to insert records into my sqlite database only when the database is created (i.e. only when my app installs for the first time on a device). I googled for help and some people suggested to insert the data in the onCreate() method of the SQLiteOpenHelper, but records couldn't be inserted using that method.

This is my code

public class EventsData extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "events.db";
    private static final int DATABASE_VERSION = 1;

    // Table name
    public static final String TABLE = "events";

    // Columns
    public static final String NAME = "first";
    public static final String TITLE = "second";

    public EventsData(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        db.execSQL("CREATE TABLE "+TABLE+"(" + _ID + "INTEGER PRMARY KEY AUTOINCREMENT, " + NAME +"TEXT, " + TITLE + "TEXT NOT NULL);");
        db.execSQL("INSERT INTO " + TABLE +" VALUES (1,'david','packard')");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
                    db.execSQL("DROP TABLE IF EXISTS " + TABLE);
                    onCreate(db);
    }
}

The simple solution is to use prepopulated database,HOW? check this stackoverflow.com/questions/9109438/… — Yaqub Ahmad
– Yaqub Ahmad, Commented Jun 16, 2012 at 15:19
no... i could add records from the main activity, but couldnt do the same from "SQLiteOpenHelper" class — rampireram
– rampireram, Commented Jun 16, 2012 at 17:25

Community · Accepted Answer · 2017-05-23 10:28:11Z

1

use sqlite database browser to make datbase it will help a lot try this link Inserting data to record in sqlite

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered Jun 15, 2013 at 19:10

user2326414

271 silver badge6 bronze badges

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

Comments

Gene · Accepted Answer · 2012-06-16 15:18:28Z

0

It will work fine when you get the CREATE statement right. It's missing spaces and correct spellings. _ID + "INTEGER... must be _ID + " INTEGERandPRMARYmust bePRIMARY`. There may be other mistakes. It's a good idea to have a debugging option in your program to emit all SQL you're executing to the log.

answered Jun 16, 2012 at 15:18

Gene

47.1k4 gold badges64 silver badges101 bronze badges

Comments

marc_s · Accepted Answer · 2016-02-12 21:44:56Z

0

Looks in you CREATE TABLE query spaces are missing between texts....

NAME +"TEXT, " + TITLE + "TEXT NOT NULL);"

Just print the queries in SOP and try to execute them in you SQLITe tools on desktop.

edited Feb 12, 2016 at 21:44

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jun 16, 2012 at 15:15

Dheeresh Singh

15.7k3 gold badges40 silver badges36 bronze badges

1 Comment

rampireram Over a year ago

no... i could add records from the main activity, but couldnt do the same from "SQLiteOpenHelper" class :-( even after correcting the errors

Collectives™ on Stack Overflow

Inserting records into sqlite database only when the database is first created

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related