Re: Django database problem

Yes it seems that I can influence to the 'jumps' with my management command. First my bot went through tens of items per loop, however when I changed the bot to check only 2 items per loop, the 'jumps' got smaller. So even though the table rows do not accrue (nothing is added) when no new items

Re: Django database problem

I have looked at this several times myself. :-) Regards, Andréas Den mån 27 aug. 2018 kl 13:33 skrev Jason : > oh, good catch. I didn't think of that, but you're right. > > > https://stackoverflow.com/questions/449346/mysql-auto-increment-does-not-rollback > > On Monday, August 27, 2018 at

Re: Django database problem

oh, good catch. I didn't think of that, but you're right. https://stackoverflow.com/questions/449346/mysql-auto-increment-does-not-rollback On Monday, August 27, 2018 at 3:50:28 AM UTC-4, Andréas Kühne wrote: > > The management command could be wrapped within a transaction, this would > then

Re: Django database problem

The management command could be wrapped within a transaction, this would then in the database create a lot of models, but if the transaction fails - the rollback will not reset the database id. Regards, Andréas Den sön 26 aug. 2018 kl 12:29 skrev Mikko Meronen < mikkovillemero...@gmail.com>:

Re: Django database problem

yeah, there is a limit, and its set by the data type you use for the id field. by default, id is set to IntegerField which has a maximum value of 2147483647 sounds like the issue with the ids jumping

Re: Django database problem

Hi, Thanks for advice ^^ I have one new concern. Is there a limit for for Django model IDs? Now I have automated the data insert with python code loop, but the ID-number is not consecutive. It jumps for example from ...56 to 571... and from ...587 to 3763... and so forth. Do you know why it is

Re: Django database problem

Hi, Instead of doing everything by hand I would recommend doing a custom management command in Django. Because management commands live inside Django ecosystem you get full benefits of Django. Migrations to setup database tables from model definitions. Models and ORM to interact with database.

Re: Django database problem

Hi and thanks for your help. I have tried postgress and now I have a problem using it. Here's my code following an error. I appreciate any help. def do(): x = 1 while x == 1: create_table() print('finding data') find_data() time.sleep(120) def

Re: Django database problem

You could generate models from sqlite database - https://docs.djangoproject.com/en/2.1/howto/legacy-databases/ Than switch to PostgresQL -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails

Re: Django database problem

Mikko, Check out this link below, it will help you understand how to connect you Django project to any DB manager. https://docs.djangoproject.com/en/2.1/intro/tutorial02/ On Fri, Aug 17, 2018 at 6:55 PM Mikko Meronen wrote: > Hi, > > I'm quite new with django and python and I wish someone

Re: Django database problem

You will have to create a database on your system first (it is better to use mysql instead of sqlite) and then run commands :- 1. python manage.py makemigrations 2. python manage.py migrate Also you will have to create forms (forms.ModelForm or forms.Forms) for taking input. On Fri, 17 Aug

Django database problem

Hi, I'm quite new with django and python and I wish someone could help me. I'm building a webpage where my python program/bot collects data from webpages. Is there a way that I can use my python program to store the data to django's database? At the moment when I run my program, I collect the