4.4. 資料¶
4.4.1. 接続文字列¶
DB管理システム 接続文字列例 SQLite sqlite://storage.dbMySQL mysql://username:password@localhost/testPostgreSQL postgres://username:password@localhost/testMSSQL mssql://username:password@localhost/testFireBird firebird://username:password@localhost/testOracle oracle://username/password@testDB2 db2://username:password@testIngres ingres://username:password@localhost/testSybase sybase://username:password@localhost/testInformix informix://username:password@testTeradata teradata://DSN=dsn;UID=user;PWD=pass;DATABASE=testCubrid cubrid://username:password@localhost/testSAPDB sapdb://username:password@localhost/testIMAP imap://user:password@server:portMongoDB mongodb://username:password@localhost/testGoogle/SQL google:sql://project:instance/databaseGoogle/NoSQL google:datastoreConnection 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