Popular recipes tagged "sql" but not "python"

Publish SQLite data to PDF using named tuples (Python)

2015-02-24T22:08:11-08:00

Python recipe 579027 by Vasudev Ram (conversion, pdf, pdfwriter, sql, sqlite, sqlite3, xtopdf).

This recipe shows how to publish SQLite data to PDF, using named tuples from the collections module of Python, the sqlite3 library, and the xtopdf library for PDF generation.

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/

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.

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.

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.

Conjunction select using foreign keys (Text)

2011-06-11T02:43:22-07:00

Text recipe 577747 by Kaushik Ghose (conjunction, foreign, key, select, sql).

Say we have a table (notes) containing rows we want to select. Each note has one or more keywords (stored in a table of the same name). We want to select notes that have a conjunction of keywords (AND). notes and keywords are linked through a foreign key table notes_keywords. The following SQL statement allows us to do this

A MSSQL XML importer for MySQL (Python)

2011-03-09T03:46:49-08:00

Python recipe 577601 by Albert Perrien II (mysql, server, sql, xml).

This is a simple function that takes records exported to XML from SQL Server or Access and imports them into MySQL.

Minimalistic PostgreSQL console shell (Python)

2011-11-30T13:43:28-08:00

Python recipe 577468 by ccpizza (postgres, postgresql, sql). Revision 17.

Primitive shell for running PostgreSQL quieries from console. Make sure you set the right connection settings in the script.

All queries are executed in autocommit mode.

Example command line usage:

pg.py select * from mytable where oidh=1

The script recognizes a number of magic keywords:

pg.py show databases
pg.py show schemas
pg.py describe <table_name>

ExecSql.cgi returning JSON for SQL (Python)

2009-11-28T02:00:30-08:00

Python recipe 576971 by Martchenko (cgi, json, sql).

CGI script getting JSON for SQL request

Transparently execute SQL queries as prepared statements with Postgresql (Python)

2009-03-23T07:30:07-07:00

Python recipe 576698 by Michael Palmer (postgresql, prepared_statements, sql). Revision 4.

This recipe defines a mixin class for DBAPI cursors that gives them an 'executeps' method. This method transparently converts any SQL query into a prepared statement, which gets cached and executed instead of the original query.