Программные средства для заполнения базы персональных данных

(обязательное)

Листинг класса DbHelper

package demidov.docrecognition.database;

import android.content.ContentValues;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import static demidov.docrecognition.database.DocRecognizerContract.DocumentType.COLUMN_NAME_CODE;

import static demidov.docrecognition.database.DocRecognizerContract.DocumentType.COLUMN_NAME_NAME;

import static demidov.docrecognition.database.DocRecognizerContract.DocumentType.VALUE_CODE_PASSPORT;

import static demidov.docrecognition.database.DocRecognizerContract.DocumentType.VALUE_CODE_SNILS;

import static demidov.docrecognition.database.DocRecognizerContract.DocumentType.VALUE_NAME_PASSPORT;

import static demidov.docrecognition.database.DocRecognizerContract.DocumentType.VALUE_NAME_SNILS;

public class DbHelper extends SQLiteOpenHelper {

private static final int DATABASE_VERSION = 3;

private static final String DATABASE_NAME = "DocRecognizer.db";

private static final String SQL_CREATE_DOCUMENT =

"CREATE TABLE " + DocRecognizerContract.Document.TABLE_NAME + " (" +

DocRecognizerContract.Document._ID + " INTEGER PRIMARY KEY," +

DocRecognizerContract.Document.COLUMN_NAME_INSERT_DATE + " TEXT," +

DocRecognizerContract.Document.COLUMN_NAME_DATA + " TEXT," +

DocRecognizerContract.Document.COLUMN_NAME_USER_ID + " INTEGER," +

DocRecognizerContract.Document.COLUMN_NAME_DOC_TYPE_ID + " INTEGER)";

private static final String SQL_CREATE_DOCUMENT_TYPE =

"CREATE TABLE " + DocRecognizerContract.DocumentType.TABLE_NAME + " (" +

DocRecognizerContract.DocumentType._ID + " INTEGER PRIMARY KEY," +

DocRecognizerContract.DocumentType.COLUMN_NAME_NAME + " TEXT," +

DocRecognizerContract.DocumentType.COLUMN_NAME_CODE + " TEXT)";

private static final String SQL_CREATE_USER =

"CREATE TABLE " + DocRecognizerContract.User.TABLE_NAME + " (" +

DocRecognizerContract.User._ID + " INTEGER PRIMARY KEY," +

DocRecognizerContract.User.COLUMN_NAME_USERNAME + " TEXT," +

DocRecognizerContract.User.COLUMN_NAME_PASSWORD + " TEXT)";

private static final String SQL_DROP_DOCUMENT =

"DROP TABLE IF EXISTS " + DocRecognizerContract.Document.TABLE_NAME;

private static final String SQL_DROP_DOCUMENT_TYPE =

"DROP TABLE IF EXISTS " + DocRecognizerContract.DocumentType.TABLE_NAME;

private static final String SQL_DROP_USER =

"DROP TABLE IF EXISTS " + DocRecognizerContract.User.TABLE_NAME;

public DbHelper(Context context) {

super(context, DATABASE_NAME, null, DATABASE_VERSION);

}

@Override

public void onCreate(SQLiteDatabase db) {

db.execSQL(SQL_CREATE_DOCUMENT);

db.execSQL(SQL_CREATE_DOCUMENT_TYPE);

db.execSQL(SQL_CREATE_USER);

ContentValues docTypeValues = new ContentValues();

docTypeValues.put(COLUMN_NAME_CODE, VALUE_CODE_PASSPORT);

docTypeValues.put(COLUMN_NAME_NAME, VALUE_NAME_PASSPORT);

db.insert(DocRecognizerContract.DocumentType.TABLE_NAME, null, docTypeValues);

docTypeValues = new ContentValues();

docTypeValues.put(COLUMN_NAME_CODE, VALUE_CODE_SNILS);

docTypeValues.put(COLUMN_NAME_NAME, VALUE_NAME_SNILS);

db.insert(DocRecognizerContract.DocumentType.TABLE_NAME, null, docTypeValues);

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

db.execSQL(SQL_DROP_DOCUMENT);

db.execSQL(SQL_DROP_DOCUMENT_TYPE);

db.execSQL(SQL_DROP_USER);

onCreate(db);

}

@Override

public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {

onUpgrade(db, oldVersion, newVersion);

}

}

ПРИЛОЖЕНИЕ 21