Popular recipes tagged "database" but not "python"

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

Printing list of ODBC data sources with pyodbc module (Python)

2014-01-28T10:40:56-08:00

Python recipe 578815 by Michal Niklas (database, odbc, sql).

I have similar recipe but with odbc module: http://code.activestate.com/recipes/578782-printing-list-of-odbc-data-sources/

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.

Printing list of ODBC data sources (Python)

2013-12-10T11:07:37-08:00

Python recipe 578782 by Michal Niklas (database, odbc, sql).

This simple code shows ODBC data sources. It uses odbc module.

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

sql+ the SQL*Plus killer (Python)

2013-03-14T09:13:01-07:00

Python recipe 578490 by jo (database, db, db_client, sql, sql_client). Revision 3.

This recipe is an emulator of the Oracle SQL*Plus, but it does things in a more friendly way ;).

If you need a client to access your Oracle but you don't like SQL*Plus, try this one.

This recipe was inspired by James Thiele's Console built with Cmd object recipe.

It provides a 'help' facility and supplies command completion when you hit the 'tab' key.

In addition you can use command line editing and history keys.

Here are the commands that you can use:

========================================
Documented commands (type help <topic>):
========================================
constraints  edit      help     input   sequences  shell
db           exit      history  output  set        tables
desc         foreigns  index    quit    settings   triggers

You can edit the queries using 'vim' or any other editor.

The command 'output' can redirect output to a file and command 'input' can input commands from a file.

There's paginated output.

The command 'shell' or '!' allow you to perform operating system commands.

You can add commands by defining methods with names of the form 'do_xxx()' where 'xxx' is the name of the command you wish to add.

There is a configuration file (.sql+) where you need to enter the dburi, editor name and other settings.

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 !

Inner Join (Python)

2011-11-01T20:10:34-07:00

Python recipe 577937 by Raymond Hettinger (database, join, sql). Revision 2.

Implemented an SQL style INNER JOIN for two lists of tuples to be joined on a common field.

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.