Thread: [Sqlalchemy-tickets] =?utf-8?q?=5Bsqlalchemy=5D_=23108=3A_Sequences=2C_autoincrement_and_compa?= =?

Brought to you by: zzzeek

sqlalchemy-tickets

[Sqlalchemy-tickets] =?utf-8?q?=5Bsqlalchemy=5D_=23108=3A_Sequences=2C_autoincrement_and_compa?= =?utf-8?q?ny?=

From: sqlalchemy <mi...@zz...> - 2006-03-10 07:51:17

IzEwODogU2VxdWVuY2VzLCBhdXRvaW5jcmVtZW50IGFuZCBjb21wYW55DQotLS0tLS0tLS0tLS0t
LS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tDQogUmVwb3J0ZXI6ICBndWVzdCAgIHwgICAgICAgT3duZXI6ICB6enplZWsNCiAgICAg
VHlwZTogIGRlZmVjdCAgfCAgICAgIFN0YXR1czogIG5ldyAgIA0KIFByaW9yaXR5OiAgbWFqb3Ig
ICB8ICAgTWlsZXN0b25lOiAgICAgICAgDQpDb21wb25lbnQ6ICAobm9uZSkgIHwgICAgIFZlcnNp
b246ICAgICAgICANCiBLZXl3b3JkczogICAgICAgICAgfCAgDQotLS0tLS0tLS0tLS0tLS0tLS0t
LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
DQpDb25zaWRlciBNeVNRTCB0YWJsZSBsaWtlIHRoaXM6DQoge3t7DQogICBDUkVBVEUgVEFCTEUg
YGNhbXBhaWduc2AgKA0KICAgICBgaWRgIHZhcmNoYXIoMzYpIE5PVCBOVUxMIGRlZmF1bHQgJycs
DQogICAgIGB0cmFja2VyX2tleWAgaW50KDExKSBOT1QgTlVMTCBhdXRvX2luY3JlbWVudCwNCiAg
ICAgYG5hbWVgIHZhcmNoYXIoNTApIGRlZmF1bHQgTlVMTCwNCiAgICAgLi4uDQogICAgIFBSSU1B
UlkgS0VZICAoYGlkYCksDQogICAgIEtFWSBgYXV0b190cmFja2VyX2tleWAgKGB0cmFja2VyX2tl
eWApLA0KICAgKTsNCiB9fX0NCiBJbWFnaW5lIGFsc28gdGhhdCB5b3UgaGF2ZSBgQ2FtcGFpZ25g
IGNsYXNzIGNvbm5lY3RlZCB0byB0aGlzIHRhYmxlIChpZA0KIGNvbHVtbiBoYXMgYHByaW1hcnlf
a2V5ID0gVHJ1ZWApLg0KDQogSWYgeW91IGNyZWF0ZSBuZXcgaW5zdGFuY2Ugb2YgdGhpcyBvYmpl
Y3QgYGNhbSA9IENhbXBhaWduKG5hbWU9J3Rlc3QnKWANCiBhbmQgY29tbWl0LCB5b3Ugd2lsbCBn
ZXQgdGhlIGZvbGxvd2luZzo6DQoge3t7DQogICBjYW0uaWQgIyA1OUwNCiAgIGNhbS50cmFja2Vy
X2tleSAjIE5vbmUNCiB9fX0NCiBXaGljaCBpcyBjbGVhcmx5IHdyb25nLiBJdCBzaG91bGQgYmU6
DQoge3t7DQogICBjYW0uaWQgIyAnJw0KICAgY2FtLnRyYWNrZXJfa2V5ICMgNTlMDQogfX19DQoN
Ci0tIA0KVGlja2V0IFVSTDogPGh0dHA6Ly9zcWxhbGNoZW15Lm9yZy90cmFjL3RpY2tldC8xMDg+
DQpzcWxhbGNoZW15IDxodHRwOi8vZXhhbXBsZS5jb20vPg0KTXkgZXhhbXBsZSBwcm9qZWN0

[Sqlalchemy-tickets] =?utf-8?q?Re=3A_=5Bsqlalchemy=5D_=23108=3A_Sequences=2C_autoincrement_and?= =?utf-8?q?_company?=

From: sqlalchemy <mi...@zz...> - 2006-03-10 15:11:09

IzEwODogU2VxdWVuY2VzLCBhdXRvaW5jcmVtZW50IGFuZCBjb21wYW55DQotLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tDQogIFJlcG9ydGVyOiAgZ3Vlc3QgICAgICAgfCAgICAgICBPd25lcjogIHp6emVlaw0K
ICAgICAgVHlwZTogIGRlZmVjdCAgICAgIHwgICAgICBTdGF0dXM6ICBjbG9zZWQNCiAgUHJpb3Jp
dHk6ICBtYWpvciAgICAgICB8ICAgTWlsZXN0b25lOiAgICAgICAgDQogQ29tcG9uZW50OiAgKG5v
bmUpICAgICAgfCAgICAgVmVyc2lvbjogICAgICAgIA0KUmVzb2x1dGlvbjogIHdvcmtzZm9ybWUg
IHwgICAgS2V5d29yZHM6ICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCkNoYW5nZXMgKGJ5
IHp6emVlayk6DQoNCiAgKiByZXNvbHV0aW9uOiAgPT4gd29ya3Nmb3JtZQ0KICAqIHN0YXR1czog
IG5ldyA9PiBjbG9zZWQNCg0KQ29tbWVudDoNCg0KIGl0IHNlZW1zIGxpa2UgeW91ciBtYXBwZXIg
aXMgbm90IGNvbmZpZ3VyZWQgY29ycmVjdGx5LiAgZnJvbSBhbiBlbmdpbmUNCiBwZXJzcGVjdGl2
ZSBpdCB3b3JrcyBmaW5lLg0KDQogaGVyZXMgb25lIHZlcnNpb24gb2YgYSB0ZXN0IHdpdGggeW91
ciB0YWJsZToNCg0KIHt7ew0KIHQgPSBUYWJsZSgnY2FtcGFpZ25zJywgeCwNCiAgICAgICAgIENv
bHVtbignaWQnLCBTdHJpbmcoMzYpLCBwcmltYXJ5X2tleT1UcnVlKSwNCiAgICAgICAgIENvbHVt
bigndHJhY2tlcl9rZXknLCBJbnRlZ2VyLCBudWxsYWJsZT1GYWxzZSksDQogICAgICAgICBDb2x1
bW4oJ25hbWUnLCBTdHJpbmcoNTApKQ0KICAgICAgICAgKQ0KDQogdC5pbnNlcnQoKS5leGVjdXRl
KGlkPSdpZDInLCBuYW1lPSdyb3cyJykNCiB9fX0NCg0KIHByb2R1Y2VzIHRoZSBxdWVyeToNCiB7
e3sNCiBJTlNFUlQgSU5UTyBjYW1wYWlnbnMgKGlkLCBuYW1lKSBWQUxVRVMgKCVzLCAlcykNCiBb
J2lkMicsICdyb3cyJ10NCiB9fX0NCg0KIGhlcmUgaXQgaXMgdXNpbmcgcmVmbGVjdGlvbjoNCg0K
IHt7ew0KIHQgPSBUYWJsZSgnY2FtcGFpZ25zJywgeCwgYXV0b2xvYWQ9VHJ1ZSkNCg0KIHQuaW5z
ZXJ0KCkuZXhlY3V0ZShpZD0naWQzJywgbmFtZT0ncm93MycpDQoNCiB9fX0NCg0KIHt7ew0KIFNI
T1cgQ1JFQVRFIFRBQkxFIGNhbXBhaWducw0KIHt9DQogZGVzY3JpYmUgY2FtcGFpZ25zDQoge30N
CiBJTlNFUlQgSU5UTyBjYW1wYWlnbnMgKGlkLCBuYW1lKSBWQUxVRVMgKCVzLCAlcykNCiBbJ2lk
MycsICdyb3czJ10NCiB9fX0NCg0KLS0gDQpUaWNrZXQgVVJMOiA8aHR0cDovL3d3dy5zcWxhbGNo
ZW15Lm9yZy90cmFjL3RpY2tldC8xMDg+DQpzcWxhbGNoZW15IDxodHRwOi8vZXhhbXBsZS5jb20v
Pg0KTXkgZXhhbXBsZSBwcm9qZWN0

[Sqlalchemy-tickets] =?utf-8?q?Re=3A_=5Bsqlalchemy=5D_=23108=3A_Sequences=2C_autoincrement_and?= =?utf-8?q?_company?=

From: sqlalchemy <mi...@zz...> - 2006-03-10 17:25:58

IzEwODogU2VxdWVuY2VzLCBhdXRvaW5jcmVtZW50IGFuZCBjb21wYW55DQotLS0tLS0tLS0tLS0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tDQogIFJlcG9ydGVyOiAgZ3Vlc3QgICB8ICAgICAgIE93bmVyOiAgenp6ZWVrICANCiAg
ICAgIFR5cGU6ICBkZWZlY3QgIHwgICAgICBTdGF0dXM6ICByZW9wZW5lZA0KICBQcmlvcml0eTog
IG1ham9yICAgfCAgIE1pbGVzdG9uZTogICAgICAgICAgDQogQ29tcG9uZW50OiAgKG5vbmUpICB8
ICAgICBWZXJzaW9uOiAgICAgICAgICANClJlc29sdXRpb246ICAgICAgICAgIHwgICAgS2V5d29y
ZHM6ICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KQ2hhbmdlcyAoYnkgZ3Vlc3QpOg0K
DQogICogcmVzb2x1dGlvbjogIHdvcmtzZm9ybWUgPT4NCiAgKiBzdGF0dXM6ICBjbG9zZWQgPT4g
cmVvcGVuZWQNCg0KQ29tbWVudDoNCg0KIFllcywgaXQgZ2VuZXJhdGVzIGNvcnJlY3QgcXVlcmll
cywgdGhlIHByb2JsZW0gaXMgcmVmcmVzaGluZyB0aGUgcHl0aG9uDQogaW5zdGFuY2UgdXNpbmcg
YXV0b2dlbmVyYXRlZCBjb2x1bW5zLiBUcnkgdGhpczoNCg0KIHt7ew0KICAgQ1JFQVRFIFRBQkxF
IGBjYW1wc2AgKA0KICAgICBgaWRgIHZhcmNoYXIoMzYpIE5PVCBOVUxMIGRlZmF1bHQgJycsDQog
ICAgIGB0cmFja2VyX2tleWAgaW50KDExKSBOT1QgTlVMTCBhdXRvX2luY3JlbWVudCwNCiAgICAg
YG5hbWVgIHZhcmNoYXIoNTApIGRlZmF1bHQgTlVMTCwNCiAgICAgUFJJTUFSWSBLRVkgIChgaWRg
KSwNCiAgICAgS0VZIGBhdXRvX3RyYWNrZXJfa2V5YCAoYHRyYWNrZXJfa2V5YCkNCiAgICk7DQog
fX19DQogQW5kIHRoZW4gdGhpczoNCiB7e3sNCiB0ID0gVGFibGUoJ2NhbXBzJywgZGJjcm0sDQog
ICAgICAgICBDb2x1bW4oJ2lkJywgU3RyaW5nKDM2KSwgcHJpbWFyeV9rZXk9VHJ1ZSksDQogICAg
ICAgICBDb2x1bW4oJ3RyYWNrZXJfa2V5JywgSW50ZWdlciwgbnVsbGFibGU9RmFsc2UpLA0KICAg
ICAgICAgQ29sdW1uKCduYW1lJywgU3RyaW5nKDUwKSkNCiAgICAgICAgICkNCg0KIGNsYXNzIENh
bXBzKG9iamVjdCk6DQogICAgIHBhc3MNCg0KIGFzc2lnbl9tYXBwZXIoQ2FtcHMsIHQpDQogY2Ft
cCA9IENhbXBzKGlkPSdpZDInLCBuYW1lPSdyb3cyJykNCiBvYmplY3RzdG9yZS5jb21taXQoKQ0K
IH19fQ0KDQogQWxsIGxvb2tzIGZpbmUuIFRoZXJlIGlzIGNvcnJlY3Qgcm93IGluc2lkZSBhIGRh
dGFiYXNlLCBidXQ6DQoNCiB7e3sNCiBjYW1wLmlkICMgImlkMiIgLSBPSw0KIGNhbXAubmFtZSAj
ICJyb3cyIiAtIE9LDQogY2FtcC50cmFja2VyX2tleSAjIE5vbmUgLSBOT1QgT0sNCiB9fX0NCg0K
IElmIHlvdSB0cnk6DQoNCiB7e3sNCiBjYW1wMyA9IENhbXBzKG5hbWU9J3JvdzMnKQ0KIG9iamVj
dHN0b3JlLmNvbW1pdCgpDQoNCiBjYW1wLmlkICMgM0wgLSBOT1QgT0sNCiBjYW1wLm5hbWUgIyAi
cm93MyIgLSBPSw0KIGNhbXAudHJhY2tlcl9rZXkgIyBOb25lIC0gTk9UIE9LDQogfX19DQoNCiBJ
dCB0b29rIGF1dG9nZW5lcmF0ZWQgYHRyYWNrZXJfa2V5YCBhbmQgc3R1ZmZlZCBpbnRvIGBpZGAg
KGJlY2F1c2UgaXQgaXMNCiB0aGUgUEsgaSBndWVzcykuDQoNCi0tIA0KVGlja2V0IFVSTDogPGh0
dHA6Ly9zcWxhbGNoZW15Lm9yZy90cmFjL3RpY2tldC8xMDg+DQpzcWxhbGNoZW15IDxodHRwOi8v
ZXhhbXBsZS5jb20vPg0KTXkgZXhhbXBsZSBwcm9qZWN0

[Sqlalchemy-tickets] =?utf-8?q?Re=3A_=5Bsqlalchemy=5D_=23108=3A_Sequences=2C_autoincrement_and?= =?utf-8?q?_company?=

From: sqlalchemy <mi...@zz...> - 2006-03-10 18:05:30

IzEwODogU2VxdWVuY2VzLCBhdXRvaW5jcmVtZW50IGFuZCBjb21wYW55DQotLS0tLS0tLS0tLS0t
LS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tDQogIFJlcG9ydGVyOiAgZ3Vlc3QgICB8ICAgICAgIE93bmVyOiAgenp6ZWVrDQogICAg
ICBUeXBlOiAgZGVmZWN0ICB8ICAgICAgU3RhdHVzOiAgY2xvc2VkDQogIFByaW9yaXR5OiAgbWFq
b3IgICB8ICAgTWlsZXN0b25lOiAgICAgICAgDQogQ29tcG9uZW50OiAgKG5vbmUpICB8ICAgICBW
ZXJzaW9uOiAgICAgICAgDQpSZXNvbHV0aW9uOiAgZml4ZWQgICB8ICAgIEtleXdvcmRzOiAgICAg
ICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpDaGFuZ2VzIChieSB6enplZWspOg0KDQogICogcmVz
b2x1dGlvbjogID0+IGZpeGVkDQogICogc3RhdHVzOiAgcmVvcGVuZWQgPT4gY2xvc2VkDQoNCkNv
bW1lbnQ6DQoNCiB0aGVyZSBhcmUgc29tZSBjb25mdXNpbmcgZWxlbWVudHMgdG8geW91ciB0ZXN0
LiAgbmFtZWx5IHRoYXQgb24gdGhlIHNlY29uZA0KIHJvdW5kLCB5b3UgYXJlIG5vdCBzcGVjaWZ5
aW5nIGEgcHJpbWFyeSBrZXkgdmFsdWUuICBTUUxBbGNoZW15IHRoZW4NCiBmZXRjaGVzICJjdXJz
b3IubGFzdHJvd2lkIiB3aGljaCBNeVNRTCByZXBvcnRzIGFzIEFVVE9JTkNSRU1FTlQgdGhhdCB3
YXMNCiBwbGFjZWQgaW4gdGhlIG5vbi1wcmltYXJ5IGtleSBjb2x1bW4sIHNjcmV3aW5nIHVwIGV2
ZXJ5dGhpbmcuDQoNCiBzaW5jZSB5b3UgaGF2ZSBubyBkZWZhdWx0IHNwZWNpZmllZCBmb3IgeW91
ciBwcmltYXJ5IGtleSBjb2x1bW4sIHlvdQ0KICptdXN0KiBwdXQgYW4gZXhwbGljaXQgdmFsdWUg
Zm9yIHRoaXMuDQoNCiBBbHNvLCB0aGVyZSBpcyBhbiBhcy15ZXQgdW5kb2N1bWVudGVkIChleGNl
cHQgb24gdGhlIG1haWxpbmcgbGlzdCkgZmVhdHVyZQ0KIGZvciBwb3N0LWZldGNoaW5nIGRiLWdl
bmVyYXRlZCBkZWZhdWx0IHZhbHVlcy4NCg0KIHRoZSB3b3JraW5nIHZlcnNpb24gb2YgdGhlIHBy
b2dyYW0gaXMgYXMgZm9sbG93czoNCg0KIHt7ew0KIGZyb20gc3FsYWxjaGVteSBpbXBvcnQgKg0K
DQogeCA9DQogY3JlYXRlX2VuZ2luZSgnbXlzcWw6Ly9kYj10ZXN0Jmhvc3Q9MTI3LjAuMC4xJnVz
ZXI9c2NvdHQmcGFzc3dkPXRpZ2VyJywNCiBlY2hvPVRydWUpDQoNCiAjIHNwZWNpZnkgUGFzc2l2
ZURlZmF1bHQgb24gInRyYWNrZXJfa2V5IiwgaW5kaWNhdGluZyB0aGF0DQogIyBTUUxBbGNoZW15
IHNob3VsZCBwb3N0LWZldGNoIHRoZSByb3cgdG8gc2VlIHdoYXQgd2FzIGNyZWF0ZWQgYnkgdGhl
IERCDQogdCA9IFRhYmxlKCdjYW1wYWlnbnMnLCB4LA0KICAgICAgICAgIENvbHVtbignaWQnLCBT
dHJpbmcoMzYpLCBwcmltYXJ5X2tleT1UcnVlKSwNCiAgICAgICAgICBDb2x1bW4oJ3RyYWNrZXJf
a2V5JywgSW50ZWdlciwgUGFzc2l2ZURlZmF1bHQoInRyYWNrZXIiKSwNCiBudWxsYWJsZT1GYWxz
ZSApLA0KICAgICAgICAgIENvbHVtbignbmFtZScsIFN0cmluZyg1MCkpDQogICAgICAgICAgKQ0K
DQogdC5kZWxldGUoKS5leGVjdXRlKCkNCg0KIGNsYXNzIENhbXBzKG9iamVjdCk6DQogICAgICAg
ICBwYXNzDQoNCiBhc3NpZ25fbWFwcGVyKENhbXBzLCB0KQ0KIGNhbXAgPSBDYW1wcyhpZD0naWQy
JywgbmFtZT0ncm93MicpDQogb2JqZWN0c3RvcmUuY29tbWl0KCkNCg0KICMgYWxsIGlzIGdvb2QN
CiBwcmludCBjYW1wLmlkDQogcHJpbnQgY2FtcC5uYW1lDQogcHJpbnQgY2FtcC50cmFja2VyX2tl
eQ0KDQoNCiAjIGV4cGxpY2l0IGlkIGlzICpyZXF1aXJlZCosIGJlY2F1c2UgeW91IGhhdmUgbm8g
ZGVmYXVsdCBzZXQgdXANCiAjIGZvciB5b3VyICJpZCIgY29sdW1uIChpLmUuIG5vIEFVVE9JTkNS
RU1FTlQgb3IgYW55dGhpbmcpDQogIyBpZiB5b3UgZG9udCBwdXQgaWQsIE15U1FMIGlzIHJldHVy
bmluZyB0aGUgbnVtYmVyIGZyb20gdGhlIHRyYWNrZXJfa2V5DQogIyBhcyB0aGUgY3Vyc29yICJs
YXN0cm93aWQiLCBnaXZpbmcgU1FMQWxjaGVteSB0aGUgd3JvbmcgdmFsdWUgdG8gcG9zdC0NCiBz
ZWxlY3QNCiBjYW1wMyA9IENhbXBzKGlkPSJpZDMiLCAgbmFtZT0ncm93MycpDQoNCiBvYmplY3Rz
dG9yZS5jb21taXQoKQ0KDQogIyBwcmludCBjYW1wMw0KIHByaW50IGNhbXAzLmlkDQogcHJpbnQg
Y2FtcDMubmFtZQ0KIHByaW50IGNhbXAzLnRyYWNrZXJfa2V5DQogfX19DQoNCi0tIA0KVGlja2V0
IFVSTDogPGh0dHA6Ly93d3cuc3FsYWxjaGVteS5vcmcvdHJhYy90aWNrZXQvMTA4Pg0Kc3FsYWxj
aGVteSA8aHR0cDovL2V4YW1wbGUuY29tLz4NCk15IGV4YW1wbGUgcHJvamVjdA==