SqliteʵÏÖĬÈÏʱ¼äΪµ±Ç°Ê±¼äÁеķ½·¨
ÔÚSQL ServerÖУ¬´´½¨±í¸ñµÄʱºò£¬¶ÔÓÚʱ¼äÁÐÓÐʱºòÎÒÃÇ¿ÉÒÔ¸ù¾ÝÐèÒªÖ¸¶¨Ä¬ÈÏֵΪµ±Ç°Ê±¼ä£¨Ò²¾ÍÊÇ˵¼Ç¼Éú³ÉµÄʱºòÓÐĬÈϵÄʱ¼ä´Á£©¡£ÀýÈ磺
create table log(
content varchar(256),
logtime datetime default getdate()
)
È»¶øÔÚSqliteÖÐÈçºÎʵÏÖÄØ£¿²éÎĵµµÃÖªSqliteÖв¢Ã»ÓÐgetdate()º¯Êý£¬µ«ÆäϵͳÄÚÖú¯ÊýÓÐdatetime()£¬Òò´ËÄܲ»Äܰ´ÕÕÏÂÃæµÄд·¨ÊµÏÖĬÈÏʱ¼ä´ÁÄØ£º
create table log(
content varchar(256),
logtime datetime default datetime('now')
)
´ð°¸ÊÇ·ñ¶¨µÄ£¬»áÌáʾÓï·¨´íÎó¡£ÄÇôӦ¸ÃÈçºÎÉùÃ÷ÄØ£¿ÈçÏÂËùʾ£º
create table log(
content varchar(256),
logtime TIMESTAMP default CURRENT_TIMESTAMP
)
Õâ¸ö¿ÉÒԴﵽЧ¹û£¬µ«ÊÇĬÈϵÄʱ¼äÊÇÒÔ¸ñÁÖÄáÖαê׼ʱ¼äΪ»ù×¼µÄ£¬Òò´ËÔÚÖйúʹÓõϰ»áÕýºÃÔç8¸öСʱ¡£ÎªÁ˽â¾öÕâ¸öÎÊÌ⣬ÎÒÃÇ¿ÉÒÔÕâÑùÉùÃ÷£º
create table log(
content varchar(256),
logtime TIMESTAMP default (datetime('now', 'localtime'))
)
²âÊÔһϣ¬Ò»ÇÐÕý³££º£©
Ïà¹ØÎĵµ£º
×î½üÓÉÓÚÏîÄ¿ÐèÒª£¬ ÒªÔÚwince4.2, wince5.0, mobileÈýÖÖ»úÐÍÉÏÃæ×ö´óÊý¾ÝÁ¿µÄ²éѯ£¬³õ²½¹À¼ÆÔÚ50W-500WÌõ¼Ç¼֮¼ä¡£
ÓÉÓÚÒÔǰ×ömobile5µÄÊý¾Ý¿âÏîÄ¿Ö÷ÒªÊDzÉÓÃC#À´Ð´£¬¶øÇÒÊý¾ÝÁ¿Ò²¶¥¶à¼¸ÍòÌõ£¬ËùÒÔ£¬ÎªÁËÈ·±£ÏîÄ¿ºóÆÚÉÙ×ßÍä·£¬ÎÒÌØÒâ×öÁËÒ»ÏÂÒÆ¶¯Êý¾Ý¿âÐÔÄܲâÊÔ¡£ÏÂÃæÊÇÕâÖܵŤ×÷¼Ç¼¡£¹©´ó¼Ò²Î¿¼¡£
Ò». ÓÉÓÚwince4.2 ......
¡¾¹¤×÷»·¾³£º»ùÓÚÓÑÉÆÖ®±Ûmini2440¿ª·¢°å+Qtopia2.2°æ±¾+RedHat9+SQLite-3.3.6¡¿
1.QtopiaÖÐʹÓÃSQLite
ÓÉÓÚQt2²»Ö§³ÖÊý¾Ý¿â²Ù×÷£¬£¨Qt3°æ±¾¾ÍÌṩÁËÖ§³ÖÊý¾Ý¿â²Ù×÷µÄÀ࣬µ«ÊÇQtopia2±È½Ï¾µä£¬ÊÇ»ùÓÚQt2µÄ£¬Ã»°ì·¨£¡£©ËùÒÔÔÚQt/Qtopia³ÌÐòÖÐÐèÒªÊý¾Ý¿âʱ£¬¿ÉÒÔ¿¼ÂÇÔÚQtÖÐʹÓÃLinuxϲÙ×÷SQLiteÊý¾Ý¿âµÄ·½·¨¡££¨±í´ïµÄÓе ......
import os
import unittest # °üº¬µ¥Ôª²âÊÔÄ£¿é
import sqlite3 as sqlite # °üº¬sqlite3Ä£¿é
def get_db_path():
return "sqlite_testdb"
class TransactionTests(unittest.TestCase): # µ¥Ôª²âÊÔµÚÒ»²½:¡¡ÓÉTestCaseÅÉÉúÀà
def setUp(self): # µ¥Ôª²âÊÔ»·¾³ÅäÖÃ
......
(1) ÈçºÎ½¨Á¢×Ô¶¯Ôö³¤×Ö¶Î?
¼ò¶Ì»Ø´ð£ºÉùÃ÷Ϊ INTEGER PRIMARY KEY µÄÁн«»á×Ô¶¯Ôö³¤¡£
³¤Ò»µãµÄ´ð°¸£º Èç¹ûÄãÉùÃ÷±íµÄÒ»ÁÐΪ INTEGER PRIMARY KEY£¬ÄÇô£¬ ÿµ±ÄãÔÚ¸ÃÁÐÉϲåÈëÒ»NULLֵʱ£¬ NULL×Ô¶¯±»×ª»»ÎªÒ»¸ö±È¸ÃÁÐÖÐ×î´óÖµ´ó1µÄÒ»¸öÕûÊý£¬Èç¹û±íÊǿյģ¬ ½«»áÊÇ1¡£ (Èç¹ûÊÇ×î´ó¿ÉÄܵÄÖ÷¼ü 9223372036854775807 ......
ÕâЩÌìÒ»Ö±ÔÚæÏúÊÛ¹ÜÀíÈí¼þÒ×Âôͨ¿Í»§¶ËµÄ³ÌÐò±àд£¬ÓÉÓÚÐèÒª²ÉÓñ¾µØÊý¾Ý»º´æ»úÖÆÀ´Ìá¸ß³ÌÐòµÄÊý¾Ý·ÃÎÊЧÂÊ£¬ËùÒÔÐèÒªÔÚ¿Í»§¶ËʹÓÃÒ»¸öСÇɵı¾µØÊý¾Ý¿â¡£Õâ¸öÊý¾Ý¿âµ±È»ÒªÐ¡¶ø¾«º·µÄ¡£ÎÒÒ²²»Ïë×öÇ¿µÁ£¬ÓÚÊǾÍÑ¡ÔñSqlite°É——ÎļþÊý¾Ý¿â£¬Ö»ÒªÒ»¸öSqlite.dll¾Í¿ÉÒÔ²Ù×÷Êý¾Ý¿â¡£
²»µÃ²»³ÃÈ˱¾ÈËÊÇÓеã͵ÀÁ£¬Ad ......