Android Open Source - permission-explorer Global Schema

From Project

Back to project page permission-explorer.

License

The source code is released under:

Copyright (C) 2012 Rui Gon?alves and Daniel Cibr?o Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"),...

If you think the Android project permission-explorer listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package pt.up.fe.ssin.pexplorer.data;
//from   w ww  .  j a v  a  2s . co  m
import java.io.IOException;
import java.util.Scanner;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class GlobalSchema {

    public static final String PERMISSION_TABLE_NAME = "permissions";
    private static final String CREATE_SCRIPT_FILE = "data.sql";

    public static void createSchema(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + PERMISSION_TABLE_NAME + " ( "
                + PermissionExplorerContentProvider.PERMISSION_ID
                + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + PermissionExplorerContentProvider.PERMISSION_NAME
                + " VARCHAR(255), "
                + PermissionExplorerContentProvider.PERMISSION_COMMON
                + " INTEGER ,"
                + PermissionExplorerContentProvider.PERMISSION_DESCRIPTION
                + " VARCHAR(255));");
    }

    public static void readDataFromDBFile(SQLiteDatabase db, Context context,
            String dataBaseName) {
        Scanner sc = null;
        try {
            sc = new Scanner(context.getAssets().open(CREATE_SCRIPT_FILE));
            sc.useDelimiter(";");
            while (sc.hasNext()) {
                String sqlCmd = sc.next();
                Log.i("SQL Command", sqlCmd);
                db.execSQL(sqlCmd);
            }
        } catch (IOException e) {
            Log.e("DB " + dataBaseName, "Failed to read script file.");
            e.printStackTrace();
            return;
        } finally {
            if (sc != null)
                sc.close();
        }
    }
}

Java Source Code List