Gist 8407898

100%

✓ Published0🌍 Public

Last edited Jan 19, 2014

Created on Jan 13, 2014

This example demonstrates a PHP-based synchronization tool for exporting and importing Seenthis messages to and from disk, using SQL queries against a database. The code shows how message data is exported into `.eml` files, including headers like Message-Id, Date, and From, with an option to skip unchanged files via file modification times. It also parses imported `.eml` files, extracting fields such as UUIDs, reply parents, and authorship while creating missing user accounts. The implementation relies on SPIP’s database abstraction layer (`sql_query`, `sql_fetch`, `sql_insertq`) and PHP’s `DateTime` for date handling.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 4434273

This example visualizes the hierarchical structure of database tables and their backup progress as a node-link diagram. It shows how a PHP script recursively traverses MySQL databases and tables, with each node representing a table and links reflecting parent-child relationships. The visualization uses D3.js’s `d3.forceSimulation` for layout and rendering, while the underlying data comes from the script’s output, which logs backup status via `+`, `-`, or error messages. The code explicitly relies on PHP’s `mysql_connect`, `mysql_query`, and `system` calls, alongside `mysqldump` and `gzip`, to generate the backup process that the graph depicts.

PPhilippe Rivière

57% match

Loading thumbnail…

Gist 6701427

This visualization is a step-by-step HTML email template demonstrating 12 best practices for coding robust emails that render consistently across major email clients, including Gmail, Yahoo, Outlook, and Lotus Notes. The example uses nested tables, inline styles, and spacer cells to control layout, with explicit width/height attributes on images and `display:block` to prevent rendering quirks. It illustrates techniques such as treating the outer table as the body, avoiding line-height-sensitive tags, using HTML/CSS mixtures for typography, and adding a "no pictures" fallback header. A sample email structure is shown, with a header, grey shadow box, main content area, and footer, all built from table-based layouts with fixed widths and background colors.

FFasani

51% match

Loading thumbnail…

Gist d2f55e96546318a1e8e393d423ea36e9

This example shows a SQL query that transfers data from one Excel sheet to another, creating a new table in a separate workbook file. The visualization demonstrates how data can be exported or copied between spreadsheet locations using an embedded query. The code uses the `SELECT * INTO` syntax with an `[Excel 8.0;DATABASE=...]` connection string, specifying the destination file path and sheet name. The query pulls all records from the source sheet and writes them to the target workbook, illustrating a straightforward data-migration pattern. The rendering approach relies on the database driver’s handling of the Excel file format, with no additional charting or graphics libraries involved.

HHugoberry

50% match

Loading thumbnail…

Gist 98aa71734dd0d7e9e89fd00440c278c4

This example demonstrates a database-driven player lookup interface, showing how stored player records are retrieved and displayed based on email queries. The code uses the `sqlite3` Node.js library to execute SQL queries, with `getPlayers` fetching all records and `getPlayerByEmail` filtering by a specific email address. The visualization likely renders the resulting name, city, and email data in a table or list format, though the exact visual output is not shown. The implementation relies on promise-based asynchronous database access, where each function returns a promise that resolves with the queried rows, making it suitable for integration with a frontend framework or a simple server response.

WWill Carter

50% match

Loading thumbnail…

Gist e9eac02df35654daa5d0

This example demonstrates a minimal data pipeline that reads JSON data and inserts it into a local SQLite database. The script, `jsonToSqlite.py`, loads a JSON file containing a list of objects, extracts the first object’s `"foo"` and `"bar"` fields, and writes those two values as a single row into a table named `table_name`. It uses the standard `json` module for parsing and `sqlite3` for database operations, creating a table and inserting the data with a parameterized `execute` call. The visualization shows only the code structure, not a graphical output, highlighting the simple ETL pattern of extracting, transforming, and loading data.

CCBasis

49% match

Loading thumbnail…

Outil pour créer une copie locale statique de "mes" seens

Ce script PHP génère une copie locale statique des signets « seens » de Seenthis, en les téléchargeant et les organisant sur le disque dur. Il récupère d'abord tous les fichiers distants listés dans un fichier, en les nommant d'après un hash MD5 de leur URL et en gérant les extensions selon le type MIME détecté (images, documents, HTML, etc.). Ensuite, il découpe le backup XML de l'utilisateur en petits fichiers HTML, créant ainsi une arborescence locale navigable. Le tout fonctionne avec une authentification configurable et produit une copie statique locale, idéale pour être indexée par le système de fichiers ou versionnée avec git.

PPhilippe Rivière

49% match

Loading thumbnail…

Gist 82724

This example shows a minimal Merb application that implements a contact form with server-side validation and email delivery. The visualization maps the request lifecycle, from the controller’s `contact` action handling POST data, through DataMapper model validation, to the `ContactMailer` dispatching a notification email. The code uses Merb’s `Merb::Mailer.config` for SMTP settings and `render_mail` for the mailer template. The gist includes controller, model, mailer, and environment configuration files, but does not include any data visualization—it is purely a code snippet collection, with no charts, graphs, or rendering APIs involved.

DDylanFM

47% match

Loading thumbnail…

Gist 220219

This example shows a web-based import status monitor for a golf offers admin interface. It uses jQuery’s `$.getJSON` to poll a server-side job state and updates the page’s activity area with a spinner, success, or failure message. The animation, a 5-second interval-driven poller, is powered by `setInterval`, while dynamic HTML is injected via the jQuery `html()` method. The code relies on a custom `GAImporter` object and a JSON API, rendering text and icons rather than chart elements.

DDylanFM

47% match