parse_datetime
Next: Introduction, Up: (dir) [Contents][Index]
This manual documents version 1.8 of the GNU recutils.
This manual is for GNU recutils (version 1.8, 3 January 2019).
Copyright © 2009-2019 Jose E. Marchesi
Copyright © 1994-2014 Free Software Foundation, Inc.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the section entitled “GNU Free Documentation License”.
The Basics | ||
---|---|---|
• Introduction: | Introducing recutils. | |
• The Rec Format: | Writing recfiles. | |
Using the Recutils | ||
• Querying Recfiles: | Extracting data from recfiles. | |
• Editing Records: | Inserting and deleting records. | |
• Editing Fields: | Inserting, modifying and deleting fields. | |
Data Integrity | ||
• Field Types: | Restrictions on the values of fields. | |
• Constraints on Record Sets: | Requiring or forbidding specific fields. | |
• Checking Recfiles: | Making sure the data is ok. | |
Advanced Topics | ||
• Remote Descriptors: | Implementing distributed databases. | |
• Grouping and Aggregates: | Statistics. | |
• Queries which Join Records: | Crossing record of different types. | |
• Auto-Generated Fields: | Counters and time-stamps. | |
• Encryption: | Storing sensitive information. | |
• Generating Reports: | Formatted output with templates. | |
• Interoperability: | Importing and exporting to other formats. | |
• Bash Builtins: | Boosting the recutils in the shell. | |
Reference Material | ||
• Invoking the Utilities: | Exhaustive list of command line arguments. | |
• Regular Expressions: | Flavor of regexps supported in recutils. | |
• Date input formats: | Specifying dates and times. | |
• GNU Free Documentation License: | Distribution terms for this document. | |
Indexes | ||
• Concept Index: | ||
— The Detailed Node Listing — ——————————— Here are some other nodes which are really subnodes of the ones already listed, mentioned here so you can get to them in one step: Introduction | ||
• Purpose: | Why recutils. | |
• A Little Example: | Recutils in action. | |
The Rec Format | ||
• Fields: | The key–value pairs which comprise the data. | |
• Records: | The main entities of a recfile. | |
• Comments: | Information for humans’ benefit only. | |
• Record Descriptors: | Describing different types of records. | |
Querying Recfiles | ||
• Simple Selections: | Introducing recsel .
| |
• Selecting by Type: | Get the records of some given type. | |
• Selecting by Position: | Get the record occupying some position. | |
• Random Records: | Get a set of random records. | |
• Selection Expressions: | Get the records satisfying some expression. | |
• Field Expressions: | Selecting a subset of fields. | |
• Sorted Output: | Get the records in a given order. | |
Editing Records | ||
• Inserting Records: | Inserting data into recfiles. | |
• Deleting Records: | Removing entries. | |
• Sorting Records: | Physical reordering of records. | |
Editing Fields | ||
• Setting Fields: | Editing field values. | |
• Adding Fields: | Adding new fields to records. | |
• Deleting Fields: | Removing or commenting-out fields. | |
Field Types | ||
• Declaring Types: | Declaration of types in record descriptors. | |
• Types and Fields: | Associating fields with types. | |
• Scalar Field Types: | Numbers and ranges. | |
• String Field Types: | Lines, limited strings and regular expressions. | |
• Enumerated Field Types: | Enumerations and boolean values. | |
• Date and Time Types: | Dates and times. | |
• Other Field Types: | Emails, fields, UUIDs, … | |
Constraints on Record Sets | ||
• Mandatory Fields: | Requiring the presence of fields. | |
• Prohibited Fields: | Forbidding the presence of fields. | |
• Allowed Fields: | Restricting the presence of fields. | |
• Keys and Unique Fields: | Fields characterizing records. | |
• Size Constraints: | Limiting the size of a record set. | |
• Arbitrary Constraints: | Constraints records must comply with. | |
Checking Recfiles | ||
• Syntactical Errors: | Fixing structure errors in recfiles. | |
• Semantic Errors: | Fixing semantic errors in recfiles. | |
Remote Descriptors Grouping and Aggregates | ||
• Grouping Records: | Combining records by fields. | |
• Aggregate Functions: | Statistics and more. | |
Joins | ||
• Foreign Keys: | Referring records from another records. | |
• Joining Records: | Performing cross-joins. | |
Auto-Generated Fields | ||
• Counters: | Generating incremental Ids. | |
• Unique Identifiers: | Generating universally unique Ids. | |
• Time-Stamps: | Tracking the creation of records. | |
Encryption | ||
• Confidential Fields: | Declaring fields as sensitive data. | |
• Encrypting Files: | Encrypt confidential fields. | |
• Decrypting Data: | Reading encrypted fields. | |
Generating Reports | ||
• Templates: | Formatted output. | |
Interoperability | ||
• CSV Files: | Converting recfiles to/from csv files. | |
• Importing MDB Files: | Importing MS Access Databases. | |
Bash Builtins | ||
• readrec: | Exporting the contents of records to the shell. | |
Invoking the Utilities | ||
• Invoking recinf: | Printing information about rec files. | |
• Invoking recsel: | Selecting records. | |
• Invoking recins: | Inserting records. | |
• Invoking recdel: | Deleting records. | |
• Invoking recset: | Managing fields. | |
• Invoking recfix: | Fixing broken rec files, and diagnostics. | |
• Invoking recfmt: | Formatting records using templates. | |
• Invoking csv2rec: | Converting csv data into rec data. | |
• Invoking rec2csv: | Converting rec data into csv data. | |
• Invoking mdb2rec: | Converting mdb files into rec files. | |
Next: Introduction, Up: (dir) [Contents][Index]