From dc40765aa4c48b802a135ae22f5349f4a9d275de Mon Sep 17 00:00:00 2001 From: Silvio Date: Mon, 29 Mar 2010 12:20:10 -0300 Subject: Adding db schemas and adding sample code --- .gitignore | 4 +- index.php | 194 ++++------------------------------------------------- isis.php | 91 ++++++++++++++++--------- schemas/anu10.yaml | 42 ++++++++++++ schemas/tupi.yaml | 128 +++++++++++++++++++++++++++++++++++ test.php | 190 +++++++++++++++++++++++++++++++++++++++++++++++++++ 6 files changed, 434 insertions(+), 215 deletions(-) create mode 100644 schemas/anu10.yaml create mode 100644 schemas/tupi.yaml create mode 100644 test.php diff --git a/.gitignore b/.gitignore index 0ec7f93..ea134eb 100644 --- a/.gitignore +++ b/.gitignore @@ -1,5 +1,5 @@ *.swp -malete localhost:* db/* -spyc* +contrib/* +tmp/* diff --git a/index.php b/index.php index f5a5704..423485e 100644 --- a/index.php +++ b/index.php @@ -1,191 +1,25 @@ - -Query - - 22, - 'b' => 42, - )); - - // Create a db with field list ("fdt") - $fdt_anu10 = array( - 'Periodico' => 1, - 'Data' => 2, - 'Titulo' => 3, - 'Autor' => 4, - 'Assuntos primarios' => 5, - 'Assuntos secundarios' => 6, - 'Ilustrado' => 7, - 'Caderno' => 8, - 'Pagina' => 9, - 'Arquivo digital' => 10, - 'Forma documento' => 11, - 'Local de publicacao' => 12, - 'Observacoes' => 13, - 'Descritores imagem' => 14, - 'Termo geografico' => 16, - 'Coluna' => 17, - 'Recorte' => 19, - 'Alimentador' => 20, - 'Tema Anuario' => 21, - ); - - $fdt_tupi = array( - 'cod.titulo' => 1, - 'postopo' => 2, - 'num.entrada' => 3, - 'num.tombo' => 4, - 'datain' => 5, - 'dataex' => 6, - 'acervo (DIF ou PRE)' => 7, - 'cadarq' => 10, - 'caddep' => 11, - 'cadddl' => 12, - 'outarq' => 13, - 'categorias' => 15, - 'presok' => 16, - 'roteiro de locução' => 17, - 'mat.acervo' => 18, - 'mat.orig' => 19, - 'titulo' => 20, - 'outros titulos' => 22, - 'data/série' => 24, - 'conteudo/sinopse' => 25, - 'descritores' => 26, - 'descritores secundários' => 27, - 'identidades' => 28, - 'ndxlib' => 29, - 'materiais' => 40, - 'materiais' => 41, - 'materiais' => 42, - 'materiais' => 43, - 'materiais' => 44, - 'materiais' => 45, - 'mat' => 46, - 'mat' => 47, - 'mat' => 48, - 'mat' => 49, - 'mat' => 50, - 'mat' => 51, - 'mat' => 52, - 'mat' => 53, - 'mat' => 54, - 'mat' => 55, - 'evol.estado tec.' => 56, - 'movimentacao' => 57, - 'movimentacao' => 58, - 'obsmat' => 59, - 'producao*' => 60, - 'dir.arte*' => 61, - 'fotografia*' => 62, - 'musica*' => 63, - 'som*' => 64, - 'montagem*' => 65, - 'direcao*' => 66, - 'arg/roteiro*' => 67, - 'distribuicao*' => 68, - 'colab./outros' => 69, - 'producao1' => 70, - 'dir.arte1' => 71, - 'fotografia1' => 72, - 'musica1' => 73, - 'som1' => 74, - 'montagem1' => 75, - 'producao2(res.p/expandir)' => 80, - 'dir.arte2(res.p/expandir)' => 81, - 'fotografia2(res.p/expandir)' => 82, - 'musica2(res.p/expandir)' => 83, - 'som2(res.p/expandir)' => 84, - 'loc.prod.lan' => 85, - 'dat.prod.lan' => 86, - 'lab/est/locacoes' => 87, - 'premios' => 88, - 'fontes' => 89, - 'certificados' => 95, - 'examinador' => 98, - 'observações' => 99, - 'termos geográficos' => 165, - 'quicktime' => 900, - 'revisão' => 901, - 'vídeo' => 902, - ); - - $db = 'tupi'; - //$db = 'anu10'; - $fdt = ${'fdt_'. $db}; - $yaml = Spyc::YAMLDump($fdt); -?> +// Import database classes +require 'isis.php'; -

server

+// Test database connection. +$schema = Spyc::YAMLLoad('schemas/anu10.yaml'); +$db = new MaleteDb($schema); +if ($db) { + $result = $db->read(4); + echo '
';
+  print_r($result);
+  echo '
'; +} -srv->sock) { - echo "could not contact server\n"; - } - else { - //print_r($db); ?> - -

number of records...

- -num_recs($query); - echo "got ",count($recs), " terms for '$query'
\n"; -?> - -

terms beginning with...

- -terms(strtoupper($query)); - echo "got ",count($terms), " terms for '$query'
\n"; - foreach ($terms as $t) { - list($cnt, $term) = explode("\t", $t); - echo "'$term'($cnt) "; - } - echo "
\n"; -?> - -

query reading records

- -query(strtoupper($query)); - echo "got ",count($recs), " records for '$query'
\n"; - foreach ($recs as $r) { - echo "
---\n", $r->toString(), "---\n
\n"; - } -?> - -

query reading a record

- -read(6); - echo "
---\n", $r->toString(), "---\n

\n"; - echo '
';
-    //print_r($r);
-    //print_r($r->val[8]);
-    print_r(preg_split('/\t/', $r->val[7]));
-
-    echo '
'; - } // end else could contact server -?> - - diff --git a/isis.php b/isis.php index 66b3b7d..9c8bbc2 100644 --- a/isis.php +++ b/isis.php @@ -3,27 +3,6 @@ * Database procedures. */ -/** - * Schema format example. - */ -$schema = array( - 'db' => array( - 'name' => 'dbname', - ), - 'fields' => array( - 'field_name' => array( - 'id' => 1, - 'size' => 1000, - 'format' => 'numeric', - 'repeat' => TRUE, - 'subfields' => array( - 'a' => 'test', - 'b' => 'test2', - ), - ), - ), -); - /** * Generic interface for reading Isis databases. */ @@ -32,16 +11,19 @@ interface IsisDb { public function __construct($schema); // Return field data for a given entry. - public function fields($id); + public function fields($id = NULL); // Return subfield data for a given entry. - public function subfields($id); + public function subfields($id = NULL); // Read an entry. public function read($id); // Return number of rows in the database. public function rows(); + + // Return a default example schema. + public function default_schema(); } /** @@ -54,33 +36,76 @@ class MaleteDb implements IsisDb { public function __construct($schema) { // Save db schema. - $format = $schema; + $this->format = $schema; // Setup $fdt used by malete. foreach ($schema['fields'] as $field => $info) { - $fdt[$field] = $info['id']; + $this->fdt[$field] = $info['name']; } // Open a database connection. - $db = new Isis_Db($fdt, $schema['db']['name'], new Isis_Server()); + $this->db = new Isis_Db($this->fdt, $schema['db']['name'], new Isis_Server()); + if (!$this->db->srv->sock) { + return FALSE; + } } - public function fields($id == NULL) { + public function fields($id = NULL) { } - public function subfields($id == NULL) { + public function subfields($id = NULL) { } - // TODO: put result into $schema format. public function read($id) { - if (!is_numeric($id) { + if (!is_numeric($id)) { return FALSE; } - return $this->$db->read($id); + $results = $this->db->read($id); + return $this->tag($results); } public function rows() { } -} -?> + /** + * Schema format example. + */ + public function default_schema() { + $schema = array( + 'db' => array( + 'name' => 'dbname', + ), + 'fields' => array( + 1 => array( + 'name' => 'field_name', + 'size' => 1000, + 'format' => 'numeric', + 'repeat' => TRUE, + 'subfields' => array( + 'a' => 'test', + 'b' => 'test2', + ), + ), + ), + ); + + return $schema; + } + + // Tag results of a db query. + function tag($results) { + foreach ($results->val as $key => $value) { + $field = $results->tag[$key]; + $name = $this->format['fields'][$field]['name']; + + // Handles field repetition. + if ($this->format['fields'][$field]['repeat']) { + $data[$name][] = $value; + } + else { + $data[$name] = $value; + } + } + return $data; + } +} diff --git a/schemas/anu10.yaml b/schemas/anu10.yaml new file mode 100644 index 0000000..77d7c61 --- /dev/null +++ b/schemas/anu10.yaml @@ -0,0 +1,42 @@ +--- +db: + name: anu10 +fields: + 1: + name: Periodico + 2: + name: Data + 3: + name: Titulo + 4: + name: Autor + 5: + name: Assuntos primarios + 6: + name: Assuntos secundarios + 7: + name: Ilustrado + 8: + name: Caderno + 9: + name: Pagina + 10: + name: Arquivo digital + 11: + name: Forma documento + 12: + name: Local de publicacao + 13: + name: Observacoes + 14: + name: Descritores imagem + 16: + name: Termo geografico + 17: + name: Coluna + 19: + name: Recorte + 20: + name: Alimentador + 21: + name: Tema Anuario diff --git a/schemas/tupi.yaml b/schemas/tupi.yaml new file mode 100644 index 0000000..e7904cb --- /dev/null +++ b/schemas/tupi.yaml @@ -0,0 +1,128 @@ +--- +db: + name: tupi +fields: + 1: + name: cod.titulo + 2: + name: postopo + 3: + name: num.entrada + 4: + name: num.tombo + 5: + name: datain + 6: + name: dataex + 7: + name: acervo (DIF ou PRE) + 10: + name: cadarq + 11: + name: caddep + 12: + name: cadddl + 13: + name: outarq + 15: + name: categorias + 16: + name: presok + 17: + name: roteiro de locução + 18: + name: mat.acervo + 19: + name: mat.orig + 20: + name: titulo + 22: + name: outros titulos + 24: + name: data/série + 25: + name: conteudo/sinopse + 26: + name: descritores + 27: + name: descritores secundários + 28: + name: identidades + 29: + name: ndxlib + 45: + name: materiais + 55: + name: mat + 56: + name: evol.estado tec. + 58: + name: movimentacao + 59: + name: obsmat + 60: + name: 'producao*' + 61: + name: 'dir.arte*' + 62: + name: 'fotografia*' + 63: + name: 'musica*' + 64: + name: 'som*' + 65: + name: 'montagem*' + 66: + name: 'direcao*' + 67: + name: 'arg/roteiro*' + 68: + name: 'distribuicao*' + 69: + name: colab./outros + 70: + name: producao1 + 71: + name: dir.arte1 + 72: + name: fotografia1 + 73: + name: musica1 + 74: + name: som1 + 75: + name: montagem1 + 80: + name: producao2(res.p/expandir) + 81: + name: dir.arte2(res.p/expandir) + 82: + name: fotografia2(res.p/expandir) + 83: + name: musica2(res.p/expandir) + 84: + name: som2(res.p/expandir) + 85: + name: loc.prod.lan + 86: + name: dat.prod.lan + 87: + name: lab/est/locacoes + 88: + name: premios + 89: + name: fontes + 95: + name: certificados + 98: + name: examinador + 99: + name: observações + 165: + name: termos geográficos + 900: + name: quicktime + 901: + name: revisão + 902: + name: vídeo diff --git a/test.php b/test.php new file mode 100644 index 0000000..8818c88 --- /dev/null +++ b/test.php @@ -0,0 +1,190 @@ + + +Query + + 22, + 'b' => 42, + )); + + // Create a db with field list ("fdt") + $fdt_anu10 = array( + 'Periodico' => 1, + 'Data' => 2, + 'Titulo' => 3, + 'Autor' => 4, + 'Assuntos primarios' => 5, + 'Assuntos secundarios' => 6, + 'Ilustrado' => 7, + 'Caderno' => 8, + 'Pagina' => 9, + 'Arquivo digital' => 10, + 'Forma documento' => 11, + 'Local de publicacao' => 12, + 'Observacoes' => 13, + 'Descritores imagem' => 14, + 'Termo geografico' => 16, + 'Coluna' => 17, + 'Recorte' => 19, + 'Alimentador' => 20, + 'Tema Anuario' => 21, + ); + + $fdt_tupi = array( + 'cod.titulo' => 1, + 'postopo' => 2, + 'num.entrada' => 3, + 'num.tombo' => 4, + 'datain' => 5, + 'dataex' => 6, + 'acervo (DIF ou PRE)' => 7, + 'cadarq' => 10, + 'caddep' => 11, + 'cadddl' => 12, + 'outarq' => 13, + 'categorias' => 15, + 'presok' => 16, + 'roteiro de locução' => 17, + 'mat.acervo' => 18, + 'mat.orig' => 19, + 'titulo' => 20, + 'outros titulos' => 22, + 'data/série' => 24, + 'conteudo/sinopse' => 25, + 'descritores' => 26, + 'descritores secundários' => 27, + 'identidades' => 28, + 'ndxlib' => 29, + 'materiais' => 40, + 'materiais' => 41, + 'materiais' => 42, + 'materiais' => 43, + 'materiais' => 44, + 'materiais' => 45, + 'mat' => 46, + 'mat' => 47, + 'mat' => 48, + 'mat' => 49, + 'mat' => 50, + 'mat' => 51, + 'mat' => 52, + 'mat' => 53, + 'mat' => 54, + 'mat' => 55, + 'evol.estado tec.' => 56, + 'movimentacao' => 57, + 'movimentacao' => 58, + 'obsmat' => 59, + 'producao*' => 60, + 'dir.arte*' => 61, + 'fotografia*' => 62, + 'musica*' => 63, + 'som*' => 64, + 'montagem*' => 65, + 'direcao*' => 66, + 'arg/roteiro*' => 67, + 'distribuicao*' => 68, + 'colab./outros' => 69, + 'producao1' => 70, + 'dir.arte1' => 71, + 'fotografia1' => 72, + 'musica1' => 73, + 'som1' => 74, + 'montagem1' => 75, + 'producao2(res.p/expandir)' => 80, + 'dir.arte2(res.p/expandir)' => 81, + 'fotografia2(res.p/expandir)' => 82, + 'musica2(res.p/expandir)' => 83, + 'som2(res.p/expandir)' => 84, + 'loc.prod.lan' => 85, + 'dat.prod.lan' => 86, + 'lab/est/locacoes' => 87, + 'premios' => 88, + 'fontes' => 89, + 'certificados' => 95, + 'examinador' => 98, + 'observações' => 99, + 'termos geográficos' => 165, + 'quicktime' => 900, + 'revisão' => 901, + 'vídeo' => 902, + ); + + //$db = 'tupi'; + $db = 'anu10'; + $fdt = ${'fdt_'. $db}; + $yaml = Spyc::YAMLDump($fdt); +?> + +

server

+ +srv->sock) { + echo "could not contact server\n"; + } + else { + //print_r($db); +?> + +

number of records...

+ +num_recs($query); + echo "got ",count($recs), " terms for '$query'
\n"; +?> + +

terms beginning with...

+ +terms(strtoupper($query)); + echo "got ",count($terms), " terms for '$query'
\n"; + foreach ($terms as $t) { + list($cnt, $term) = explode("\t", $t); + echo "'$term'($cnt) "; + } + echo "
\n"; +?> + +

query reading records

+ +query(strtoupper($query)); + echo "got ",count($recs), " records for '$query'
\n"; + foreach ($recs as $r) { + echo "
---\n", $r->toString(), "---\n
\n"; + } +?> + +

query reading a record

+ +read(6); + echo "
---\n", $r->toString(), "---\n

\n"; + echo '
';
+    //print_r($r);
+    //print_r($r->val[8]);
+    //print_r(preg_split('/\t/', $r->val[7]));
+    //print_r(array_flip($fdt_anu10));
+    echo '
'; + } // end else could contact server +?> + -- cgit v1.2.3