SQLite Get Row


Node Information
Returns a single row in the specified table in the specified SQLite database.
General Information
• This node doesn't have other available options.
Visual
Visual

Ports
Text Type DataType Accepts IsList CustomAcception
Database IN Object ONE FALSE FALSE
TableName IN String ONE FALSE FALSE
Row OUT SQLiteRow MULTIPLE FALSE FALSE

Source
namespace Korduene.KGraph.Nodes.Database.SQLite
{
    [IsNode("Get Row")]
    public class GetRow : Node
    {
        Port db = new Port(PortType.IN, typeof(object), AcceptsLinks.ONE, "Database");
        Port tname = new Port(PortType.IN, typeof(string), AcceptsLinks.ONE, "TableName");
        Port colname = new Port(PortType.IN, typeof(string), AcceptsLinks.ONE, "ColumnName");
        Port eq = new Port(PortType.IN, typeof(string), AcceptsLinks.ONE, "Equals");
        Port names = new Port(PortType.OUT, typeof(Korduene.Database.SQLite.SQLiteRow), AcceptsLinks.MULTIPLE, "Row");
        public GetRow()
        {
            NodeType = KGraph.NodeType.Function;
            ReturnType = typeof(Korduene.Database.SQLite.SQLiteRow);
            Name = "SQLite Get Row";
            Dependency = DependencyLibraries.SQLITE;
            AddPort(db);
            AddPort(tname);
            AddPort(names);
            Information = "Returns a single row in the specified table in the specified SQLite database.";
        }
        public override string Code()
        {
            return "return " + GetValue(db) + ".GetRow(" + GetValue(tname) + ", " + GetValue(colname) + ", " + GetValue(eq) + ");";
        }
    }
}