How to have a default database

Mon, 05/17/2010 - 06:42 | by gabor

SDK Version:

If you want to include a database with initial data in your apk, you have to insert the database file into the projects assets folder, then programmatically check if the database, and if it does not exists copy the one from the assets.

You will need a function to check if the database exists, fox example:

private static final String DATABASE_NAME = "testdatabase";
private static final String DB_PATH = "/data/data/"+mContext.getPackageName()+"/databases/";
 
private boolean isDataBaseExist() {
        File dbFile = new File(DB_PATH+DATABASE_NAME);
        return dbFile.exists();
}

If the check shows that the the database does not exist, a function like this will copy it:

private void copyDataBase() throws IOException {
        // Open your local db as the input stream
        InputStream myInput = mContext.getAssets().open("databases/"+DATABASE_NAME);
        // Path to the just created empty db
        String outFileName = DB_PATH + DATABASE_NAME;
        OutputStream myOutput = new FileOutputStream(outFileName);
        // transfer bytes from the inputfile to the outputfile
        byte[] buffer = new byte[1024];
        int length;
        while ((length = myInput.read(buffer)) > 0) {
                myOutput.write(buffer, 0, length);
        }
        // Close the streams
        myOutput.flush();
        myOutput.close();
        myInput.close();
}

I usually use SQLiteOpenHelper, so I add the methods above to the SQLiteOpenHelper class, and use the following code to open the database:

try{
        mDbHelper = new DatabaseHelper(mContext);
        boolean isExist = mDbHelper.isDataBaseExist();
        if(!mDbHelper.isDataBaseExist()){
                //get database, we will override it in next steep
                //but folders containing the database are created
                mDb = mDbHelper.getWritableDatabase();
                mDb.close();
                //copy database
                mDbHelper.copyDataBase();                               
        }                                               
        mDb = mDbHelper.getWritableDatabase();
}catch(SQLException eSQL){
        Log.e("log_tag","Can not open database");
}
catch (IOException IOe) {
        Log.e("log_tag","Can not copy initial database");
}

As you can see each method handles the database as a general file, so it can be used for any file you want to have a default "value" in your application.

Tags:

Bookmark/Search this post with

Comments

دردشة سورية دردشة

ameer | Tue, 01/03/2012 - 10:20.

دردشة سورية
دردشة لبنانية
دردشة عراقية
شات سوري
شات لبناني
دردشة سوريا
دردشة لبنان
شات سوريا
شات لبنان
دردشة السويدي
منتديات السويدي
اغاني عراقية
صور فنانين
الرياضة العراقية
شعراء العراق
نغمات عراقية
اغاني عربية
اغاني كردية
دردشة عراقية
دردشة بنات العراق
دردشة صبايا بغداد
دردشة البصره
دردشة بغداد
دردشة بغدادية
دردشة صبايا بغداد
دردشة شباب العراق
دردشة بنات العراق
دردشة الكرادة
دردشة دمشق
دردشة بيروت
دردشة حلب
دردشة حلب
دردشة عراقية
دردشة العراق
شات عراقي
جات عراقي
دردشه عراقيه
دردشة صبايا لبنان
دردشة بنات لبنان

دردشة سورية دردشة

ameer | Tue, 01/03/2012 - 10:05.

شات صوتي | دردشة صوتية | كلام

nn7575 | Mon, 12/12/2011 - 15:51.

شات صوتي

Guter Artikel

Kai Springmüller | Sun, 10/09/2011 - 11:40.

Wirklich ein sehr interessanter und kritischer Blog, der immer wieder aktuelle Themen. Handy-Netz24 | alte handys | Super Preiswertes Smartphone

Market understands very well

jeckwelch89 | Tue, 08/09/2011 - 04:22.

Market understands very well what their consumer wants. So, they are busied in doing best for their consumers. Used BMW Cars Some well known companies of digital camera industry have great how know about their customers. Canon is one from the best companies in cameras market. Previously, they have satisfied many of their consumers by powerful inventions in cameras industry. Used Daihatsu Cars Today, I am reviewing Canon’s best product PowerShot SX130 IS exclusively for you. Used Audi Cars for Sale

Peltiseppä Good day, Can I

ali.shass | Fri, 10/07/2011 - 06:36.

Peltiseppä Good day, Can I export your post picture and apply that on my personal blogging site?

work and reporting! Keep up

ali.shass | Wed, 09/14/2011 - 11:53.

work and reporting! Keep up the great works guys I've added you guys to my blogroll. This is a great article thanks for sharing this informative information.. I will visit your blog regularly for some latest post.thanks for sharing beauty videos

ur Pretty good post. I just

ali.shass | Wed, 09/14/2011 - 11:52.

ur Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon.
skincare reviews

u guess I will have to

ali.shass | Wed, 09/14/2011 - 11:51.

u guess I will have to continue studying yours and pray that someday I will write on a subject with as a lot wisdom as you have! Bravo! skin care products

Just want to say your article

ali.shass | Sun, 09/04/2011 - 12:34.

Just want to say your article is stunning. The lucidity in your post is simply striking and i can assume you are an expert on this subject. Well with your permission allow me to grab your rss feed to keep up to date with incoming post. Thanks a million and please keep up the delightful work.sales tax compliance

All the contents you

ali.shass | Sun, 09/04/2011 - 11:56.

All the contents you mentioned in post is too good and can be very useful. I will keep it in mind, thanks for sharing the information. Keep updating, looking forward for more posts. Thanks sales tax consulting

Many thanks for making the

ali.shass | Sun, 09/04/2011 - 11:54.

Many thanks for making the sincere effort to explain this. I feel fairly strong about it and would like to read more. If it's OK, as you find out more in depth knowledge, would you mind writing more posts similar to this one with more information?
sales tax audit

I am very enjoyed for this

ali.shass | Sun, 09/04/2011 - 11:53.

I am very enjoyed for this side. Its a nice topic. It help me very much to solve some problems. Its opportunity are so fantastic and working style so speedy. I think it may be help all of you. Thanks, sales tax filing

I certainly enjoyed the way

ali.shass | Tue, 08/23/2011 - 17:16.

I certainly enjoyed the way you explore your experience and knowledge of the subject! Keep up on it. Thanks for sharing the info How to grow taller

I really like the fresh

ali.shass | Tue, 08/23/2011 - 17:15.

I really like the fresh perpective you did on the issue. Really was not expecting that when I started off studying. Your concepts were easy to understand that I wondered why I never looked at it before. Glad to know that there's an individual out there that definitely understands what he's discussing. Great job Christmas Lights

OMG! I have to say, your blog

ali.shass | Tue, 08/23/2011 - 17:14.

OMG! I have to say, your blog needs to be one of the best written blogs that I have learn in a protracted time.What I wouldn't give as a way to put up posts which might be as interesting| as yours. dressing gowns

Just want to say your article

ali.shass | Fri, 08/19/2011 - 18:11.

All the contents you

ali.shass | Fri, 08/19/2011 - 18:09.

Many thanks for making the

ali.shass | Fri, 08/19/2011 - 18:07.

I am very enjoyed for this

ali.shass | Fri, 08/19/2011 - 18:06.

hey buddy,this is one of the

ali.shass | Fri, 08/19/2011 - 18:04.

hey buddy,this is one of the best posts that I’ve ever seen; you may include some more ideas in the same theme. I’m still waiting for some interesting thoughts from your side in your next post
San Diego Handyman

Happy to see your blog as it

ali.shass | Fri, 08/19/2011 - 18:03.

Happy to see your blog as it is just what I’ve looking for and excited to read all the posts. I am looking forward to another great article from you.
Temecula Handyman

I have to say, your blog

ali.shass | Fri, 08/19/2011 - 17:57.

I have to say, your blog needs to be one of the best written blogs that I have learn in a protracted time.What I wouldn't give as a way to put up posts which might be as interesting| as yours. Rancho Cucamonga Handyman

I really like the fresh

ali.shass | Fri, 08/19/2011 - 17:58.

I certainly enjoyed the way

ali.shass | Fri, 08/19/2011 - 18:00.

I certainly enjoyed the way you explore your experience and knowledge of the subject! Keep up on it. Thanks for sharing the info Palm Desert Handyman

certainly enjoyed the way you

ali.shass | Thu, 08/11/2011 - 04:38.

certainly enjoyed the way you explore your experience and knowledge of the subject! Keep up on it. Thanks for sharing the info
deck waterproofing

I am impressed by the way you

ali.shass | Fri, 08/19/2011 - 18:02.

I am impressed by the way you covered this topic. It is not often I come across a blog with captivating articles like yours. I will note your feed to keep up to date with your approaching updates.Just striking and do uphold up the good work.
Moreno Valley Handyman

Mens Trench coat

yjbond | Sun, 08/07/2011 - 13:45.

You are focused on realizing all you possibly can about this. We're completely satisfied you discovered us. On this site, we have introduced collectively an unlimited array of data and sources on this.

Mens Trench coat

Patio Furniture Clearance

yjbond | Sun, 08/07/2011 - 13:44.

blog as it is just what I’ve looking for and excited to read all the posts. I am looking forward to another great article from you.

Patio Furniture Clearance

Grard Boutin semble satisfait

jeckwelch89 | Sat, 08/06/2011 - 05:59.

Grard Boutin semble satisfait de son dernier investissement et ces businessmen du soleil ne semblent plus craindre le rchauffement climatique tant que le soleil brillera sur leurs toitures. Most Popular Articles

Good post. Very impressive.

wenger backpack | Fri, 08/05/2011 - 22:22.

Good post. Very impressive. Thanks for sharing.
android tablet

joann fabrics printable coupons

yjbond | Fri, 08/05/2011 - 08:29.

Hey--I just wanted to say hi and tell you how wonderful I think your blog is. I am a latecomer, unfortunately--but I will keep a close eye on it, now that I have found it. Take care, and thanks for all of the awesome information!

joann fabrics printable coupons

One Shoulder Dress

yjbond | Fri, 08/05/2011 - 08:27.

blog as it is just what I’ve looking for and excited to read all the posts. I am looking forward to another great article from you.

One Shoulder Dress

Homes

aliyog | Fri, 08/05/2011 - 07:58.

Your blog is a great one. What really impresses me is that you are correctly mentioned that there are thousands of tools that are available to create a website or launch one but what matters is that you choose the right one, the one that gives you all that is actually needed
Austin Home Search

Android

Jessica Smith | Fri, 08/05/2011 - 07:23.

Very interesting articles. Great job done
batik fabric

towing Service rochester ny

yjbond | Thu, 08/04/2011 - 20:02.

I came to your article from another article and am really interested in this learning about this. , I feel strongly about information and love learning more on this. If possible, as you gain expertise, It is extremely helpful for me. would you mind updating your blog with more information?

towing Service rochester ny
towing rochester ny

presentation folders

yjbond | Thu, 08/04/2011 - 20:01.

presentation folders
custom pocket folders

It such a great list. You

redrose034 | Thu, 08/04/2011 - 04:40.

It such a great list. You have done really a great job to collect all that stuff. Thanks for it.

hack facebook account

A default database is a very

Alvasin | Wed, 08/03/2011 - 13:31.

A default database is a very useful thing. By the help of it we can solve many difficult internet browsing problems. Thanks for illustrating the commands. Without illustration it’s really tough to understand.austin tattoo removal

Awesome

redrose034 | Wed, 08/03/2011 - 13:02.

i Just Found You Site is Beautiful with a lot of good Information :)

psn code generator

NICE BLOG

kalis | Wed, 08/03/2011 - 12:59.

Thanks for sharing. i really appreciate it that you shared with us such a informative post. Car Loan

gerda spillmann coupon code

yjbond | Tue, 08/02/2011 - 20:40.

you’ve always shared with us. Just keep writing this kind of posts.The time which was wasted in traveling for tuition now it can be used for studies.Thanks

gerda spillmann coupon code

gerda spillman cosmetics

yjbond | Tue, 08/02/2011 - 20:39.

Nice post man. Thanks a lot for the kind of perfect topic I have not a lot of information about it but I have got an extra unique info in your unique post. I also like posting comments because helps build community.

gerda spillman cosmetics

Blackout Curtains

yjbond | Mon, 08/01/2011 - 21:09.

You also know how to make people rally behind it, obviously from the responses taking time and real effort to make a good article !!

Blackout Curtains

Patio Furniture Clearance

yjbond | Mon, 08/01/2011 - 21:08.

Thanks for informative and helpful post, obviously in your blog everything is good.If you post informative comments on blogs there is always the chance that actual humans will click through.

Patio Furniture Clearance

Computers for Sale So, they

jeckwelch89 | Mon, 08/01/2011 - 06:59.

Computers for Sale So, they are plug n play devices for all operating systems (Except windows 98 and previous) with USB function. Mp3 player requires simple medium of transfer files like copy and paste but some required computer software. A backward function, they have very slow speed of file transfer as compared to USB flash drives.Electronics for Sale

thanks

blogger88 | Mon, 08/01/2011 - 05:13.

thanks for your article its really great and useful
sportbike specifications SKEMA RANGKAIAN Electronic Circuit scolarship wireless car specifications gadget and computer car first look Motorcycle Modification sexi-stars. newlaptop circuits-audio electronic projects auto girl weapons system science kids gadget bikes walpaper mobil-wallpaper MODIFIKASI MOBIL plane-wallpaper celebsexypict artist-scandal sport-cars bikespict motor-modify sexi-model laptopharga gambar-artist fast-superbike autoshowmodel harga-kamera notebook-price diamonds-collections phones-gallery camera-prices home-pic audio-gallery autocarpict living-cares homes life-style

Help Wedding Planning

How to have a default database

Comments

Main menu

New tutorials from Helloandroid

Recent Apps

Android on Twitter

Poll

Useful resources

Android Development Projects