Все вопросы: [pysqlite]
15 вопросов
What is a difference between "sqlite" and "pysqlite2/sqlite3" modules?
I gave up to make "sqlite3" working but I just found out (with help("modules")) that I have "sqlite" module. I tested it (create table, insert some values and so on) and it works fine. But before I start to use this module I would like to know if it has some significant limitations in comparison ...
How can I make Python see sqlite?
I cannot use sqlite3 (build python package), for the reason that _sqlite3.so file is missing. I found that people had the same problem and they resolved it here. To solve my problem I have to "install sqlite3 and recompile Python". I also found out that the problem can be solved by "building from...
How to get _sqlite3.so file?
I have installed Python 2.6.2.. I did it "locally" since I do not have root permissions. With this version of Python I wanted to use module called "sqlite3" (it is called "pysqlite" in earlier versions). In theory I had to be able to use this module without any problems since it is supposed to b...
Why my python does not see pysqlite?
I would like to have an interface between Python and sqlite. Both are installed on the machine. I had an old version of Python (2.4.3). So, pysqlite was not included by default. First, I tried to solve this problem by installing pysqlite but I did not succeed in this direction. My second attempt ...
How should I handle software packages?
I am trying to install pysqlite and have troubles with that. I found out that the most probable reason of that is missing sqlite headers and I have to install them. My platform: CentOS release 5.3 (Final). I have Python-2.6.2. I also found out that I need .rpm files. As far as I have them I exec...
What are sqlite development headers and how to install them?
I am trying to install pysqlite and have troubles with that. I found out that the most probable reason of that is missing sqlite headers and I have to install them. However, I have no ideas what these headers are (where I can find them, what they are doing and how to install them). Can anybody,...
Why pysqlite does not work properly?
I tried to install pysqlite. Some suspicious things start to appear during the installation. Why I typed: python setup.py build I got the following message in the end: src/module.c:286: error: ‘SQLITE_PRAGMA’ undeclared here (not in a function) src/module.c:287: error: ‘SQLITE_READ’ undeclare...
How to build sqlite for Python 2.4?
I would like to use pysqlite interface between Python and sdlite database. I have already Python and SQLite on my computer. But I have troubles with installation of pysqlite. During the installation I get the following error message: error: command 'gcc' failed with exit status 1 As far as ...
How to install pysqlite?
I am trying to install pysqlite (Python interface to the SQLite). I downloaded the file with the package (pysqlite-2.5.5.tar.gz). And I did the following: gunzip pysqlite-2.5.5.tar.gz tar xvf pysqlite-2.5.5.tar \cd pysqlite-2.5.5 python setup.py install At the last step I have a problem. I get...
Shall I bother with storing DateTime data as julianday in SQLite?
SQLite docs specifies that the preferred format for storing datetime values in the DB is to use Julian Day (using built-in functions). However, all frameworks I saw in python (pysqlite, SQLAlchemy) store the datetime.datetime values as ISO formatted strings. Why are they doing so? I'm usually t...
Проблема с исполнением SQLite
Я не могу найти свою ошибку в следующем коде. При запуске выдается ошибка типа для строки: cur.executemany (sql% itr.next ()) => ' функция принимает ровно 2 аргумента (1 задан) , import sqlite3 con = sqlite3.connect('test.sqlite') cur = con.cursor() cur.execute("create table IF NOT EXIS...
Очистка внутреннего соединения pysqlite при уничтожении объекта
У меня есть объект с подключением к внутренней базе данных, который активен на протяжении всего срока службы. В конце выполнения программы соединение должно быть зафиксировано и закрыто. До сих пор я использовал явный метод close, но это несколько громоздко, особенно когда в вызывающем коде могу...
Django на CentOS
Я хочу использовать Django на общем хосте, на котором запущена неизвестная версия CentOS. Моя основная проблема - это попытка взаимодействия с базой данных. На сервере установлен MySQL, но нет MySQL-python. Сначала я подумал о том, чтобы предложить запустить «yum install MySQL-python», но, очеви...
Типы пользователей pysqlite в операторе выбора
Использование pysqlite, как можно использовать определяемый пользователем тип в качестве значения при сравнении, например. g: «... ГДЕ columnName> userType»? Например, я определил тип bool с необходимой регистрацией, преобразователем и т. д. Pysqlite / Sqlite отвечает ожидаемым образом на ...
Python pysqlite не принимает мою параметризацию qmark
Мне кажется, что я тупица, возможно, не импортирую нужный пакет, но когда я это сделаю ... from pysqlite2 import dbapi2 as sqlite import types import re import sys ... def create_asgn(self): stmt = "CREATE TABLE ? (login CHAR(8) PRIMARY KEY NOT NULL, grade INTEGER NOT NULL)" ...