Alex Grintsvayg
396f42bc91
never update created_at, updated_at columns
2018-04-16 12:41:55 -04:00
Alex Grintsvayg
e4a52e21b6
switch to our errors package
2018-02-07 09:35:46 -05:00
Alex Grintsvayg
cd445bf2f4
revert interpolateParams, since we're doing our own logging now
2017-09-02 11:31:15 -04:00
Alex Grintsvayg
55f42bc038
just use interfaces
2017-08-24 11:58:13 -04:00
Alex Grintsvayg
3abac13aeb
export InterpolateParams
2017-08-23 16:37:33 -04:00
Aaron L
e339812027
Stop using aliases in the relationship select
...
- This caused issues with mysql who doesn't understand the syntax:
"delete from x as y where y.id = ?"
2017-08-01 14:39:10 -04:00
Guy Tish
23f245776d
Added table columns and table names as anonymous struct
2017-08-01 14:27:50 -04:00
Alex Grintsvayg
99a3a1d091
make merge compatible with an existing transaction
2017-08-01 13:00:14 -04:00
Alex Grintsvayg
9c8262b702
fix exists() finisher
2017-07-20 10:50:55 -04:00
Alex Grintsvayg
05c7f7d06a
switch to more complete null package, implement nicer sql logging
2017-07-06 15:15:00 -04:00
Alex Grintsvayg
ed423a3606
detect autoincrement column, fix lastID in upsert when update doesnt change anything
2017-06-12 14:02:04 -04:00
Alex Grintsvayg
09c585cdb1
dont run delete query when there's nothing to delete
2017-06-01 09:58:50 -04:00
Alex Grintsvayg
912a689701
added unique key detection (mysql only for now), improved merging
2017-05-12 06:56:48 -04:00
Alex Grintsvayg
31fe8b6e1d
model merging
2017-05-10 15:35:05 -04:00
Alex Grintsvayg
b160e5c1f4
dont error if no rows found
2017-05-10 11:21:29 -04:00
Alex Grintsvayg
ed43c9078f
made query structs public, added IS NULL to filter
2017-05-09 15:30:04 -04:00
Alex Grintsvayg
f863ecb48e
add model Filters, FindOrCreate methods, IsNew()
2017-05-08 16:39:16 -04:00
Maksim
bdd28d9d5b
fix removing whitespace
2017-04-24 12:46:56 -04:00
Aaron L
0818af0e26
Don't use XSlice where unneeded.
...
- In the bowels of the eager loading we weave in and out of reflection,
but we should not care about using XSlice unless it's going back to
the user. This change makes it so the XSlice is only used where it
matters, everywhere else is *[]*X to avoid type assertion errors from
being able to have either or come into the Load() functions.
- Fix #124
2017-04-04 19:44:36 -07:00
Aaron L
10cfe74989
Fix a bug that could occur on no-field inserts
2017-04-04 19:42:49 -07:00
Aaron L
d13410617f
Correct whitespace errors
2017-04-04 19:40:12 -07:00
Sergey Kurt
fd2c7ad764
Fixed Upsert statement for postgres, mysql
2017-04-02 12:27:33 +03:00
Sergey Kurt
b2acda8ade
Generic Select statement in Reload
2017-04-01 21:11:01 +03:00
Sergey Kurt
f913d5e791
Generic Delete statement
2017-04-01 21:08:29 +03:00
Sergey Kurt
178d925c24
Generic Update statement
2017-04-01 21:00:13 +03:00
Sergey Kurt
783e7a82b3
Choosing StartIndex at template time
2017-04-01 20:30:40 +03:00
Sergey Kurt
dfbcef7fe3
Fixed typo and combined variables declaration
2017-03-31 11:27:34 +03:00
Sergey Kurt
b10df110a0
Newline at end of file
2017-03-31 11:05:52 +03:00
Sergey Kurt
b4fc4447f8
Fixed trim direction
2017-03-31 11:03:16 +03:00
Sergey Kurt
83b935168f
Branching with if-else
2017-03-31 10:59:03 +03:00
Sergey Kurt
8ef33a1127
PkgName in error
2017-03-31 10:52:54 +03:00
Sergey Kurt
9bafa2f158
MSSQL Upsert statement
2017-03-21 13:04:07 +03:00
Sergey Kurt
13bdda4e20
Simplified insert query
2017-03-19 18:12:06 +03:00
Sergey Kurt
d40d074320
Filtering columns with auto values
2017-03-19 12:44:15 +03:00
Sergey Kurt
12dce9d986
Auto columns in Inserts removed
2017-03-19 12:42:55 +03:00
Sergey Kurt
f3f8074833
Removed blank lines and spaces
2017-03-18 15:18:04 +03:00
Sergey Kurt
b1b0249898
New line at end of file
2017-03-16 11:01:49 +03:00
Sergey Kurt
8de60ee26a
Update and Insert for columns with autogenerated values
2017-03-16 10:54:55 +03:00
Sergey Kurt
e943c37a99
Update and Insert only for columns without autogenerated
2017-03-16 10:26:05 +03:00
Sergey Kurt
4c2062caee
Fixed code generation for Update and Reload
2017-03-15 19:35:44 +03:00
Sergey Kurt
f45f98ef03
Fixed placeholders
2017-03-15 19:13:20 +03:00
Sergey Kurt
ad15668462
Fixed code generation
2017-03-15 19:04:13 +03:00
Sergey Kurt
51e9961f0a
Fixed OUTPUT values on Insert
2017-03-14 18:06:33 +03:00
Sergey Kurt
a48e5f7f82
MS SQL compatible query for RETURNING clause
2017-03-14 16:52:54 +03:00
Sergey Kurt
aa01f21b5c
Pass UseTopClause flag into the Dialect object
2017-03-14 13:59:05 +03:00
Sergey Kurt
ed6dad7eed
MS SQL compatible query for checks if the row exists
2017-03-14 13:53:35 +03:00
Sergey Kurt
83d90f3f28
Fixed quote symbols order
2017-03-14 13:48:38 +03:00
Sergey Kurt
e00ea60679
Initial MSSQL support
2017-03-13 12:55:26 +03:00
Aaron L
8f96ba35d6
Allow insertion of only-defaulted tables
...
- Tables that are only comprised of default values and have nothing
passed into them on insertion will no longer generate syntax errors.
2017-03-01 18:18:47 -08:00
Aaron L
a5cb765403
Ensure created_at isn't updated when unnecessary
...
- When we build the update whitelist (when the user doesn't provide one)
we simply say that the whitelist is all columns except pkeys. The
reason we do this is because sqlboiler doesn't support dirty tracking
and if you want to update just a few fields, it's easier to just
explicitly pass a whitelist when you update. However, in the case of
created_at - it's a field that's usually managed by us and so we
should not be updating it unless a user explicitly requests it via the
whitelist. So if the whitelist is empty we prune that column now if it
exists from the auto-created whitelist.
- The user also reported that upsert has the same fate, but the logic is
somewhat different there. It expects that there's a value for
created_at or it assumes that one needs to be created. There's no
more magic we can do around this one unfortunately. Upsert is a
mythical beast that doesn't play as nicely with our model, so users
will just have to be more careful.
- Fix #106
2017-02-24 22:52:09 -08:00
