Re: Erro em uma consulta Sqlite3

Bom dia meu amigo muito obrigado pela ajuda, foi um erro muito óbvio mas é isso mesmo, valeu pela ajuda! comunidade foda! Em qui., 4 de ago. de 2022 às 07:34, Joel Goldstick < joel.goldst...@gmail.com> escreveu: > On Thu, Aug 4, 2022 at 6:21 AM Luciano Martins wrote: > > > > É annotate > >

Re: Erro em uma consulta Sqlite3

On Thu, Aug 4, 2022 at 6:21 AM Luciano Martins wrote: > > É annotate > Publisher.objects.annotate(below_5=below_5).annotate(above_5=above_5) > Em quarta-feira, 3 de agosto de 2022 às 19:31:18 UTC-3, > alvaroteixe...@gmail.com escreveu: >> >> Bom dia amigos, estou desenvolvendo um blog e me

Re: Erro em uma consulta Sqlite3

É *annotate* Publisher.objects.annotate(below_5=below_5).annotate(above_5=above_5) Em quarta-feira, 3 de agosto de 2022 às 19:31:18 UTC-3, alvaroteixe...@gmail.com escreveu: > Bom dia amigos, estou desenvolvendo um blog e me deparei com um erro em > uma consulta, vou mandar o trecho do codigo

Erro em uma consulta Sqlite3

Bom dia amigos, estou desenvolvendo um blog e me deparei com um erro em uma consulta, vou mandar o trecho do codigo onde esta o erro: def get_queryset(self): qs = super().get_queryset() qs = qs.order_by('-id') qs = qs.annotade( numero_comentarios=Count(

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

make install > 1039 /home/felix/.local/python/python-3.9.1/bin/python3 > 1040 history > [felix@localhost Python-3.9.1]$ > /home/felix/.local/python/python-3.9.1/bin/python3 > Python 3.9.1 (default, Jan 21 2021, 10:58:50) > [GCC 10.2.0] on linux > Type "help"

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

/python-3.9.1/bin/python3 1040 history [felix@localhost Python-3.9.1]$ /home/felix/.local/python/python-3.9.1/bin/python3 Python 3.9.1 (default, Jan 21 2021, 10:58:50) [GCC 10.2.0] on linux Type "help", "copyright", "credits" or "license" for more informatio

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

issue, but do anyone know how to avoid this problem?: > > (venv) [felix@localhost blueprint]$ python > Python 3.9.1 (default, Jan 20 2021, 14:32:50) > [GCC 10.2.0] on linux > Type "help", "copyright", "credits" or "license" for more information

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

likely a Python level issue, but do anyone know how to avoid this problem?: (venv) [felix@localhost blueprint]$ python Python 3.9.1 (default, Jan 20 2021, 14:32:50) [GCC 10.2.0] on linux Type "help", "copyright", "credits" or "license" for more informatio

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

;help", "copyright", "credits" or "license" for more information. >>> import sqlite3 >>> conn = sqlite3.connect(':memory:') >>> conn.create_function('f', 2, lambda *args: None, deterministic=True) Traceback (most recent call last):   File &qu

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

The exception is raised from inside the C implementation in Python when checking sqlite3 version check. In Django: @async_unsafe def get_new_connection(self, conn_params): conn = Database.connect(**conn_params) if PY38: create_deterministic_function = functools.partial

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

rint]$ python > Python 3.9.1 (default, Jan 20 2021, 14:32:50) > [GCC 10.2.0] on linux > Type "help", "copyright", "credits" or "license" for more information. > >>> import sqlite3 > >>> conn = sqlite3.connect(':memory:') &g

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

how to avoid this problem?: (venv) [felix@localhost blueprint]$ python Python 3.9.1 (default, Jan 20 2021, 14:32:50) [GCC 10.2.0] on linux Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite3 >>> conn = s

Re: python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

quot;credits" or "license" for more information. >>> import sqlite3 >>> conn = sqlite3.connect(':memory:') >>> conn.create_function('f', 2, lambda *args: None, deterministic=True) Traceback (most recent call last): File "", line 1, in

python manage.py runserver can not use newly compiled sqlite3 lib on CentOS 7

System environment: Cent OS 7 Sqlite3 3.34.0 (Compile from source) Python 3.9.1 (Compile from source) Django 3.1.5 (Pip install) 1. Compile sqlite3: ./configure --prefix=/home/felix/.local/sqlite/sqlite-3.34.0 make && make install 2. Add sqlite3 lib to lib search path: export LD_LIBR

Re: Reg:Electron and sqlite3 packaging issue

wrote: > Dear Friends, > I am working on electron js and sqlite3. As my app is working fine in > development mode but it is giving issue after packaging and running my > exe.you can find issue in my attachment.If any one have any clue please let > me know. > I will

Re: Django shared-cache for in-memory SQLite3 is not working

the > main thread. I am using py3.6 and sqlite3 version is also met. > > $ python3 -c "from sqlite3 import dbapi2 as Database; print > (Database.__name__, Database.sqlite_version__info)" > > sqlite3.dbapi2 (3, 22, 0) > > Am I missing something? Any help is apprecia

Re: Sqlite3 error

Hi Chucks, On 28/04/2020 19.17, chucks ogwo wrote: I also tried to use pip to install sqlite3, it does not work too, I get a different error. (venv) C:\Users\Dell\PycharmProjects\interact_with_database>pip install sqlite3 Collecting sqlite3   Could not find a version that satisf

Re: Sqlite3 error

Well try to download sqlite from google then install to your mashine manually dont use pip On Tue, 28 Apr 2020, 20:17 chucks ogwo, wrote: > Hi, Everyone, I have been trying to interact with the sqlite3 database on > Pycharm, every time I run the code it gives me an import error. > >

Sqlite3 error

Hi, Everyone, I have been trying to interact with the sqlite3 database on Pycharm, every time I run the code it gives me an import error. Traceback (most recent call last): File ".\file.py", line 1, in import sqlite3 File "C:\Users\Dell\anaconda3\lib\sqlite3\__init

Re: I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

Export to csv in SQL then import into postgresql from there On Wed, Mar 25, 2020, 6:43 PM Thắng IT wrote: > solution > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it,

Re: I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

One possible solution: $ createdb newdb $ pgloader ./test/sqlite/sqlite.db postgresql:///newdb https://github.com/dimitri/pgloader El miércoles, 25 de marzo de 2020, 17:45:54 (UTC+1), Thắng IT escribió: > > solution -- You received this message because you are subscribed to the Google

Re: I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

cant be done directly from sqlite to postgres as there are differences between them ... safer to generate an intermediate file like a CSV or Excel file from the sqlite database .. create the new postgres database with proper column types .. make a python script to loop through each row in CSV or

I have issue. I want to migrate database from sqlite3 to postgresql. With a table have 10M records. I need a solution for issue. Maybe help me?

solution -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit

Recorrer una tabla sqlite3 en una view Django

¿Como puedo recorrer registro a registro una tabla e ir insertando dicha informacion en otra tabla segun criterio de lo que tenga en un campo de la primera tabla? -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group

Re: Can anyone share code for uploading csv or excel file to sqlite3 database.

Subject: Re: Can anyone share code for uploading csv or excel file to sqlite3 database. I have tried this but not working def upload_csv(request): data = {} if "GET" == request.method: return render(request, "add_student/bulk.html", data) # if not GET,

Re: Can anyone share code for uploading csv or excel file to sqlite3 database.

; You'll find there all the needed information for reading and interpreting >> CSV files without having to implement the raw parsing, and have there rows >> in a form ready to use for inserting objects in your model. >> >> >> For performance's sake, it is advi

Re: Can anyone share code for uploading csv or excel file to sqlite3 database.

There's blog article on Excel import here: https://www.pythoncircle.com/post/591/how-to-upload-and-process-the-excel-file-in-django/ On Thursday, 27 September 2018 01:35:47 UTC+2, BBG wrote: > > I want to create upload bulk data. Can anyone share code to upload csv or > excel file. > -- You

Re: Can anyone share code for uploading csv or excel file to sqlite3 database.

ormance's sake, it is advised to use bulk inserts or updates > instead on individual saves on the Django side if your CSV files contain a > lot of data. > > > Best > > > Eric > -- > *From:* django...@googlegroups.com < > django...@go

Re: Can anyone share code for uploading csv or excel file to sqlite3 database.

, September 26, 2018 6:04:09 PM To: Django users Subject: Can anyone share code for uploading csv or excel file to sqlite3 database. I want to create upload bulk data. Can anyone share code to upload csv or excel file. -- You received this message because you are subscribed to the Google Groups "D

Can anyone share code for uploading csv or excel file to sqlite3 database.

I want to create upload bulk data. Can anyone share code to upload csv or excel file. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: Beginner problem with sqlite3 db

Cześć! ;) You should first answer a question, why do you even bother using dbshell when there's an other option to deal with data? (docs <https://docs.djangoproject.com/en/2.1/intro/tutorial02/#playing-with-the-api> ) If you know why I'm asking, simply installing sqlite3 is gonna be th

Beginner problem with sqlite3 db

Hi, I'm going through "Writing your first Django app, part 2" link <https://docs.djangoproject.com/en/2.1/intro/tutorial02/#database-setup> and I have problem with sqlite3 db - I have created database tables with migrate command (got db.sqlite3 file in my project folder)

Re: django sqlite3 error

gt; i have used the join to merge this > > db = sqlite3.connect('db.sqlite3') > cursor = db.cursor() > > cursor.execute('\n' > >'INSERT INTO music_result SELECT username, meaning > ,NULL\n' > >'FROM music_na

Re: django sqlite3 error

What C. Kirby said. I don't see any use of django in this question, and if you are interested in using it, I would look at the tutorial in the documentation for an introduction to the ORM. -- You received this message because you are subscribed to the Google Groups "Django users" group. To

Re: django sqlite3 error

t) > > i have used the join to merge this > > db = sqlite3.connect('db.sqlite3') > cursor = db.cursor() > > cursor.execute('\n' > >'INSERT INTO music_result SELECT username, meaning > ,NULL\n' > >'FROM music_na

django sqlite3 error

Hi these are my tables music_name = char(username),userId(int) meaning = char(meaning),userid(int) i have used the join to merge this db = sqlite3.connect('db.sqlite3') cursor = db.cursor() cursor.execute('\n' 'INSERT INTO music_result SELECT username, meaning

Re: Data Retrieval from sqlite3

table > > If i entered "*d*" in the front end (html) > > my expected output must be like > > d four > > what is the django sqlite3 query to make run of it please do help me to > come out from this ? > > Thank you in advance > > > -- &

Re: Data Retrieval from sqlite3

two > c three > d four > e five > > This is my table > > If i entered "d" in the front end (html) > > my expected output must be like > > d four > > what is the django sqlit

Re: Data Retrieval from sqlite3

cursor.execute('SELECT * FROM music_output WHERE username =?', t) name2 = cursor.fetchall() return render(request, "home.html", {'name3': name2}) This one suits me a error for using that *"?" how can i pass parameter to get dynamic input* thats my problem sir On Thursday, August 16, 2018

Re: Data Retrieval from sqlite3

I would suggest you go through the django tutorial at https://docs.djangoproject.com/en/2.1/intro/tutorial01/ Your question suggests that you haven't done so, and it should help you find the answer to your question. -- You received this message because you are subscribed to the Google Groups

Data Retrieval from sqlite3

the django sqlite3 query to make run of it please do help me to come out from this ? Thank you in advance -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to d

Django Admin with SQLite3 :memory:

Hello, I was wondering if it is possible to use SQLite3 with the :memory: option in conjunction with Django Admin. I have gone as far as creating and running migrations on startup, and I can see that the auth_user table gets created, but when I try to log into the admin web interface, I get

help in understanding the sqlite3 backend

Hello, I am trying to understand the sqlite3 backend, especially the register_converter part. I wanted to understand why are those converters put in place? I commented out this registration and even then was able to to query the database in django shell via the ORM.. Even raw query execution

Re: Upgrading from 1.11 to 2.0: "sqlite3.OperationalError: no such table"

Check 1.11 to 2.0 upgrade. You already checked the project configuration and make migrations ?, it could be changed with the upgrade!!! I will hope help you. PD I'm a beginner in Django. El 06/05/18 a las 23:38, Michael Gauland escribió: Just in case anyone else runs into this, I fixed it by

Re: Upgrading from 1.11 to 2.0: "sqlite3.OperationalError: no such table"

Just in case anyone else runs into this, I fixed it by specifying db_contraint=False for foreign keys which cross databases. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send

Upgrading from 1.11 to 2.0: "sqlite3.OperationalError: no such table"

I've got a project that's been developed using django 1.11. I've tried upgrading to 2.0, but now I'm getting an error I haven't been able to track down. My database engine is sqlite3. I have three database files: - db.sqlite3 is the default. This is the only one that django manages

Re: sqlite3.NotSupportedError: URIs not supported

The original email was from 2 years ago, So I'm sure a lot has changed. Dylan On Mon, Feb 26, 2018 at 12:49 PM, Samantha Atkins wrote: > Well this is useless to those of us actually on python3. Exactly what > version of what fixeds this issue *for* python3? > > On

Re: sqlite3.NotSupportedError: URIs not supported

Well this is useless to those of us actually on python3. Exactly what version of what fixeds this issue *for* python3? On Wednesday, August 24, 2016 at 1:16:53 PM UTC-7, Jeff Silverman wrote: > > Can anyone point me in the right direction to solve this? I am running > DJANGO with python3.4 in

Re: django migrating from sqlite3 to oracle gives error ORA-02000

Hi. Could you give full traceback and preferably migration code that fails. Just Oracle error code isn't enough to help you. 9.2.2018 23.12 "Mohamed Saleh" <mohamedsalehaf...@gmail.com> kirjoitti: > I hava a Django app on a windows server 2012 which was set up with

django migrating from sqlite3 to oracle gives error ORA-02000

I hava a Django app on a windows server 2012 which was set up with sqlite3 as the db, but it's going to production so I'm migrating the tables to oracle 12c on the server, i don't care about the data just the tables so when I run python manage.py migrate I get ORA-2000 Error: missing

Re: how to create path for sqlite3 in django? I'm unable to access my database.

Hi, you may need to install sqlite3 for windows and set your PATH to the directory where sqlite3 executable is found. Etienne Le 2017-10-30 à 03:52, bonagiri abhishek a écrit : C:\Users\admin\cricwebsite>python manage.py dbshell CommandError: You appear not to have the 'sqlite3' prog

how to create path for sqlite3 in django? I'm unable to access my database.

C:\Users\admin\cricwebsite>python manage.py dbshell CommandError: You appear not to have the 'sqlite3' program installed or on your path. Can anyone please explain me the problem? I'm unable to access the database as it is showing the above CommandError. -- You received this message because

Re: sqlite3 table not found

URL to visit one of my views, I get an > error, an excerpt of which is shown below: > > File > "/home/jja/testenv3.5/lib/python3.5/site-packages/django/db/backends/sqlite3/base.py", > > line 337, in execute > return Database.Cursor.execute(self, query, par

Re: sqlite3 table not found

error, an excerpt of which is shown below: File "/home/jja/testenv3.5/lib/python3.5/site-packages/ django/db/backends/sqlite3/base.py", line 337, in execute return Database.Cursor.execute(self, query, params) sqlite3.OperationalError: no such table: siggy_siggytemplate I would like to

sqlite3 table not found

e/jja/testenv3.5/lib/python3.5/site-packages/django/db/backends/sqlite3/base.py", line 337, in execute return Database.Cursor.execute(self, query, params) sqlite3.OperationalError: no such table: siggy_siggytemplate I would like to look at the SQL tables and it looks like 'python mana

Re: sqlite3 database encrytion for Django.

On Tuesday 09 May 2017 09:24:08 Antonis Christofides wrote: > > and root seems (unsurprisingly) able to do anything desired with the > > database. > > He meant that root wouldn't be able to read the database if the > database was encrypted. But, again, the question is whether root > would have

Re: sqlite3 database encrytion for Django.

he > least of my worries. ;-) > >> 2) root can't do anything with it nor can daemons that are >> compromised before switching to unprivileged user. > You sure about this? I just tested the scenario: > > $ su - > Password: > root@laptop:~# sqlite3 test.db >

Re: sqlite3 database encrytion for Django.

su - Password: root@laptop:~# sqlite3 test.db SQLite version 3.8.7.1 2014-10-29 13:59:56 Enter ".help" for usage hints. sqlite> create table example (id int); sqlite> insert into example values (42); sqlite> select * from example; 42 sqlite> root@laptop:~

Re: sqlite3 database encrytion for Django.

On Monday 08 May 2017 18:29:35 Antonis Christofides wrote: > Assume Django is running as user 'django' and the db is "db.sqlite3". > > If you "chown django db.sqlite3" and "chmod 600 db.sqlite3", only user > django can access it. > > What would you gain by encrypting it? Three things: 1) If the

Re: sqlite3 database encrytion for Django.

Assume Django is running as user 'django' and the db is "db.sqlite3". If you "chown django db.sqlite3" and "chmod 600 db.sqlite3", only user django can access it. What would you gain by encrypting it? Antonis Christofides http://djangodeployment.com On 2017-05-08 18:06, Melvyn Sopacua wrote: >

Re: sqlite3 database encrytion for Django.

On Monday 08 May 2017 17:35:59 Antonis Christofides wrote: > > Unfortunately, that doesn't prevent theft at runtime, which is the > > primary case for encrypting "documents". I used to do something > > like this with svn passwords, using a file-backed mdconfig store > > and geli. > > But during

Re: sqlite3 database encrytion for Django.

17-05-08 17:19, Melvyn Sopacua wrote: > > On Saturday 06 May 2017 11:56:28 Tim Chase wrote: > > > On 2017-05-05 11:51, agajesh...@atompower.com wrote: > > > > I want to encrypt my sqlite3 database such that it cannot be > > > > accessed without a key. I c

Re: sqlite3 database encrytion for Django.

On Saturday 06 May 2017 11:56:28 Tim Chase wrote: > On 2017-05-05 11:51, agajesh...@atompower.com wrote: > > I want to encrypt my sqlite3 database such that it cannot be > > accessed without a key. I came across "sqlcipher" tool which > > provides encryption for s

Re: sqlite3 database encrytion for Django.

On 2017-05-05 11:51, agajesh...@atompower.com wrote: > I want to encrypt my sqlite3 database such that it cannot be > accessed without a key. I came across "sqlcipher" tool which > provides encryption for sqlite3 database, but I couldn't find > enough support to ma

Re: sqlite3 database encrytion for Django.

Hi, That's interesting. May I ask why you want to do this? Regards, A. Antonis Christofides http://djangodeployment.com On 2017-05-05 21:51, agajesh...@atompower.com wrote: > Hello everyone, > > I want to encrypt my sqlite3 database such that it cannot be accessed without > a

Re: sqlite3 database encrytion for Django.

I suggest you consider using keyzar and django-encrypted-fields. Here's the code: https://github.com/defrex/django-encrypted-fields/ On Fri, May 5, 2017 at 11:51 AM, <agajesh...@atompower.com> wrote: > Hello everyone, > > I want to encrypt my sqlite3 database such that it can

sqlite3 database encrytion for Django.

Hello everyone, I want to encrypt my sqlite3 database such that it cannot be accessed without a key. I came across "sqlcipher" tool which provides encryption for sqlite3 database, but I couldn't find enough support to make it work from django. It would be very helpful if someone

Anyone know howto solve this: Error loading either pysqlite2 or sqlite3 module

Hello, everybody: I am a newbie in Django and I recently installed Python 3.6 and Django 1.110.5, but when try execute the server show me: {code} Traceback (most recent call last): File "/root/myDjangoProject/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py",

Re: Django migrate generates SQLite3 file filled with junk

tps://groups.google.com/d/msgid/django-users/2980ce12-c366-454b-844a-c625e7520977%40googlegroups.com <https://groups.google.com/d/msgid/django-users/2980ce12-c366-454b-844a-c625e7520977%40googlegroups.com?utm_medium=email_source=footer> . > For more options, visit https://groups.google.com/d/opto

Re: Django migrate generates SQLite3 file filled with junk

That file is an SQLite database, which is a binary format. It should look like this. I know it is confusing, because of that bunch of SMS statements, but it's OK that way. If you want to interact with it, use the sqlite3 command, or an SQLite GUI. On Sun, Sep 25, 2016, 14:17 kbman99 <kylebo

Django migrate generates SQLite3 file filled with junk

Just getting started with django and having an issue with the migrate.py script. It generates a db.SQLite3 file which is filled with a lot of garbage characters. It's in UTF-8 encoding, but looks like this. I've deleted the file and

Re: sqlite3.NotSupportedError: URIs not supported

Well I may have answered my own question. Seems it may be a version incompatibility. I built another virtual environment at Python 2.7 and the error is gone. Also I am using the pycontrol module which is also not work g with Python 3.4. On Wednesday, August 24, 2016, Jeff Silverman

sqlite3.NotSupportedError: URIs not supported

Can anyone point me in the right direction to solve this? I am running DJANGO with python3.4 in virtualenv. I get this error running manage.py. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving

sqlite3 “OperationalError: no such table” on threaded operation

By everything I read in the docs, both Django and py-sqlite3 should be fine with threaded access. (Right?) But the attached code snippet fails for me. The operations in the main thread work, but not in the thread(s) I create. There I get: File "C:\Python27\lib\site-packages\django-1.9-

Re: Can you remove a model's last field of SQLite3 in Django 1.8?

: https://www.sqlite.org/lang_createtable.html /Markus On Sun, Nov 29, 2015 at 09:17:53AM -0800, KwangYoun Jung wrote: Can you remove a model's last field of SQLite3 in Django 1.8? I have a model that has only one column in SQLite3. When I remove a last field of the model, I get an error like

Re: Can you remove a model's last field of SQLite3 in Django 1.8?

On Sunday, 29 November 2015 17:17:54 UTC, KwangYoun Jung wrote: > > Can you remove a model's last field of SQLite3 in Django 1.8? > > I have a model that has only one column in SQLite3. > When I remove a last field of the model, I get an error like below > > > > *djang

Can you remove a model's last field of SQLite3 in Django 1.8?

Can you remove a model's last field of SQLite3 in Django 1.8? I have a model that has only one column in SQLite3. When I remove a last field of the model, I get an error like below *django.db.utils.OperationalError: near ")": syntax error*Anyone knows about this issue ? -- Yo

Re: Foreign key in sqlite3

any other > database: > > fieldname = models.ForeignKey(AnotherModel) > On 30 Sep 2015 15:18, "Bhanu Kathuria" <001kathuriabh...@gmail.com> wrote: > >> I am using sqlite3 database. >> How can I add foreign key between two tables. >> >> -- >&

Re: Foreign key in sqlite3

Assuming you are using Django and it's ORM, the same way as in any other database: fieldname = models.ForeignKey(AnotherModel) On 30 Sep 2015 15:18, "Bhanu Kathuria" <001kathuriabh...@gmail.com> wrote: > I am using sqlite3 database. > How can I add foreign

Foreign key in sqlite3

I am using sqlite3 database. How can I add foreign key between two tables. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-user

Re: Sqlite3 to Postgres Migration?

. No one in the group has experience with web development. We decided on Django, and I wrote a prototype using sqlite3. Sqlite3 will not be used going forward. Instead either Postgres or MySql will be used. Personally I am in favor of Postgres, Good call. IMO. but I have been telling

Re: Sqlite3 to Postgres Migration?

> > I am leading a project to create a web application for uploading certain > scientific data into a database. No one in the group has experience with > web development. We decided on Django, and I wrote a prototype using > sqlite3. Sqlite3 will not be used going forward. Instead either P

Re: Sqlite3 to Postgres Migration?

experience with web development. We decided on Django, and I wrote a prototype using sqlite3. Sqlite3 will not be used going forward. Instead either Postgres or MySql will be used. Personally I am in favor of Postgres, but I have been telling the group, perhaps incorrectly, that Django is "dat

Re: Sqlite3 to Postgres Migration?

On 20/02/2015 3:07 AM, Tom Lockhart wrote: On Feb 18, 2015, at 11:04 PM, talex <bkielhor...@gmail.com> wrote: I have a functioning Django application that is based on sqlite3, but I want to change to using Postgres. I’ll point out for the benefit of others who might be getting s

Re: Trouble changing from sqlite3 to postgres

self.cursor.execute(sql, params) > django.db.utils.ProgrammingError: column "date" cannot be cast > automatically to type integer > HINT: Specify a USING expression to perform the conversion. > > > On Tuesday, February 17, 2015 at 4:39:27 PM UTC-8, Joel Burton wrote: >>

Re: Sqlite3 to Postgres Migration?

On Feb 18, 2015, at 11:04 PM, talex <bkielhor...@gmail.com> wrote: > I have a functioning Django application that is based on sqlite3, > but I want to change to using Postgres. I’ll point out for the benefit of others who might be getting started: Postgres is a full featu

Re: Sqlite3 to Postgres Migration?

On Feb 19, 2015, at 1:04 AM, talex wrote: > Am I correct that use of "python makemigrations" followed by > "python migrate", should copy the existing data into Postgres > and leave me with a working application? I'm afraid not. Migration allows for predictable and

Sqlite3 to Postgres Migration?

I have a functioning Django application that is based on sqlite3, but I want to change to using Postgres. I have altered the DATABASES clause in settings.py to use Postgres. and I am using Django version 1.7. Am I correct that use of "python makemigrations" followed by "python m

Re: Trouble changing from sqlite3 to postgres

t uses the date field. Can you > post the full traceback? That will let us see where the caller was that > created the problem. > > On Tuesday, February 17, 2015 at 3:13:30 PM UTC-5, tony@gmail.com > wrote: >> >> I have written a simple Django app (my first) tha

Re: Trouble changing from sqlite3 to postgres

first) that works with sqlite3 > database. > I want to change to postgres, but when I run the Django 1.7 migration > utility with the command > "python manage.py migrate" > > I get the error: > psycopg2.ProgrammingError: column "date" cannot be

Trouble changing from sqlite3 to postgres

I have written a simple Django app (my first) that works with sqlite3 database. I want to change to postgres, but when I run the Django 1.7 migration utility with the command "python manage.py migrate" I get the error: psycopg2.ProgrammingError: column "date" cannot b

Re: Installing south and using sqlite3's :memory: ruins total test suite time

It seems, for some reason settings.COMPRESS_ENABLED gets set to False when south is installed. On Tuesday, January 20, 2015 at 12:37:44 PM UTC-8, Peter Bengtsson wrote: > > I have a django project on django 1.6. It's using django-nose and it's > using sqlite3's :memory: trick: >

Re: Installing south and using sqlite3's :memory: ruins total test suite time

in runtime because I have `COMPRESS_OFFLINE = True` on and I run compress before running tests. On Tuesday, January 20, 2015 at 12:37:44 PM UTC-8, Peter Bengtsson wrote: > > I have a django project on django 1.6. It's using django-nose and it's > using sqlite3's :memory: trick: >

Installing south and using sqlite3's :memory: ruins total test suite time

I have a django project on django 1.6. It's using django-nose and it's using sqlite3's :memory: trick: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': ':memory:', } } Before I added `south` to INSTALLED_APPS it would take about ~5 seconds

Re: django - How to fix “the procedure entry point sqlite3_rtree_geometry_callback could not be located in the dynamic link library sqlite3.dll”

I got the same error message when I used django.contrib.gis on Windows (OSGeo4W). A python ctypes function tried to open wrong sqlite3.dll (wrong directory). That was the origin of issue. I reordered list of pathes in system environment variable "path" (replaced path to O

django - How to fix “the procedure entry point sqlite3_rtree_geometry_callback could not be located in the dynamic link library sqlite3.dll”

I have problem with django project. I am facing error when i am trying to execute project in browser. "the procedure entry point sqlite3_rtree_geometry_callback could not be located in the dynamic link library sqlite3.dll" I have no idea where is the issue. -- You received th

Re: moving from sqlite3 to mysql

erguson <d...@afccommercial.co.uk>wrote: > >> Hi >> >> Just like SQLlite, you tell Django where the MySQL database is in >> settings.py >> >> At the top you should have something like >> >> DATABASES = { >> 'default': { >>

Re: moving from sqlite3 to mysql

> DATABASES = { > 'default': { > 'ENGINE': 'django.db.backends.mysql', > 'NAME': 'django_1', # Or path to database file if using sqlite3. > # 'USER': '', > # 'PASSWORD': '', > # 'HOST': '', # Empty for localhost > # 'PORT': '', # Set to empty string for default. > } &g

Re: moving from sqlite3 to mysql

Hi Just like SQLlite, you tell Django where the MySQL database is in settings.py At the top you should have something like DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'django_1', # Or path to database file if using sqlite3. # 'USER': '', # 'PASSWORD

Re: moving from sqlite3 to mysql

. manage.py: error: no such option: --django_1 <> Ok, so MySQL wanted a db name, even though there was no db name (at least not one I gave it) on sqlite3 when I ran syncdb without a name, it said no db selected When I tried pointing it to a name, I got 'doesn't accept arguments' and then 'no suc

  1   2   3   4   >