Ejemplos de DocumentMapping.ToUpsertFunction en C# (CSharp)

Ejemplo n.º 1

        public void can_generate_upsert_function_for_95()
        {
            var writer = new StringWriter();

            theHierarchy.ToUpsertFunction().WriteFunctionSql(PostgresUpsertType.Standard, writer);

            var sql = writer.ToString();

            sql.ShouldContain("CREATE OR REPLACE FUNCTION mt_upsert_squad(doc JSONB, docId varchar, docType varchar) RETURNS VOID AS");
            sql.ShouldContain("DO UPDATE SET \"data\" = doc, \"mt_doc_type\" = docType;");
        }