[Linpha-cvs] SF.net SVN: linpha: [4877] trunk/misc
Status: Inactive
Brought to you by:
bzrudi
Menu
▾
▴
[Linpha-cvs] SF.net SVN: linpha: [4877] trunk/misc
|
From: <fan...@us...> - 2008-02-13 22:00:31
|
Revision: 4877
http://linpha.svn.sourceforge.net/linpha/?rev=4877&view=rev
Author: fangehrn
Date: 2008-02-13 14:00:22 -0800 (Wed, 13 Feb 2008)
Log Message:
-----------
Modified Paths:
--------------
trunk/misc/benchmark/benchmark.php
Added Paths:
-----------
trunk/misc/datadict/
trunk/misc/datadict/info.txt
trunk/misc/datadict/linpha_schema.xml
trunk/misc/datadict/test_datadict.php
trunk/misc/datadict/test_xml.php
trunk/misc/datadict/test_xmldb.xml
Modified: trunk/misc/benchmark/benchmark.php
===================================================================
--- trunk/misc/benchmark/benchmark.php 2008-02-13 19:01:14 UTC (rev 4876)
+++ trunk/misc/benchmark/benchmark.php 2008-02-13 22:00:22 UTC (rev 4877)
@@ -1,5 +1,18 @@
<?php
+define('LINPHA_DIR','../../linpha2');
+include_once(LINPHA_DIR.'/lib/include/common.php');
+
+/**
+ * some init stuff
+ */
+ require_once(LINPHA_DIR.'/lib/classes/linpha.class.php');
+ global $linpha;
+ $linpha = new Linpha();
+ $linpha->sql->startSession();
+
+
+
function callbackBenchmark()
{
benchmarkConfigTable();
Added: trunk/misc/datadict/info.txt
===================================================================
--- trunk/misc/datadict/info.txt (rev 0)
+++ trunk/misc/datadict/info.txt 2008-02-13 22:00:22 UTC (rev 4877)
@@ -0,0 +1,7 @@
+
+
+some sqlite datadict files (untested):
+
+http://trac.akelos.org/browser/branches/kaste/framework/vendor/adodb/datadict/datadict-sqlite.inc.php?rev=459
+http://trac.phpdoctrine.org/browser/classes/adodb-hack/drivers/sqlite/sqlite_datadict.inc?rev=1
+http://www.xaraya.com/documentation/phpxref/nav.html?xaradodb/datadict/datadict-sqlite.inc.php.source.html
\ No newline at end of file
Added: trunk/misc/datadict/linpha_schema.xml
===================================================================
--- trunk/misc/datadict/linpha_schema.xml (rev 0)
+++ trunk/misc/datadict/linpha_schema.xml 2008-02-13 22:00:22 UTC (rev 4877)
@@ -0,0 +1,332 @@
+<?xml version="1.0"?>
+<schema version="0.3">
+ <table name="linpha2_config">
+ <field name="id" type="I" size="11">
+ <KEY/>
+ <AUTOINCREMENT/>
+
+ </field>
+ <field name="option_name" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="option_value" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="user_id" type="I" size="11">
+ <DEFAULT value="0"/>
+
+ </field>
+ <field name="override" type="I" size="6">
+ <DEFAULT value="0"/>
+ </field>
+ <field name="override2" type="I" size="6">
+ <DEFAULT value="1"/>
+ </field>
+ </table>
+ <table name="linpha2_groups">
+ <field name="id" type="I" size="11">
+ <KEY/>
+ <AUTOINCREMENT/>
+
+ </field>
+ <field name="group_name" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ </table>
+ <table name="linpha2_meta_category">
+ <field name="id" type="I" size="11">
+ <KEY/>
+ <AUTOINCREMENT/>
+
+ </field>
+ <field name="field_id" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="name" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="isprivate" type="I" size="6"/>
+
+ </table>
+ <table name="linpha2_meta_comments">
+ <field name="id" type="I" size="11">
+ <KEY/>
+ <AUTOINCREMENT/>
+ </field>
+ <field name="md5sum" type="C" size="32">
+ <NOTNULL/>
+ </field>
+
+ <field name="meta_time" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="meta_author" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="meta_comment" type="X">
+ <NOTNULL/>
+
+ </field>
+ </table>
+ <table name="linpha2_meta_data">
+ <field name="id" type="I" size="11">
+ <KEY/>
+ <AUTOINCREMENT/>
+ </field>
+ <field name="field_id" type="I" size="11">
+ <NOTNULL/>
+
+ <DEFAULT value="0"/>
+ </field>
+ <field name="md5sum" type="C" size="32">
+ <NOTNULL/>
+ </field>
+ <field name="meta_data" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ </table>
+
+ <table name="linpha2_meta_exif">
+ <field name="md5sum" type="C" size="32">
+ <KEY/>
+ </field>
+ <field name="datetimeoriginal" type="C" size="255"/>
+ <field name="make" type="C" size="255"/>
+ <field name="model" type="C" size="255"/>
+ <field name="artist" type="C" size="255"/>
+ <field name="copyright" type="C" size="255"/>
+
+ <field name="aperturevalue" type="C" size="255"/>
+ <field name="shutterspeedvalue" type="C" size="255"/>
+ <field name="exposuretime" type="C" size="255"/>
+ <field name="flash" type="C" size="255"/>
+ <field name="focallength" type="C" size="255"/>
+ <field name="fnumber" type="C" size="255"/>
+ </table>
+ <table name="linpha2_meta_fields">
+ <field name="id" type="I" size="11">
+
+ <KEY/>
+ <AUTOINCREMENT/>
+ </field>
+ <field name="name" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="field_type" type="I" size="6">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+
+ </field>
+ <field name="flags" type="I" size="6">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ </table>
+ <table name="linpha2_meta_iptc">
+ <field name="md5sum" type="C" size="32">
+ <KEY/>
+
+ </field>
+ </table>
+ <table name="linpha2_meta_xmp">
+ <field name="md5sum" type="C" size="32">
+ <KEY/>
+ </field>
+ </table>
+ <table name="linpha2_permissions">
+ <field name="id" type="I" size="11">
+
+ <KEY/>
+ <AUTOINCREMENT/>
+ </field>
+ <field name="photos_id" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="perm_type" type="C" size="255">
+ <NOTNULL/>
+
+ <DEFAULT value="0"/>
+ </field>
+ <field name="permission" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ </table>
+ <table name="linpha2_photos">
+ <field name="id" type="I" size="11">
+ <KEY/>
+
+ <AUTOINCREMENT/>
+ </field>
+ <field name="parent_id" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="img_type" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+
+ </field>
+ <field name="name" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="md5sum" type="C" size="32">
+ <NOTNULL/>
+ </field>
+ <field name="width" type="I" size="11">
+ <NOTNULL/>
+
+ <DEFAULT value="0"/>
+ </field>
+ <field name="height" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="filesize" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+
+ </field>
+ <field name="time_add" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="time_mod" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+
+ <field name="time_exif" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="rotate" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="stats_numbers" type="I" size="11">
+
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="stats_views" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="stats_downloads" type="I" size="11">
+ <NOTNULL/>
+
+ <DEFAULT value="0"/>
+ </field>
+ <field name="geodata" type="I" size="1">
+ <DEFAULT value="0"/>
+ </field>
+ </table>
+ <table name="linpha2_photos_cache">
+ <field name="id" type="I" size="11">
+ <KEY/>
+
+ <AUTOINCREMENT/>
+ </field>
+ <field name="photo_id" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="img_width" type="I" size="6">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+
+ </field>
+ <field name="img_height" type="I" size="6">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="img_quality" type="I" size="6">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+
+ <field name="img_size" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="is_rotated" type="I" size="6">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="has_watermark" type="I" size="6">
+
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="time_add" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="time_use" type="I" size="11">
+ <NOTNULL/>
+
+ <DEFAULT value="0"/>
+ </field>
+ <field name="time_creating" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ <field name="hits" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+
+ </field>
+ </table>
+ <table name="linpha2_user_group">
+ <field name="id" type="I" size="11">
+ <KEY/>
+ <AUTOINCREMENT/>
+ </field>
+ <field name="group_id" type="I" size="11">
+ <NOTNULL/>
+
+ <DEFAULT value="0"/>
+ </field>
+ <field name="user_id" type="I" size="11">
+ <NOTNULL/>
+ <DEFAULT value="0"/>
+ </field>
+ </table>
+ <table name="linpha2_users">
+ <field name="id" type="I" size="11">
+
+ <KEY/>
+ <AUTOINCREMENT/>
+ </field>
+ <field name="username" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="password" type="C" size="255">
+ <NOTNULL/>
+ </field>
+
+ <field name="user_email" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="display_name" type="C" size="255">
+ <NOTNULL/>
+ </field>
+ <field name="stats_downloads" type="I" size="11">
+ <DEFAULT value="0"/>
+ </field>
+
+ <field name="stats_downloads_size" type="I" size="11">
+ <DEFAULT value="0"/>
+ </field>
+ </table>
+
+ <sql>
+ <descr>Insert some data into the users table.</descr>
+ <query>insert into linpha2_config (option_name, option_value) values ( 'admin', 'true' )</query>
+ <query>insert into linpha2_config (option_name, option_value) values ( 'admin2', 'false' )</query>
+ </sql>
+
+</schema>
\ No newline at end of file
Added: trunk/misc/datadict/test_datadict.php
===================================================================
--- trunk/misc/datadict/test_datadict.php (rev 0)
+++ trunk/misc/datadict/test_datadict.php 2008-02-13 22:00:22 UTC (rev 4877)
@@ -0,0 +1,72 @@
+<?php
+define('LINPHA_DIR','../../linpha2');
+
+error_reporting(E_ALL);
+include_once(LINPHA_DIR.'/lib/adodb/adodb.inc.php');
+
+//$db = &NewADOConnection("mysql://root:test@localhost/linpha2");
+//$db = &NewADOConnection("pgsql://root:test@localhost/linpha2");
+$db = &NewADOConnection("sqlite://sqlite.db");
+
+$db->debug = true;
+
+/*$db->Execute('SET NAMES "UTF8"');
+$db->Execute("SET collation_connection='utf8_general_ci'");
+$db->Execute("SET collation_server='utf8_general_ci'");
+$db->Execute("SET character_set_client='utf8'");
+$db->Execute("SET character_set_connection='utf8'");
+$db->Execute("SET character_set_results='utf8'");
+$db->Execute("SET character_set_server='utf8'");*/
+
+
+# First create a normal connection
+//$db = NewADOConnection('mysql');
+//$db->Connect(...);
+
+# Then create a data dictionary object, using this connection
+$dict = &NewDataDictionary($db);
+
+# We have a portable declarative data dictionary format in ADOdb, similar to SQL.
+# Field types use 1 character codes, and fields are separated by commas.
+# The following example creates three fields: "col1", "col2" and "col3":
+$flds = "
+ event_id I(11) NOTNULL AUTOINCREMENT PRIMARY,
+ event_type I(4) NOTNULL INDEX idx_evt,
+ event_start_date T DEFAULT NULL INDEX id_esd,
+ event_end_date T DEFAULT '0000-00-00 00:00:00' INDEX id_eted,
+ event_parent I(11) UNSIGNED NOTNULL DEFAULT 0 INDEX id_evp,
+ event_owner I(11) DEFAULT 0 INDEX idx_ev1,
+ event_project I(11) DEFAULT 0 INDEX idx_ev1,
+ event_times_recuring I(11) UNSIGNED NOTNULL DEFAULT 0,
+ event_icon C(20) DEFAULT 'obj/event',
+ event_description X
+";
+
+# We demonstrate creating tables and indexes
+$tabname = "datadict_test";
+$idxname = "datadict_indexes";
+$taboptarray = array(
+ 'mysql' => 'ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci',
+ /*'oci8' => 'tablespace users',*/
+ 'REPLACE'
+);
+
+$sqlarray = $dict->CreateTableSQL($tabname, $flds, $taboptarray);
+$dict->ExecuteSQLArray($sqlarray);
+
+/*echo '<pre>';
+print_r($sqlarray);
+echo '</pre>';*/
+
+$col_orig = "event_project";
+$col_ren = "event_project_ren";
+
+$sqlarray = $dict->RenameColumnSQL($tabname,$col_orig,$col_ren,"event_project_ren I(11) DEFAULT 0 INDEX idx_ev1");
+$dict->ExecuteSQLArray($sqlarray);
+
+/*echo '<pre>';
+print_r($sqlarray);
+echo '</pre>';*/
+
+
+?>
\ No newline at end of file
Added: trunk/misc/datadict/test_xml.php
===================================================================
--- trunk/misc/datadict/test_xml.php (rev 0)
+++ trunk/misc/datadict/test_xml.php 2008-02-13 22:00:22 UTC (rev 4877)
@@ -0,0 +1,36 @@
+<?php
+define('LINPHA_DIR','../../linpha2');
+
+error_reporting(E_ALL);
+include_once(LINPHA_DIR.'/lib/adodb/adodb.inc.php');
+
+$db = &NewADOConnection("mysql://root:test@localhost/linpha2");
+//$db = &NewADOConnection("pgsql://root:test@localhost/linpha2");
+//$db = &NewADOConnection("sqlite://sqlite.db");
+
+$db->debug = false;
+
+/*$db->Execute('SET NAMES "UTF8"');
+$db->Execute("SET collation_connection='utf8_general_ci'");
+$db->Execute("SET collation_server='utf8_general_ci'");
+$db->Execute("SET character_set_client='utf8'");
+$db->Execute("SET character_set_connection='utf8'");
+$db->Execute("SET character_set_results='utf8'");
+$db->Execute("SET character_set_server='utf8'");*/
+
+
+/* You must tell the script where to find the ADOdb and
+ * the AXMLS libraries.
+ */
+require( LINPHA_DIR.'/lib/adodb/adodb-xmlschema03.inc.php' );
+
+$schema = new adoSchema( $db );
+$sql = $schema->ParseSchema( 'linpha_schema.xml' );
+$result = $schema->ExecuteSchema();
+
+echo '<pre>';
+print_r($sql);
+echo '</pre>';
+
+//echo $schema->ExtractSchema();
+?>
\ No newline at end of file
Added: trunk/misc/datadict/test_xmldb.xml
===================================================================
--- trunk/misc/datadict/test_xmldb.xml (rev 0)
+++ trunk/misc/datadict/test_xmldb.xml 2008-02-13 22:00:22 UTC (rev 4877)
@@ -0,0 +1,31 @@
+<?xml version="1.0"?>
+<schema version="0.3">
+
+ <table name="users">
+ <desc>A typical users table for our application.</desc>
+ <opt platform="mysql">ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci</opt>
+ <field name="userId" type="I">
+ <descr>A unique ID assigned to each user.</descr>
+
+ <KEY/>
+ <AUTOINCREMENT/>
+ </field>
+
+ <field name="userName" type="C" size="16"><NOTNULL/></field>
+
+
+ <index name="userName">
+ <descr>Put a unique index on the user name</descr>
+ <col>userName</col>
+ <UNIQUE/>
+
+ </index>
+ </table>
+
+ <sql>
+ <descr>Insert some data into the users table.</descr>
+ <query>insert into users (userName) values ( 'admin' )</query>
+
+ <query>insert into users (userName) values ( 'Joe' )</query>
+ </sql>
+</schema>
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
