As we already know, Django generates a database by default in the form of **SQLite**. 

#   
## Django app with SQLite database
A superuser has been created using an SQLite database, given below. 
* We start the terminal by clicking the "Run" button. 
* Now, we can find the application by clicking on the given link below the "Run" button. 

* To see the login page for the Django admin site, we need to append **`/admin/`** at the end of our base URL.
For example, if the application is running at `http://127.0.0.1:8000`, we can access the admin panel at `http://127.0.0.1:8000/admin/`.

> **Note**: We will use "educative" as the user name and "edu123" as the password. 

#!/usr/bin/env python
"""Django's command-line utility for administrative tasks."""
import os
import sys


def main():
    """Run administrative tasks."""
    os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'my_project.settings')
    try:
        from django.core.management import execute_from_command_line
    except ImportError as exc:
        raise ImportError(
            "Couldn't import Django. Are you sure it's installed and "
            "available on your PYTHONPATH environment variable? Did you "
            "forget to activate a virtual environment?"
        ) from exc
    execute_from_command_line(sys.argv)


if __name__ == '__main__':
    main()


import React from 'react';
import { shallow, configure } from 'enzyme';
import Adapter from 'enzyme-adapter-react-16';

configure({ adapter: new Adapter() });

import HelloWorld from './app';

var TestResult = function() {
    this.succeeded = false;
    this.reason = "";
    this.input = "";
    this.expected_output = "";
    this.actual_output = "";
}

export const executeTests = function() {

  var results = [];

  result = new TestResult();
  result.input = 'HelloWorld Component';
  result.expected_output = "span containing text 'Hello World'"

  let wrapper = shallow(<HelloWorld />);

  // Call your Challenge function here.

  let type = wrapper.type();
  let testSuccessful = true;
  let failureReason;

  if (type !== 'span') {
    testSuccessful = false;
    failureReason = "You need to render exactly one span HTML element";
  } else if (wrapper.props().children != "Hello World") {
     testSuccessful = false;
     failureReason = "You have rendered wrong message in your span element";
  }

  result.actual_output = wrapper.html();

  if (testSuccessful) {
    result.succeeded = true;
    result.reason = "Succeeded"
  } else {
    result.succeeded = false;
    result.reason = failureReason;
  }

  results.push(result);

  return results;
}


SqliteDB

React

Dart

GoJS React

Typescript React

Vue.js

#    
## The Django application with PostgreSQL database
We can connect PostgreSQL with Django by following these simple steps.  

- Download and install the PostgreSQL database from here: https://www.postgresql.org/download/
> **Note**: PostgreSQL has already been installed on our platform.

* Start the terminal by clicking the "Run" button in the given example below. 

* Start the service by typing the given command on the given terminal. 
```
service postgresql start
```
* We can alter the password of the superuser of PostgreSQL by typing the given command.   
```n
su - postgres -c "psql -d postgres -U postgres -c \"alter user postgres with password 'password123';\""
```
* We can create a database using the given command. 
```n
su - postgres -c "psql -d postgres -U postgres -c \"CREATE DATABASE example;\""
```
* The database section has been replaced in `settings.py`.
```
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'example',
        'USER': 'postgres',
        'PASSWORD': 'password123',
        'HOST': 'localhost',
    }
}
```
* Now, we type the following commands step by step:
  * `cd /usercode`
  * `python3 manage.py makemigrations`
   * `python3 manage.py migrate` 


* Next, we create a superuser by writing the following command.
``` 
python3 manage.py createsuperuser
```
> **Note**: A superuser will be created if we have entered all fields correctly. 

* To run the server, we type the following command.  
```
python3 manage.py runserver 0.0.0.0:8000
```

* Now we can find the application by clicking on the link given below the "Run" button.

* We append `/admin/` at the end of the base URL to access the admin panel.  




 



 

PostgreSQL2

pgSQL.tar.gz

PostgreSQL

How to connect PostgreSQL with Django

Connect PostgreSQL with Django by installing PostgreSQL, configuring `settings.py`, and using specific terminal commands for database setup and server launch.