Popular recipes tagged "database" but not "sql"

Put Peewee ORM data to PDF with xtopdf (Python)

2016-09-29T18:04:57-07:00

Python recipe 580704 by Vasudev Ram (conversion, converter, database, formats, orm, pdf, pdf_generation, peewee, python, python2, sqlite, xtopdf).

This recipe shows how some basics of how to fetch data from database tables managed by the Peewee ORM (a lightweight expressive ORM for Python) and write that data, formatted, to a PDF file. The recipe uses Python, the Peewee ORM and the xtopdf toolkit for PDF creation.

DBF reader and writer -- selective fields and nullreplace (Python)

2016-09-18T20:39:20-07:00

Python recipe 580696 by Tomas Nordin (database).

This fork assumes a desire for limited selection of field names. With huge files this might be necessary on some machines.

Also, assuming that the meaning of null in a dbf file means zero might be a mistake, so the fork adds an argument nullreplace as way to choose what to replace null with. Null is sometimes used to mean missing value. This change is decoupled from the selective names feature.

Python ADO Database Interface for MS SQL Server - Python 3 version 1.0 (Python)

2014-08-27T16:04:04-07:00

Python recipe 578913 by Jorge Besada (ado, database). Revision 3.

This DBI implements the Cursor and Connection objects. You can create connections, cursors, do fetchone, fetchall. It uses ADO. Will add more features later

Python Database Interface for MS SQL Server - Python 3 version (Python)

2014-07-11T19:25:48-07:00

Python recipe 578906 by Jorge Besada (database).

This DBI implements the Cursor and Connection objects. It is functional: you can create connections, cursors, do fetchone, fetchall, get rowcount, etc. It uses osql or sqlcmd instead of ODBC or ADO. There is a good sized section with examples to get you started.

Publish Berkeley DB data to PDF with xtopdf (Python)

2014-01-24T17:57:21-08:00

Python recipe 578814 by Vasudev Ram (bsddb, database, pdf, python, xtopdf).

This recipe shows how to convert the data stored in a Berkeley DB database to PDF, using the xtopdf toolkit for PDF creation. It should work on either Linux/Unix or Windows.

A Phone Book GUI Built in wxPython Connected To Database Using Data Grid View (Python)

2013-09-29T19:25:23-07:00

Python recipe 578676 by toufic zaarour (database, datagridview, graphical, gui, interface).

this GUI as simple as it is explains some basic but important graphical database interfacing; "Add", "Edit","Delete","Search" and few others along with a data grid view. in order to work create an sqlite3 database as follows:

data table : Phone, column 1 : ID, column 2 : name, column 3 : surname, column 4 : telephone.

save the sqlite3 file as file.db in a folder called Data and place it in the same directory as your python script.

if you want to create the sqlite3 database graphically use my previous post : http://code.activestate.com/recipes/578665-a-wxpython-gui-to-create-sqlite3-databases/

Also there is more: I did not use auto-number for 'id' because I also wanted to include in the code a renumbering script.

I am pleased to receive all the suggestions and improvements on this site or to my e-mail directly if this is convenient to you.

note: if you don't like the database table name, and columns name create your own but make sure to change them in the code as well! in the end life is great! remember that!

List MySql databases in a Gtk.TreeView (Python)

2013-11-27T14:03:21-08:00

Python recipe 578774 by Anonimista (database, gtk, gui, mysqldb, user_interface).

List MySql databases in a Gtk.TreeView

Save and restore SHA-512 internal state (Python)

2013-03-03T18:05:42-08:00

Python recipe 578479 by Dima Tisnek (database, inner, pickle, restore, sha512, state).

If you have a very long input to hash, you may want to save your progress.

CPython doesn't normally let you, but it's easy to hack around via ctypes

Profile Manager (Cave Story) (Python)

2012-12-07T01:21:04-08:00

Python recipe 578368 by Stephen Chappell (database, manager, profile).

If you have ever played a game that only had one save slot and wanted to be able to manage profiles, the following code written for Cave Story may be of use to you. The recipe provides a starting point for how one might go about writing a profile manager for such a program that runs through a command interface.

Saving snippets to SQLite3 database (Python)

2014-07-30T07:23:36-07:00

Python recipe 578285 by p@ntut$ (database). Revision 5.

Save your snippets/codes to sqlite3 database, search, edit, and delete.

Read tabular data from Excel spreadsheets the fast and easy way (Python)

2012-10-09T07:00:55-07:00

Python recipe 578283 by wei.Liu (database).

Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC + mxODBC), but the easiest way I've found is this one : provide a file name and a sheet name, and read the data !

Simple Knowlegde Database (Python)

2012-01-05T08:58:40-08:00

Python recipe 577975 by Thomas Lehmann (antagonisms, database, knowledge, opposites, relationships). Revision 2.

What's the idea?

The idea is to be able to ask more successful questions than data provided.
To have a kind of simple database

How is this done?

A releationship is always though as a from of older/younger or bigger/smaller. You have to define those opposite meanings by calling 'defineAntagonism'
After this you can define a relationship by calling 'defineRelationship' using one of the opposite meanings and two ... I say names (can be persons or objects)
When you define that somebody/someting is bigger than somebody/something else then you implicitly provide two information (bigger <-> smaller)
Also when defining - more commonly explained - that A > B and B > C then also A > C and C < A.
That's the main logic implemented by this python code.

Special notes

We have to avoid inconsistent data; when it is defined that A > B then you are not allowed to say that B > A.
We have to sort relations because they build up - I name it like this - a dependency chain. When a query checks for A > C but A > B and B > C is defined only we need an order for searching.

Simple curses based MySQL 'top' (Python)

2011-11-02T20:28:48-07:00

Python recipe 577936 by Mike 'Fuzzy' Partin (curses, database, mysql, time). Revision 3.

This is little more than a modification of my previous recipe, however, I found it useful so I thought I would post it in the hopes that someone else would as well. There is color (BOLD white really) designation for 'Query' states vs others like 'Sleep'.

Rudimentary Database Engine (Python)

2013-09-02T01:51:53-07:00

Python recipe 577825 by Stephen Chappell (database, engine, example, experiment). Revision 2.

This module was written for self-academic purposes in an attempt to understand databases better. Just as in college where students are required to reinvent "wheels" like linked lists, trees, binary searches, et cetera, developing this program helped me understand some of the things that goes on behind the scenes in a database while also helping to learn what the desired output of each operation should be. The code in this module provides support for running a simple database engine that runs completely in memory and allows usage of various concepts available in a structured query language to get and set data that may be saved to file.

Multiprocessing import wrapper (Python)

2011-08-23T22:11:42-07:00

Python recipe 577856 by Matt Keranen (database, etl, import, multiprocessing). Revision 2.

A script used to launch multiple import scripts using the multiprocessing module. Developed to parallelize loading of multiple log files into a database for aggregate analysis

Export Oracle Database to CSV using cx_Oracle (Python)

2010-07-11T19:49:42-07:00

Python recipe 577304 by FB36 (csv, database).

Creates a CSV file for each table in the target Oracle database.

Simple numeric database (Python)

2011-05-16T08:41:46-07:00

Python recipe 577697 by Mike Sweeney (array, database, numeric). Revision 2.

A simple in-memory numeric database for Python. Arrays are used to minimise memory consumption.

Simple numeric database (Python)

2011-05-16T12:11:24-07:00

Python recipe 577698 by Hamidreza Joshaghani (array, database, numeric).

A simple in-memory numeric database for Python. Arrays are used to minimise memory consumption.

Nagios plugin for monitoring database servers (Python)

2011-08-23T22:12:20-07:00

Python recipe 577599 by Matt Keranen (database, monitor, nagios). Revision 4.

An example implementation of a Nagios script in Python for monitoring database servers via ODBC queries. The example tests contained are for checking the status of MS SQL Server replication and log shipping, but any status check that can be performed by a query can be implemented. This method is not considered a replacement for SNMP monitoring, but to implement custom logic checks.

New tests are implemented by adding an @nagios_test decorator, and called by the -t parameter with the function name. Usage text list available tests.

url_spider (Python)

2011-03-14T09:08:28-07:00

Python recipe 577608 by amir naghavi (database, regex, web). Revision 3.

a simple url spider that goes through web pages and collects urls.