The question now arises about how we might populate our new database with data.
We could log into PostgreSQL and we could issue countless SQL commands to populate the various tables. But often in many web applications, users provide the data and the data enters via the website.
For other applications, we might have larger precompiled datasets, such as lists of postcodes and addresses, phonebooks, product catalogues, etc and certainly when we are developing an application, we might want nothing more than just to insert a small amount of data into our applications that we can test out our development.
Those are two the main ways that you might go about populating your database, and probably the main one for larger dataset is to write a script that will update the database.
But Django also provides a useful administration interface that we can use to examine the contents of the database and add and edit there too.
In order to use that, we’ll need to add an administrative user to our project.
So in CMD, in the directory with manage.py:
(env) $ python manage.py createsuperuser
We will be asked username, email address, password (twice) – by convention you can use admin and a normal password. Once all done this will return “Superuser created successfully.”
You may need to go to settings.py now and add your host into ALLOWED HOSTS if you are running from a remote host.
We can now start the server
(env) $ python manage.py runserver
We can now go to http://127.0.0.1:8000/admin/ and log in to Django Admin using the new username and password created.
Now go to admin.py in VSC which is in the genedata directory.
We firstly need to import all the models that we have previously written.
from .models import *
We need to create classes which create a tuple which defines the different columns that we’ve already defined.
class GeneAdmin(admin.ModelAdmin): list_display = ('gene_id', 'entity', 'start', 'stop', 'sense')
That configures what we’re going to show in the administrative interface, but then we need to actually use it in the administrative interface and to do this we have to register each model we want to share.
Save this and then go back to http://127.0.0.1:8000/admin/ You should already see groups and users. If you hit refresh, Genes should now appear too.
You can now click on Add to add some data.
In the example we weren’t able to add Sequencing and Ec as there we no options. So we went back to admin.py and added:
class ECAdmin(admin.ModelAdmin): list_display = ('ec_name', ) class SequencingAdmin(admin.ModelAdmin): list_display = ('sequencing_factory', 'factory_location') admin.site.register(EC, ECAdmin) admin.site.register(Sequencing, SequencingAdmin)
The server will actually restart every time we save a file. The CMD window should confirm this.
So let’s go back to http://127.0.0.1:8000/admin/genedata/gene/add/ In the left-hand column we should see Ecs, Genes and Sequencings listed under GENEDATA.
We can add an ec name, eg oxidoreductase, and a sequencing name, eg Sanger, UK, saving both of these.
Now we can try again and add a gene.
We can go back to admin.py and add products and attributes too:
class ProductAdmin(admin.ModelAdmin): list_display = ('type', 'product') class AttributeAdmin(admin.ModelAdmin): list_display = ('key', 'value') admin.site.register(Product, ProductAdmin) admin.site.register(Attribute, AttributeAdmin)
We can also include the link table too – this goes at the start of all the classes:
class GeneAttributeLinkInline(admin.TabularInline): model = GeneAttributeLink extra = 3
And add this in the gene class:
inlines = [GeneAttributeLinkInline]
Here’s the complete code for the page:
from django.contrib import admin from .models import * class GeneAttributeLinkInline(admin.TabularInline): model = GeneAttributeLink extra = 3 class GeneAdmin(admin.ModelAdmin): list_display = ('gene_id', 'entity', 'start', 'stop', 'sense') inlines = [GeneAttributeLinkInline] class ECAdmin(admin.ModelAdmin): list_display = ('ec_name', ) class SequencingAdmin(admin.ModelAdmin): list_display = ('sequencing_factory', 'factory_location') admin.site.register(Gene, GeneAdmin) admin.site.register(EC, ECAdmin) admin.site.register(Sequencing, SequencingAdmin)