Advertisement
JaiminB

SQLite QUERY Android

Jul 8th, 2020
1,301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.12 KB | None | 0 0
  1. 1)
  2. CREATE TABLE restaurants {
  3.                              Name TEXT PRIMARY KEY,
  4.                              Food_Type TEXT,
  5.                              Distance INTEGER,
  6.                              DATE TEXT AS ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS"),
  7.                              Rating INTEGER,                      
  8. };
  9.  
  10. 2)
  11.  
  12. public class PostsDatabaseHelper extends SQLiteOpenHelper {
  13.     private static final String DATABASE_NAME = "myRestaurantsList";
  14.     private static final INT DATABASE_VERSION = 1;
  15.  
  16. public PostsDatabaseHelper(Context context) {
  17.         super(context, DATABASE_NAME, NULL, DATABASE_VERSION);
  18.     }
  19.  
  20. public void onCreate(SQLiteDatabase db) {
  21.         String My_Restaurant_List_TABLE = "CREATE TABLE " + "myRestaurantsList" +
  22.                 "("
  23.                     + KEY_NAME + " TEXT PRIMARY KEY," // Define a PRIMARY KEY
  24.                     + KEY_FOOD_TYPE + " TEXT, "
  25.                     + KEY_DISTANCE + "INTEGER,"
  26.                     + KEY_DATE + "TEXT,"
  27.                     + KEY_RATING + "INTEGER,"
  28.                + ")";
  29.  
  30.         db.execSQL(CREATE_POSTS_TABLE)
  31.     }
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement