1mVqhZDf

1package com.dev.maveriw.mydiary.database;
2
3/**
4 * Created by maveriw on 24/10/2016.
5 */
6
7import android.content.ContentValues;
8import android.content.Context;
9import android.database.Cursor;
10import android.database.sqlite.SQLiteDatabase;
11import android.database.sqlite.SQLiteOpenHelper;
12
13
14import com.dev.maveriw.mydiary.model.Note;
15
16import java.text.SimpleDateFormat;
17import java.util.ArrayList;
18import java.util.Date;
19
20public class DatabaseManager extends SQLiteOpenHelper {
21
22    public static final int database_version = 1;
23
24    public static final String DATABASE_NAME = "mydiary";
25
26    public static final String TABLE_NOTE = "note";
27
28    public static final String KEY_NOTE_ID =          "note_id";
29    public static final String KEY_NOTE_USERNAME =    "note_username";
30    public static final String KEY_NOTE_TITLE =       "note_title";
31    public static final String KEY_NOTE_CONTENT =     "note_content";
32    public static final String KEY_NOTE_DATE =        "note_date";
33
34    public static final String CREATE_TABLE_NOTE =
35            "CREATE TABLE " + TABLE_NOTE + "(" +
36                    KEY_NOTE_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
37                    KEY_NOTE_USERNAME + " TEXT NOT NULL,"+
38                    KEY_NOTE_TITLE + " TEXT,"+
39                    KEY_NOTE_CONTENT + " TEXT NOT NULL,"+
40                    KEY_NOTE_DATE + " DATETIME NOT NULL )";
41
42    public DatabaseManager(Context context) {
43        super(context, DATABASE_NAME, null, database_version);
44
45    }
46
47
48    @Override
49    public void onCreate(SQLiteDatabase db) {
50        db.execSQL(CREATE_TABLE_NOTE);
51    }
52
53    @Override
54    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
55        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NOTE);
56        onCreate(db);
57    }
58
59    public long createNote(String username, String title, String content ) {
60
61        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
62        Date date = new Date();
63
64        SQLiteDatabase db = this.getWritableDatabase();
65
66        ContentValues contentValues = new ContentValues();
67        contentValues.put(KEY_NOTE_USERNAME, username);
68        contentValues.put(KEY_NOTE_TITLE, title);
69        contentValues.put(KEY_NOTE_CONTENT, username);
70        contentValues.put(KEY_NOTE_DATE, dateFormat.format(date));
71
72        return db.insert(TABLE_NOTE, null, contentValues);
73    }
74
75    public ArrayList<Note> getNotes(){
76        SQLiteDatabase db = this.getReadableDatabase();
77        try {
78            Cursor cursor = db.query(false, TABLE_NOTE, null, null, null, null, null, null, null);
79            ArrayList<Note> notes = new ArrayList<Note>();
80            if(cursor.moveToFirst()) {
81                do {
82                    //int id = cursor.getInt(cursor.getColumnIndex(KEY_PEOPLE_ID));
83                    //String name = cursor.getString(cursor.getColumnIndex(KEY_PEOPLE_NAME));
84                    //peoples.add(new People(id, name, this));
85
86                } while (cursor.moveToNext());
87            }
88            return notes;
89        }catch (Exception e){
90            return null;
91        }
92
93    }
94
95    public void deletePeople(int id) {
96        SQLiteDatabase db = this.getWritableDatabase();
97
98        db.delete(TABLE_NOTE, KEY_NOTE_ID + "=" + id, null);
99        db.close();
100    }
101
102
103}