23 Topics

Member Avatar for
Member Avatar for misstj555

Hello. I am making a database using SQLite. Then I need to make an API with functions that returns information about that database. Then I need to print out a report. However, when I try to return an answer to a query using inputs, nothing is returned. I either get …

Member Avatar for John_165
0
414
Member Avatar for Jiby_1

Deleting a table data from adminer,It is showing error unable to "unable to open database file"..But command line sqlite3 delete query is working in ubuntu.

0
159
Member Avatar for Pyler
Member Avatar for Pyler

I can serialize an object if it's class definition has attributes. So if I have an object whose class does not have attributes, do I serialize the attributes importedi in it's class definition? For example; suppose I have the following class, #ifndef BREAD_H #define BREAD_H #include "EGGS.h"; #include "FLOUR.h"; class …

Member Avatar for mike_2000_17
0
272
Member Avatar for Jeroen Mathon

Hello, The reason why im asking for this is becouse im currently making a project that needs data storage. And sqlite seems to be perfect for that matter. I've already read the documentation of Sqlite3 but i found that insufficient. It didn't really explain much besides the obvious. I can …

Member Avatar for JasonHippy
0
555
Member Avatar for crebz

Hi am kinda new in python programing. I have this game that involves a user inputs a value , say color it iterates over imported modules( in this case color) and prints data about it. The problem is that i cant get to code the best way to iterate over …

Member Avatar for crebz
0
229
Member Avatar for Gribouillis

This python script prints all the columns of an sqlite database which path is given as argument.

4
865
Member Avatar for maurice.waka

Is there a pythonistic way available to search all the tables and columns of an Sqlite3 database? The only inputs would be the name of the sqlite DB file or a raw input. I am trying to write a forensics tool and want to search sqlite files for a specific …

Member Avatar for Gribouillis
0
342
Member Avatar for CodingCabbage

I'm trying to represent my data using a bar graph, the data being displayed is goodVotes, neutralVotes and badVotes on the x-axis for each of my pieces of data (records in an sqlite3 database). I wish the "bookName" of each record to be displayed on the x axis of the …

Member Avatar for vegaseat
0
279
Member Avatar for anisha.silva

HI, I created an app to add a clinc details to the sqlite3 db from xcode. the code is below. The (sqlite3_step(statement1) == SQLITE_DONE) does not execute it. I dont get an error or anything. I can't figure out what exactly is wrong.Apprecite if someone can tell me what i …

Member Avatar for hericles
0
280
Member Avatar for CodingCabbage

Sorry, I posted this in software development not python. How do i make an auto-incrementing column? Heres my pseudocode/sql attempt c.execute('''CREATE TABLE <tableName> ( <columnName> <auto incrementing??!!>, <columnName2> text, <columnName3> text, <columnName4> text ) ''')

Member Avatar for vegaseat
0
501
Member Avatar for CodingCabbage

How do i make an auto-incrementing column? Heres my pseudocode/sql attempt How do you make an auto-incrementing ID for a record c.execute('''CREATE TABLE <tableName> ( <columnName> <aut incrementing??!!>, <columnName2> text, <columnName3> text, <columnName4> text ) ''')

Member Avatar for pritaeas
0
144
Member Avatar for CodingCabbage

I'm starting my Computing project and am using Python linked via sqlite3 to a database. As part of my project I shall be searching for maths books in the database via name or module etc. I wish to display the results on a GUI in python so need to set …

Member Avatar for Gribouillis
0
352
Member Avatar for lewashby

I have a very small sqlite3 database with one row consisting of three columns but I can get the page to display the row to save my life. So far all I've been able to get the page to display is the first column of the one row that's in …

Member Avatar for lewashby
-1
1K
Member Avatar for wolf29

I have a program that takes csv values, parses the content and inserts it in an sqlite3 database. I am using sqlite3 to save on space and to make the py scripts a little more portable. The next refactoring may well need to have postgresql or mysql to deal with …

0
161
Member Avatar for wolf29

I want to create sqlite3 databases from within a python script. I am currently running this code which does not pass the right variable content to the sqlite3 command prompt, so I have one issue there. I also do not want to have the user have an sqlite3 command shell …

Member Avatar for james.lu.75491856
0
355
Member Avatar for wolf29

I have 2 functions, one of which works and one of which doesn't. I do not understand this, because the only difference is that the second function puts in just the name of the variable, where the 1st function puts in the value. There is only one line to build …

Member Avatar for wolf29
0
301
Member Avatar for vegaseat
3
341
Member Avatar for pritaeas

Below is a documented code example showing how to use the SQLite3 class to connect and query your database (and check for errors). IMHO using PDO is a better alternative, as this extension uses mixed technology in a non-standard way (objects, arrays and exceptions). If there are any questions let …

2
4K
Member Avatar for andrewtrench

Hi. I have a problem that I am tearing my hair out to solve. I am trying to transfer tens of thousands of records into a sqlite db using the script below. The script seems to run okay and I can see the db growing as it runs to some …

Member Avatar for andrewtrench
0
2K
Member Avatar for neroth

A bit of background: I've been working on a python script to do some calculations on a land use model. Basically, I take amount of space developed in the future and pull out a table that has the amount of space by geographic area within the larger area. I load …

Member Avatar for neroth
0
293
Member Avatar for killerpopiller

Hi, I can connect to an energy-meter (Baudrate 300!) and the logfile with 228 lines comes slowly in.[code=Python]line = ser.readline(eol='!') print line [/code] If I use the above code, the complete logfiles is shown. And if I parse separatly saved logfiles with match, it sorts out the right values into …

0
114
Member Avatar for shinsengumi

Hi everyone. I'm using sqlite3 in Linux and I currently have a problem. I have a database and 2 tables in it: db1 and db2. db1 has 3 columns: empID, empName, empAddr. db2 has just 1 column: empID and its value is set to 0 by default. I created a …

Member Avatar for shinsengumi
0
544

The End.