Mercurial > sqlpython

comparison sqlpython/pagila_test.txt @ 497:128aa57c4b8d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
first try at switching postgres query to dbapiext form
author Catherine Devlin <catherine.devlin@gmail.com>
date Wed, 27 Oct 2010 10:04:31 -0400
parents
children c36e0aa695a4
comparison
equal deleted inserted replaced
496:af846fd968cd 497:128aa57c4b8d
1 """
2 Run these against a ``pagila`` database (user paglia, password paglia)
3 created from http://pgfoundry.org/projects/dbsamples/
4 """
5 SQL.No_Connection> connect postgres://pagila:pagila@localhost/pagila
6 0:pagila@pagila> set color off
7 colors - was: True
8 now: False
9 0:pagila@pagila> desc actor
10 BASE TABLE public.actor
11 Name Nullable Type
12 ----------- -------- ---------------------------
13 actor_id NOT NULL integer
14 first_name NOT NULL varchar(45)
15 last_name NOT NULL varchar(45)
16 last_update NOT NULL timestamp without time zone
17
18 0:pagila@pagila> desc actor\g
19 BASE TABLE public.actor
20
21
22 **** Row: 1
23 Name: actor_id
24 Nullable: NOT NULL
25 Type: integer
26
27 **** Row: 2
28 Name: first_name
29 Nullable: NOT NULL
30 Type: varchar(45)
31
32 **** Row: 3
33 Name: last_name
34 Nullable: NOT NULL
35 Type: varchar(45)
36
37 **** Row: 4
38 Name: last_update
39 Nullable: NOT NULL
40 Type: timestamp without time zone
41
42 0:pagila@pagila> \d -l actor\g
43 BASE TABLE public.actor
44
45
46 **** Row: 1
47 N: 1
48 Name: actor_id
49 Nullable: NOT NULL
50 Type: integer
51 Key: P
52 Default: nextval('actor_actor_id_seq'::regclass)
53 Comments:
54
55 **** Row: 2
56 N: 2
57 Name: first_name
58 Nullable: NOT NULL
59 Type: varchar(45)
60 Key:
61 Default:
62 Comments:
63
64 **** Row: 3
65 N: 3
66 Name: last_name
67 Nullable: NOT NULL
68 Type: varchar(45)
69 Key:
70 Default:
71 Comments:
72
73 **** Row: 4
74 N: 4
75 Name: last_update
76 Nullable: NOT NULL
77 Type: timestamp without time zone
78 Key:
79 Default: now()
80 Comments:
81
82
83 0:pagila@pagila> show constraints on actor
84 Constraints on BASE TABLE public.actor
85 Primary key "actor_pkey": (actor_id)
86
87 0:pagila@pagila> show indexes on actor
88 Indexes on BASE TABLE public.actor
89 idx_actor_last_name (last_name) btree
90
91 0:pagila@pagila> select actor_id, first_name, last_name from actor;3
92
93 actor_id first_name last_name
94 -------- ---------- ---------
95 1 PENELOPE GUINESS
96 2 NICK WAHLBERG
97 3 ED CHASE
98
99 3 rows selected.
100
101 0:pagila@pagila> select actor_id, first_name, last_name from actor\j3
102
103
104 {"actor": [
105 {"actor_id": 1, "first_name": "PENELOPE", "last_name": "GUINESS"},
106 {"actor_id": 2, "first_name": "NICK", "last_name": "WAHLBERG"},
107 {"actor_id": 3, "first_name": "ED", "last_name": "CHASE"}
108 ]
109 }
110
111 3 rows selected.
112
113 0:pagila@pagila> set wild on
114 wildsql - was: False
115 now: True
116 0:pagila@pagila> select #1, #2, #3 from actor;3
117
118 actor_id first_name last_name
119 -------- ---------- ---------
120 1 PENELOPE GUINESS
121 2 NICK WAHLBERG
122 3 ED CHASE
123
124 3 rows selected.
125
126 0:pagila@pagila> select !#4 from actor;3
127
128 actor_id first_name last_name
129 -------- ---------- ---------
130 1 PENELOPE GUINESS
131 2 NICK WAHLBERG
132 3 ED CHASE
133
134 3 rows selected.
135
136 0:pagila@pagila> select *name from actor;3
137
138 first_name last_name
139 ---------- ---------
140 PENELOPE GUINESS
141 NICK WAHLBERG
142 ED CHASE
143
144 3 rows selected.
145
146 0:pagila@pagila> show constraint on film_actor;
147 Constraints on BASE TABLE public.film_actor
148 Foreign key "film_actor_actor_id_fkey": columns (actor_id) in table "actor"
149 Foreign key "film_actor_film_id_fkey": columns (film_id) in table "film"
150 Primary key "film_actor_pkey": (film_id,actor_id)