4.4. 資料¶
4.4.1. 接続文字列¶
DB管理システム 接続文字列例 SQLite sqlite://storage.db
MySQL mysql://username:password@localhost/test
PostgreSQL postgres://username:password@localhost/test
MSSQL mssql://username:password@localhost/test
FireBird firebird://username:password@localhost/test
Oracle oracle://username/password@test
DB2 db2://username:password@test
Ingres ingres://username:password@localhost/test
Sybase sybase://username:password@localhost/test
Informix informix://username:password@test
Teradata teradata://DSN=dsn;UID=user;PWD=pass;DATABASE=test
Cubrid cubrid://username:password@localhost/test
SAPDB sapdb://username:password@localhost/test
IMAP imap://user:password@server:port
MongoDB mongodb://username:password@localhost/test
Google/SQL google:sql://project:instance/database
Google/NoSQL google:datastore
Connection Strings | 接続文字列 より
4.4.2. フィールドタイプ毎のデフォルト・バリデータ¶
field type default field validators string IS_LENGTH(length) …default length is 512 text IS_LENGTH(65536) blob None boolean None integer IS_INT_IN_RANGE(-1e100, 1e100) double IS_FLOAT_IN_RANGE(-1e100, 1e100) decimal(n,m) IS_DECIMAL_IN_RANGE(-1e100, 1e100) date IS_DATE() time IS_TIME() datetime IS_DATETIME() password None upload None reference <table> IS_IN_DB(db,’<table>.id’) list:string None list:integer None list:reference <table> IS_IN_DB(db,’<table>.id’,multiple=True) json IS_JSON() bigint None big-id None big-reference None