69 Members
33 Servers

Load older messages

12 Nov 2020
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> @BLANK please check now, your first choice was available 18:27:20
@tunnelmaster:matrix.orgtunnelmaster [discord] <BLANK> Works, thanks. I'll need to remake the API keys right? 18:27:58
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> you don't need to regenerate them, they are already changed 18:28:28
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> you just need to set the new ones in your editors 18:28:35
@tunnelmaster:matrix.orgtunnelmaster [discord] <BLANK> Ah, alright 18:28:38
@tunnelmaster:matrix.orgtunnelmaster [discord] <BLANK> Thanks again. I don't need to do anything else right? 18:28:57
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> nope, it should work 18:29:09
@tunnelmaster:matrix.orgtunnelmaster [discord] <BLANK> Great 18:29:16
18 Nov 2020
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> welcome @zaoxbkqx 👋 15:52:07
19 Nov 2020
@tunnelmaster:matrix.orgtunnelmaster [discord] <Rain Falls Up> I just had a though that many others probably have had. I think that global leaderboards would be cool for code::stats. Its the perfect way to drive programmers to dump even more of their time into programming 17:17:29
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> yeah it's been talked about many times. the issue is that they would be full of cheaters 17:18:54
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> even just the global "top languages" list that we used to have quickly became useless because people can just add unlimited XP through the API 17:19:27
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> and sometimes that happens by mistake with some editor plugins 17:19:35
@tunnelmaster:matrix.orgtunnelmaster [discord] <Rain Falls Up> Oof yeah, I sorta thought about that 17:21:13
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> one planned feature is groups 17:24:32
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> then you could have group leaderboard because you can always kick out the cheaters 😛 17:24:41
@tunnelmaster:matrix.orgtunnelmaster [discord] <Rain Falls Up> Thats dope 17:30:28
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> but with the current rate, look forward to it in around 5 years 😄 17:30:54
@fperson:tchncs.defpersonyep, cool idea 17:35:22
@tunnelmaster:matrix.orgtunnelmaster [discord] <Rain Falls Up> Ay, fair. Everyone's got lives. Theoretically of course 17:31:32
@fperson:tchncs.defpersonare these groups something public?17:35:34
@fperson:tchncs.defpersonor maybe they can be both public and private17:35:43
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> yeah private and public 17:39:08
20 Nov 2020
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> some work-in-progress query magic from yesterday: 06:19:43
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> ```elixir
@spec update_aliases(t()) :: :ok
def update_aliases(user) do
alias_map = Language.get_alias_map(Repo)
user_aliases = user.aliases |> Enum.reduce(%{}, &Map.put(&2, &1.source_id, &1.target_id))
combined_aliases = Map.merge(alias_map, user_aliases)
{originals, targets} = combined_aliases |> Map.to_list() |> Enum.unzip()

query =
  from(x in XP,
      m in fragment(
        "select * from unnest(?::integer[], ?::integer[]) as m(original_language_id, language_id)",
    on: m.original_language_id == x.original_language_id,
    join: p in Pulse,
    on: x.pulse_id == p.id,
    where: p.user_id == ^user.id and x.language_id != m.language_id,
    select: {p.user_id, x.id, m.original_language_id, x.language_id, m.language_id}
    # update: [set: [language_id: m.language_id]]

IO.inspect(query |> Repo.all())



@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> part of the aliases editor, this will update all of the user's XP rows to match the aliases 06:20:45
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> alias editor is working now. needs some styling though 19:05:56
@tunnelmaster:matrix.orgtunnelmaster [discord] <Nicd> and it's so slow that it needs a loading indicator 😄 19:06:17
21 Nov 2020
@tunnelmaster:matrix.orgtunnelmaster [discord] <Rain Falls Up> Howdy there dbaer! 05:10:32
@tunnelmaster:matrix.orgtunnelmaster [discord] <Rain Falls Up> Welcome to the server 05:10:38

There are no newer messages yet.

Back to Room List