use std::mem;
use std::time::Duration;
use crate::database::error::DatabaseError;
use chrono::{DateTime, NaiveDate, TimeZone, Utc};
use proto::touchpad::common::v1::{Event, EventTime, EventTimeResult, Gender, individual_event, IndividualEvent, relay_event, RelayEvent, Stroke, SwimMeet, Swimmer, Team};
use sqlx::postgres::{PgPool, PgPoolOptions, PgQueryResult};
use proto::ProtoTimestamp;
use proto::touchpad::common::v1;

pub struct PostgresClient {
    pool: PgPool,
}

impl PostgresClient {
    pub async fn new<S: AsRef<str>>(url: S) -> Result<PostgresClient, sqlx::Error> {
        Ok(PostgresClient {
            pool: PgPoolOptions::new().connect(url.as_ref()).await?,
        })
    }
}

#[async_trait::async_trait]
impl super::DatabaseClient for PostgresClient {
    async fn get_swimmer(&self, id: u32) -> Result<Swimmer, DatabaseError> {
        let swimmer: SwimmersTableSchema = sqlx::query_as!(
            SwimmersTableSchema,
            "SELECT * FROM swimmers WHERE id = $1;",
            id as i32
        )
            .fetch_one(&self.pool)
            .await?;

        Ok(Swimmer {
            id,
            name: swimmer.name,
            gender: Gender::from_iso_5218(swimmer.gender as u8) as i32,
        })
    }

    async fn add_swimmer(&self, swimmer: &Swimmer) -> Result<(), DatabaseError> {
        let gender = Gender::from_i32(swimmer.gender)
            .ok_or(DatabaseError::BadInput("Invalid gender".into()))?
            .to_iso_5218();

        sqlx::query!(
            "INSERT INTO swimmers VALUES ($1, $2, $3);",
            swimmer.id as i32,
            swimmer.name,
            gender as i16
        )
            .execute(&self.pool)
            .await?;

        Ok(())
    }

    async fn get_team(&self, id: u32) -> crate::database::Result<Team> {
        let team: TeamsTableSchema = sqlx::query_as!(
            TeamsTableSchema,
            "SELECT * FROM teams WHERE id = $1;",
            id as i32
        )
            .fetch_one(&self.pool)
            .await?;

        Ok(Team {
            id,
            name: team.name,
        })
    }

    async fn add_team(&self, team: &Team) -> crate::database::Result<()> {
        sqlx::query!(
            "INSERT INTO teams VALUES ($1, $2);",
            team.id as i32,
            team.name
        )
            .execute(&self.pool)
            .await?;

        Ok(())
    }

    async fn get_meet(&self, id: u32) -> crate::database::Result<SwimMeet> {
        let mut meet: Vec<GetMeetSchema> = sqlx::query_as!(
            GetMeetSchema,
            "
SELECT meets.name as meet_name, start_date, end_date, team_id, t.name as team_name
FROM meets
INNER JOIN meets_teams mt on meets.id = mt.meet_id
INNER JOIN teams t on mt.team_id = t.id
WHERE meets.id = $1;
",
            id as i32
        )
            .fetch_all(&self.pool)
            .await?;

        let meet_name = mem::take(&mut meet.get_mut(0).ok_or(DatabaseError::NotFound)?.meet_name);
        let start = meet.get(0).ok_or(DatabaseError::NotFound)?.start_date.and_hms(0, 0, 0);
        let end = meet.get(0).ok_or(DatabaseError::NotFound)?.end_date.and_hms(0, 0, 0);

        let teams = meet.into_iter()
            .map(|m| Team {
                id: m.team_id as u32,
                name: m.team_name,
            })
            .collect();

        Ok(SwimMeet {
            id,
            meet_name,
            start: Some(Utc.from_utc_datetime(&start).into()),
            end: Some(Utc.from_utc_datetime(&end).into()),
            teams,
            points: Default::default(),
        })
    }

    async fn add_meet(&self, meet: &SwimMeet) -> crate::database::Result<()> {
        let mut tx = self.pool.begin().await?;

        // Convert protobuf timestamp into chrono Datetime
        let start_date: DateTime<Utc> = {
            let proto_timestamp: ProtoTimestamp = meet.start.clone()
                .ok_or(DatabaseError::BadInput("empty start date".into()))?
                .into();
            proto_timestamp.into()
        };

        let end_date: DateTime<Utc> = {
            let proto_timestamp: ProtoTimestamp = meet.end.clone()
                .ok_or(DatabaseError::BadInput("empty end date".into()))?
                .into();
            proto_timestamp.into()
        };

        // Insert into meets table
        sqlx::query!(
            "INSERT INTO meets VALUES ($1, $2, $3, $4)",
            meet.id as i32,
            meet.meet_name,
            start_date.date_naive(),
            end_date.date_naive(),
        )
            .execute(&mut tx)
            .await?;

        for team in &meet.teams {
            sqlx::query!(
                "INSERT INTO teams VALUES ($1, $2) ON CONFLICT DO NOTHING",
                team.id as i32,
                team.name,
            )
                .execute(&mut tx)
                .await?;

            sqlx::query!(
                "INSERT INTO meets_teams VALUES ($1, $2)",
                meet.id as i32,
                team.id as i32,
            )
                .execute(&mut tx)
                .await?;
        }

        tx.commit().await?;

        Ok(())
    }

    async fn get_event(&self, id: u32) -> crate::database::Result<Event> {
        let event: Vec<GetEventSchema> = sqlx::query_as!(
            GetEventSchema,
"
SELECT *
FROM events e
LEFT JOIN timings t on e.id = t.event_id
WHERE e.id = $1;
",
            id as i32,
        )
            .fetch_all(&self.pool)
            .await?;

        db_event_to_proto(event)
    }

    async fn get_event_by_number(&self, meet_id: u32, number: u32) -> crate::database::Result<Event> {
        let event: Vec<GetEventSchema> = sqlx::query_as!(
            GetEventSchema,
"
SELECT *
FROM events e
LEFT JOIN timings t on e.id = t.event_id
WHERE e.meet_id = $1 AND e.event_num = $2;
",
            meet_id as i32,
            number as i32,
        )
            .fetch_all(&self.pool)
            .await?;

        db_event_to_proto(event)
    }

    async fn add_event(&self, event: &Event) -> crate::database::Result<()> {
        let mut tx = self.pool.begin().await?;

        let stroke = Stroke::from_i32(event.stroke)
            .ok_or(DatabaseError::BadInput("invalid stroke".into()))?;
        let gender = Gender::from_i32(event.gender)
            .ok_or(DatabaseError::BadInput("invalid gender".into()))?
            .to_iso_5218();

        sqlx::query!(
            "INSERT INTO events VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9);",
            event.id as i32,
            event.meet_id as i32,
            event.event_num as i16,
            event.age_lo as i16,
            event.age_hi as i16,
            event.distance as i32,
            stroke as i16,
            gender as i16,
            event.is_relay
        )
            .execute(&mut tx)
            .await?;

        match &event.event {
            Some(v1::event::Event::Individual(ev)) => {
                for t in &ev.times {
                    if let Some(time) = &t.time {
                        insert_event_timing(
                            &mut tx,
                            time,
                            None,
                            Some(t.swimmer_id),
                        ).await?;
                    }
                }
            }
            Some(v1::event::Event::Relay(ev)) => {
                for t in &ev.times {
                    if let Some(time) = &t.time {
                        insert_event_timing(
                            &mut tx,
                            time,
                            Some(&t.name),
                            None,
                        ).await?;
                    }
                }
            }
            None => {}
        }

        tx.commit().await?;

        Ok(())
    }
}

struct SwimmersTableSchema {
    id: i32,
    name: String,
    gender: i16,
}

struct TeamsTableSchema {
    id: i32,
    name: String,
}

struct GetMeetSchema {
    meet_name: String,
    start_date: NaiveDate,
    end_date: NaiveDate,
    team_id: i32,
    team_name: String,
}

struct GetEventSchema {
    id: i32,
    meet_id: i32,
    event_num: i16,
    age_lo: i16,
    age_hi: i16,
    distance: i32,
    stroke: i16,
    gender: i16,
    is_relay: bool,

    name: Option<String>,
    swimmer_id: Option<i32>,
    event_id: i32,
    team_id: i32,
    heat: i16,
    lane: i16,
    result: i16,
    final_time: Option<i64>,
    seed_time: Option<i64>,
    rank: i16,
    points: f32,
}

fn db_event_to_proto(event: Vec<GetEventSchema>) -> crate::database::Result<Event> {
    let first = event.first().ok_or(DatabaseError::NotFound)?;

    let mut proto_event = Event {
        id: first.event_id as u32,
        meet_id: first.meet_id as u32,
        event_num: first.event_num as u32,
        age_lo: first.age_lo as u32,
        age_hi: first.age_hi as u32,
        distance: first.distance as u32,
        stroke: Stroke::from_i32(first.stroke as i32).unwrap_or_default() as i32,
        gender: Gender::from_iso_5218(first.stroke as u8) as i32,
        is_relay: first.is_relay,
        event: None,
    };

    if proto_event.is_relay {
        proto_event.event = Some(v1::event::Event::Relay(RelayEvent {
            times: event.into_iter()
                .map(|mut e| relay_event::RelayEventTime {
                    name: e.name.take().unwrap_or_default(),
                    time: Some(create_proto_ev_time(&e)),
                })
                .collect()
        }));
    } else {
        proto_event.event = Some(v1::event::Event::Individual(IndividualEvent {
            times: event.into_iter()
                .map(|e| individual_event::IndividualEventTime {
                    swimmer_id: e.swimmer_id.unwrap_or_default() as u32,
                    time: Some(create_proto_ev_time(&e)),
                })
                .collect()
        }))
    }

    Ok(proto_event)
}

fn create_proto_ev_time(e: &GetEventSchema) -> EventTime {
    EventTime {
        event_id: e.event_id as u32,
        team_id: e.team_id as u32,
        heat: e.heat as u32,
        lane: e.lane as u32,
        result: EventTimeResult::from_i32(e.result as i32).unwrap_or_default() as i32,
        time: e.final_time.map(|t| Duration::from_millis(t as u64).into()),
        seed: e.seed_time.map(|t| Duration::from_millis(t as u64).into()),
        rank: e.rank as i32,
        points: e.points,
    }
}

async fn insert_event_timing(
    ex: impl sqlx::PgExecutor<'_>,
    time: &EventTime,
    name: Option<&str>,
    swimmer_id: Option<u32>,
) -> Result<PgQueryResult, sqlx::Error> {
    let result = EventTimeResult::from_i32(time.result)
        .unwrap_or_default();

    let final_time: Option<i64> = time.time.clone()
        .and_then(|t| t.try_into().ok())
        .and_then(|t: Duration| t.as_millis().try_into().ok());
    let seed_time: Option<i64> = time.seed.clone()
        .and_then(|t| t.try_into().ok())
        .and_then(|t: Duration| t.as_millis().try_into().ok());

    sqlx::query!(
        "INSERT INTO timings VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11);",
        name,
        swimmer_id.map(|id| id as i32),
        time.event_id as i32,
        time.team_id as i32,
        time.heat as i16,
        time.lane as i16,
        result as i16,
        time.rank as i32,
        time.points,
        final_time,
        seed_time,
    )
        .execute(ex)
        .await
}n>
<option value='lithdew/picohttp-mimalloc'>lithdew/picohttp-mimalloc</option>
<option value='main'>main</option>
<option value='move-templates'>move-templates</option>
<option value='nestjs-guide'>nestjs-guide</option>
<option value='next-cleanup'>next-cleanup</option>
<option value='origin/main'>origin/main</option>
<option value='plugin/plugindata'>plugin/plugindata</option>
<option value='plugin/resolvedir'>plugin/resolvedir</option>
<option value='postinstall_3'>postinstall_3</option>
<option value='repl'>repl</option>
<option value='request-body-stream'>request-body-stream</option>
<option value='reserve-commands'>reserve-commands</option>
<option value='revert-5167-dylan/decode-regex-if-needed'>revert-5167-dylan/decode-regex-if-needed</option>
<option value='rfc/bun-bundler-api'>rfc/bun-bundler-api</option>
<option value='rfc/bunfig-overhaul'>rfc/bunfig-overhaul</option>
<option value='save-in-update'>save-in-update</option>
<option value='sdl'>sdl</option>
<option value='test/action'>test/action</option>
<option value='types/mock'>types/mock</option>
<option value='types/readable-stream-default'>types/readable-stream-default</option>
<option value='types/tty'>types/tty</option>
<option value='u/vjpr/zig-0.10'>u/vjpr/zig-0.10</option>
<option value='xHyroM/types/expose-Bun-Env'>xHyroM/types/expose-Bun-Env</option>
</select> <input type='submit' value='switch'/></form></td></tr>
<tr><td class='sub'>Unnamed repository; edit this file 'description' to name the repository.</td><td class='sub right'></td></tr></table>
<table class='tabs'><tr><td>
<a href='/ansg191/bun/about/?h=cli-flags'>about</a><a href='/ansg191/bun/?h=cli-flags'>summary</a><a href='/ansg191/bun/refs/?h=cli-flags'>refs</a><a class='active' href='/ansg191/bun/log/src/bun.js/modules/NodeBufferModule.h?h=cli-flags&amp;showmsg=1&amp;follow=1'>log</a><a href='/ansg191/bun/tree/src/bun.js/modules/NodeBufferModule.h?h=cli-flags'>tree</a><a href='/ansg191/bun/commit/src/bun.js/modules/NodeBufferModule.h?h=cli-flags&amp;follow=1'>commit</a><a href='/ansg191/bun/diff/src/bun.js/modules/NodeBufferModule.h?h=cli-flags&amp;follow=1'>diff</a></td><td class='form'><form class='right' method='get' action='/ansg191/bun/log/src/bun.js/modules/NodeBufferModule.h'>
<input type='hidden' name='h' value='cli-flags'/><input type='hidden' name='showmsg' value='1'/><select name='qt'>
<option value='grep'>log msg</option>
<option value='author'>author</option>
<option value='committer'>committer</option>
<option value='range'>range</option>
</select>
<input class='txt' type='search' size='10' name='q' value=''/>
<input type='submit' value='search'/>
</form>
</td></tr></table>
<div class='path'>path: <a href='/ansg191/bun/log/?h=cli-flags&amp;showmsg=1&amp;follow=1'>root</a>/<a href='/ansg191/bun/log/src?h=cli-flags&amp;showmsg=1&amp;follow=1'>src</a>/<a href='/ansg191/bun/log/src/bun.js?h=cli-flags&amp;showmsg=1&amp;follow=1'>bun.js</a>/<a href='/ansg191/bun/log/src/bun.js/modules?h=cli-flags&amp;showmsg=1&amp;follow=1'>modules</a>/<a href='/ansg191/bun/log/src/bun.js/modules/NodeBufferModule.h?h=cli-flags&amp;showmsg=1&amp;follow=1'>NodeBufferModule.h</a> (<a href='/ansg191/bun/log/src/bun.js/modules/NodeBufferModule.h?h=cli-flags&amp;showmsg=1'>unfollow</a>)</div><div class='content'><table class='list nowrap'><tr class='nohover'><th class='left'>Age</th><th class='left'>Commit message (<a href='/ansg191/bun/log/src/bun.js/modules/NodeBufferModule.h?h=cli-flags&amp;follow=1'>Collapse</a>)</th><th class='left'>Author</th><th class='left'>Files</th><th class='left'>Lines</th></tr>
<tr class='logheader'><td><span title='2023-10-12 16:33:37 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/install/install.zig?h=cli-flags&amp;id=c9e1c6455fadd55a07eabcd9128541a1d349fff7&amp;follow=1'>Tweaks</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>1</td><td><span class='deletions'>-2</span>/<span class='insertions'>+2</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:05:03 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/cli.zig?h=cli-flags&amp;id=c12140f2aab40b8c8e548312c030f00adcde3ec1&amp;follow=1'>Fix struct</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>1</td><td><span class='deletions'>-1</span>/<span class='insertions'>+1</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:04:57 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/install/install.zig?h=cli-flags&amp;id=71a40672c2b73b39b4a54197f939ba1428902639&amp;follow=1'>Clean up, implement warn_on_unrecognized_flag</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>4</td><td><span class='deletions'>-26</span>/<span class='insertions'>+40</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:04:25 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/deps/zig-clap/clap/streaming.zig?h=cli-flags&amp;id=6180b2dc2afec4a8c8ad9e8462301b8c8d089199&amp;follow=1'>WIP</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>4</td><td><span class='deletions'>-77</span>/<span class='insertions'>+14</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:04:02 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/install/install.zig?h=cli-flags&amp;id=07db922aad3b043a0b1826019e356b9e09c8d27b&amp;follow=1'>WIP</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>5</td><td><span class='deletions'>-347</span>/<span class='insertions'>+353</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:03:28 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/install/install.zig?h=cli-flags&amp;id=bd2c8ca3d3d4c9ab6b89917395b13989bb08b051&amp;follow=1'>WIP</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>5</td><td><span class='deletions'>-209</span>/<span class='insertions'>+446</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:02:34 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/deps/zig-clap/clap.zig?h=cli-flags&amp;id=c12ae0c46451eddb23c44d3335e79b56f6307ed9&amp;follow=1'>WIP</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>2</td><td><span class='deletions'>-24</span>/<span class='insertions'>+106</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:02:34 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/cli.zig?h=cli-flags&amp;id=acb3b56bec314dea1aa1e1bdb60d27315c178b93&amp;follow=1'>Improve helptext</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>1</td><td><span class='deletions'>-55</span>/<span class='insertions'>+83</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:02:34 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/deps/zig-clap/clap/streaming.zig?h=cli-flags&amp;id=2b661aa52bcc0a85c1d5a84d7cb0bd934ee420cf&amp;follow=1'>WIP</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>3</td><td><span class='deletions'>-49</span>/<span class='insertions'>+147</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 16:02:34 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/deps/zig-clap/clap.zig?h=cli-flags&amp;id=3cd555210cae15d39e5b615a79f1ecad9de71861&amp;follow=1'>WIP</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>2</td><td><span class='deletions'>-0</span>/<span class='insertions'>+19</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 15:17:03 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/test/cli/install/loader-runner-4.3.0.tgz?h=cli-flags&amp;id=892593c73b93bd5c0d4a9211c08646729f22f034&amp;follow=1'>fix install test</a></td><td><img src='//www.gravatar.com/avatar/0f2ac0141773b63a6cd646063e7ebfca?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Dylan Conway
</td><td>2</td><td><span class='deletions'>-6</span>/<span class='insertions'>+8</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 15:02:05 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/test/js/bun/test/jest-extended.test.js?h=cli-flags&amp;id=691cf338c2a88fd2629f50934fe35fcb5bd08ae2&amp;follow=1'>fix editing package json when adding github dependency (#6432)</a></td><td><img src='//www.gravatar.com/avatar/9c0e69537b9d9493708725dd4c91e3af?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Dylan Conway
</td><td>5</td><td><span class='deletions'>-14</span>/<span class='insertions'>+146</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
* fix package name added to package json

* check for github tag

* remove alloc

* some tests

* fix test

</td></tr>
<tr class='logheader'><td><span title='2023-10-12 14:12:53 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/docs/installation.md?h=cli-flags&amp;id=beb746e5eaf7681212e9f6d72c782abe7789471d&amp;follow=1'>Update installation.md</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>1</td><td><span class='deletions'>-8</span>/<span class='insertions'>+14</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 13:43:45 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/docs/installation.md?h=cli-flags&amp;id=89faee2522c463f7d59bc4ef9f6146a83a9e5a8b&amp;follow=1'>Update installation.md</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>1</td><td><span class='deletions'>-3</span>/<span class='insertions'>+3</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 02:03:02 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/test/cli/install/overrides.test.ts?h=cli-flags&amp;id=969da088f5db3258a803ec186012e30f992829b4&amp;follow=1'>fix(install): re-evaluate overrides when removed</a><span class='decoration'><a class='tag-deco' href='/ansg191/bun/tag/?h=bun-v1.0.6'>bun-v1.0.6</a></span></td><td><img src='//www.gravatar.com/avatar/7eeb3c9446e467f71ba578a6fcc9c614?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> dave caruso
</td><td>3</td><td><span class='deletions'>-3</span>/<span class='insertions'>+45</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 01:00:27 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/docs/bundler/index.md?h=cli-flags&amp;id=c50be68790782e82c268e80e1c5a31c5d8caf093&amp;follow=1'>chore: add missing ending quote (#6436)</a></td><td><img src='//www.gravatar.com/avatar/7390814850c81bbb7be3542d6c73b500?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Luna
</td><td>1</td><td><span class='deletions'>-1</span>/<span class='insertions'>+1</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-12 00:44:15 -0700'>2023-10-12</span></td><td class='logsubject'><a href='/ansg191/bun/commit/test/cli/install/overrides.test.ts?h=cli-flags&amp;id=2fbb95142a8ad6ce182e034ca11e70fdf2b95c34&amp;follow=1'>feat(install): support npm overrides/yarn resolutions, one level deep only ↵</a></td><td><img src='//www.gravatar.com/avatar/7eeb3c9446e467f71ba578a6fcc9c614?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> dave caruso
</td><td>7</td><td><span class='deletions'>-31</span>/<span class='insertions'>+640</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
(#6435)

* disable zig fmt on generated ResolvedSourceTag.zig

* overrides

* it works

* ok

* a

---------

Co-authored-by: Jarred Sumner &lt;jarred@jarredsumner.com&gt;

</td></tr>
<tr class='logheader'><td><span title='2023-10-11 20:41:12 -0700'>2023-10-11</span></td><td class='logsubject'><a href='/ansg191/bun/commit/test/cli/install/bun-install.test.ts?h=cli-flags&amp;id=755e16d962667621039a73e9d336b7ae16dcc00f&amp;follow=1'>fix #6416 (#6430)</a></td><td><img src='//www.gravatar.com/avatar/9c0e69537b9d9493708725dd4c91e3af?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Dylan Conway
</td><td>2</td><td><span class='deletions'>-1</span>/<span class='insertions'>+132</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
* make sure latest is checked after prerelease

* test and fix

* test for when latest matches prerelease

</td></tr>
<tr class='logheader'><td><span title='2023-10-11 20:04:15 -0700'>2023-10-11</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/bun.js/WebKit?h=cli-flags&amp;id=b1063edf3e76a2ef68d2ba3eff686932f742c77c&amp;follow=1'>Bump WebKit</a></td><td><img src='//www.gravatar.com/avatar/5145ad1d8bb861137d85da7a3e32ef36?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Jarred Sumner
</td><td>9</td><td><span class='deletions'>-29</span>/<span class='insertions'>+29</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-11 19:05:52 -0700'>2023-10-11</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/build-id?h=cli-flags&amp;id=edb4cbac2b03c4350c6efcfbfc50bda5159800be&amp;follow=1'>Bump!</a></td><td><img src='//www.gravatar.com/avatar/5145ad1d8bb861137d85da7a3e32ef36?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Jarred Sumner
</td><td>1</td><td><span class='deletions'>-1</span>/<span class='insertions'>+1</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-11 15:26:55 -0700'>2023-10-11</span></td><td class='logsubject'><a href='/ansg191/bun/commit/src/bun.js/bindings/JSCUSocketsLoopIntegration.cpp?h=cli-flags&amp;id=a59a69e21baefc0bb3c671ec9a688b02ad126790&amp;follow=1'>Update JSCUSocketsLoopIntegration.cpp</a></td><td><img src='//www.gravatar.com/avatar/0f2ac0141773b63a6cd646063e7ebfca?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Dylan Conway
</td><td>1</td><td><span class='deletions'>-2</span>/<span class='insertions'>+2</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>
<tr class='logheader'><td><span title='2023-10-11 14:31:39 -0700'>2023-10-11</span></td><td class='logsubject'><a href='/ansg191/bun/commit/docs/installation.md?h=cli-flags&amp;id=4c9e0099719895eaf95e3149256bf8d1338d2378&amp;follow=1'>Update installation.md</a></td><td><img src='//www.gravatar.com/avatar/7314f20052c467b4e5b959ac03e39ff0?s=13&amp;d=retro' width='13' height='13' alt='Gravatar' /> Colin McDonnell
</td><td>1</td><td><span class='deletions'>-10</span>/<span class='insertions'>+7</span></td></tr>
<tr class='nohover-highlight'><td/><td colspan='5' class='logmsg'>
</td></tr>