~ubuntu-branches/debian/sid/sqlalchemy/sid : revision 39

32

33

var DOCUMENTATION_OPTIONS = {

34

URL_ROOT: '../',

35

VERSION: '0.9.4',

35

VERSION: '0.9.6',

36

COLLAPSE_MODINDEX: false,

37

FILE_SUFFIX: '.html'

38

};

44

45

46

47

47

48

48

49

49

50

69

70

71

72

73

72

74

73

75

74

76

75

77

76

78

79

80

77

81

82

83

Release: 0.9.6 | Release Date: June 23, 2014

84

</div>

85

78

86

<h1>SQLAlchemy 0.9 Documentation</h1>

79

87

80

81

Search:

82

83

84

85

86

</form>

87

</div>

88

89

90

Release: 0.9.4 | Release Date: March 28, 2014

91

92

93

</div>

94

95

</div>

96

97

98

88

</div>

89

</div>

90

91

92

93

94

95

96

97

<h3><a href="../index.html">SQLAlchemy 0.9 Documentation</a></h3>

98

99

100

<a href="expression_api.html" title="SQL Statements and Expressions API">Up</a> |

101

102

<a href="sqlelement.html" title="Column Elements and Expressions">Prev</a> |

103

104

105

106

107

<a href="../index.html">Contents</a> |

108

<a href="../genindex.html">Index</a>

109

110

111

112

113

114

115

116

</form>

117

</div>

118

119

</div>

120

121

122

123

124

Selectables, Tables, FROM objects

125

126

</a></h3>

99

127

<ul>

100

<li>Prev:

101

<a href="sqlelement.html" title="previous chapter">Column Elements and Expressions</a>

102

</li>

103

<li>Next:

104

<a href="dml.html" title="next chapter">Insert, Updates, Deletes</a>

105

</li>

106

107

<li>

108

<a href="../contents.html">Table of Contents</a> |

109

<a href="../genindex.html">Index</a>

110

| <a href="../_sources/core/selectable.txt">view source

111

</li>

112

</ul>

113

</div>

114

115

116

<a href="../index.html">SQLAlchemy 0.9 Documentation</a>

117

» <a href="index.html" title="SQLAlchemy Core">SQLAlchemy Core</a>

118

» <a href="expression_api.html" title="SQL Statements and Expressions API">SQL Statements and Expressions API</a>

119

»

120

Selectables, Tables, FROM objects

121

122

123

<h2>

124

125

Selectables, Tables, FROM objects

126

127

</h2>

128

</div>

129

130

</div>

131

132

133

134

135

<h3><a href="../index.html">Table of Contents</a></h3>

136

<ul>

137

128

<li><a class="reference internal" href="#">Selectables, Tables, FROM objects</a></li>

138

129

</ul>

139

130

140

131

141

<h4>Previous Topic</h4>

142

143

<a href="sqlelement.html" title="previous chapter">Column Elements and Expressions</a>

144

145

<h4>Next Topic</h4>

146

147

<a href="dml.html" title="next chapter">Insert, Updates, Deletes</a>

148

149

150

151

<h4>Quick Search</h4>

152

153

154

155

156

157

</form>

158

132

133

134

</div>

159

135

160

136

</div>

161

137

138

139

162

140

163

141

164

142

401

379

Use this parameter to explicitly specify “from” objects which are not

402

380

automatically locatable. This could include

403

381

<a class="reference internal" href="metadata.html#sqlalchemy.schema.Table" title="sqlalchemy.schema.Table"><tt class="xref py py-class docutils literal">Table</tt></a> objects that aren’t otherwise present,

404

or <a class="reference internal" href="#sqlalchemy.sql.expression.Join" title="sqlalchemy.sql.expression.Join"><tt class="xref py py-class docutils literal">Join</tt></a> objects whose presence will supercede that of the

382

or <a class="reference internal" href="#sqlalchemy.sql.expression.Join" title="sqlalchemy.sql.expression.Join"><tt class="xref py py-class docutils literal">Join</tt></a> objects whose presence will supersede that of the

405

383

<a class="reference internal" href="metadata.html#sqlalchemy.schema.Table" title="sqlalchemy.schema.Table"><tt class="xref py py-class docutils literal">Table</tt></a> objects already located in the other

406

384

clauses.</li>

407

385

<li>autocommit<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.select.params.autocommit">¶</a> – Deprecated. Use .execution_options(autocommit=<True|False>)

652

630

VALUES clause. This typically refers to Sequence execution but may

653

631

also refer to any server-side default generation function

654

632

associated with a primary key <cite>Column</cite>.</li>

633

<li>compile_kwargs<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.Alias.compile.params.compile_kwargs">¶</a> – optional dictionary of additional parameters

634

that will be passed through to the compiler within all “visit”

635

methods. This allows any custom flag to be passed through to

636

a custom compilation construct, for example. It is also used

637

for the case of passing the <tt class="docutils literal">literal_binds</tt> flag through:

638

<div class="highlight-python"><div class="highlight"><pre>from sqlalchemy.sql import table, column, select

639

640

t = table('t', column('x'))

641

642

s = select([t]).where(t.c.x == 5)

643

644

print s.compile(compile_kwargs={"literal_binds": True})</pre></div>

645

</div>

646

647

New in version 0.9.0.

648

</div>

649

</li>

655

650

</ul>

656

651

</td>

657

652

</tr>

658

653

</tbody>

659

654

</table>

655

656

See also

657

<a class="reference internal" href="../faq.html#faq-sql-expression-string">How do I render SQL expressions as strings, possibly with bound parameters inlined?</a>

658

</div>

660

659

</dd></dl>

661

660

662

661

1046

1045

VALUES clause. This typically refers to Sequence execution but may

1047

1046

also refer to any server-side default generation function

1048

1047

associated with a primary key <cite>Column</cite>.</li>

1048

<li>compile_kwargs<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.CompoundSelect.compile.params.compile_kwargs">¶</a> – optional dictionary of additional parameters

1049

that will be passed through to the compiler within all “visit”

1050

methods. This allows any custom flag to be passed through to

1051

a custom compilation construct, for example. It is also used

1052

for the case of passing the <tt class="docutils literal">literal_binds</tt> flag through:

1053

<div class="highlight-python"><div class="highlight"><pre>from sqlalchemy.sql import table, column, select

1054

1055

t = table('t', column('x'))

1056

1057

s = select([t]).where(t.c.x == 5)

1058

1059

print s.compile(compile_kwargs={"literal_binds": True})</pre></div>

1060

</div>

1061

1062

New in version 0.9.0.

1063

</div>

1064

</li>

1049

1065

</ul>

1050

1066

</td>

1051

1067

</tr>

1052

1068

</tbody>

1053

1069

</table>

1070

1071

See also

1072

<a class="reference internal" href="../faq.html#faq-sql-expression-string">How do I render SQL expressions as strings, possibly with bound parameters inlined?</a>

1073

</div>

1054

1074

</dd></dl>

1055

1075

1056

1076

1202

1222

parts_alias = parts.alias()

1203

1223

included_parts = included_parts.union_all(

1204

1224

select([

1225

parts_alias.c.sub_part,

1205

1226

parts_alias.c.part,

1206

parts_alias.c.sub_part,

1207

1227

parts_alias.c.quantity

1208

1228

]).

1209

1229

where(parts_alias.c.part==incl_alias.c.sub_part)

1213

1233

included_parts.c.sub_part,

1214

1234

func.sum(included_parts.c.quantity).

1215

1235

label('total_quantity')

1216

]). select_from(included_parts.join(parts,

1217

included_parts.c.part==parts.c.part)).\

1236

]).\

1218

1237

group_by(included_parts.c.sub_part)

1219

1238

1220

1239

result = conn.execute(statement).fetchall()</pre></div>

1620

1639

VALUES clause. This typically refers to Sequence execution but may

1621

1640

also refer to any server-side default generation function

1622

1641

associated with a primary key <cite>Column</cite>.</li>

1642

<li>compile_kwargs<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.CTE.compile.params.compile_kwargs">¶</a> – optional dictionary of additional parameters

1643

that will be passed through to the compiler within all “visit”

1644

methods. This allows any custom flag to be passed through to

1645

a custom compilation construct, for example. It is also used

1646

for the case of passing the <tt class="docutils literal">literal_binds</tt> flag through:

1647

<div class="highlight-python"><div class="highlight"><pre>from sqlalchemy.sql import table, column, select

1648

1649

t = table('t', column('x'))

1650

1651

s = select([t]).where(t.c.x == 5)

1652

1653

print s.compile(compile_kwargs={"literal_binds": True})</pre></div>

1654

</div>

1655

1656

New in version 0.9.0.

1657

</div>

1658

</li>

1623

1659

</ul>

1624

1660

</td>

1625

1661

</tr>

1626

1662

</tbody>

1627

1663

</table>

1664

1665

See also

1666

<a class="reference internal" href="../faq.html#faq-sql-expression-string">How do I render SQL expressions as strings, possibly with bound parameters inlined?</a>

1667

</div>

1628

1668

</dd></dl>

1629

1669

1630

1670

2305

2345

VALUES clause. This typically refers to Sequence execution but may

2306

2346

also refer to any server-side default generation function

2307

2347

associated with a primary key <cite>Column</cite>.</li>

2348

<li>compile_kwargs<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.GenerativeSelect.compile.params.compile_kwargs">¶</a> – optional dictionary of additional parameters

2349

that will be passed through to the compiler within all “visit”

2350

methods. This allows any custom flag to be passed through to

2351

a custom compilation construct, for example. It is also used

2352

for the case of passing the <tt class="docutils literal">literal_binds</tt> flag through:

2353

<div class="highlight-python"><div class="highlight"><pre>from sqlalchemy.sql import table, column, select

2354

2355

t = table('t', column('x'))

2356

2357

s = select([t]).where(t.c.x == 5)

2358

2359

print s.compile(compile_kwargs={"literal_binds": True})</pre></div>

2360

</div>

2361

2362

New in version 0.9.0.

2363

</div>

2364

</li>

2308

2365

</ul>

2309

2366

</td>

2310

2367

</tr>

2311

2368

</tbody>

2312

2369

</table>

2370

2371

See also

2372

<a class="reference internal" href="../faq.html#faq-sql-expression-string">How do I render SQL expressions as strings, possibly with bound parameters inlined?</a>

2373

</div>

2313

2374

</dd></dl>

2314

2375

2315

2376

2461

2522

parts_alias = parts.alias()

2462

2523

included_parts = included_parts.union_all(

2463

2524

select([

2525

parts_alias.c.sub_part,

2464

2526

parts_alias.c.part,

2465

parts_alias.c.sub_part,

2466

2527

parts_alias.c.quantity

2467

2528

]).

2468

2529

where(parts_alias.c.part==incl_alias.c.sub_part)

2472

2533

included_parts.c.sub_part,

2473

2534

func.sum(included_parts.c.quantity).

2474

2535

label('total_quantity')

2475

]). select_from(included_parts.join(parts,

2476

included_parts.c.part==parts.c.part)).\

2536

]).\

2477

2537

group_by(included_parts.c.sub_part)

2478

2538

2479

2539

result = conn.execute(statement).fetchall()</pre></div>

3065

3125

VALUES clause. This typically refers to Sequence execution but may

3066

3126

also refer to any server-side default generation function

3067

3127

associated with a primary key <cite>Column</cite>.</li>

3128

<li>compile_kwargs<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.Join.compile.params.compile_kwargs">¶</a> – optional dictionary of additional parameters

3129

that will be passed through to the compiler within all “visit”

3130

methods. This allows any custom flag to be passed through to

3131

a custom compilation construct, for example. It is also used

3132

for the case of passing the <tt class="docutils literal">literal_binds</tt> flag through:

3133

<div class="highlight-python"><div class="highlight"><pre>from sqlalchemy.sql import table, column, select

3134

3135

t = table('t', column('x'))

3136

3137

s = select([t]).where(t.c.x == 5)

3138

3139

print s.compile(compile_kwargs={"literal_binds": True})</pre></div>

3140

</div>

3141

3142

New in version 0.9.0.

3143

</div>

3144

</li>

3068

3145

</ul>

3069

3146

</td>

3070

3147

</tr>

3071

3148

</tbody>

3072

3149

</table>

3150

3151

See also

3152

<a class="reference internal" href="../faq.html#faq-sql-expression-string">How do I render SQL expressions as strings, possibly with bound parameters inlined?</a>

3153

</div>

3073

3154

</dd></dl>

3074

3155

3075

3156

3524

3605

VALUES clause. This typically refers to Sequence execution but may

3525

3606

also refer to any server-side default generation function

3526

3607

associated with a primary key <cite>Column</cite>.</li>

3608

<li>compile_kwargs<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.Select.compile.params.compile_kwargs">¶</a> – optional dictionary of additional parameters

3609

that will be passed through to the compiler within all “visit”

3610

methods. This allows any custom flag to be passed through to

3611

a custom compilation construct, for example. It is also used

3612

for the case of passing the <tt class="docutils literal">literal_binds</tt> flag through:

3613

<div class="highlight-python"><div class="highlight"><pre>from sqlalchemy.sql import table, column, select

3614

3615

t = table('t', column('x'))

3616

3617

s = select([t]).where(t.c.x == 5)

3618

3619

print s.compile(compile_kwargs={"literal_binds": True})</pre></div>

3620

</div>

3621

3622

New in version 0.9.0.

3623

</div>

3624

</li>

3527

3625

</ul>

3528

3626

</td>

3529

3627

</tr>

3530

3628

</tbody>

3531

3629

</table>

3630

3631

See also

3632

<a class="reference internal" href="../faq.html#faq-sql-expression-string">How do I render SQL expressions as strings, possibly with bound parameters inlined?</a>

3633

</div>

3532

3634

</dd></dl>

3533

3635

3534

3636

3783

3885

parts_alias = parts.alias()

3784

3886

included_parts = included_parts.union_all(

3785

3887

select([

3888

parts_alias.c.sub_part,

3786

3889

parts_alias.c.part,

3787

parts_alias.c.sub_part,

3788

3890

parts_alias.c.quantity

3789

3891

]).

3790

3892

where(parts_alias.c.part==incl_alias.c.sub_part)

3794

3896

included_parts.c.sub_part,

3795

3897

func.sum(included_parts.c.quantity).

3796

3898

label('total_quantity')

3797

]). select_from(included_parts.join(parts,

3798

included_parts.c.part==parts.c.part)).\

3899

]).\

3799

3900

group_by(included_parts.c.sub_part)

3800

3901

3801

3902

result = conn.execute(statement).fetchall()</pre></div>

4567

4668

parts_alias = parts.alias()

4568

4669

included_parts = included_parts.union_all(

4569

4670

select([

4671

parts_alias.c.sub_part,

4570

4672

parts_alias.c.part,

4571

parts_alias.c.sub_part,

4572

4673

parts_alias.c.quantity

4573

4674

]).

4574

4675

where(parts_alias.c.part==incl_alias.c.sub_part)

4578

4679

included_parts.c.sub_part,

4579

4680

func.sum(included_parts.c.quantity).

4580

4681

label('total_quantity')

4581

]). select_from(included_parts.join(parts,

4582

included_parts.c.part==parts.c.part)).\

4682

]).\

4583

4683

group_by(included_parts.c.sub_part)

4584

4684

4585

4685

result = conn.execute(statement).fetchall()</pre></div>

4719

4819

VALUES clause. This typically refers to Sequence execution but may

4720

4820

also refer to any server-side default generation function

4721

4821

associated with a primary key <cite>Column</cite>.</li>

4822

<li>compile_kwargs<a class="paramlink headerlink reference internal" href="#sqlalchemy.sql.expression.TableClause.compile.params.compile_kwargs">¶</a> – optional dictionary of additional parameters

4823

that will be passed through to the compiler within all “visit”

4824

methods. This allows any custom flag to be passed through to

4825

a custom compilation construct, for example. It is also used

4826

for the case of passing the <tt class="docutils literal">literal_binds</tt> flag through:

4827

<div class="highlight-python"><div class="highlight"><pre>from sqlalchemy.sql import table, column, select

4828

4829

t = table('t', column('x'))

4830

4831

s = select([t]).where(t.c.x == 5)

4832

4833

print s.compile(compile_kwargs={"literal_binds": True})</pre></div>

4834

</div>

4835

4836

New in version 0.9.0.

4837

</div>

4838

</li>

4722

4839

</ul>

4723

4840

</td>

4724

4841

</tr>

4725

4842

</tbody>

4726

4843

</table>

4844

4845

See also

4846

<a class="reference internal" href="../faq.html#faq-sql-expression-string">How do I render SQL expressions as strings, possibly with bound parameters inlined?</a>

4847

</div>

4727

4848

</dd></dl>

4728

4849

4729

4850