Example #1
0
 public void Apply(IOneToManyCollectionInstance instance)
 {
     instance.Key.Column(string.Format(CultureInfo.InvariantCulture, "{0}_id",
                                       NameConverter.ConvertName(instance.EntityType.Name)));
     instance.Key.ForeignKey(string.Format(CultureInfo.InvariantCulture, "fk_{0}_{1}",
                                           NameConverter.ConvertName(instance.Member.Name), NameConverter.ConvertName(instance.EntityType.Name)));
 }
        public void Apply(IIdentityInstance instance)
        {
            var sequenceName = string.Format(CultureInfo.InvariantCulture, "{0}_id_seq", NameConverter.ConvertName(instance.EntityType.Name));
            var columnName   = string.Format(CultureInfo.InvariantCulture, "{0}", NameConverter.ConvertName(instance.Property.Name));

            instance.GeneratedBy.Native(sequenceName);
            instance.Column(columnName);
        }
Example #3
0
        public void Apply(IManyToOneInstance instance)
        {
            var entityName = NameConverter.ConvertName(instance.EntityType.Name);
            var columnName = NameConverter.ConvertName(instance.Name);
            var keyName    = string.Format("fk_{0}_{1}", columnName, entityName);

            instance.ForeignKey(keyName);
            instance.Column(string.Format(CultureInfo.InvariantCulture, "{0}_id", columnName));
            instance.Index(string.Format(CultureInfo.InvariantCulture, "ix_{0}_{1}_id", entityName, columnName));
        }
Example #4
0
        public async Task PlayerChart(string name)
        {
            using (var c = new BarcabotDatabaseConnection())
            {
                var playerObject = c.GetPlayerByName(name);

                if (playerObject == null)
                {
                    await Context.Channel.SendMessageAsync(
                        $":warning: Error: Could not find player `{name}`. Are you sure they exist and are a FCB player?\nIf you think there is a player missing from the database please report it to the creator of BarcaBot `Trace#8994`.");
                }
                else
                {
                    var convertedName = NameConverter.ConvertName(playerObject.Name);
                    var stats         = playerObject.Per90Stats;
                    var x             = new ArrayList {
                        "Shots", "Shots on Target", "Key Passes", "Tackles", "Blocks", "Interceptions", "Duels Won", "Dribbles Attempted", "Dribbles Won", "Fouls Drawn", "Fouls Committed"
                    };
                    var y = new ArrayList {
                        stats.Shots.Total, stats.Shots.OnTarget, stats.Passes.KeyPasses, stats.Tackles.TotalTackles, stats.Tackles.Blocks, stats.Tackles.Interceptions, stats.Duels.Won, stats.Dribbles.Attempted, stats.Dribbles.Won, stats.Fouls.Drawn, stats.Fouls.Committed
                    };

                    var chart = new PlotlyChart
                    {
                        Figure = new Figure
                        {
                            Data = new ArrayList {
                                new BarTrace
                                {
                                    X    = x,
                                    Y    = y,
                                    Name = convertedName
                                }
                            },
                            Layout = GetLayout($"{convertedName} Per 90 Stats", false)
                        },
                        Height = 500,
                        Width  = 1000
                    };

                    var chartAsBytes = await _plotlyClient.GetChartAsByteArray(chart);

                    var stream = new MemoryStream(chartAsBytes);

                    await Context.Channel.SendFileAsync(stream, "chart.png");
                }
            }
        }
Example #5
0
        public void Apply(IManyToManyCollectionInstance instance)
        {
            var memberName    = NameConverter.ConvertName(instance.Member.Name);
            var entityName    = NameConverter.ConvertName(instance.EntityType.Name);
            var childTypeName = NameConverter.ConvertName(instance.ChildType.Name);

            var tableName = string.CompareOrdinal(entityName, childTypeName) < 0
                ? string.Format(CultureInfo.InvariantCulture, "{0}_{1}", entityName, childTypeName)
                : string.Format(CultureInfo.InvariantCulture, "{0}_{1}", childTypeName, entityName);
            var keyName         = string.Format(CultureInfo.InvariantCulture, "fk_{0}_{1}", memberName, entityName);
            var otherKeyName    = string.Format(CultureInfo.InvariantCulture, "fk_{0}_{1}", entityName, memberName);
            var columnName      = string.Format(CultureInfo.InvariantCulture, "{0}_id", entityName);
            var otherColumnName = string.Format(CultureInfo.InvariantCulture, "{0}_id", childTypeName);

            instance.Table(tableName);
            instance.Key.Column(columnName);
            instance.Key.ForeignKey(keyName);
            instance.Relationship.Column(otherColumnName);
            instance.Relationship.ForeignKey(otherKeyName);
        }
Example #6
0
        public static string ConvertToCustomName(string propertyName)
        {
            var result = string.Format(CultureInfo.InvariantCulture, "{0}", NameConverter.ConvertName(propertyName));

            return(result);
        }
Example #7
0
        public override string GetComponentColumnPrefix(Member member)
        {
            var result = NameConverter.ConvertName(member.Name) + "_";

            return(result);
        }
Example #8
0
 public void Apply(IClassInstance instance)
 {
     instance.Table(string.Format(CultureInfo.InvariantCulture, "{0}", NameConverter.ConvertName(instance.EntityType.Name)));
 }