D 2010-10-29T23:51:13
J +comment \n\n<hr\s/><i>anonymous\sadded\son\s2010-10-29\s23:51:13:</i><br\s/>\nHow\sto\saccess\sfunctions\saccessible\sin\sfossil\sby\sbuilt-in\ssqlite\sshell?\r\n\r\nThanks.\r\n\r\n<pre>\r\nc:\\bin>fossil\shelp\ssqlite\r\nUsage:\sfossil\ssqlite3\s?DATABASE?\s?OPTIONS?\r\nRun\sthe\sstandalone\ssqlite3\scommand-line\sshell\son\sDATABASE\swith\sOPTIONS.\r\nIf\sDATABASE\sis\somitted,\sthen\sthe\srepository\sthat\sserves\sthe\sworking\r\ndirectory\sis\sopened.\r\n\r\nc:\\bin>fossil\ssqlite\smyfossilclone.fossil\r\nSQLite\sversion\s3.7.3\r\nEnter\s".help"\sfor\sinstructions\r\nEnter\sSQL\sstatements\sterminated\swith\sa\s";"\r\nsqlite>\sSELECT\s*\sFROM\ssqlite_master\swhere\sname\s='blob';\r\ntable|blob|blob|2|CREATE\sTABLE\sblob(\r\n\s\srid\sINTEGER\sPRIMARY\sKEY,\r\n\s\srcvid\sINTEGER,\r\n\s\ssize\sINTEGER,\r\n\s\suuid\sTEXT\sUNIQUE\sNOT\sNULL,\r\n\s\scontent\sBLOB,\r\n\s\sCHECK(\slength(uuid)==40\sAND\srid>0\s)\r\n)\r\n\r\nsqlite>\sselect\s*\sfrom\sblob\swhere\srid\s=9310;\r\n9310|526|43735|a67ab11ff47c2c026af817110a564a13fd9c33a2|\r\n\r\nsqlite>\sselect\scontent\sfrom\sblob\swhere\srid\s=9310;\r\nreturns\snothing\r\n</pre>
J resolution Open
K b18338c226f6fb4899bf646accf79cd0bca221a1
U anonymous
Z 2f74b1a42c685d811df896d7cb95560a