forked from mattmakai/fullstackpython.com
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsqlalchemy.html
More file actions
278 lines (278 loc) · 14.9 KB
/
Copy pathsqlalchemy.html
File metadata and controls
278 lines (278 loc) · 14.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
<div class="row">
<div class="c12">
<h3 class="toc-examples"><a href="/sqlalchemy.html">SQLAlchemy</a>:
<a href="/sqlalchemy-extensions-plug-ins-related-libraries.html">Extensions, Plug-ins and Related Libraries</a> &
<a href="/sqlalchemy-code-examples.html">Example Projects and Code</a>
</h3>
<h4 class="bp">sqlalchemy.databases
<a href="/sqlalchemy-databases-mysql-examples.html">mysql</a>
</h4>
<h4 class="bp">sqlalchemy.dialects
<a href="/sqlalchemy-dialects-mssql-examples.html">mssql</a>,
<a href="/sqlalchemy-dialects-mysql-examples.html">mysql</a>,
<a href="/sqlalchemy-dialects-oracle-examples.html">oracle</a>,
<a href="/sqlalchemy-dialects-postgresql-examples.html">postgresql</a>,
<a href="/sqlalchemy-dialects-sqlite-examples.html">sqlite</a>
</h4>
<h4 class="bp">sqlalchemy.dialects.mysql
<a href="/sqlalchemy-dialects-mysql-pymysql-examples.html">pymysql</a>
</h4>
<h4 class="bp">sqlalchemy.dialects.postgresql
<a href="/sqlalchemy-dialects-postgresql-array-examples.html">ARRAY</a>,
<a href="/sqlalchemy-dialects-postgresql-bigint-examples.html">BIGINT</a>,
<a href="/sqlalchemy-dialects-postgresql-bit-examples.html">BIT</a>,
<a href="/sqlalchemy-dialects-postgresql-double-precision-examples.html">DOUBLE_PRECISION</a>,
<a href="/sqlalchemy-dialects-postgresql-excludeconstraint-examples.html">ExcludeConstraint</a>,
<a href="/sqlalchemy-dialects-postgresql-integer-examples.html">INTEGER</a>,
<a href="/sqlalchemy-dialects-postgresql-json-examples.html">JSON</a>,
<a href="/sqlalchemy-dialects-postgresql-tsvector-examples.html">TSVECTOR</a>,
<a href="/sqlalchemy-dialects-postgresql-array-examples.html">array</a>,
<a href="/sqlalchemy-dialects-postgresql-json-examples.html">json</a>,
<a href="/sqlalchemy-dialects-postgresql-pypostgresql-examples.html">pypostgresql</a>
</h4>
<h4 class="bp">sqlalchemy.dialects.postgresql.base
<a href="/sqlalchemy-dialects-postgresql-base-pgcompiler-examples.html">PGCompiler</a>,
<a href="/sqlalchemy-dialects-postgresql-base-pgidentifierpreparer-examples.html">PGIdentifierPreparer</a>,
<a href="/sqlalchemy-dialects-postgresql-base-pgtypecompiler-examples.html">PGTypeCompiler</a>
</h4>
<h4 class="bp">sqlalchemy.dialects.postgresql.psycopg2
<a href="/sqlalchemy-dialects-postgresql-psycopg2-pgdialect-psycopg2-examples.html">PGDialect_psycopg2</a>
</h4>
<h4 class="bp">sqlalchemy.dialects.sqlite
<a href="/sqlalchemy-dialects-sqlite-pysqlite-examples.html">pysqlite</a>
</h4>
<h4 class="bp">sqlalchemy.engine
<a href="/sqlalchemy-engine-connection-examples.html">Connection</a>,
<a href="/sqlalchemy-engine-engine-examples.html">Engine</a>,
<a href="/sqlalchemy-engine-create-engine-examples.html">create_engine</a>,
<a href="/sqlalchemy-engine-default-examples.html">default</a>,
<a href="/sqlalchemy-engine-url-examples.html">url</a>
</h4>
<h4 class="bp">sqlalchemy.engine.default
<a href="/sqlalchemy-engine-default-defaultdialect-examples.html">DefaultDialect</a>
</h4>
<h4 class="bp">sqlalchemy.engine.interfaces
<a href="/sqlalchemy-engine-interfaces-executioncontext-examples.html">ExecutionContext</a>
</h4>
<h4 class="bp">sqlalchemy.engine.result
<a href="/sqlalchemy-engine-result-resultmetadata-examples.html">ResultMetaData</a>,
<a href="/sqlalchemy-engine-result-rowproxy-examples.html">RowProxy</a>
</h4>
<h4 class="bp">sqlalchemy.engine.strategies
<a href="/sqlalchemy-engine-strategies-enginestrategy-examples.html">EngineStrategy</a>,
<a href="/sqlalchemy-engine-strategies-mockenginestrategy-examples.html">MockEngineStrategy</a>
</h4>
<h4 class="bp">sqlalchemy.engine.url
<a href="/sqlalchemy-engine-url-make-url-examples.html">make_url</a>
</h4>
<h4 class="bp">sqlalchemy.events
<a href="/sqlalchemy-events-schemaeventtarget-examples.html">SchemaEventTarget</a>
</h4>
<h4 class="bp">sqlalchemy.exc
<a href="/sqlalchemy-exc-argumenterror-examples.html">ArgumentError</a>,
<a href="/sqlalchemy-exc-dataerror-examples.html">DataError</a>,
<a href="/sqlalchemy-exc-databaseerror-examples.html">DatabaseError</a>,
<a href="/sqlalchemy-exc-integrityerror-examples.html">IntegrityError</a>,
<a href="/sqlalchemy-exc-invalidrequesterror-examples.html">InvalidRequestError</a>,
<a href="/sqlalchemy-exc-noinspectionavailable-examples.html">NoInspectionAvailable</a>,
<a href="/sqlalchemy-exc-nosuchtableerror-examples.html">NoSuchTableError</a>,
<a href="/sqlalchemy-exc-operationalerror-examples.html">OperationalError</a>,
<a href="/sqlalchemy-exc-programmingerror-examples.html">ProgrammingError</a>,
<a href="/sqlalchemy-exc-unsupportedcompilationerror-examples.html">UnsupportedCompilationError</a>
</h4>
<h4 class="bp">sqlalchemy.ext
<a href="/sqlalchemy-ext-compiler-examples.html">compiler</a>
</h4>
<h4 class="bp">sqlalchemy.ext.associationproxy
<a href="/sqlalchemy-ext-associationproxy-associationproxy-examples.html">AssociationProxy</a>
</h4>
<h4 class="bp">sqlalchemy.ext.automap
<a href="/sqlalchemy-ext-automap-automap-base-examples.html">automap_base</a>
</h4>
<h4 class="bp">sqlalchemy.ext.compiler
<a href="/sqlalchemy-ext-compiler-compiles-examples.html">compiles</a>
</h4>
<h4 class="bp">sqlalchemy.ext.declarative
<a href="/sqlalchemy-ext-declarative-declarativemeta-examples.html">DeclarativeMeta</a>,
<a href="/sqlalchemy-ext-declarative-declarative-base-examples.html">declarative_base</a>
</h4>
<h4 class="bp">sqlalchemy.ext.hybrid
<a href="/sqlalchemy-ext-hybrid-hybrid-method-examples.html">HYBRID_METHOD</a>,
<a href="/sqlalchemy-ext-hybrid-hybrid-property-examples.html">HYBRID_PROPERTY</a>,
<a href="/sqlalchemy-ext-hybrid-hybrid-method-examples.html">hybrid_method</a>,
<a href="/sqlalchemy-ext-hybrid-hybrid-property-examples.html">hybrid_property</a>
</h4>
<h4 class="bp">sqlalchemy.ext.mutable
<a href="/sqlalchemy-ext-mutable-mutable-examples.html">Mutable</a>
</h4>
<h4 class="bp">sqlalchemy.inspection
<a href="/sqlalchemy-inspection-inspect-examples.html">inspect</a>
</h4>
<h4 class="bp">sqlalchemy.orm
<a href="/sqlalchemy-orm-columnproperty-examples.html">ColumnProperty</a>,
<a href="/sqlalchemy-orm-compositeproperty-examples.html">CompositeProperty</a>,
<a href="/sqlalchemy-orm-load-examples.html">Load</a>,
<a href="/sqlalchemy-orm-mapper-examples.html">Mapper</a>,
<a href="/sqlalchemy-orm-query-examples.html">Query</a>,
<a href="/sqlalchemy-orm-relationshipproperty-examples.html">RelationshipProperty</a>,
<a href="/sqlalchemy-orm-session-examples.html">Session</a>,
<a href="/sqlalchemy-orm-synonymproperty-examples.html">SynonymProperty</a>,
<a href="/sqlalchemy-orm-aliased-examples.html">aliased</a>,
<a href="/sqlalchemy-orm-attributes-examples.html">attributes</a>,
<a href="/sqlalchemy-orm-backref-examples.html">backref</a>,
<a href="/sqlalchemy-orm-class-mapper-examples.html">class_mapper</a>,
<a href="/sqlalchemy-orm-column-property-examples.html">column_property</a>,
<a href="/sqlalchemy-orm-composite-examples.html">composite</a>,
<a href="/sqlalchemy-orm-interfaces-examples.html">interfaces</a>,
<a href="/sqlalchemy-orm-mapper-examples.html">mapper</a>,
<a href="/sqlalchemy-orm-mapperlib-examples.html">mapperlib</a>,
<a href="/sqlalchemy-orm-object-mapper-examples.html">object_mapper</a>,
<a href="/sqlalchemy-orm-object-session-examples.html">object_session</a>,
<a href="/sqlalchemy-orm-query-examples.html">query</a>,
<a href="/sqlalchemy-orm-relationship-examples.html">relationship</a>,
<a href="/sqlalchemy-orm-session-examples.html">session</a>,
<a href="/sqlalchemy-orm-sessionmaker-examples.html">sessionmaker</a>,
<a href="/sqlalchemy-orm-strategies-examples.html">strategies</a>
</h4>
<h4 class="bp">sqlalchemy.orm.attributes
<a href="/sqlalchemy-orm-attributes-instrumentedattribute-examples.html">InstrumentedAttribute</a>,
<a href="/sqlalchemy-orm-attributes-queryableattribute-examples.html">QueryableAttribute</a>,
<a href="/sqlalchemy-orm-attributes-flag-modified-examples.html">flag_modified</a>
</h4>
<h4 class="bp">sqlalchemy.orm.collections
<a href="/sqlalchemy-orm-collections-instrumentedlist-examples.html">InstrumentedList</a>
</h4>
<h4 class="bp">sqlalchemy.orm.exc
<a href="/sqlalchemy-orm-exc-noresultfound-examples.html">NoResultFound</a>,
<a href="/sqlalchemy-orm-exc-unmappedclasserror-examples.html">UnmappedClassError</a>,
<a href="/sqlalchemy-orm-exc-unmappedinstanceerror-examples.html">UnmappedInstanceError</a>
</h4>
<h4 class="bp">sqlalchemy.orm.interfaces
<a href="/sqlalchemy-orm-interfaces-mapperproperty-examples.html">MapperProperty</a>,
<a href="/sqlalchemy-orm-interfaces-propcomparator-examples.html">PropComparator</a>
</h4>
<h4 class="bp">sqlalchemy.orm.mapper
<a href="/sqlalchemy-orm-mapper-mapper-examples.html">Mapper</a>
</h4>
<h4 class="bp">sqlalchemy.orm.properties
<a href="/sqlalchemy-orm-properties-columnproperty-examples.html">ColumnProperty</a>,
<a href="/sqlalchemy-orm-properties-relationshipproperty-examples.html">RelationshipProperty</a>
</h4>
<h4 class="bp">sqlalchemy.orm.query
<a href="/sqlalchemy-orm-query-query-examples.html">Query</a>,
<a href="/sqlalchemy-orm-query-querycontext-examples.html">QueryContext</a>
</h4>
<h4 class="bp">sqlalchemy.orm.relationships
<a href="/sqlalchemy-orm-relationships-relationshipproperty-examples.html">RelationshipProperty</a>
</h4>
<h4 class="bp">sqlalchemy.orm.session
<a href="/sqlalchemy-orm-session-session-examples.html">Session</a>,
<a href="/sqlalchemy-orm-session-object-session-examples.html">object_session</a>
</h4>
<h4 class="bp">sqlalchemy.orm.util
<a href="/sqlalchemy-orm-util-aliasedclass-examples.html">AliasedClass</a>,
<a href="/sqlalchemy-orm-util-aliasedinsp-examples.html">AliasedInsp</a>,
<a href="/sqlalchemy-orm-util-identity-key-examples.html">identity_key</a>
</h4>
<h4 class="bp">sqlalchemy.pool
<a href="/sqlalchemy-pool-nullpool-examples.html">NullPool</a>,
<a href="/sqlalchemy-pool-staticpool-examples.html">StaticPool</a>
</h4>
<h4 class="bp">sqlalchemy.schema
<a href="/sqlalchemy-schema-checkconstraint-examples.html">CheckConstraint</a>,
<a href="/sqlalchemy-schema-column-examples.html">Column</a>,
<a href="/sqlalchemy-schema-createindex-examples.html">CreateIndex</a>,
<a href="/sqlalchemy-schema-createtable-examples.html">CreateTable</a>,
<a href="/sqlalchemy-schema-ddlelement-examples.html">DDLElement</a>,
<a href="/sqlalchemy-schema-foreignkey-examples.html">ForeignKey</a>,
<a href="/sqlalchemy-schema-foreignkeyconstraint-examples.html">ForeignKeyConstraint</a>,
<a href="/sqlalchemy-schema-index-examples.html">Index</a>,
<a href="/sqlalchemy-schema-primarykeyconstraint-examples.html">PrimaryKeyConstraint</a>,
<a href="/sqlalchemy-schema-table-examples.html">Table</a>
</h4>
<h4 class="bp">sqlalchemy.sql
<a href="/sqlalchemy-sql-clauseelement-examples.html">ClauseElement</a>,
<a href="/sqlalchemy-sql-select-examples.html">Select</a>,
<a href="/sqlalchemy-sql-column-examples.html">column</a>,
<a href="/sqlalchemy-sql-expression-examples.html">expression</a>,
<a href="/sqlalchemy-sql-extract-examples.html">extract</a>,
<a href="/sqlalchemy-sql-functions-examples.html">functions</a>,
<a href="/sqlalchemy-sql-operators-examples.html">operators</a>,
<a href="/sqlalchemy-sql-schema-examples.html">schema</a>,
<a href="/sqlalchemy-sql-select-examples.html">select</a>,
<a href="/sqlalchemy-sql-sqltypes-examples.html">sqltypes</a>,
<a href="/sqlalchemy-sql-table-examples.html">table</a>
</h4>
<h4 class="bp">sqlalchemy.sql.compiler
<a href="/sqlalchemy-sql-compiler-sqlcompiler-examples.html">SQLCompiler</a>
</h4>
<h4 class="bp">sqlalchemy.sql.elements
<a href="/sqlalchemy-sql-elements-columnelement-examples.html">ColumnElement</a>,
<a href="/sqlalchemy-sql-elements-label-examples.html">Label</a>
</h4>
<h4 class="bp">sqlalchemy.sql.expression
<a href="/sqlalchemy-sql-expression-clauseelement-examples.html">ClauseElement</a>,
<a href="/sqlalchemy-sql-expression-columnclause-examples.html">ColumnClause</a>,
<a href="/sqlalchemy-sql-expression-columnelement-examples.html">ColumnElement</a>,
<a href="/sqlalchemy-sql-expression-executable-examples.html">Executable</a>,
<a href="/sqlalchemy-sql-expression-functionelement-examples.html">FunctionElement</a>,
<a href="/sqlalchemy-sql-expression-unaryexpression-examples.html">UnaryExpression</a>
</h4>
<h4 class="bp">sqlalchemy.sql.functions
<a href="/sqlalchemy-sql-functions-functionelement-examples.html">FunctionElement</a>,
<a href="/sqlalchemy-sql-functions-genericfunction-examples.html">GenericFunction</a>
</h4>
<h4 class="bp">sqlalchemy.sql.naming
<a href="/sqlalchemy-sql-naming-conv-examples.html">conv</a>
</h4>
<h4 class="bp">sqlalchemy.sql.schema
<a href="/sqlalchemy-sql-schema-column-examples.html">Column</a>,
<a href="/sqlalchemy-sql-schema-schemaitem-examples.html">SchemaItem</a>
</h4>
<h4 class="bp">sqlalchemy.sql.sqltypes
<a href="/sqlalchemy-sql-sqltypes-nulltype-examples.html">NULLTYPE</a>,
<a href="/sqlalchemy-sql-sqltypes-nulltype-examples.html">NullType</a>
</h4>
<h4 class="bp">sqlalchemy.sql.util
<a href="/sqlalchemy-sql-util-clauseadapter-examples.html">ClauseAdapter</a>
</h4>
<h4 class="bp">sqlalchemy.sql.visitors
<a href="/sqlalchemy-sql-visitors-traverse-examples.html">traverse</a>
</h4>
<h4 class="bp">sqlalchemy.types
<a href="/sqlalchemy-types-boolean-examples.html">BOOLEAN</a>,
<a href="/sqlalchemy-types-boolean-examples.html">Boolean</a>,
<a href="/sqlalchemy-types-date-examples.html">DATE</a>,
<a href="/sqlalchemy-types-datetime-examples.html">DATETIME</a>,
<a href="/sqlalchemy-types-date-examples.html">Date</a>,
<a href="/sqlalchemy-types-datetime-examples.html">DateTime</a>,
<a href="/sqlalchemy-types-enum-examples.html">Enum</a>,
<a href="/sqlalchemy-types-float-examples.html">FLOAT</a>,
<a href="/sqlalchemy-types-float-examples.html">Float</a>,
<a href="/sqlalchemy-types-integer-examples.html">INTEGER</a>,
<a href="/sqlalchemy-types-integer-examples.html">Integer</a>,
<a href="/sqlalchemy-types-interval-examples.html">Interval</a>,
<a href="/sqlalchemy-types-nulltype-examples.html">NULLTYPE</a>,
<a href="/sqlalchemy-types-nulltype-examples.html">NullType</a>,
<a href="/sqlalchemy-types-string-examples.html">String</a>,
<a href="/sqlalchemy-types-text-examples.html">TEXT</a>,
<a href="/sqlalchemy-types-time-examples.html">TIME</a>,
<a href="/sqlalchemy-types-text-examples.html">Text</a>,
<a href="/sqlalchemy-types-time-examples.html">Time</a>,
<a href="/sqlalchemy-types-typeengine-examples.html">TypeEngine</a>,
<a href="/sqlalchemy-types-userdefinedtype-examples.html">UserDefinedType</a>,
<a href="/sqlalchemy-types-to-instance-examples.html">to_instance</a>
</h4>
<h4 class="bp">sqlalchemy.util
<a href="/sqlalchemy-util-ordereddict-examples.html">OrderedDict</a>,
<a href="/sqlalchemy-util-orderedset-examples.html">OrderedSet</a>,
<a href="/sqlalchemy-util-set-creation-order-examples.html">set_creation_order</a>,
<a href="/sqlalchemy-util-symbol-examples.html">symbol</a>,
<a href="/sqlalchemy-util-topological-examples.html">topological</a>
</h4>
<h4 class="bp">sqlalchemy.util.langhelpers
<a href="/sqlalchemy-util-langhelpers-public-factory-examples.html">public_factory</a>,
<a href="/sqlalchemy-util-langhelpers-symbol-examples.html">symbol</a>
</h4>
</div>
</div>