![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How we can store Python functions in a Sqlite table?
In the following code, we import sqlite3 module and establish a database connection. We create a table and then insert data and retrieve information from the sqlite3 database and close the connection finally.
Example
#sqlitedemo.py import sqlite3 from employee import employee conn = sqlite3.connect('employee.db') c=conn.cursor() c.execute(‘’’CREATE TABLE employee(first text, last text, pay integer)’’’) emp_1 = employee('John', 'Doe', 50000 ) emp_2 = employee('Jane', 'Doe', 60000) emp_3 = employee('James', 'Dell', 80000) c.execute(‘’’INSERT INTO employee VALUES(:first, :last, :pay)’’’,{'first':emp_1.first, 'last':emp_1.last, 'pay':emp_1.pay}) c.execute(‘’’INSERT INTO employee VALUES(:first, :last, :pay)’’’,{'first':emp_2.first, 'last':emp_2.last, 'pay':emp_2.pay}) c.execute(‘’’INSERT INTO employee VALUES(:first, :last, :pay)’’’,{'first':emp_3.first, 'last':emp_3.last, 'pay':emp_3.pay}) c.execute("SELECT * FROM employee WHERE last ='Doe'") print(c.fetchone()) print(c.fetchmany(2)) conn.commit() conn.close()
Output
(u'James', u'Dell', 80000) [(u'James', u'Dell', 80000), (u'James', u'Dell', 80000)]
Advertisements