http://sqlite.org/faq.html#q3 <http://sqlite.org/faq.html#q3>
(3) SQLite lets me insert a string into a database column of type integer!
> 在 2015年12月23日，上午1:50，Nathan Edwards <n...@georgetown.edu> 写道：
>
>
> A number of my students used some form of the ForeignKey abuse shown
> below. The first one B(anInt=2,afk=a.id) is pretty benign (though
> unnecessary), but the really strange one is B(anInt=4,afk='Strange!').
> At least with sqlite3 as the backend, this is stored in the database as
> a string (!!!!), even though the schema declares it as an INT and
> formalizes the reference constraint to table A's id (also an INT).
>
> Python 2.7.3, SQLObject version 2.1.2.
>
> from sqlobject import *
>
> class A(SQLObject):
> aFloat = FloatCol()
>
> class B(SQLObject):
> anInt = IntCol()
> afk = ForeignKey("A")
>
> sqlhub.processConnection = connectionForURI('sqlite:test.db3?debug=1')
>
> A.dropTable(ifExists=True)
> B.dropTable(ifExists=True)
> A.createTable()
> B.createTable()
>
> a = A(aFloat=1.0)
>
> b = B(anInt=1,afk=a)
> b = B(anInt=2,afk=a.id)
> b = B(anInt=3,afk=str(a.id))
> # This succeeds and is inserted to sqlite database!
> b = B(anInt=4,afk='Strange!')
> # IntCols are checked!
> # This throws a formencode exception
> # b = B(anInt='a string',afk=a)
>
> for a in A.select():
> print a
> for b in B.select():
> # ValueError exception thrown in attempt to dereference
> print b,b.afk
>
> - n
>
> --
> Dr. Nathan Edwards n...@georgetown.edu
> Department of Biochemistry and Molecular & Cellular Biology
> Georgetown University Medical Center
> Room 1217, Harris Building,
> 3300 Whitehaven St, NW, Washington DC 20007
> Phone: 202-687-7042, Fax: 202-687-0057
>
> ------------------------------------------------------------------------------
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
------------------------------------------------------------------------------
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
