SqliteEditor is an Android application for SQLITE database management. Our goal is to create an application that will help users within a company; the goal is to provide them with an interface allowing basic manipulation of databases. The main functions of this application are: the creation of objects (databases, tables, lines), the deletion of objects (lines, tables) in addition to an authentication layer allowing to distinguish between two types of users (Administrator and normal user).
How the app works
Our application is based on internal databases allowing the storage of users, and tables created. The start interface includes a connection form allowing each user authentication to access the view dedicated to him. There are two types of view depending on the type of user: "Administrator" or "User".
The "Administrator" view allows the management and search of users with an account on the application, while the "User" view allows through an interface the creation of databases, tables, the execution of SQL queries and the database export.
To get a local copy up and running follow these simple example steps.
The application currently requires JDK to build. If you already have JDK installed, skip this step.
Check if the right JDK is already available
Run the command java -version
. If you have the JDK installed, you should see something like:
openjdk version "11.0.10" 2021-01-19
OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.10+9)
OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.10+9, mixed mode)
If this command shows a different version is not a problem, you can follow the instructions below to install the JDK.
Install the JDK
We recommend using jEnv to manage your JDK installations. Here are instructions to setup a working JDK 1.8 installation :
-
Setup up Homebrew.
-
Install
jEnv
using Homebrew.
brew install jenv
- Add the following lines to your shell configuration file (
~/.bash_profile
if you're using bash, or~/.zshrc
if you're using zsh).
export PATH="$HOME/.jenv/bin:$PATH"
eval "$(jenv init -)"
- Once this is done, you'll need to restart the terminal or reload the configuration file in order for the
jenv
command to be recognised.
source <path to shell configuration file>
- Install the JDK using Homebrew.
brew tap AdoptOpenJDK/openjdk
brew install adoptopenjdk11
- Add the installed JDK to
jEnv
or another version
jenv add /Library/Java/JavaVirtualMachines/adoptopenjdk-11.jdk/Contents/Home
- Run the command
jenv versions
. You should see something like:
system
11
* 11.0
11.0.10
openjdk64-11.0.10
Clone the project using git.
Run the following command in a terminal.
$ git clone https://github.com/rabelamerany/SQLITE-Editor
Install Android Studio
Download and install Android Studio from their website.
Import the project into Android Studio.
When Android Studio starts up, it will prompt you to create a new project or import an existing project. Select the option to import an existing
project, navigate to the SQLITE-Editor
directory you cloned earlier, and select it.
When building for the first time, gradle will download all dependencies so it'll take a few minutes to complete. Subsequent builds will be faster.
The Simple App can be run locally on an Android emulator using Android Studio. To do this,
Create a Run/Debug configuration
- Open the Run/Debug configurations window through Run -> Edit Configurations (ref)
- Create a new configuration using the
Android App
template - Set the module to
app
, and finish creating the configuration
Create a virtual device
- Create an Android Virtual Device (AVD) using the AVD Manager, usually found in Tools -> AVD Manager. (ref)
- Select a device and operating system
- Note: You will have to download one of the available OS options the first time you create an AVD
Set the right build variant
- Open the Build Variants window through View -> Tool Windows -> Build Variants, or clicking the item in the lower left corner of the main window
- Set the Build Variant of the app module to
qaDebug
Run the app
- Click "Run", either through Run -> Run, or the green play button in the top toolbar.
Rabab El Amerany - rab.el.amerany@gmail.com
Project Link: https://github.com/rabelamerany/SQLITE-Editor