How to Connect Django Project to Already Existing Database

[@hommastonlimited3187]

very lucid and straight to the point. 100 percent on point

[@albertoromero1588]

Thanks a lot! so easy... I was trying some times but, i can´t do it. After your video all is well. Greetings from Mexico City.

[@fatihcakular]

Thanks to you, I was able to find the solution I was looking for.

[@Gorlung]

Brilliant! One more video on the channel and again exactly I was looking for!

[@SandeepKumar-ik1he]

Thank you sir your effort is beneficial for a beginner

[@for41]

thank you so much! this is exactly what I was looking for. very clean explanation. love it. wish you only the best!!!

[@nikhilshikare8182]

Thank-You Sir , After lot of searching and watching finally found this. this is exact i am searching for

[@KenBroTech]

I'm glad you found this helpful

[@therumbekans7944]

Thanks man! Wow ....doing my second yewr project and this is wow

[@SahPhoenix]

EXACTLY what I needed, 10/10 thank you

[@ya00278]

Can't thank you enough! Very clear explanations and helped me a lot. wish you all the best!

[@KenBroTech]

Glad it helped!

[@Davidkiania]

This is splendid work my brother from Accra have several DBs I want to Djangofy 👏🏾👏🏾

[@KenBroTech]

Big up

[@justflybluesky]

Well done mate. In the official Django documentation I was missing exactly the connection of an existing SQL db to a django project.

[@requestmusekwa8757]

this is very usefull bro..

[@henrykpano1715]

Great tutorials. I was looking for this. Thanks

[@deshi4722]

WOnderful, very very thank you SIr

[@TN61GAMER]

It's really helpful for me🎉😊

[@lenikki6348]

Thank you for this. I've been searching for this didn't find any answer.

[@aniketsaha7273]

Exactly what I needed thanks alot

[@adassb2999]

excellent video , many thanksss

[@asgeralia8802]

superb superb superb sir

[@princesamuel100]

This is very useful Ken. Thanks soo much.

[@KenBroTech]

You are very welcome

[@tlideas]

amazing tutorial ever. thanks you man

[@KenBroTech]

Glad you liked it!

[@md.rahimuddin1738]

Thanks brother, Just amazing

[@KenBroTech]

Glad you liked it!

[@asgeralia8802]

Superb sir, pls help in crud operations

[@BERTDELASPEED]

Great content and very well explained, Thanks a lot

[@axelamoe]

Great video

[@bensonsaju9533]

thanks alot bro..this was so helpfull

[@KenBroTech]

Glad it helped

[@ThegreatestVN]

Hi Ken, I am running in to an error unfortunately, it says "Did you install mysqlclient?" after i connected everything, what should I do, should i pip install mysqlclient?

[@AttilioBongiorni]

Thank you, very good tutorial!

[@KenBroTech]

Glad it was helpful!

[@moviewithdan4499]

thank you ... helped me alot

[@shubhsingh1138]

Thanks a lot for this video.

[@KenBroTech]

You are most welcome

[@JesudhasXavierJ]

Hi, can you please make a video for connecting a secondary db which is already exist

[@redrum4486]

this is perfect!! you da man bro

[@KenBroTech]

Glad it helped!

[@redrum4486]

@@KenBroTech I have 1 issue, some of the tables in my second database do not have a parimary key column so I have having trouble accessing them via admin panel, what could I do? As the django docs state that each model should have at least 1 primary key

[@pavanbaswani2454]

Will it update the records in the phpmyadmin too??? I got confused that you use the localhost/admin page to create a user, will the database is in sync (if you update in admin page will it be affected in phpmyadmin page?)

[@natural8471]

Thank you! Really helpful!!!

[@khurramkhan5606]

what if i want to autoamte this tables like i have to connect user's database and for which i don't actually know the quantity and names of table then?

[@vishalmhatre1731]

Does in django primary key should always be id or we can name anything

[@moritzstecher7364]

Very helpful, thank you!!

[@sweethouse2773]

what should you do when you have images or static files linked to your db

[@oparesimon]

Kudos

[@michaelfields7296]

Will creating models mess up my views or templates I have for my html pages?

[@KenBroTech]

This video offers solution to a specific instance where a database system already exists and you want to integrate it into your Django project. This will not affect your views or template in anyway. All you need to be mindful are the names you used in the models and make them reflect when you write them in the views.

[@xtremedestroyer9241]

you're a fucking top G brother! Thank you very much for this easy to follow video!

[@Sergeika1000]

I did not understand where in the config the name of the table Students was written?

[@gulzarsingh716]

How to connect multiple legacy databases with tables in the same app?

[@cheerio4742]

What if the Database is update like new tables has been added, do I need to inspectdb again?

[@KenBroTech]

yes, but I think after the initial connection to the existing database, any other updates will be done via the models.py

[@wanheda-codm7685]

you saved me

[@omarnaitelhaj4446]

Thanks ❤️❤️

[@KenBroTech]

You're welcome 😊

[@hommastonlimited3187]

I wished you had a tutorial on how to import excel files into django

[@kamakshitrivedi8561]

Can you please make a similar video for alreading existing mongodb database? Please..

[@pinakityagi3638]

when using the inspect command for mongodb database it's not working

[@ashokthegamer3439]

Character field data fetching is ok. But imagefield is not fetching the data and not return to html page How could i do

[@anithasshenoy6662]

Great tutorial. However no matter I do I can't seem to get data on the webpage. The context send to the html page is not reading on it. What could be the reason ?

[@KenBroTech]

Anitha, please I am unable to understand your question very well. Kindly let me understand and I will be glad to assist you

[@anithasshenoy6662]

@@KenBroTech I think if you see my code you shall understand better. Models.py from django.db import models class Cities(models.Model): cities_id = models.AutoField(primary_key=True) citiesname = models.CharField(db_column='citiesname', max_length=100) citiescol = models.CharField(db_column='citiescol', max_length=45, blank=True, null=True) class Meta: managed = False db_table = 'cities' views.py rom django.shortcuts import render from .models import Cities # Create your views here. def hi(request): return render(request, 'eshops/main.html') def hi1(request): cty=Cities.objects.all() content={ 'ctname': cty.citiesname } return render(request, 'eshops/mntop.html',{'di': content}) Here typing cty. do not show any of the column objects in the table Cities The html page displays error msg "'QuerySet' object has no attribute 'citiesname'" Sometimes the page displays "django.db.models.query_utils.DeferredAttribute object at 0x0000000003F9F0D0" error msg. Absolutely stuck now for the 2nd day. Can you identify what I am doing wrong ? cty=Cities.objects.all() displays a warning Unresolved attribute reference 'object' for class 'Cities' if I enter Objects=None in the models.py inside the Cities class, this warning goes away. But nothing else changes.

[@anithasshenoy6662]

After watching your video again, I have modified the views.py and the html page as def hi1(request): city = Cities.objects.all() context = { 'city': Cities } return render(request, 'eshops/mntop.html', context) and the html page modified thus {{ city.citiesname }} However on running, the html page do not display anything. It simply displays a blank tag. Means no data from the table passes to the html page. In fact I noticed that while typing {{ city. }} the column names do not appear as popdown list like when you where typing. This shows city do not contain any objects from the Cities. And pyCharm displays "Unresolved attribute reference 'objects' for class 'Cities' . This could be the reason why context is not passing any data from the table. Some blogs tell adding objects = models.manager() solves this issue. But when I tried it, it gave another error that .manager cannot called. I wonder how it works in your system ?

[@KenBroTech]

Hi Anitha, if this is exactly what you have typed: def hi1(request): city = Cities.objects.all() context = { 'city': Cities } return render(request, 'eshops/mntop.html', context) then you need to change the value Cities inside your context dictionary to city. So your context dictionary will look like context ={ 'city': city }

[@anithasshenoy6662]

@@KenBroTech Thank you so much. finally I could make it.

[@vaishnavideshmukh5194]

I am getting an error whenever I m importing a Class from models to the views I get this error "ValueError: source code string cannot contain null bytes" Even tho I don't have any null values . Can you please help. Thankyou

[@idedhica]

i got an error when i want to runserver. "You have 1 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s): UserApi. Run 'python manage.py migrate' to apply them."... when i apply migrations it show that relations table already exist

[@KenBroTech]

Kindly run python manage.py makemigrations then later run python manage.py migrate

[@daiphuc5357]

thanks very much

[@KenBroTech]

Always welcome

[@diegofoca7664]

Thank you so much

[@KenBroTech]

You're most welcome

[@juanda4269]

Thank you!

[@Namastedbt]

Thanks 👍

[@KenBroTech]

Welcome 👍

[@josealvarezmendoza5448]

when i run the page, django gives me an error who says " No such column: Prueba.id" mi classname is prueba. I dont know how to fix this error it seems like django creates a new column for the id. And trust me i do step by step like in your video.

[@KenBroTech]

Kindly give me a proper context to the error you get so I can assist you

[@jbailey130]

I like you

[@mahmudoduoye7391]

Bravo!

[@oparesimon]

Monitoring 24/7

[@KenBroTech]

Thanks bro. The projects I have for tomorrow and Thursday will excite you more

[@oparesimon]

@@KenBroTech look forward to bro.

[@Noritoshi-r8m]

Thank you so much!!! Helped a lot

[@KenBroTech]

You're welcome!