public string GetTableNameWithSchema(string table, RedShiftSchemasEnum schema)
        {
            PropertyInfo tablePropertyInfo = this.GetType().GetProperty(table);

            if (tablePropertyInfo == null)
            {
                throw new ArgumentException("Invalid table");
            }

            bool schemaExist = tablePropertyInfo.GetCustomAttribute <RedShiftSchemasAttribute>().Schemas.Contains(schema);

            if (schemaExist)
            {
                return(schema.ToString() + '.' + tablePropertyInfo.GetCustomAttribute <RedShiftTableNameAttribute>().Name.ToString());
            }
            else
            {
                throw new ArgumentException("Redshift schema don't exist");
            }
        }
Exemple #2
0
        /// <summary>
        /// This method is useful when you want to ADD JOIN clause with existing table. Automatic gets selector parameter expression name as alias.
        /// </summary>
        /// <typeparam name="TSource">Must be class, must implement IAmazonRedshiftTableTranslator inerface and must have public constructor</typeparam>
        /// <typeparam name="T1">First Table (already joined), not joined table</typeparam>
        /// <typeparam name="T2">Second table, which we want to join</typeparam>
        /// <param name="query"></param>
        /// <param name="schema">Schema from RedShiftSchemasEnum.</param>
        /// <param name="selector">Table selector. You MUST select one table only.</param>
        /// <param name="conditionExpression">ON clause.</param>
        /// <param name="leftJoin">left or inner join (default is inner join).</param>
        /// <returns>modified query as string builder</returns>
        public static StringBuilder AddJoinClause <TSource, T1, T2>(this StringBuilder query, RedShiftSchemasEnum schema, Expression <Func <TSource, object> > selector,
                                                                    Expression <Func <T1, T2, bool> > conditionExpression, bool leftJoin = false)
            where TSource : class, IAmazonRedshiftTableTranslator, new()
            where T1 : class
            where T2 : class
        {
            TSource tableTranslator          = new TSource();
            string  alias                    = GetParameterExpressionNameAsAlias(selector);
            IEnumerable <MemberInfo> members = GetExpressionMembers(selector, "Invalid FROM clause");

            if (!members.Any() || members.Count() > 1)
            {
                throw new ArgumentException("Invalid FROM clause");
            }

            query.AppendFormat(" {0} join ", leftJoin ? "left" : "inner");
            query.AppendFormat(" {0}  {1} ", tableTranslator.GetTableNameWithSchema(members.First().Name, schema), alias);
            query.AppendFormat("ON {0} ", GetQueryTranslator().Translate(conditionExpression, useExpressionSelectorAsAlias: true));

            return(query);
        }
Exemple #3
0
        /// <summary>
        /// With this method you can add from clause from existing table.
        /// </summary>
        /// <typeparam name="TSource">Must be class, must implement IAmazonRedshiftTableTranslator inerface and must have public constructor.</typeparam>
        /// <param name="query"></param>
        /// <param name="schema">Schema from RedShiftSchemasEnum.</param>
        /// <param name="selector">You MUST select one table only.</param>
        /// <param name="useExpressionSelectorAsAlias">(use/don't use) alias - example: alias.property expression will be translated to alias.property or just property.</param>
        /// <returns>modified query as string builder</returns>
        public static StringBuilder AddFromClause <TSource>(this StringBuilder query, RedShiftSchemasEnum schema, Expression <Func <TSource, object> > selector, bool useExpressionSelectorAsAlias = false)
            where TSource : class, IAmazonRedshiftTableTranslator, new()
        {
            TSource tableTranslator          = new TSource();
            string  alias                    = (useExpressionSelectorAsAlias == true) ? GetParameterExpressionNameAsAlias(selector) : string.Empty;
            IEnumerable <MemberInfo> members = GetExpressionMembers(selector, "Invalid FROM clause");

            if (!members.Any() || members.Count() > 1)
            {
                throw new ArgumentException("Invalid FROM clause");
            }

            return(query.AppendFormat(" FROM {0} {1} ",
                                      tableTranslator.GetTableNameWithSchema(members.First().Name, schema),
                                      alias));
        }