Tuesday, July 27, 2010

NoSQL(Not only SQL) A Relational Database Management System

NoSQL is a fast, portable, relational database management system without arbitrary limits, (other than memory and processor speed) that runs under, and interacts with, the UNIX1 Operating System. It uses the "Operator-Stream Paradigm" described in "Unix Review", March, 1991, page 24, entitled "A 4GL Language". There are a number of "operators" that each perform a unique function on the data. The "stream" is supplied by the UNIX Input/Output redirection mechanism. Therefore each operator processes some data and then passes it along to the next operator via the UNIX pipe function. This is very efficient as UNIX pipes are implemented in memory. NoSQL is compliant with the "Relational Model".



What is NoSQL

NoSQL, which I personally like to pronounce as noseequel2, is a derivative of the RDB database system. The latter was developed at RAND Organization by Walter W. Hobbs. The few Perl scripts included with NoSQL are still very close to the original RDB ones, so a good share of the credit for them goes to the original author.
Other major contributors to the original RDB system, besides Walter Hobbs, are:
  • Chuck Bush
  • Don Emerson
  • Judy Lender
  • Roy Gates
  • Rae Starr
People who helped with turning RDB into NoSQL:
  • Vincenzo (Vicky) Belloli
  • David Frey
  • Giuseppe Paternò
  • Maurizio (Masar) Sartori
  • Paul Lussier
  • Seth LaForge
  • Micah Stetson
  • Thomas Miller
  • Michael Somos
  • Agustín Ferrin
The NoSQL logo was kindly provided by Kyle Hart.
As its name implies, NoSQL is not an SQL database but rather a shell-level tool, as explained in Philosophy of NoSQL. NoSQL data is contained in regular UNIX ASCII files, and so can be manipulated by regular UNIX utilities, e.g. ls, wc, mv, cp, cat, head, more, less, editors like 'vi,' etc., as well as by powerful versioning systems, such as RCS and CVS.
The form of each file of data is that of a relation, or table, with rows and columns of information.
To extract information, a file of data is fed to one or more "operators" via the UNIX Input/Output redirection mechanism.
There are also programs to generate, modify, and validate the data. A more through discussion of why this type of relational database structure makes sense is found in the book, "UNIX Relational Database Management", in the "References" section below.
It is assumed that the reader has at least a basic familiarity with the UNIX Operating System, including knowledge of Input/Output redirection (e.g., STDIN, STDOUT, pipes).
NoSQL tends to be biased in favor of Linux. This means that, wherever it matters, NoSQL makes use of the GNUversion of the various UNIX commands, as those are the ones normally found on Linux. NoSQL is Free Software, released under the terms of the GNU General Public License. As such, it fully qualifies also as Open Source Software.

What NoSQL is not

NoSQL has been around for more than a decade now and it has nothing to do with the newborn NoSQL Movement, which has been receiving much hype lately. While the former is a well-defined software package, is a relational database to all effects and just does intentionally not use SQL as a query language, the newcomer is mostly a concept (and by no means a novel one either), which departs from the relational model altogether and it should therefore have been called more appropriately "NoREL", or something to that effect.

How to get NoSQL

NoSQL can be freely downloaded from http://www.strozzi.it/shared/nosql/. Make sure you get also any patches to the base code, for the version that you download.
Starting from version 4.0.14 the NoSQL development repository was moved from CVS to Subversion. Authorized users can download the latest development code from my Subversion server:
svn checkout --username anonymous svn://subversion.strozzi.it/pub/nosql/trunk
Versions of NoSQL from 4.1.0 to 4.1.6 depend on the Shell-Ware Utilities (SWU) package, which can be downloaded from http://www.strozzi.it/shared/swu/ . Since only a small portion of SWU is actually required for NoSQL to work, starting from version 4.1.7 I have removed such dependency by including a minimal, stripped-down version of SWU with NoSQL itself. If you have already installed the full-blown SWU, NoSQL will use that one instead.

Wednesday, July 21, 2010

BOSS/GNU Debian Linux Configure Network Interface Cards – IP address and Netmasks

Q. How do I configure networking or network interface card on HP Debian Linux U1 Server?

A. Debian Linux provides GUI, command line tools and direct configuration file editing options to set up networking. Network configuration from the command line is possible.

Configure the Network Manually

You can use ip or ifconfig command to configure IP address and other information.

Task: Display the Current Network Configuration

Type the following command:
$ ip address show
Output:
1: lo:  mtu 16436 qdisc noqueue
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
    inet6 ::1/128 scope host
       valid_lft forever preferred_lft forever
2: eth0:  mtu 1500 qdisc pfifo_fast qlen 100
    link/ether 00:19:d1:2a:ba:a8 brd ff:ff:ff:ff:ff:ff
    inet 192.168.2.1/24 brd 192.168.2.255 scope global eth0
    inet6 fe80::219:d1ff:fe2a:baa8/64 scope link
       valid_lft forever preferred_lft forever
3: ra0:  mtu 1500 qdisc pfifo_fast qlen 1000
    link/ether 00:17:9a:0a:f6:44 brd ff:ff:ff:ff:ff:ff
    inet 192.168.1.106/24 brd 192.168.1.255 scope global ra0
    inet6 fe80::217:9aff:fe0a:f644/64 scope link
       valid_lft forever preferred_lft forever
4: ppp0:  mtu 1496 qdisc pfifo_fast qlen 3
    link/ppp
    inet 10.1.3.103 peer 10.0.31.18/32 scope global ppp0
You can also use ifconfig -a command, enter:
$ ifconfig -a
Output:
eth0      Link encap:Ethernet  HWaddr 00:19:D1:2A:BA:A8
          inet addr:192.168.2.1  Bcast:192.168.2.255  Mask:255.255.255.0
          inet6 addr: fe80::219:d1ff:fe2a:baa8/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:15819 errors:0 dropped:0 overruns:0 frame:0
          TX packets:27876 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:100
          RX bytes:1695948 (1.6 MB)  TX bytes:40399983 (38.5 MB)
          Base address:0x1000 Memory:93180000-931a0000 

lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:11943 errors:0 dropped:0 overruns:0 frame:0
          TX packets:11943 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:7024449 (6.6 MB)  TX bytes:7024449 (6.6 MB)

ppp0      Link encap:Point-to-Point Protocol
          inet addr:10.1.3.103  P-t-P:10.0.31.18  Mask:255.255.255.255
          UP POINTOPOINT RUNNING NOARP MULTICAST  MTU:1496  Metric:1
          RX packets:34922 errors:0 dropped:0 overruns:0 frame:0
          TX packets:15764 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:3
          RX bytes:50535608 (48.1 MB)  TX bytes:1256881 (1.1 MB)

ra0       Link encap:Ethernet  HWaddr 00:17:9A:0A:F6:44
          inet addr:192.168.1.106  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::217:9aff:fe0a:f644/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:73809 errors:0 dropped:0 overruns:0 frame:0
          TX packets:31332 errors:1 dropped:1 overruns:0 carrier:0
          collisions:27 txqueuelen:1000
          RX bytes:61373519 (58.5 MB)  TX bytes:5007190 (4.7 MB)
          Interrupt:20
The information is grouped by network interfaces. Every interface entry starts with a digit, called the interface index, with the interface name displayed after the interface index. In the above example, there are four interfaces:
  • lo : Loopback interface, used to access local services such as proxy or webserver http://127.0.0.1/
  • eth0 : The first Ethernet interface connected to network switch or router
  • ra0 : The first wireless interface
  • ppp0 :The first point-to-point interface, used to connect via VPN or dial up service

Task: Device / Interface Statistics

Type the following command:
$ ip -s link show interface-name
$ ip -s link show eth0
$ ip -s link show ppp0

Output:
4: ppp0:  mtu 1496 qdisc pfifo_fast qlen 3
    link/ppp
    RX: bytes  packets  errors  dropped overrun mcast
    50537336   34946    0       0       0       0
    TX: bytes  packets  errors  dropped carrier collsns
    1257745    15776    0       0       0       0

Change the Current Network Configuration

You must login as the root to change current network settings.

Task: Assign an IP Address to a Device Interface

In the following example, the command assigns the IP address 192.168.1.10 to the device eth0. The network mask is 24 (255.255.255.0) bits long. The brd + option sets the broadcast address automatically as determined by the network mask.
# ip address add 192.168.1.100/24 brd + dev eth0
You can also use ifconfig command, enter
# ifconfig eth0 192.168.1.100 netmask 255.255.255.0 up

Task: Remove / Delete / Deactivate IP address from a device interface

To remove IP / delete device, enter:
# ip address del 192.168.1.100 dev eth0
OR
# ifconfig eth0 down

Save Network Settings to a Configuration File

To change the current network configuration setting you'll need to edit /etc/network/interfaces file using a text editor such as vi. This is the only way to save device setting to a configuration file so that system can remember changes after a reboot.

Task: Configure a Device Statically

Open /etc/network/interfaces file as the root user:
# vi /etc/network/interfaces
Let us assign static public routable (or private) IP address to eth0, enter:
auto eth0
iface eth0 inet static
address 192.168.2.1
netmask 255.255.255.0

Save and close the file. Where,
  • auto eth0 : Identify the physical interfaces such as eth0, eth1 and so on
  • iface eth0 inet static : This method used to define ethernet interfaces with statically allocated IPv4 addresses
  • address 192.168.2.1 : Static IP address
  • netmask 255.255.255.0 : Static netmask

Task: Configure a Device Dynamically with DHCP

Open /etc/network/interfaces file as the root user:
# vi /etc/network/interfaces
Let us configure eth0 using DHCP. When the device is configured by using DHCP, you don’t need to set any options for the network address configuration in the file.
auto eth0
iface eth0 inet dhcp

Save and close the file.
Where,
  • auto eth0 : Identify the physical interfaces such as eth0, eth1 and so on
  • iface eth0 inet dhcp : This method used to define ethernet interfaces with DHCP server allocated IPv4 addresses

Start and Stop Configured Interfaces

To apply changes to a configuration file, you need to stop and restart the corresponding interface
# /etc/init.d/networking stop
# /etc/init.d/networking start
# /etc/init.d/networking restart

You can also use following command to bring down or up the eth0. Disables the device eth0, enter:
# ifdown eth0
Enables eth0 again, enter:
# ifup eth0

Monday, July 19, 2010

DJANGO WEB FRAMEWORK(BOSS/GNU Linux- Debian)- Part II

HOW TO DJANGO'S AUTOMATICALLY GENERATED ADMIN SITE
=========================================================
Philosophy

Generating admin sites for your staff or clients to add, change and delete content is tedious work that doesn’t require much creativity. For that reason, Django entirely automates creation of admin interfaces for models.

Django was written in a newsroom environment, with a very clear separation between “content publishers” and the “public” site. Site managers use the system to add news stories, events, sports scores, etc., and that content is displayed on the public site. Django solves the problem of creating a unified interface for site administrators to edit content.

The admin isn’t necessarily intended to be used by site visitors; it’s for site managers

ACTIVATE ADMIN SITE:
********************
The Django admin site is not activated by default – it’s an opt-in thing. To activate the admin site for your installation, do these three things:

* Add "django.contrib.admin" to your INSTALLED_APPS setting.
* Run python manage.py syncdb. Since you have added a new application to INSTALLED_APPS, the database tables need to be updated.
* Edit your cms/urls.py file and uncomment the lines that reference the admin – there are three lines in total to uncomment. This file is a URLconf; we’ll dig into URLconfs in the next tutorial. For now, all you need to know is that it maps URL roots to applications. In the end, you should have a urls.py file that looks like this:

Changed in Django 1.1: The method for adding admin urls has changed in Django 1.1.

from django.conf.urls.defaults import *

# Uncomment the next two lines to enable the admin:
from django.contrib import admin
admin.autodiscover()


urlpatterns = patterns('',
# Example:
# (r'^cms/', include('cms.foo.urls')),

# Uncomment the admin/doc line below and add 'django.contrib.admindocs'
# to INSTALLED_APPS to enable admin documentation:
# (r'^admin/doc/', include('django.contrib.admindocs.urls')),

# Uncomment the next line to enable the admin:
(r'^admin/', include(admin.site.urls)),
)

(The bold lines are the ones that needed to be uncommented.)

START THE DEVELOPMENT SERVER

******************************************

Let’s start the development server and explore the admin site.
http://docs.djangoproject.com/en/1.1/_images/admin01.png
Recall from Tutorial 1 that you start the development server like so:

python manage.py runserver

Now, open a Web browser and go to "/admin/" on your local domain -- e.g., http://127.0.0.1:8000/admin/. You should see the admin's login screen:
Django admin login screen

Enter the admin site

Now, try logging in. (You created a superuser account in the first part of this tutorial, remember? If you didn't create one or forgot the password you can create another one.) You should see the Django admin index page:

Django admin index page

You should see a few other types of editable content, including groups, users and sites. These are core features Django ships with by default.

Make the poll app modifiable in the admin

But where's our poll app? It's not displayed on the admin index page.
Just one thing to do: We need to tell the admin that Poll objects have an admin interface. To do this, create a file called admin.py in your polls directory, and edit it to look like this:
from cms.polls.models import Poll
from django.contrib import admin

admin.site.register(Poll)
You'll need to restart the development server to see your changes. Normally, the server auto-reloads code every time you modify a file, but the action of creating a new file doesn't trigger the auto-reloading logic.

Explore the free admin functionality

Now that we've registered Poll, Django knows that it should be displayed on the admin index page:


Django admin index page, now with polls displayed

 

 Click "Polls." Now you're at the "change list" page for polls. This page displays all the polls in the database and lets you choose one to change it. There's the "What's up?" poll we created in the first tutorial:

Polls change list page
Click the "What's up?" poll to edit it:

Editing form for poll object
Things to note here:
  • The form is automatically generated from the Poll model.
  • The different model field types (DateTimeField, CharField) correspond to the appropriate HTML input widget. Each type of field knows how to display itself in the Django admin.
  • Each DateTimeField gets free JavaScript shortcuts. Dates get a "Today" shortcut and calendar popup, and times get a "Now" shortcut and a convenient popup that lists commonly entered times.
The bottom part of the page gives you a couple of options:
  • Save -- Saves changes and returns to the change-list page for this type of object.
  • Save and continue editing -- Saves changes and reloads the admin page for this object.
  • Save and add another -- Saves changes and loads a new, blank form for this type of object.
  • Delete -- Displays a delete confirmation page.
Change the "Date published" by clicking the "Today" and "Now" shortcuts. Then click "Save and continue editing." Then click "History" in the upper right. You'll see a page listing all changes made to this object via the Django admin, with the timestamp and username of the person who made the change:

History page for poll object

Customize the admin form

Take a few minutes to marvel at all the code you didn't have to write. By registering the Poll model with admin.site.register(Poll), Django was able to construct a default form representation. Often, you'll want to customize how the admin form looks and works. You'll do this by telling Django the options you want when you register the object.
Let's see how this works by re-ordering the fields on the edit form. Replace the admin.site.register(Poll) line with:
class PollAdmin(admin.ModelAdmin):
    fields = ['pub_date', 'question']

admin.site.register(Poll, PollAdmin)
You'll follow this pattern -- create a model admin object, then pass it as the second argument to admin.site.register() -- any time you need to change the admin options for an object.
This particular change above makes the "Publication date" come before the "Question" field:

Fields have been reordered

This isn't impressive with only two fields, but for admin forms with dozens of fields, choosing an intuitive order is an important usability detail.
And speaking of forms with dozens of fields, you might want to split the form up into fieldsets:
class PollAdmin(admin.ModelAdmin):
    fieldsets = [
        (None,               {'fields': ['question']}),
        ('Date information', {'fields': ['pub_date']}),
    ]

admin.site.register(Poll, PollAdmin)
The first element of each tuple in fieldsets is the title of the fieldset. Here's what our form looks like now:

Form has fieldsets now

You can assign arbitrary HTML classes to each fieldset. Django provides a "collapse" class that displays a particular fieldset initially collapsed. This is useful when you have a long form that contains a number of fields that aren't commonly used:
class PollAdmin(admin.ModelAdmin):
    fieldsets = [
        (None,               {'fields': ['question']}),
        ('Date information', {'fields': ['pub_date'], 'classes': ['collapse']}),
    ]
 
 
Fieldset is initially collapsed

Thursday, July 15, 2010

Postgresql : psql: FATAL: IDENT authentication failed for user "postgres"

So what I have is a postgreSQL database and I was trying to connect to
it via a Python module (PyGreSQL) from the same machine. I created a
table under the user 'postgres' called postgres.

When I started up the machine and logged on, I was the root. When I
tried to do this:

psql -U postgres -d postgres

I got:

psql: FATAL: IDENT authentication failed for user "postgres"

so I figured out I had to switch user and be postgres instead of root
with:

su postgres

then, after issuing the same command:

psql -U postgres -d postgres

I had success.

By the way, the same goes if you're trying to access a table via a
Python module. If the database (or table) is for a certain user, you
must be logged in as that user before you can access it with pg or
pgdb.

Hope that helps someone...

Wednesday, July 14, 2010

HOW TO INSTALL FONTS TO BOSS/GNU LINUX-DEBIAN

BOSS/GNU LINUX searches for fonts in specific locations as listed in the /etc/fonts/fonts.conf file.

A look at the contents of /etc/fonts/fonts.conf file indicates the following directories which are searched by Ubuntu Linux for fonts. They are :

1. /usr/share/fonts
2. /usr/share/X11/fonts
3. /usr/local/share/fonts
4. ~/.fonts

So if you want to install new fonts in Ubuntu Linux or Debian for that matter, you can copy the fonts to any one of the 4 directories listed above.

The last directory ~/.fonts is a local hidden directory in every user’s Home folder. If you install the new fonts in this directory, the fonts will be available only for the person logged into that particular user account.

If you want your new fonts to be available system wide, to all users, then you should install them in any one of the first three directories listed above.

Once all your fonts are copied to the specific font directories, you have to make Ubuntu Linux aware of the new fonts so that it can make use of them. This is done by running the following command in the console :

$ sudo fc-cache -f -v

Please note that you have to have super user powers to run this command. In Debian Linux, it means you have to be logged in as root user.

What the fc-cache command does is, it reads and caches all the fonts installed in the font directories. You have to run this command each time you install any new fonts in Linux.

This method of installing fonts works not just for Ubuntu or Debian Linux but probably for all other Linux distributions.

Tuesday, July 13, 2010

DJANGO WEB FRAMEWORK(BOSS/GNU Linux- Debian)

DJANGO INSTALLATION
****************************
1)Download latest version DJANGO 1.2.1 from djangoproject.com/download

2)Install Python 2.5 (OR) above versions

3)Extract downloaded tar file to a specific folder.

4)Get in to the extracted directory run following from gnome-terminal

sudo python setup.py install

*******************************************************************

GETTING STARTED
After getting installed django

create new project cms by using the commmand

django-admin.py startproject cms

This will create a folder called 'cms' that contains following default files
cms/
__init__.py
manage.py
settings.py
urls.py

these files are:

__init__.py: An empty file that tells Python that this directory should be considered a Python package. (Read more about packages in the official Python docs if you're a Python beginner.)

manage.py: A command-line utility that lets you interact with this Django project in various ways. You can read all the details about manage.py in django-admin.py and manage.py.

settings.py: Settings/configuration for this Django project. Django settings will tell you all about how settings work.

urls.py: The URL declarations for this Django project; a "table of contents" of your Django-powered site. You can read more about URLs in URL dispatcher.

Create simple web server execute following this from created project directory 'cms'

python manage.py runserver

Default port no is :8000

To run the server from own port specify

python manage.py runserver ip_address:port_number

example
python manage.py runserver 192.168.x.x:9000

DATABASE SETUP
Now, edit settings.py. It's a normal Python module with module-level variables representing Django settings. Change the following keys in the DATABASES 'default' item to match your databases connection settings.

ENGINE -- Either 'django.db.backends.postgresql_psycopg2', 'django.db.backends.mysql' or 'django.db.backends.sqlite3'. Other backends are also available.

NAME -- The name of your database. If you're using SQLite, the database will be a file on your computer; in that case, NAME should be the full absolute path, including filename, of that file. If the file doesn't exist, it will automatically be created when you synchronize the database for the first time (see below).

When specifying the path, always use forward slashes, even on Windows (e.g. C:/homes/user/cms/sqlite3.db).

USER -- Your database username (not used for SQLite).

PASSWORD -- Your database password (not used for SQLite).

HOST -- The host your database is on. Leave this as an empty string if your database server is on the same physical machine (not used for SQLite).

Note

If you're using PostgreSQL or MySQL, make sure you've created a database by this point. Do that with "CREATE DATABASE database_name;" within your database's interactive prompt.

If you're using SQLite, you don't need to create anything beforehand - the database file will be created automatically when it is needed.

While you're editing settings.py, take note of the INSTALLED_APPS setting towards the bottom of the file. That variable holds the names of all Django applications that are activated in this Django instance. Apps can be used in multiple projects, and you can package and distribute them for use by others in their projects.

By default, INSTALLED_APPS contains the following apps, all of which come with Django:

* django.contrib.auth -- An authentication system.
* django.contrib.contenttypes -- A framework for content types.
* django.contrib.sessions -- A session framework.
* django.contrib.sites -- A framework for managing multiple sites with one Django installation.

These applications are included by default as a convenience for the common case.

Each of these applications makes use of at least one database table, though, so we need to create the tables in the database before we can use them. To do that, run the following command:

python manage.py syncdb


The syncdb command looks at the INSTALLED_APPS setting and creates any necessary database tables according to the database settings in your settings.py file. You'll see a message for each database table it creates, and you'll get a prompt asking you if you'd like to create a superuser account for the authentication system. Go ahead and do that.

If you're interested, run the command-line client for your database and type \dt (PostgreSQL), SHOW TABLES; (MySQL), or .schema (SQLite) to display the tables Django created.

For the minimalists

Like we said above, the default applications are included for the common case, but not everybody needs them. If you don't need any or all of them, feel free to comment-out or delete the appropriate line(s) from INSTALLED_APPS before running syncdb. The syncdb command will only create tables for apps in INSTALLED_APPS.

CREATING MODELS
*********************

Now that your environment -- a "project" -- is set up, you're set to start doing work.

Each application you write in Django consists of a Python package, somewhere on your Python path, that follows a certain convention. Django comes with a utility that automatically generates the basic directory structure of an app, so you can focus on writing code rather than creating directories.


Projects vs. apps

What's the difference between a project and an app? An app is a Web application that does something -- e.g., a weblog system, a database of public records or a simple poll app. A project is a collection of configuration and apps for a particular Web site. A project can contain multiple apps. An app can be in multiple projects.

In this tutorial, we'll create our poll app in the cms directory, for simplicity. As a consequence, the app will be coupled to the project -- that is, Python code within the poll app will refer to cms.polls. Later in this tutorial, we'll discuss decoupling your apps for distribution.

To create your app, make sure you're in the 'cms' directory and type this command:

python manage.py startapp polls

That'll create a directory polls, which is laid out like this:

polls/
__init__.py
models.py
tests.py
views.py

This directory structure will house the poll application.

The first step in writing a database Web app in Django is to define your models -- essentially, your database layout, with additional metadata.

Philosophy

A model is the single, definitive source of data about your data. It contains the essential fields and behaviors of the data you're storing. Django follows the DRY Principle. The goal is to define your data model in one place and automatically derive things from it.

In our simple poll app, we'll create two models: polls and choices. A poll has a question and a publication date. A choice has two fields: the text of the choice and a vote tally. Each choice is associated with a poll.

These concepts are represented by simple Python classes. Edit the polls/models.py file so it looks like this:

from django.db import models

class Poll(models.Model):
question = models.CharField(max_length=200)
pub_date = models.DateTimeField('date published')

class Choice(models.Model):
poll = models.ForeignKey(Poll)
choice = models.CharField(max_length=200)
votes = models.IntegerField()

The code is straightforward. Each model is represented by a class that subclasses django.db.models.Model. Each model has a number of class variables, each of which represents a database field in the model.

Each field is represented by an instance of a Field class -- e.g., CharField for character fields and DateTimeField for datetimes. This tells Django what type of data each field holds.

The name of each Field instance (e.g. question or pub_date ) is the field's name, in machine-friendly format. You'll use this value in your Python code, and your database will use it as the column name.

You can use an optional first positional argument to a Field to designate a human-readable name. That's used in a couple of introspective parts of Django, and it doubles as documentation. If this field isn't provided, Django will use the machine-readable name. In this example, we've only defined a human-readable name for Poll.pub_date. For all other fields in this model, the field's machine-readable name will suffice as its human-readable name.

Some Field classes have required elements. CharField, for example, requires that you give it a max_length. That's used not only in the database schema, but in validation, as we'll soon see.

Finally, note a relationship is defined, using ForeignKey. That tells Django each Choice is related to a single Poll. Django supports all the common database relationships: many-to-ones, many-to-manys and one-to-ones.

ACTIVATING MODELS
That small bit of model code gives Django a lot of information. With it, Django is able to:

* Create a database schema (CREATE TABLE statements) for this app.
* Create a Python database-access API for accessing Poll and Choice objects.

But first we need to tell our project that the polls app is installed.

Philosophy

Django apps are "pluggable": You can use an app in multiple projects, and you can distribute apps, because they don't have to be tied to a given Django installation.

Edit the settings.py file again, and change the INSTALLED_APPS setting to include the string 'cms.polls'. So it'll look like this:

INSTALLED_APPS = (
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'cms.polls'
)

Now Django knows cms includes the polls app. Let's run another command:

python manage.py sql polls

You should see something similar to the following (the CREATE TABLE SQL statements for the polls app):

BEGIN;
CREATE TABLE "polls_poll" (
"id" serial NOT NULL PRIMARY KEY,
"question" varchar(200) NOT NULL,
"pub_date" timestamp with time zone NOT NULL
);
CREATE TABLE "polls_choice" (
"id" serial NOT NULL PRIMARY KEY,
"poll_id" integer NOT NULL REFERENCES "polls_poll" ("id"),
"choice" varchar(200) NOT NULL,
"votes" integer NOT NULL
);
COMMIT;

Note the following:

* The exact output will vary depending on the database you are using.
* Table names are automatically generated by combining the name of the app (polls) and the lowercase name of the model -- poll and choice. (You can override this behavior.)
* Primary keys (IDs) are added automatically. (You can override this, too.)
* By convention, Django appends "_id" to the foreign key field name. Yes, you can override this, as well.
* The foreign key relationship is made explicit by a REFERENCES statement.
* It's tailored to the database you're using, so database-specific field types such as auto_increment (MySQL), serial (PostgreSQL), or integer primary key (SQLite) are handled for you automatically. Same goes for quoting of field names -- e.g., using double quotes or single quotes. The author of this tutorial runs PostgreSQL, so the example output is in PostgreSQL syntax.
* The sql command doesn't actually run the SQL in your database - it just prints it to the screen so that you can see what SQL Django thinks is required. If you wanted to, you could copy and paste this SQL into your database prompt. However, as we will see shortly, Django provides an easier way of committing the SQL to the database.

If you're interested, also run the following commands:

* python manage.py validate -- Checks for any errors in the construction of your models.
* python manage.py sqlcustom polls -- Outputs any custom SQL statements (such as table modifications or constraints) that are defined for the application.
* python manage.py sqlclear polls -- Outputs the necessary DROP TABLE statements for this app, according to which tables already exist in your database (if any).
* python manage.py sqlindexes polls -- Outputs the CREATE INDEX statements for this app.
* python manage.py sqlall polls -- A combination of all the SQL from the sql, sqlcustom, and sqlindexes commands.

Looking at the output of those commands can help you understand what's actually happening under the hood.

Now, run syncdb again to create those model tables in your database:

python manage.py syncdb


The syncdb command runs the sql from 'sqlall' on your database for all apps in INSTALLED_APPS that don't already exist in your database. This creates all the tables, initial data and indexes for any apps you have added to your project since the last time you ran syncdb. syncdb can be called as often as you like, and it will only ever create the tables that don't exist.

PLAYING WITH PYTHON API

Now, let's hop into the interactive Python shell and play around with the free API Django gives you. To invoke the Python shell, use this command:

python manage.py shell

We're using this instead of simply typing "python", because manage.py sets up the project's environment for you. "Setting up the environment" involves two things:

* Putting 'cms' on sys.path. For flexibility, several pieces of Django refer to projects in Python dotted-path notation (e.g. 'cms.polls.models'). In order for this to work, the cms package has to be on sys.path.

We've already seen one example of this: the INSTALLED_APPS setting is a list of packages in dotted-path notation.
* Setting the DJANGO_SETTINGS_MODULE environment variable, which gives Django the path to your settings.py file.

Note:

Bypassing manage.py


If you'd rather not use manage.py, no problem. Just make sure cms is at the root level on the Python path (i.e., import cms works) and set the DJANGO_SETTINGS_MODULE environment variable to cms.settings.

For more information on all of this, see the django-admin.py documentation.


Once you're in the shell, explore the database API:

>>> from cms.polls.models import Poll, Choice # Import the model classes we just wrote.

# No polls are in the system yet.
>>> Poll.objects.all()
[]

# Create a new Poll.
>>> import datetime
>>> p = Poll(question="What's up?", pub_date=datetime.datetime.now())

# Save the object into the database. You have to call save() explicitly.
>>> p.save()

# Now it has an ID. Note that this might say "1L" instead of "1", depending
# on which database you're using. That's no biggie; it just means your
# database backend prefers to return integers as Python long integer
# objects.
>>> p.id
1

# Access database columns via Python attributes.
>>> p.question
"What's up?"
>>> p.pub_date
datetime.datetime(2007, 7, 15, 12, 00, 53)

# Change values by changing the attributes, then calling save().
>>> p.pub_date = datetime.datetime(2007, 4, 1, 0, 0)
>>> p.save()

# objects.all() displays all the polls in the database.
>>> Poll.objects.all()
[]

Wait a minute. is, utterly, an unhelpful representation of this object. Let's fix that by editing the polls model (in the polls/models.py file) and adding a __unicode__() method to both Poll and Choice:

class Poll(models.Model):
# ...
def __unicode__(self):
return self.question

class Choice(models.Model):
# ...
def __unicode__(self):
return self.choice

Note:
If __unicode__() doesn't seem to work


If you add the __unicode__() method to your models and don't see any change in how they're represented, you're most likely using an old version of Django. (This version of the tutorial is written for the latest development version of Django.) If you're using a Subversion checkout of Django's development version (see the installation docs for more information), you shouldn't have any problems.

If you want to stick with an older version of Django, you'll want to switch to the Django 0.96 tutorial, because this tutorial covers several features that only exist in the Django development version.

t's important to add __unicode__() methods to your models, not only for your own sanity when dealing with the interactive prompt, but also because objects' representations are used throughout Django's automatically-generated admin.


Why __unicode__() and not __str__()?


If you're familiar with Python, you might be in the habit of adding __str__() methods to your classes, not __unicode__() methods. We use __unicode__() here because Django models deal with Unicode by default. All data stored in your database is converted to Unicode when it's returned.

Django models have a default __str__() method that calls __unicode__() and converts the result to a UTF-8 bytestring. This means that unicode(p) will return a Unicode string, and str(p) will return a normal string, with characters encoded as UTF-8.

If all of this is jibberish to you, just remember to add __unicode__() methods to your models. With any luck, things should Just Work for you.

Note these are normal Python methods. Let's add a custom method, just for demonstration:

import datetime
# ...
class Poll(models.Model):
# ...
def was_published_today(self):
return self.pub_date.date() == datetime.date.today()

Note the addition of import datetime to reference Python's standard datetime module.

Save these changes and start a new Python interactive shell by running python manage.py shell again:

>>> from cms.polls.models import Poll, Choice

# Make sure our __unicode__() addition worked.
>>> Poll.objects.all()
[]

# Django provides a rich database lookup API that's entirely driven by
# keyword arguments.
>>> Poll.objects.filter(id=1)
[]
>>> Poll.objects.filter(question__startswith='What')
[]

# Get the poll whose year is 2007.
>>> Poll.objects.get(pub_date__year=2007)


>>> Poll.objects.get(id=2)
Traceback (most recent call last):
...
DoesNotExist: Poll matching query does not exist.

# Lookup by a primary key is the most common case, so Django provides a
# shortcut for primary-key exact lookups.
# The following is identical to Poll.objects.get(id=1).
>>> Poll.objects.get(pk=1)


# Make sure our custom method worked.
>>> p = Poll.objects.get(pk=1)
>>> p.was_published_today()
False

# Give the Poll a couple of Choices. The create call constructs a new
# choice object, does the INSERT statement, adds the choice to the set
# of available choices and returns the new Choice object. Django creates
# a set to hold the "other side" of a ForeignKey relation
# (e.g. a poll's choices) which can be accessed via the API.
>>> p = Poll.objects.get(pk=1)

# Display any choices from the related object set -- none so far.
>>> p.choice_set.all()
[]

# Create three choices.
>>> p.choice_set.create(choice='Not much', votes=0)

>>> p.choice_set.create(choice='The sky', votes=0)

>>> c = p.choice_set.create(choice='Just hacking again', votes=0)

# Choice objects have API access to their related Poll objects.
>>> c.poll


# And vice versa: Poll objects get access to Choice objects.
>>> p.choice_set.all()
[, , ]
>>> p.choice_set.count()
3

# The API automatically follows relationships as far as you need.
# Use double underscores to separate relationships.
# This works as many levels deep as you want; there's no limit.
# Find all Choices for any poll whose pub_date is in 2007.
>>> Choice.objects.filter(poll__pub_date__year=2007)
[, , ]

# Let's delete one of the choices. Use delete() for that.
>>> c = p.choice_set.filter(choice__startswith='Just hacking')
>>> c.delete()

Friday, July 9, 2010

Error found When pgadmin3 and postgresql-8.3

Error:
=====
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LANG = "en_US.UTF-8"
are supported and installed on your system.

Solution
==========
Type the following command set locales

dpkg-reconfigure locales

JMeter JSON Extractor

      json response {"Key1":"Value1","Key2":"Value2","Key2":"Value2"}  Name of t...