\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{Greg Finzer (GregFinzer)} \pdfinfo{ /Title (gremlin.pdf) /Creator (Cheatography) /Author (Greg Finzer (GregFinzer)) /Subject (Gremlin Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{AED846} \definecolor{LightBackground}{HTML}{F9FCF3} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Gremlin Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{Greg Finzer (GregFinzer)} via \textcolor{DarkBackground}{\uline{cheatography.com/15280/cs/31926/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}Greg Finzer (GregFinzer) \\ \uline{cheatography.com/gregfinzer} \\ \uline{\seqsplit{www.kellermansoftware.com}} \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 29th April, 2022.\\ Updated 29th April, 2022.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{2} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Get a Single Vertex with All Properties Listed}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.V("981b646a-923f-436e-bb39-59bdee568da3").valueMap(true).unfold()} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Get Vertices by a Label}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.V() \newline .hasLabel("Customer") \newline .valueMap(true)} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Get Other Vertices by Outer Edge}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{//Get Invoices for a Customer \newline \%\%gremlin \newline g.V("371285d7-3d78-4e01-8386-87aac4a5b9da") \newline .outE("HAS\_INVOICE") \newline .project("id", "invoiceDate", "invoiceTotal") \newline .by(otherV().id()) \newline .by(otherV().values("invoiceDate")) \newline .by(otherV().values("invoiceTotal")) \newline .toList()} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Get Vertices by Properties}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{//Get all customers with a Beverly Hills shipping zip code that live in an apartment \newline \%\%gremlin \newline g.V() \newline .hasLabel("Customer") \newline .has("ShippingZip", 90210) \newline .has("ShippingAddress", containing("APT")) \newline .valueMap(true)} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Count for a Label}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.V() \newline .hasLabel("Customer") \newline .count()} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Add Vertex and Get The ID}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.addV("Customer") \newline .property("FirstName", "Luke") \newline .property("LastName","Starbucker") \newline .project("id") \newline .by(T.id)} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Update Vertex}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.V("3f3d7d90-8a50-44e0-b6a3-9100ffc1c7d5") \newline .property(Cardinality.single, "FirstName", "Ham") \newline .property(Cardinality.single, "LastName", "Salad")} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Delete Vertex}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.V("f1fd1846-5bc6-4395-af86-77227c500199").drop()} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Get All Property Names for All Vertices}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.V() \newline .properties() \newline .groupCount() \newline .by(key()) \newline .unfold()} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Get All Labels}} \tn \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\%\%gremlin \newline g.V() \newline .groupCount() \newline .by(label()) \newline .unfold()} \tn \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}